se puede meter group by limit y order by

[aldo_rengo]

asi no me da.

lo resolvi , asi

Código MySQL:

select c,count(*)
from
(select category_id c
from item 
where category_id != 0 and qty >0
order by price ASC
limit 0,16) t
group by c