|
SELECT count(d.model) AS cnt, rt.level2 AS gid FROM fram_catalog_info AS i LEFT JOIN fram_client_orders AS o on o.client_id=7617000 AND (o.order_model IS NULL OR (i.model=o.order_model)) LEFT JOIN fram_catalog_price AS p ON i.model=p.model LEFT JOIN fram_catalog_description AS d ON i.model=d.model ,fram_rubric AS rm ,fram_rubric AS rt WHERE (p.model IS NULL OR i.model=p.model) AND (d.model IS NULL OR (i.model=d.model AND d.lang='rus')) AND d.model IS NOT NULL AND i.manufacturer = rm.id AND i.ctype = rt.id AND rm.level1='909' AND rt.level1='892' GROUP BY rt.level2 ORDER BY rt.index_ordering ASC ERROR: Class - CObjCatalogGi::listSelect: Price |