Ldorfman draft 1

SQL

use hewiki_p;
select replace(page_title, "_", " ") as article, el_index as address from page join externallinks
on page_id = el_from
where el_index like "%upload%"
and el_index like "%wikipedia%"
and not 
(el_index like "%.ogg" or
 el_index like "%.wav" or
 el_index like "%.mp3" or
 el_index like "%.oga" or
 el_index like "%.mid" or
 el_index like "%.ogv" or
 el_index like "%Key_Facts_wikipedia_Nov_2011.pdf")
and page_namespace = 0;
select replace(page_title, "_", " ") as article, el_index as address from page join externallinks
on page_id = el_from
where el_index like "%upload%"
and el_index like "%wikipedia%"
and
(el_index like "%.ogg" or
 el_index like "%.wav" or
 el_index like "%.mp3" or
 el_index like "%.oga" or
 el_index like "%.mid" or
 el_index like "%.ogv")
and page_namespace = 0
SQL

Checking query status...
