Untitled query #55446

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 up1.actor_user, up2.actor_user, count(1) val FROM upx up1, upx up2
WHERE up1.rev_page = up2.rev_page and up1.actor_user >= up2.actor_user 
GROUP BY 1,2
SQL

Checking query status...
