SELECT concat("[[Dyskusja:",p.page_title,"]]") as title, group_concat(p3.page_title) as linkujace, p2.page_is_new as tylko_ten_szablon

FROM (page p, page p2)

LEFT JOIN linktarget lt ON (lt.lt_title = p.page_title AND lt.lt_namespace = 0)

LEFT JOIN templatelinks t ON (tl_from_namespace = 1 AND tl_target_id = 144219 and tl_from = p2.page_id)

LEFT JOIN pagelinks l ON (pl_from_namespace = 0 AND pl_target_id = lt.lt_id)

LEFT JOIN page_props prop ON (prop.pp_propname = 'disambiguation' AND prop.pp_page = p.page_id)

left join page p3 on(p3.page_id = l.pl_from)

LEFT JOIN page_props prop2 ON (prop2.pp_propname = 'disambiguation' AND prop2.pp_page = p3.page_id)

WHERE

p.page_namespace = 0

AND l.pl_target_id IS NOT NULL

and t.tl_from IS NOT NULL

and p2.page_title = p.page_title

/*and p2.page_is_new = 1*/

AND p.page_is_redirect = 0

AND p3.page_is_redirect = 0

AND prop.pp_value IS NULL

AND prop2.pp_value IS NULL

group by p.page_title

ORDER BY p.page_title ASC;

​

​