The Mobile Mounting Specialist!

Featured Products

select max(qo) as des_qty,`product_id` FROM (select sum(`qty_ordered`) AS qo,`product_id`,created_at,store_id from sales_flat_order_item Group By `product_id`) AS t1 where store_id = 4 AND created_at between'2015-01-30' AND '2015-03-31' Group By `product_id` order By des_qty desc LIMIT 0, 10