This query is marked as a draft
This query has been published
use metawiki_p; select SUBSTRING_INDEX(page_title, ':', 1) as prefix, -- SUBSTRING(page_title, 0, LOCATE(":",page_title)) as prefix, count(*) as occurences from page where page_namespace = 0 and page_title like "%:%" group by prefix order by occurences desc
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in