explain
select i_id, i_title, a_fname, a_lname, sum(ol_qty)
	from tpcw_order_line as OL,
		tpcw_item as I,
		tpcw_author as A,
		(select o_id from tpcw_orders
			order by o_date desc limit 3333) as O
	where ol_o_id = o_id
	and i_subject = 'COMPUTERS'
	and ol_i_id = i_id
	and i_a_id = a_id
	group by i_id, i_title, a_fname, a_lname
	order by 5 desc limit 50;
