https://bugzilla.wikimedia.org/show_bug.cgi?id=33409
--- Comment #7 from Malafaya <[email protected]> --- Regarding Bug 32404 (marked as duplicate of this one): New occurrences of non-zero namespace pages link appearing as zero namespace in ptwiktionary dump of 24th Jan 2013: SELECT CONCAT('# [[', pl_title, ']] ([[Especial:Whatlinkshere/', pl_title, '|', COUNT(*), ' lig.]])') as linha FROM pagelinks LEFT JOIN page AS pg1 ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title LEFT JOIN page AS pg2 ON pl_from = pg2.page_id WHERE pg1.page_namespace IS NULL AND pl_namespace = 0 AND pg2.page_namespace <> 8 GROUP BY pl_namespace, pl_title ORDER BY COUNT(*) DESC LIMIT 0, 3; (note that pl_namespace = 0) yields: '# [[Usuário:ValJor]] ([[Especial:Whatlinkshere/Usuário:ValJor|4860 lig.]])' '# [[Usuário_Discussão:ValJor]] ([[Especial:Whatlinkshere/Usuário_Discussão:ValJor|4833 lig.]])' '# [[Imagem:Flag_of_Canada.svg]] ([[Especial:Whatlinkshere/Imagem:Flag_of_Canada.svg|1604 lig.]])' First is in namespace User, second in User_Discussion and third in File namespace. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
