SQL
AخA
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;*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.