Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
22 lines (21 sloc) 850 Bytes
repack_query: >
SELECT DISTINCT(a.id), a.average_daily_users, a.slug, f.id, f.created, f.filename, f.jetpack_version
FROM addons a
INNER JOIN `versions` as v ON v.addon_id = a.id
INNER JOIN `files` as f ON f.version_id = v.id
WHERE v.`id` = a.`current_version`
AND a.inactive = 0
AND a.status NOT IN (0, 5,10)
AND f.jetpack_version NOT IN ( )
ORDER BY a.average_daily_users DESC
repack_query_limit: >
SELECT DISTINCT(a.id), a.average_daily_users, a.slug, f.id, f.created, f.filename, f.jetpack_version
FROM addons a
INNER JOIN `versions` as v ON v.addon_id = a.id
INNER JOIN `files` as f ON f.version_id = v.id
WHERE v.`id` = a.`current_version`
AND a.inactive = 0
AND a.status NOT IN (0, 5,10)
AND f.jetpack_version NOT IN ( )
ORDER BY a.average_daily_users DESC
LIMIT 5