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