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 (371,372,584,585,586,3301,3302,3303,3304,3305,3306,3307,3308,3309,4225,4226,4227,4228,4229,4230,4231,4232,4233,4234,4235,4236,4237,4238,4239,4240,4241,4242,4243,4244,4245,4246,4247,4248,4249,4250,4251,4252,4253,4254,4255,4256,4257,4258,4259,4260,4261,4262,4263,4264,4265,4266,4267,4268,4269,4270,4271,4272,4273,4513)  AND i.active = 1 
				GROUP BY i.id