AMO:Developers/Queries

Useful SQL Queries

Add-on Count

Retrieves the number of add-ons that support Firefox, are public, sandboxed, or nominated, and are active.

 select count(*) from addons inner join versions on versions.id=(select id from versions where versions.addon_id=addons.id order by id desc limit 1) inner join applications_versions on applications_versions.version_id=versions.id where addons.inactive=0 and addons.status in (1,3,4) and applications_versions.application_id=1;