Delete unused strings from WPML

Categories: Wordpress, CMS

I noticed that on one of my sites the WPML plugin created a very large database table so I sought for solutions to reduce it by removing unused translation strings.

These two SQL queries did the trick:

DELETE FROM `wp_icl_strings` WHERE status = 0;
DELETE FROM wp_icl_strings WHERE context='jetpack';

The second is needed only if Jetpack is used.