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 (66159,14171,79528,360394,357317,140606,63665,68473,282274,87988,71795,67134,357623,172697,73245,88161,66166,355145,360395,124366,79099,66960,70115,63692,78376,71154,325417,14170,353971,353941,79100,71801,303882,342190,243880,317672,355200,348492,13305,182516,355079,13778,86680,67221,355219,61992,353964,77782,355894,139877,358736,357886,359235,304819,103258,336709,358156,356883,353762,74422,323545,123471,342290,354751,14250,63867,354204,63598,74899,354201,356215,357327,63540,353973,66680,116276,324215,330186,62455,69892,358703,159647,364415,248780,319342,64648,361446,365642,175232,251442,62441,341150,78519,340276,68212,68911,73105,357170,353936,312516) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 66159,14171,79528,360394,357317,140606,63665,68473,282274,87988,71795,67134,357623,172697,73245,88161,66166,355145,360395,124366,79099,66960,70115,63692,78376,71154,325417,14170,353971,353941,79100,71801,303882,342190,243880,317672,355200,348492,13305,182516,355079,13778,86680,67221,355219,61992,353964,77782,355894,139877,358736,357886,359235,304819,103258,336709,358156,356883,353762,74422,323545,123471,342290,354751,14250,63867,354204,63598,74899,354201,356215,357327,63540,353973,66680,116276,324215,330186,62455,69892,358703,159647,364415,248780,319342,64648,361446,365642,175232,251442,62441,341150,78519,340276,68212,68911,73105,357170,353936,312516) 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 (355218,135397,356079,354019,354382,358189,358190,357516,351438,173930,331886,354386,63871,351296,337913,351085,13316,77002,13619,239272,76675,116276,303882,348977,64099,66182,350631,351437,358318,323511,66054,315229,348978,256575,151648,317275,166193,354910,358464,67168,304728,357198,65749,67047,72361,328849,329173,354394,69438,218371,281952,324451,335387,350634,350641,355499,14207,329758,350436,353936,358539,11937,66075,67255,73464,107923,218350,234033,246099,246780,331062,354371,358439,366407,369186,65196,140503,144062,263150,327599,349786,350900,358463,13315,13858,62112,62510,221994,283956,339612,354397,358494,13226,62142,72363,72364,137164,166918,255457,317263) && 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, 355218,135397,356079,354019,354382,358189,358190,357516,351438,173930,331886,354386,63871,351296,337913,351085,13316,77002,13619,239272,76675,116276,303882,348977,64099,66182,350631,351437,358318,323511,66054,315229,348978,256575,151648,317275,166193,354910,358464,67168,304728,357198,65749,67047,72361,328849,329173,354394,69438,218371,281952,324451,335387,350634,350641,355499,14207,329758,350436,353936,358539,11937,66075,67255,73464,107923,218350,234033,246099,246780,331062,354371,358439,366407,369186,65196,140503,144062,263150,327599,349786,350900,358463,13315,13858,62112,62510,221994,283956,339612,354397,358494,13226,62142,72363,72364,137164,166918,255457,317263) LIMIT 40

Polo Mens T-shirts Dealers in Vijayawada

(2 products available)
top