Nonstandard user categories

SQL

select page_title, el_to from externallinks join page on page_id=el_from where page_namespace=0 and (
  el_index like "http://org.wikimedia.upload./%"
  and el_index not like "http://org.wikimedia.upload./wikipedia/commons/%"
    and el_index not like "http://org.wikimedia.upload./wikipedia/en/%"
);
select page_title, el_to from externallinks join page on page_id=el_from where page_namespace=0 and (
 el_index like "http://org.wikimedia.upload./wikipedia/en/%"
)
select page_title, el_to from externallinks join page on page_id=el_from where page_namespace=0 and (
 el_index like "http://org.wikimedia.upload./wikipedia/commons/%"
)
SQL

Checking query status...
