SELECT zp_users.id, zp_users.nick, zp_users.email, COUNT(zp_potraviny.id) as pocet

FROM `zp_potraviny`

LEFT JOIN zp_users ON zp_potraviny.id_zp_users = zp_users.id

WHERE `item_date` >= '1479686400' AND `item_date` <= '1482364799' AND zp_potraviny.id_zp_users != 2976

GROUP BY zp_potraviny.id_zp_users

ORDER BY pocet DESC