Untitled query #24978

SQL

# The text of the page itself is stored in the text table. 
#To retrieve the text of an article, MediaWiki first searches 
#for page_title in the page table. Then, page_latest is used 
#to search the revision table for rev_id, and rev_text_id is 
#obtained in the process. The value obtained for rev_text_id 
#is used to search for old_id in the text table to retrieve the text. 
SELECT p.page_title, r.rev_text_id
FROM svwiki_p.revision r
JOIN svwiki_p.externallinks el ON r.rev_page = el.el_from
JOIN svwiki_p.page p ON r.rev_id = p.page_latest
#JOIN svwiki_p.text t ON r.rev_text_id = t.old_id
where el_index like "%sverigesradio.se/sida/artikel.aspx%"
#where t.old_text like "%<ref>[http://sverigesradio.se%"
limit 10
SQL

Checking query status...
