SQL to output which approved & undisabled apps have at least one version that requires flash

gistfile1.sql

select addons.id from 
(SELECT * FROM addons WHERE status IN (2, 4, 13, 16) AND inactive = 0) AS addons
JOIN versions ON (versions.addon_id=addons.id)
JOIN (select * FROM files where uses_flash=1) AS files ON (files.version_id=versions.id)
GROUP BY addons.id;