SQL
AخA
use lvwiki_p;
SELECT
LOWER(CONVERT(page_title USING utf8)),
GROUP_CONCAT(concat("[[:Attēls:",REPLACE(page_title, '_', ' '),"]]") SEPARATOR '{{!}}{{!}}')#,
#COUNT(*)
FROM page
WHERE page_namespace = 6
GROUP BY 1
HAVING COUNT(*) > 1
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.