When performing the following query on a small test database (100 records), MySQL (phpMyAdmin) returns the number of rows as expected:
SELECT ReportedDate
FROM table
WHERE ReportedDate IN (
SELECT ReportedDate
FROM table
GROUP BY ReportedDate
HAVING count(*) > 1
ORDER BY ugid, ReportedDate
)
However when I perform the same query on the actual table (1.5 million records), MySQL returns all rows as if it would with a SELECT * FROM table
query.
Thank you for any kind of help