DELETe
FROM
qx_site_weather_hour
WHERe
id IN (
SELECt
m.id
FROM
(
SELECt
id
FROM
qx_site_weather_hour A,
( SELECt site_id, date_time FROM qx_site_weather_hour GROUP BY site_id, date_time HAVINg COUNT(site_id) > 1 ) B
WHERe
A.site_id = B.site_id
AND A.date_time = B.date_time
AND A.id NOT IN ( SELECt MIN( id ) AS ID FROM qx_site_weather_hour GROUP BY site_id, date_time HAVINg COUNT(site_id) > 1 )) m
)
