Untitled query #87728

SQL

with pia_titles as (
select 
p.page_title
from linktarget lt
join templatelinks tl on tl.tl_target_id = lt.lt_id 
join page p on p.page_id = tl.tl_from
where lt.lt_namespace = 10 -- Template
and lt.lt_title in ("ArbCom_Arab-Israeli_enforcement", "Contentious_topics/Arab-Israeli_talk_notice")
and page_namespace = 1
union
select page_title
from page
join categorylinks israel on page_id = israel.cl_from and israel.cl_to = "WikiProject_Israel_articles"
join categorylinks palestine on page_id = palestine.cl_from and palestine.cl_to = "WikiProject_Palestine_articles"
where 
page_namespace = 1
),
pia as (
select p1.page_id, p1.page_title, p1.page_namespace
from 
pia_titles pt
join page p1 on p1.page_title = pt.page_title and p1.page_namespace = 0 
)
select
concat('[[',convert(replace(p.page_title, '_',' ') using utf8mb4),']]') page_title
from page p 
join pia on p.page_title = pia.page_title
where
p.page_namespace = 0 and p.page_is_redirect = 0
and convert(p.page_title using utf8mb4) like '%attack%'
order by 1;
SQL

Checking query status...
