You can browse our shop quickly with using of left side categories and with one click add products to your shopping cart. You can see your shopping cart after adding products to cart and update your shopping cart if you want. for complete your order go to checkout steps and register your order at the end.
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'farhangc_shop.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10