ويكيبيديا العربية

SQL

select concat("Module:",page_title),page_len from page 
join revision on rev_page=page_id and rev_parent_id=0
where page_namespace=828 
and page_title not like "Adjacent_stations/%"
and page_title not like "Location_map/data/%"
and page_title not like "User:%"
and page_title not like "Sandbox/%"
and page_title not like "%/sandbox"
-- I really should clean these up someday, but never have the energy to.
and page_title not like "Road_data/%"
and page_title not like "Infobox_road/%"
and page_is_redirect=0
and page_content_model!="wikitext"
order by rev_timestamp desc;
SQL

Checking query status...
