|
select p.products_image, pd.products_name, p.products_model, p.products_weight, m.manufacturers_name, p.products_not_for_sale, p.products_not_for_sale_show, p.hide_title, p.products_description_embed_url, p.products_id, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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, pd.products_subtitle from pages_description pd, pages p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, pages_to_pages_categories p2c left join specials s on p2c.products_id = s.products_id left join pages_categories c on c.categories_id = p2c.categories_id where (p.products_date_available <= CURDATE() or p.products_date_available is null) and m.manufacturers_status='1' and c.categories_status = '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 p2c.categories_id = '170'group by p.products_id order by IF(p2c.sort_order > 0, p2c.sort_order, IF(p.products_ordered> 0, p.products_ordered, 999999)), p.products_model, pd.products_name desc3
select p.products_image, pd.products_name, p.products_model, p.products_weight, m.manufacturers_name, p.products_not_for_sale, p.products_not_for_sale_show, p.hide_title, p.products_description_embed_url, p.products_id, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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, pd.products_subtitle from pages_description pd, pages p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, pages_to_pages_categories p2c left join specials s on p2c.products_id = s.products_id left join pages_categories c on c.categories_id = p2c.categories_id where (p.products_date_available <= CURDATE() or p.products_date_available is null) and m.manufacturers_status='1' and c.categories_status = '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 p2c.categories_id = '170'group by p.products_id order by IF(p2c.sort_order > 0, p2c.sort_order, IF(p.products_ordered> 0, p.products_ordered, 999999)), p.products_model, pd.products_name desc limit 0, 3 - 3
|
