Untitled query #10019

SQL

SELECT DISTINCT p.page_id FROM page p
JOIN revision r ON r.rev_page = p.page_id AND r.rev_user = 4906524
JOIN templatelinks t1 ON t1.tl_from = p.page_id AND t1.tl_title = 'Information' AND t1.tl_namespace = 10
LEFT JOIN templatelinks t2 ON t2.tl_from = p.page_id AND t2.tl_title IN ('PD-self', 'Self') AND t2.tl_namespace = 10
WHERE p.page_namespace = 6
AND t2.tl_from IS NULL
AND r.rev_comment = 'adding {{Information}}; adding  using [[Wikipedia:FurMe|FurMe]]'

AخA
 
SELECT DISTINCT p.page_id FROM page pJOIN revision r ON r.rev_page = p.page_id AND r.rev_user = 4906524JOIN templatelinks t1 ON t1.tl_from = p.page_id AND t1.tl_title = 'Information' AND t1.tl_namespace = 10LEFT JOIN templatelinks t2 ON t2.tl_from = p.page_id AND t2.tl_title IN ('PD-self', 'Self') AND t2.tl_namespace = 10WHERE p.page_namespace = 6AND t2.tl_from IS NULLAND r.rev_comment = 'adding {{Information}}; adding  using [[Wikipedia:FurMe|FurMe]]'

SQL

Checking query status...