| SELECT u.year, uploads, deletions
FROM (
SELECT year, SUM(uploads) AS... |
2 years ago |
| SELECT u.year, uploads, deletions
FROM (
SELECT year, SUM(uploads) AS... |
2 years ago |
| SELECT year, SUM(uploads) AS uploads FROM (
SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT year, SUM(uploads) AS uploads FROM (
SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT fau.year, fau.uploads AS fu, img.uploads AS iu FROM
(SELECT... |
2 years ago |
| /*SELECT fau.year, fau.uploads, img.uploads FROM
(*/SELECT... |
2 years ago |
| /*SELECT fau.year, fau.uploads, img.uploads FROM
(*/SELECT... |
2 years ago |
| /*SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp,... |
2 years ago |
| /*SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp,... |
2 years ago |
| /*SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp,... |
2 years ago |
| SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT fau.year, fau.uploads, img.uploads FROM
(SELECT LEFT(fa_timestamp, 4)... |
2 years ago |
| SELECT fau.year, fau.uploads + img.uploads AS uploads FROM
(SELECT... |
2 years ago |
| SELECT LEFT(img_timestamp, 4) AS year, COUNT(*) AS uploads FROM image GROUP... |
2 years ago |
| SELECT * FROM image LIMIT 10;
/*SELECT fau.year, uploads, deletions
FROM ( ... |
2 years ago |
| SELECT * FROM oldimage LIMIT 10;
/*SELECT fau.year, uploads, deletions
FROM... |
2 years ago |
| SELECT fau.year, uploads, deletions
FROM ( SELECT... |
2 years ago |
| SELECT LEFT(fa_timestamp, 4) AS year, COUNT(*) AS uploads FROM filearchive... |
2 years ago |
| SELECT COUNT(*) AS uploads FROM filearchive;
SELECT COUNT(*) AS deletions... |
2 years ago |
| SELECT COUNT(*) AS uploads FROM filearchive DESC;
SELECT COUNT(*) AS... |
2 years ago |
| SELECT COUNT(*) AS uploads FROM filearchive GROUP BY uploads DESC;
SELECT... |
2 years ago |
| SELECT * FROM filearchive LIMIT 10;/*
SELECT fa.year, uploads,... |
2 years ago |
| SELECT fa.year, uploads, deletions
FROM (
SELECT
... |
2 years ago |
| SELECT year, uploads, deletions
FROM (
SELECT
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
NULL AS uploads,
... |
2 years ago |
| SELECT *
FROM (
SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
... |
2 years ago |
| /*SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
NULL AS uploads,
... |
2 years ago |
| SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
'' AS uploads,
... |
2 years ago |
| SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
`` AS uploads,
... |
2 years ago |
| SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
SUM(*) AS deletions
FROM... |
2 years ago |
| SELECT
LEFT(fa_deleted_timestamp, 4) AS year,
`` AS uploads,
SUM(*)... |
2 years ago |
| SELECT LEFT(fa_deleted_timestamp, 4) AS year,
'' AS uploads,
SUM(*)... |
2 years ago |
| SELECT fa_name, fa_storage_group, fa_deleted_timestamp, fa_deleted FROM... |
2 years ago |
| SELECT fa_name, fa_storage_group, fa_deleted_timestamp, fa_deleted FROM... |
2 years ago |
| SELECT * FROM filearchive LIMIT 10;/*
SELECT
LEFT(log_timestamp, 4) AS... |
2 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| /*SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| /*SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| /*SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
2 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| SELECT
LEFT(rc_timestamp, 4) AS year,
SUM(log_type='upload' AND... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| (SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS... |
3 years ago |
| SELECT LEFT(log_timestamp, 4) AS `year`, log_type
FROM logging
WHERE... |
3 years ago |
| SELECT
LEFT(log_timestamp, 4) AS `year`,
COUNT(log_type='upload' AND... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `count`
FROM... |
3 years ago |
| /*SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `count`
FROM... |
3 years ago |
| SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `count`
FROM... |
3 years ago |
| USE nlwiki_p;
SELECT LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS... |
3 years ago |
| USE nlwiki_p;
SELECT LEFT(log_timestamp, 4) AS 'year', COUNT(*) AS... |
3 years ago |
| USE nlwiki_p;
SELECT *
FROM logging
WHERE
log_type='delete' AND
... |
3 years ago |
| USE nlwiki_p;
SELECT *
FROM logging
WHERE
log_type='delete'... |
3 years ago |
| USE nlwiki_p;
SELECT *
FROM logging
WHERE
log_namespace=6
LIMIT 10 |
3 years ago |
| USE nlwiki_p;
SELECT page_namespace, page_title
FROM categorylinks cl1,... |
3 years ago |
| USE nlwiki_p;
SELECT page_namespace, page_title
FROM categorylinks cl1,... |
3 years ago |
| USE nlwiki_p;
SELECT page_namespace, page_title
FROM categorylinks cl1,... |
3 years ago |
| USE nlwiki_p;
SELECT page_namespace, page_title
FROM categorylinks cl1,... |
3 years ago |
| USE nlwiki_p;
SELECT page_namespace, page_title
FROM categorylinks cl1,... |
3 years ago |
| USE nlwiki_p;
SELECT cl1.cl_from
FROM categorylinks cl1, categorylinks... |
3 years ago |
| USE nlwiki_p;
SELECT c1.cl_from
FROM categorylinks cl1, categorylinks... |
3 years ago |
| USE nlwiki_p;
SELECT cl_from
FROM categorylinks cl1, categorylinks... |
3 years ago |
