Untitled query #39767

SQL

use plwikisource_p;
/*select s.slot_revision_id, count(s.slot_content_id) as ss from revision r left join slots s on s.slot_revision_id = r.rev_id where rev_actor=3 group by s.slot_content_id having ss > 1 order by ss desc;*/
select count(r.rev_id), s.slot_revision_id, count(s.slot_content_id) as ss from revision r left join slots s on s.slot_revision_id = r.rev_id where rev_actor=3 group by s.slot_content_id having ss > 1 order by ss desc;
/*select *, s.slot_content_id, count(s.slot_content_id) as ss from revision r left join slots s on s.slot_revision_id = r.rev_id where rev_actor=3 group by s.slot_content_id order by ss desc limit 10;*/
SQL

Checking query status...
