| Top 5 Verkoop: |
1030 - Got error 28 from storage engine
select distinct p.products_id, pd.products_name, p.products_image, p.products_status, p.products_price, pd.products_description, s.specials_new_products_price, p.products_tax_class_id, sum(pbs.BsP_quantity)
from products p
left join specials s
ON p.products_id = s.products_id
left join products_description pd
ON p.products_id = pd.products_id
left join products_bestsellers pbs
ON p.products_id = pbs.products_id
where p.products_status = '1'
AND pbs.BsP_country = 'BE'
AND pbs.BsP_date_buy >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
GROUP BY pbs.products_id, pbs.BSP_quantity
ORDER BY sum( pbs.BSP_quantity ) DESC
LIMIT 0 , 5
[TEP STOP]
|
