Untitled query #7749

SQL

USE arwiki_p;
SELECT page_title, rev_timestamp, rev_user_text
FROM page
LEFT JOIN langlinks
ON ll_from = page_id
LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = page_id
LEFT JOIN revision
ON rev_page = page_id
LEFT JOIN templatelinks
ON tl_from = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_parent_id = 0
AND ll_title IS NULL
AND pp_value IS NULL

AND NOT EXISTS
(SELECT * FROM templatelinks AS tl1
WHERE page_id = tl1.tl_from
AND page_namespace = tl1.tl_from_namespace
AND tl_namespace = 10
AND tl_title LIKE 'توثيق')

GROUP BY page_title
ORDER BY rev_timestamp DESC, page_title ASC;
SQL

Checking query status...
