select p2c.products_id, pd.products_name, if(ac.cities_name is null, '', ac.cities_name) as cities_name, p2c.country_id, ar.regions_name, pd.img_num, pd.img_type, pd.img_path, cd.categories_name, pd.`color` from ((products_to_categories p2c left join products_short_d pd on p2c.products_id = pd.products_id, categories c, categories_description cd) left join a_regions ar on p2c.region_id = ar.regions_id) left join a_cities ac on p2c.city_id = ac.cities_id where p2c.status_id = '1' and p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and pd.products_id in (1562323,1574771,1629670,1117269,1126014,1162553,1256023,1256843,1341924,1354880,946744,1011630,1016747,1017511,1017759,1018575,1019796,1021063,1021121,1022530,1024682,1025158,1025159) order by field(p2c.products_id, 1562323,1574771,1629670,1117269,1126014,1162553,1256023,1256843,1341924,1354880,946744,1011630,1016747,1017511,1017759,1018575,1019796,1021063,1021121,1022530,1024682,1025158,1025159)