Finding multiple entries in navicat

[SBste01]

Hey
I'm currently redoing my catalogue and was wondering if there was a query to show up all furni which has been multiplied (i.e. the same furni in different pages). Is there a query for this, or will I have to go through the pages manually?
Thanks.

 

[JayC]

For Specific Furni:

SELECT * FROM `catalog_items` WHERE `item_id` = 'ID'

Find ALL Repeats:

SELECT *, COUNT(*) As NumOfTimes FROM catalog_items GROUP BY item_id HAVING COUNT(*) > 1

 

[SBste01]

For Specific Furni:

SELECT * FROM `catalog_items` WHERE `item_id` = 'ID'

Find ALL Repeats:

SELECT *, COUNT(*) As NumOfTimes FROM catalog_items GROUP BY item_id HAVING COUNT(*) > 1

You must be registered for see images attach

How do I view the multiple furni as it is only showing one entry of it?

 

[JayC]

You must be registered for see images attach

How do I view the multiple furni as it is only showing one entry of it?

Scroll all the way to the right. It shows that there is x entries of it , it's selecting one row. Open a other query and run the specific furni query to get all x results and delete the ones you wish to delete