Untitled query #71177

SQL

select langlinks.*,page.page_title
from langlinks
inner join page on page.page_id = langlinks.ll_from
where ll_lang in ("en") and page.page_namespace in (0)
limit 10;

/*
select *
from logging 
where log_type = "delete" and log_action = "delete" and log_namespace = 0
limit 10;
*/


/*
select * from archive
where ar_namespace = 0
and ar_title like '%"""المملكة_العربية_السعودية"""%'
limit 10;
*/

/*
select * from page
where page_namespace = 0
and page_title like '%"""المملكة_العربية_السعودية"""%'
limit 10;
*/


SELECT *
FROM logging
WHERE log_type = "delete"
AND log_action = "delete"
AND log_namespace = 0
AND NOT EXISTS (
SELECT 1
FROM page
WHERE page.page_title = logging.log_title
AND page.page_namespace = logging.log_namespace
)
AND EXISTS (
SELECT 1
FROM archive
WHERE archive.ar_title = logging.log_title
AND archive.ar_namespace = logging.log_namespace
)
LIMIT 10000;
SQL

Checking query status...
