SELECT p.product_id, p.name, p.model, p.sku, p.price, p.quantity, p.image, p.min_order, p.pack_order, p.tax_class_id, p.att_str01, p.att_str02, p.att_str03, p.att_str04, p.isnew, p.istop, pd.description, p.pricing, m.name AS manufacturer, p.images, p.manufacturer_id, ss.name AS stock, 0 AS rating, ms.title AS ms_title, ms.unit AS ms_unit FROM ezc_product p LEFT JOIN ezc_product_price pp ON (p.product_id = pp.product_id) LEFT JOIN ezc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN ezc_stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN ezc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN ezc_measurement_class ms ON(p.measurement_class_id=ms.measurement_class_id) LEFT JOIN ezc_product_description pd ON(p.product_id=pd.product_id) WHERE ss.language_id = '1' AND p2c.category_id = '9167' ORDER BY p.att_str02 DESC, p.price ASC LIMIT 0,24
