Q:

MySQL GROUP BY HAVING returns nothing

I have many categories with the same name and parent in my Opencart database (duplicates). Need to find all of them. That's my query:
SELECT *
FROM
     (SELECT `oc_category`.category_id,
             `oc_category`.parent_id,
             `oc_category_description`.name
      FROM   `oc_category`, `oc_category_description`
      WHERE  `oc_category`.category_id = `oc_category_description`.category_id
     ) cats
GROUP BY `cats`.parent_id, `cats`.name
HAVING COUNT(*) > 1

But this query returns nothing. Please tell me if I'm wrong.

A:

No problem with the query, it does work, check this out:
http://sqlfiddle.com/#!9/3d170/4
Please fiddle with that and populate it with the data which produces no records, and add it to your question.

