Community > Shop > Catalog > Most Wanted
MySQL Error 1054
[STOP] select s.ID as stockID, p.ID, p.name, p.description, p.thumb, p.image, s.stock , s.sell_price, count( * ) as jumlah, t.name as store from `page` t, product p, product_stock s left join product_basket b on s.ID = b.product_stockID left join product_order o on b.product_orderID = o.ID WHERE p.ID = s.productID and s.product_storeID=t.ID and o.payment_date >0 and s.stock >0 GROUP BY b.product_stockID ORDER BY jumlah desc limit 0 , 20