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 count(*)
FROM logging
WHERE log_type = "delete"
AND log_action = "delete"
AND log_namespace = 0
#and log_title like "ب%"
and log_timestamp >= (NOW() - INTERVAL 1 MONTH)
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
)
SQL

Checking query status...
