Untitled query #78952

SQL

SELECT p.page_title, r.rev_timestamp
FROM page AS p
INNER JOIN revision AS r ON p.page_id = r.rev_page
INNER JOIN templatelinks ON p.page_id = templatelinks.tl_from
INNER JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
INNER JOIN pagelinks AS red_pagelinks ON red_pagelinks.pl_from = page.page_id
WHERE p.page_is_redirect = 0
AND p.page_namespace = 0
AND r.rev_id = 0
AND r.rev_timestamp > DATE_SUB(NOW(), INTERVAL 1 DAY)
AND red_pagelinks.pl_title NOT IN (
    SELECT red_page.page_title
    FROM page AS red_page
WHERE red_page.page_namespace = 0
)
GROUP BY p.page_title
ORDER BY r.rev_timestamp DESC
LIMIT 100
SQL

Checking query status...
