| SELECT sp.id,sp.id_razd,sp.id_item,sp.sub_sec,sp.name,sp.page_title,sp.off,sp.art,sp.art_vl2,sp.artkomplekt,sp.size,sp.country,sp.country2,sp.color,sp.showot,sp.price,sp.price_new,sp.price_msk,sp.price_msk_new,sp.foto,sp.collect,sp.getdown,sp.instoyandex,sp.vnalichii,sp.aktsii,sp.isactciya,sp.discount,sp.pop,sp.isnew,sp.count, IF(price_new > 0 , price_new, price) AS _price_to_sort, IF(o.yml_name <> '' , o.yml_name, o.name) AS owner_name, o.id AS owner_id FROM ~sections_prod AS sp LEFT JOIN ~owner AS o ON o.id=sp.country2 WHERE sp.deleted=0 /*фильтр разделов*/ AND id_razd=495 AND off=0 /*фильтр фильтра*/ AND ( 1=1 ) ORDER BY sp.chain, sp.id |
