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 logging.*
FROM logging

# not found here
LEFT JOIN page
ON page.page_title = logging.log_title
AND page.page_namespace = logging.log_namespace
AND page.page_title IS NULL
# found here 
INNER JOIN archive
ON archive.ar_title = logging.log_title
AND archive.ar_namespace = logging.log_namespace

WHERE logging.log_type = "delete"
AND logging.log_action = "delete"
AND logging.log_namespace = 0
and logging.log_title like "ب%"
LIMIT 10;
SQL

Checking query status...
