Untitled query #78555

SQL

SELECT p.page_id, p.page_title, r.rev_id
FROM revision AS r, linktarget AS lt, page AS p

      #magic three lines give only those article pages which don't have a talk page 
      LEFT OUTER JOIN page AS p2 ON
      p.page_title = p2.page_title AND p.page_namespace = 0 AND  p2.page_namespace = 1
      WHERE p2.page_title IS NULL AND

      p.page_is_redirect = 0 AND
      
      #get a time-slice
      p.page_latest = r.rev_id AND r.rev_timestamp > 20180000000000 AND r.rev_timestamp < 20190000000000
      
      # get the linktarget of the templatelink
      #tl.tl_from = p.page_id AND
      #tl.tl_from_namespace = p.page_namespace AND
      #tl.tl_target_id = lt.lt_id AND
      
      #p.page_title = "Camp_Elmore"


LIMIT 10
SQL

Checking query status...
