Untitled query #55449

SQL

with pageusers as (SELECT rev_page, a.actor_user, up.up_value gender FROM revision r
JOIN categorylinks cl ON cl.cl_to = 'Pornodarsteller' AND r.rev_page = cl.cl_from
JOIN actor a ON a.actor_id = r.rev_actor
LEFT JOIN user_properties up ON up.up_user = a.actor_user and up.up_property = 'gender'
GROUP BY 1, 2, 3),
u as (
  SELECT actor_user, count(1) c FROM pageusers GROUP BY 1 HAVING count(1) >= 10),
upx as (SELECT pu.* FROM pageusers pu
        JOIN u ON pu.actor_user = u.actor_user)
SELECT COUNT(1) FROM upx
SQL

Checking query status...
