Categories with only excluded parents

SQL

select concat(rev_id,","), rev_timestamp from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported"
and  (rev_id like "3107__" or (rev_id like "3108__" and rev_id != "310892") -- Happy-melon
      or rev_id="405302" -- P858Snake
      or (rev_id like "4830__" and rev_id != "483091") -- Varnent
      or rev_id = "540945" -- Krinkle
      or (rev_id = "791355" or rev_id="791354") -- Dantman
      or (rev_id="1072405") -- Quiddity
      or (rev_id like "1860___" and rev_id != "1860100") -- Hashar
      or (rev_id="2059386") -- BDavis (WMF)
      or (rev_id like "3688___") -- Minorax
;
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and  (rev_id like "3107__" or (rev_id like "3108__" and rev_id != "310892"));
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and rev_id="405302";
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and  (rev_id like "4830__" and rev_id != "483091");
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and rev_id = "540945";
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and (rev_id = "791355" or rev_id="791354");
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and (rev_id="1072405");
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and (rev_id like "1860___" and rev_id != "1860100");
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and rev_id="2059386";
select count(*) from revision join page on rev_page=page_id where page_namespace=10 and page_title="Documentation/imported" and  (rev_id like "3688___"); -- Minorax
SQL

Checking query status...
