Untitled query #73018

SQL

/*
select distinct concat("[[:",page0.page_title,"]]"),concat("[[:",page1.page_title,"]]") from pagelinks
inner join page page0 on pagelinks.pl_title = page0.page_title
inner join page page1 on pagelinks.pl_from = page1.page_id
where page1.page_is_redirect = 1 and page0.page_title in (
	select pl_title   from pagelinks
	where pl_from in (969509) and pl_namespace in (0)
)

select distinct page0.page_title,page1.page_title from pagelinks
inner join page page0 on pagelinks.pl_title = page0.page_title
inner join page page1 on pagelinks.pl_from = page1.page_id
where page1.page_is_redirect = 1 and page0.page_title in (
	select pl_title   from pagelinks
	where pl_from in (9175676) and pl_namespace in (0)
)
/*
select pl_title   from pagelinks
where pl_from in (969509) and pl_namespace in (0)
order by pl_title
*/

/*
select distinct pl_title   from pagelinks
where pl_from in (9175676)
*/
/*
select count(distinct page.page_id),page.page_namespace from pagelinks 
inner join page on pagelinks.pl_from =  page.page_id
where pl_title in (
  select distinct pl_title   from pagelinks where pl_from in (9175676)
) and pl_namespace = 0
group by page.page_namespace
*/


select distinct page.page_title,GROUP_CONCAT(DISTINCT actor.pl_title) from pagelinks 
inner join page on pagelinks.pl_from =  page.page_id
where pl_title in (
  select distinct pl_title from pagelinks where pl_from in (9175676)
) and pl_namespace = 0
and page.page_namespace = 0 
and page.page_title not in (  select distinct pl_title from pagelinks where pl_from in (9175676))
and page.page_title not in ("لوقا/ملعب_28")

#group by page.page_namespace
SQL

Checking query status...
