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 (11735821030551,1394718,1436593,1468785,1469790,1495640,1741511,1970948,2030382) order by field(p2c.products_id, 11735821030551,1394718,1436593,1468785,1469790,1495640,1741511,1970948,2030382)