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") 
      or rev_id="405302"
      or (rev_id like "4830__" and rev_id != "483091")
      
      or (rev_id like "1860___" and rev_id != "1860100")
     or (rev_id like "3688___")   or (rev_id = "540945" or rev_id = "719355" or rev_id="719354")
     or (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 "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");
SQL

Checking query status...
