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 |