Untitled query #50987

SQL

USE itwikiquote_p;
SELECT CONCAT('# [[{{ns:', disc.page_namespace, '}}:', disc.page_title, ']] (', DATE_FORMAT(rev_timestamp, '%e %b %Y, %H:%i'), ')')
  FROM page AS disc
  JOIN revision ON disc.page_latest = rev_id
  WHERE disc.page_namespace IN (1,5,7,9,11,13,15,101,103)
    AND disc.page_title NOT LIKE '%/da_fare'
    AND disc.page_title NOT REGEXP './[Aa]rchiv.'
    AND NOT EXISTS (
      SELECT *
      FROM page
      WHERE page_title = disc.page_title
			AND page_namespace = disc.page_namespace - 1)
  ORDER BY disc.page_namespace, rev_timestamp, disc.page_title;
SQL

Checking query status...
