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,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_catgroup_tree AS _cgtt ON (_cgtt.id=ct.catarticul_id AND _cgtt.ttype='catarticul')
WHERE it.category_id=ct.id AND it.id IN ()
GROUP BY it.id ORDER BY ct.name