| |
| | | 1054 - Unknown column 'p.SITE_NAME' in 'where clause'
select op.products_id, pd.products_name, sum(op.products_quantity) as totaal from orders_products op left join orders o on (op.orders_id = o.orders_id) left join products p on (op.products_id = p.products_id) left join products_description pd on (op.products_id = pd.products_id) where p.SITE_NAME = '1' and op.products_id > 0 and o.date_purchased > '2012-04-02' and pd.language_id = '1' group by op.products_model order by totaal DESC, pd.products_name limit 0, 10
[TEP STOP]
|
| 