Код: Выделить всё
SELECT * FROM `product` WHERE `name`<> '' and `name` IN (SELECT `name` FROM `product` GROUP BY `name` HAVING count(*)>1) LIMIT 9999
Код: Выделить всё
SELECT * FROM `product` WHERE `name`<> '' and `name` IN (SELECT `name` FROM `product` GROUP BY `name` HAVING count(*)>1) LIMIT 9999