Imam jedan kod:
$result = mysqli_query($con,"select *
FROM xlpix_votes
INNER JOIN (
SELECT MAX(ip) AS lastIp, option_id, date, MAX(id) as maxId
FROM xlpix__votes
GROUP BY ip, DATE_FORMAT(DATE(xlpix_votes.date), '%Y-%m-%d')
HAVING COUNT(*) > 1
) duplicate ON duplicate.lastIp = xlpix_votes.ip
where DATE_FORMAT(DATE(xlpix_votes.date), '%Y-%m-%d') = DATE_FORMAT(DATE(duplicate.date), '%Y-%m-%d')
AND maxId > xlpix_votes.id
AND xlpix_votes.ip != 123");
Ovaj kod mi ispravno pokazuje sve duplikate, a ako na početku umjesto SELECT * stavim DELETE, neče da obriše ove duplikate.
Pa gdje je greška?