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 ("ar") and page.page_namespace in (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
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
)
*/

SELECT wdentity.page_title, GROUP_CONCAT(DISTINCT wips.ips_site_id SEPARATOR ", ") AS interwikis
FROM revision_userindex 
JOIN page wdentity ON rev_page=wdentity.page_id
LEFT JOIN wb_items_per_site AS wips ON 
wips.ips_item_id=REPLACE(wdentity.page_title,"Q","") 
JOIN comment_revision on rev_comment_id=comment_id AND comment_text LIKE 'Page on [enwiki] deleted%'
GROUP BY wdentity.page_title
limit 10
SQL

Checking query status...
