Results 1 to 4 of 4
Mar 22, 2011, 06:11 #1
selecting products which are latest and with price sort
I am trying to fetch 12 products which are latest and sorting them for price. However not able to get the results i needed.
Here is the SQL query.
select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by products_price asc, p.products_date_added desc limit 12
How can i achieve this please ?