SELECT it.id,it.ttype AS use_type,it.alias,CONCAT('/',it.alias,'.html') AS url,it.country_id,it.articul,it.name,it.about,it.short_about,it.art_id,
                         it.price, SUM(sit.price) AS price_subitem, it.price_complect, it.price_complect_min, it.price_actual, it.price_fin, it.price_fix,
                         it.currency, it.guarantee,it.guarantee_tp AS guarantee_period, it.stock_type,it.stock_comment, it.range_rez AS range_itm,
                         it.brand_id,it.item_group_id,it.item_group_main,it.qty,
                         it.ml_delivery, it.ml_delivery_price, IF(it.qty>0,it.ml_delivery_ydays,it.ml_delivery_ndays) AS delivery_days,
                         it.category_id, ct.name AS category_name, ct.level AS category_level, IF(it.name_prefix<>'',it.name_prefix,ct.name_add) AS category_name_add,ct.alias AS category_alias,
                         ct.catarticul_id AS category_articul,  ct.catarticul_main AS category_articul_main,
                         it.unit1 AS unit_by, it.unitqty1 AS qty_by, it.is_flag&1 AS no_single,
                         it.margin, it.margin_zero, it.discount, it.discount_zero,IFNULL(iit.vvalue,0) AS accessory_type ,0 AS stock_id, '' AS stock_name,IFNULL(_cgtt.name,'') AS category_articul_name
                  FROM (mod_catalog_items AS it,mod_catalog_cat_tree AS ct)
                  LEFT JOIN mod_catalog_subitems AS sit ON (sit.item_id=it.id AND sit.active=1)  LEFT JOIN mod_catalog_item_items AS iit ON (iit.item_id='1666' AND iit.subitem_id=it.id) LEFT JOIN mod_catalog_catgroup_tree AS _cgtt ON (_cgtt.id=ct.catarticul_id AND _cgtt.ttype='catarticul')
                  WHERE it.category_id=ct.id AND it.id IN (1561,1564,1665,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,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,322,323,324,325,326,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631)
                  GROUP BY it.id ORDER BY ct.lleft

DB Error: unknown error