SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (63665,68473,64081,140606,66159,63664,360394,312580,355155,79528,182516,79102,88161,115971,75802,355894,61992,139877,14171,71850,68460,340276,357437,355086,355200,357170,70603,358736,282274,87988,355145,360395,355079,349553,179102,163105,325417,355219,74899,322040,353936,324215,66960,303882,77782,355156,357214,366507,172697,319431,63692,63598,68463,64701,357125,82223,349555,138298,63650,86680,62274,350943,115981,304819,71154,71991,323545,358703,369433,100522,74422,353988,117687,77349,13650,367442,243880,13649,357348,13305,62361,72773,355805,64958,62108,357526,75495,14170,353964,71795,356215,67134,272146,67221,76803,357854,341150,175232,361446,13083) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 63665,68473,64081,140606,66159,63664,360394,312580,355155,79528,182516,79102,88161,115971,75802,355894,61992,139877,14171,71850,68460,340276,357437,355086,355200,357170,70603,358736,282274,87988,355145,360395,355079,349553,179102,163105,325417,355219,74899,322040,353936,324215,66960,303882,77782,355156,357214,366507,172697,319431,63692,63598,68463,64701,357125,82223,349555,138298,63650,86680,62274,350943,115981,304819,71154,71991,323545,358703,369433,100522,74422,353988,117687,77349,13650,367442,243880,13649,357348,13305,62361,72773,355805,64958,62108,357526,75495,14170,353964,71795,356215,67134,272146,67221,76803,357854,341150,175232,361446,13083) LIMIT 40SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (173930,351438,355218,356079,354019,351437,66054,315229,354382,63871,357516,348977,135397,337913,304728,331062,151648,348978,358190,323511,283956,358189,358318,13316,62142,354394,358463,357198,234033,351296,351385,66182,77584,351439,13619,62510,239272,329758,358116,331886,137164,358439,71006,358464,65196,65749,333527,358539,358533,71157,273738,332317,13315,354386,357860,13858,116276,328849,246780,343626,350433,350924,337629,354371,358397,329173,64099,76675,115095,256575,317263,166193,354035,358193,350436,78647,349845,354379,76615,77002,355499,14211,144062,320615,14207,67168,107923,351085,72861,312514,317275,343563,358469,10368,322286,322800,11933,67047,144077,232684) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 62697,63871,66054,323511,351437,354019,354371,358190) DESC, FIELD(b1.slno, 173930,351438,355218,356079,354019,351437,66054,315229,354382,63871,357516,348977,135397,337913,304728,331062,151648,348978,358190,323511,283956,358189,358318,13316,62142,354394,358463,357198,234033,351296,351385,66182,77584,351439,13619,62510,239272,329758,358116,331886,137164,358439,71006,358464,65196,65749,333527,358539,358533,71157,273738,332317,13315,354386,357860,13858,116276,328849,246780,343626,350433,350924,337629,354371,358397,329173,64099,76675,115095,256575,317263,166193,354035,358193,350436,78647,349845,354379,76615,77002,355499,14211,144062,320615,14207,67168,107923,351085,72861,312514,317275,343563,358469,10368,322286,322800,11933,67047,144077,232684) LIMIT 40

Sofa Set Dealers in Nashik

(33 products available)
Filter by Locality
top