So sollte es funktionieren:
SQL-Code:
SELECT a.voting_text, count(a.voting_ip) AS ergebnis FROM
(
select
distinct( c.voting_ip), max(c.voting_text) as voting_text
from
data b
join data c on c.voting_ip = b.voting_ip
group by
c.voting_ip) a
group by a.voting_text;