Untitled query #49484

SQL

SELECT actor.actor_name, COUNT(*) AS count
FROM page

JOIN page_props AS forms
ON forms.pp_page = page.page_id

JOIN page_props AS senses
ON forms.pp_page = senses.pp_page

JOIN page_props AS statements
ON forms.pp_page = statements.pp_page

JOIN revision_actor_temp ON page.page_latest = revision_actor_temp.revactor_rev
JOIN actor ON revision_actor_temp.revactor_actor = actor.actor_id


WHERE forms.pp_propname = 'wbl-forms'
AND forms.pp_sortkey = 0

AND senses.pp_propname = 'wbl-senses'
AND senses.pp_sortkey = 0

AND statements.pp_propname = 'wb-claims'
AND statements.pp_sortkey = 0

GROUP BY actor.actor_name
ORDER BY count DESC;
SQL

Checking query status...
