| USE enwiki_p;
SELECT
LEFT(
img_name,
CASE
WHEN img_name LIKE... |
3 years ago |
| USE enwiki_p;
SELECT
LEFT(
img_name,
CASE
WHEN img_name LIKE... |
3 years ago |
| USE enwiki_p;
SELECT
LEFT(
img_name,
CASE
WHEN img_name LIKE... |
3 years ago |
| USE enwiki_p;
SELECT
DISTINCT LEFT(
img_name,
CASE
WHEN... |
3 years ago |
| USE enwiki_p;
SELECT
DISTINCT LEFT(
img_name,
CASE
WHEN... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LEFT(img_name, 3), COUNT(*)
FROM image
GROUP... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LEFT(img_name, 2), COUNT(*)
FROM image
GROUP... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LOWER(CONVERT(LEFT(img_name, 2) USING utf8)),... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LOWER(CONVERT(LEFT(img_name, 2) USING... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LEFT(img_name, 2)
FROM image
ORDER BY LEFT(img_name, 2) |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LOWER(LEFT(img_name, 2))
FROM image
ORDER BY... |
3 years ago |
| USE enwiki_p;
SELECT DISTINCT LOWER(LEFT(img_title, 2))
FROM image
ORDER BY... |
3 years ago |
