Hello community,

I'm working on a website I didn't make and I'm tryin to clean it up right now.
The previous developper went crazy and created hundreds of extrafields. I'm pretty sure many are not used and I'm trying to find a way to know which one they are. I went to the database and try a SQL query but I don't really know what to look for.
I'm not really good at SQL either.

Do you think there is a quicker way to find the unused extrafields ?

Hello there,

The extrafields are stored in the #__k2_items table in JSON format, if an id is unused, then you can delete it (keep a backup just in case)