SQL
AخA
select CONCAT( '# ' , /*, el_to_domain_index , el_to_path , */ GROUP_CONCAT( ' {{Bearbeiten|',page_title ,'|text=',page_title,'}}' ) ) as output , el_to_domain_index
FROM externallinks
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 and el_to_domain_index like '%\%%' and length(el_to_domain_index)>5 and (el_to_domain_index like 'http%')
group by el_to_domain_index
ORDER BY length(el_to_domain_index) desc
;
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.