Untitled query #12455

SQL

(SELECT p.page_title, count(ll.ll_lang) AS 'Llengües', GROUP_CONCAT(ll.ll_lang SEPARATOR ', ') AS 'Llistat de llengües'
FROM cawiki_p.page p
LEFT JOIN cawiki_p.langlinks ll ON p.page_id = ll.ll_from
WHERE p.page_namespace = 0 AND p.page_is_redirect <> 1 AND p.page_title IN ("Ada_Castells_Ferrer")
GROUP BY p.page_title)
UNION ALL
(SELECT p.page_title, count(ll.ll_lang) AS 'Llengües', GROUP_CONCAT(ll.ll_lang SEPARATOR ', ') AS 'Llistat de llengües'
FROM cawiki_p.page p
LEFT JOIN cawiki_p.langlinks ll ON p.page_id = ll.ll_from
WHERE p.page_namespace = 0 AND p.page_is_redirect <> 1 AND p.page_title IN (SELECT rd.rd_title
FROM cawiki_p.page p, cawiki_p.redirect rd
WHERE p.page_namespace = 0 AND p.page_is_redirect = 1 AND p.page_id = rd.rd_from AND p.page_title IN ("Ada_Colau"))GROUP BY p.page_title);
SQL

Checking query status...
