Lody

SELECT DISTINCT product_desc.name AS name, product.id AS id, product_desc.m_text AS text, product.sort AS sort, product_desc.seo , cat.id as catID FROM product,lang,product_desc ,cat,cat_product WHERE product.status != 0 AND product.id=product_desc.id_product AND product_desc.lang=lang.id AND lang.id=1 AND product.status=1 AND cat_product.id_product = product.id AND product.id=cat_product.id_product AND cat_product.id_cat=cat.id AND ( cat.id=2 ) ORDER BY cat.id ASC, product.sort ASC LIMIT 0,12

«« « 1 2 3 » »»

-->