SELECT DISTINCT(i.id) as item_id, di.*, i.active as item_active, i.autovendor_id as item_autovendor_id, a.vendor as item_autovendor, i.title as item_title, i.description as item_description, i.params as item_params, i.title_ua as item_title_ua, i.description_ua as item_description_ua, i.params_ua as item_params_ua, ilm.model_link_ocat_id, ml.key as ocat_key, ml.link_title as ocat_link_title, ml.link_mods as ocat_link_mods, m.id as model_id, m.model as model, m.kuzov as kuzov, tcs.own_warehouse as own_warehouse, di2.id as id_own_warehouse, di2.price as price_own_warehouse, di2.price_in as price_in_own_warehouse, di2.grp as grp_own_warehouse, di2.supplier as supplier_own_warehouse , dip.photo as photo 
					FROM cat_items_links_models ilm
					JOIN cat_items i 
						ON i.id = ilm.item_id
					LEFT JOIN cat_autovendors a
						ON i.autovendor_id = a.id
					LEFT JOIN cat_models_links ml 
						ON ml.id = ilm.model_link_ocat_id AND ml.hidden = 0
					LEFT JOIN cat_models m 
						ON ilm.model_id = m.id
					LEFT JOIN cat_items_links_prices ilp 
						ON i.id = ilp.item_id
					LEFT JOIN cat_details_import di 
						ON ilp.price_id = di.id
					LEFT JOIN cat_details_import di2 
						ON di.code=di2.code AND di2.supplier=9 AND di2.status = "on"
					LEFT JOIN  cat_suppliers tcs
						ON di.supplier = tcs.id
					 LEFT JOIN cat_details_import_photo dip ON di.code = dip.code AND di.vendor = dip.vendor AND dip.main=1 
				WHERE i.title IS NOT NULL AND i.id IN (624,897,900,903,904,911,924,931,933,937,948,973,980,981,982,999,1000,1013,1014,1015,1105,1128,1131,1132,1133,1136,1140,1152,1154,1161,1165,1171,1172,1289,1296,1297,1298,1307,1317,1322,1355,1366,1367,1377,1378,1379,1380,1383,1390,1391,1392,1393,1394,1395,1396,1397,1399,1402,1403,1404,1406,1410,1412,1421,1422,1427,1433,1434,1435,1438,1439,1441,1443,1447,1448,1449,1450,1451,1453,1458,1459,1463,1464,1465,1466,1467,1472,1516,1517,1518,1519,1520,1522,1530,1531,1535,1536,1544,1545,1570,1572,1573,1574,1575,1576,1577,1578,1579,1580,1585,1588,1594,1596,1600,1603,1604,1612,1628,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1717,1722,1723,1724,1726,1731,1752,1753,1754,1771,1772,1778,1779,1796,2482,2483,2484,2485,2486,2487,2960,2962,2975,2980,2982,2995,2996,3012,3016,3528,3529,3530,3568,3714,3716,4592,4593,4603,4722,4723,4724,4725,4726)  AND i.active = 1 
				GROUP BY i.id