SELECT DISTINCT(i.id) as item_id, 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, di.*, tcs.own_warehouse as own_warehouse , dip.photo as photo 
				FROM cat_items i 
					
				JOIN cat_links cl
					ON i.id = cl.item  AND cl.category IN (78,139,140,141,146,147)
				LEFT JOIN cat_autovendors a
					ON i.autovendor_id = a.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_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.active = 1 AND i.autovendor_id = 1 AND i.universal_item = 1