|
|
|
|
|
| | | |
|
|
|
6(select DISTINCT 1 as sort_query, c.categories_id, p.products_image, pd.products_name, p.*, if(p2c.sort_order = 0, 9999999, p2c.sort_order) as product_in_category_sort, IF(c.sort_order = 0, 1000, c.sort_order) as csort, p.products_id, p.products_date_available, p.manufacturers_id, p.products_price, p.products_order_type, p.products_sort_order, p.products_tax_class_id, p.products_quantity, p.products_unlimited_quantity,p.products_status, p.products_not_for_sale, p.products_ordered, p.products_not_for_sale_show, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_external_url, p.forawrd_product_attribute_detail from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id left join categories c on c.categories_id = p2c.categories_id left join categories_description cd on c.categories_id = cd.categories_id where m.manufacturers_status='1' and c.categories_status = '1' and c.categories_public = '1' and p.products_status = '1' and p.products_public = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and c.categories_id in (1212,1211,1213,1214,1215,1216,1217,1209) and p.manufacturers_id='-1' group by p.products_id order by product_in_category_sort asc ,products_order_type desc, products_sort_order, products_name asc, csort asc, sort_query asc, products_ordered asc, products_model asc)
| | | |
|
|
|
