Untitled

SELECT COUNT(B.id), B.category_id, SUM(CASE WHEN B.rating = 0 THEN 1 ELSE 0 END) r0, SUM(CASE WHEN B.rating = 1 THEN 1 ELSE 0 END) r1, SUM(CASE WHEN B.rating = 2 THEN 1 ELSE 0 END) r2, SUM(CASE WHEN B.rating = 3 THEN 1 ELSE 0 END) r3, SUM(CASE WHEN B.rating = 4 THEN 1 ELSE 0 END) r4, SUM(CASE WHEN B.rating = 5 THEN 1 ELSE 0 END) r5, SUM(CASE WHEN B.rating IS NULL THEN 1 ELSE 0 END) r FROM book B INNER JOIN store_book SB ON B.id=SB.book_id WHERE B.catalogue_month_id = :catalogueMonthId AND SB.store_id = :storeId AND SB.top_up > 0 AND B.category_id IN(:categoryIds) GROUP BY B.category_id;