Query Run
SELECT LEFT(cl_sortkey, 6) AS prefix, COUNT(*) AS count FROM... 8 years ago
SELECT SUBSTR(cl_sortkey, 1, 6) AS prefix, COUNT(*) AS count FROM... 8 years ago
SELECT SUBSTR(cl_sortkey, 1, 6) AS prefix, COUNT(*) AS count FROM... 8 years ago
SELECT cl_sortkey, COUNT(*) AS count FROM categorylinks GROUP BY... 8 years ago