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 (722,823,866,867,868,870,871,872,873,874,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,4162,4169,4170,4171,4172,4173,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4816,306,626,2586,3873,3874,3875,3876,3877,3878,3879,3880,3881,3882,3883,4421,4422,4423,4424,4425,4426,4427,4428,4429,4430,4431,4432,4433,4837,2569,2570,2571,2572,2573,2574,2576,2577,2578,2579,2580,2581,2582,2583,2584,340,587,616,2524,2733,2734,2735,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,4152,4153,4154,4155,4223,4224,4391,4392,4393,4394,4395,4396,4511,4782,4798,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2865,4308,2853,2854,2855,2857,2858,2859,2860,2861,2862,2863,2864,2870,2866,2867,2868,2869,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,3339,4825,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,3884,3885,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896)  AND i.active = 1 
				GROUP BY i.id