SELECT * FROM ezcontentclass_classgroup e where not exists( select * from ezcontentclass c where c.id=e.contentclass_id and c.version=e.contentclass_version);

DELETE FROM ezcontentclass_classgroup where not exists( select * from ezcontentclass c where c.id=contentclass_id and c.version=contentclass_version);