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 (613,614,879,882,884,886,887,890,891,898,899,901,902,909,910,912,914,916,917,956,963,987,990,991,996,997,1005,1006,1007,1008,1010,1011,1020,1023,1101,1102,1107,1108,1109,1110,1111,1112,1113,1114,1120,1121,1122,1123,1124,1125,1129,1130,1138,1139,1144,1145,1146,1147,1148,1149,1150,1151,1163,1164,1167,1168,1169,1170,1178,1179,1180,1181,1187,1188,1189,1190,1191,1199,1200,1201,1202,1205,1206,1207,1208,1219,1220,1221,1222,1231,1232,1241,1246,1248,1249,1250,1251,1252,1253,1260,1261,1304,1305,1306,1309,1310,1311,1314,1316,1324,1325,1326,1327,1332,1339,1340,1341,1356,1357,1362,1414,1415,1417,1418,1419,1420,1432,1468,1469,1470,1471,1473,1509,1523,1525,1526,1537,1542,1543,1581,1590,1591,1592,1593,1598,1607,1627,1642,1643,1644,1645,1646,1659,1660,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1684,1685,1686,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1708,1709,1710,1711,1713,1714,1715,1716,1718,1719,1729,1730,1734,1742,1743,1748,1749,1759,1760,1761,1768,1769,1770,1774,1775,1776,1777,1780,1783,1784,1785,1786,1793,1794,1795,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,2930,2954,2959,2966,2973,2974,2981,2986,2987,2988,2989,2990,2991,2998,2999,3000,3001,3002,3003,3005,3009,3010,3020,3025,3029,3030,3035,3036,3037,3038,3045,3537,3538,3539,3540,3541,3542,3543,3567,3572,3575,3576,3577,3578,3717,3718,3719,3720,3721,3722,3723,3725,3726,3727,3728,3729,3730,3737,3741,3742,3743,3749,3750,3751,3755,3760,3761,3762,3763,3764,3766,3767,3768,3769,3775,3784,3785,3789,3791,3792,3804,3805,3824,3825,3826,3827,3828,3829,3850,3851,3974,3975,3976,3981,3982,3983,4596,4599,4608,4609,4610,4611,4612,4613,4614,4619,4620,4628,4629,4638,4648,4649,4650,4651,4654,4655,4658,4659,4689,4690,4693,4694,4697,4720,4727,4728)  AND i.active = 1 
				GROUP BY i.id