Tihku Wiki

select name, count(name) as 'ordercount' from orderproducts where DATEPART(yyyy, received) = '2014' group by name order by 'ordercount' desc;

select name, DATEPART(yyyy, received) as 'year', count(name) as 'ordercount' from orderproducts group by name, DATEPART(yyyy, received) order by year desc, 'ordercount' desc

select orders.id, orders.categoryName, orderproducts.name, orderproducts.enduserName, orders.division, orders.costpool, orders.ordered, orders.purchased, REPLACE(REPLACE(orders.comment, CHAR(13), ''), CHAR(10), '')
from orders, orderproducts
where orders.id=orderproducts.order_id