Вложенные sql запросы
SELECT
table2.kol2 AS quantity,
table2.item_id AS item_id,
items.name AS name
FROM (
SELECT COUNT(*) AS kol2, `item_id`
FROM (
SELECT COUNT(*) AS kol, `user_id`, `item_id`
FROM `voices`
GROUP BY `user_id`
HAVING kol = 1
) AS table1
GROUP BY `item_id`
HAVING kol2 > 2
ORDER BY kol2 DESC
) AS table2
LEFT JOIN items
ON items.ID = table2.item_id