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 (2521,2527,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4310,4311,4312,4313,4314,4315,4316,4317,4318,4319,4320,4321,4322,4323,4324,4325,4326,4327,4328,4329,4330,4434,4435,4436,4437,4438,4439,4440,4441,4485,4486,4487,4488,4489,4490,4491,4492,4493,4494,4495,4496,4497,4498,4499,4500,4501,4502,4503,4504,4505,4506,4507,4508,4520,4521,4522,4523,4525,4526,4527,4528,4531,4532,4533,4537,4538,4539,4540,4541,4542,4543,4549,4552,4570,4571,4572,4573,4574,4575,4578,4634,4635,4796,4797,4824,4833,4867)  AND i.active = 1 
				GROUP BY i.id