| USE enwiki_p;
SELECT year_created, COUNT(*) FROM (
SELECT... |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM (
SELECT MIN(rev_timestamp),... |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM (
SELECT MIN(rev_timestamp),... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp), SUBSTR(rev_timestamp, 1, 4) AS... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp), SUBSTR(rev_timestamp, 1, 4) AS... |
5 years ago |
| USE enwiki_p;
SELECT page_id, SUBSTR(MIN(rev_timestamp), 1, 4) AS... |
5 years ago |
| USE enwiki_p;
SELECT page_id, SUBSTR(MIN(rev_timestamp), 1, 4) AS... |
5 years ago |
| USE enwiki_p;
SELECT page_id, SUBSTR(MIN(rev_timestamp), 1, 4) AS... |
5 years ago |
| USE enwiki_p;
SELECT SUBSTR(MIN(rev_timestamp), 1, 4) as year_created,... |
5 years ago |
| USE enwiki_p;
SELECT SUBSTR(MIN(rev_timestamp), 1, 4) as year_created,... |
5 years ago |
| USE enwiki_p;
SELECT SUBSTR(MIN(rev_timestamp) FOR 4) as year_created,... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp), SUBSTR(MIN(rev_timestamp) FOR 4) as... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp), page_title
FROM page
INNER JOIN... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp)
FROM page
INNER JOIN revision ON... |
5 years ago |
| USE enwiki_p;
SELECT *
FROM page
INNER JOIN revision ON rev_page =... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp)
FROM page
INNER JOIN revision ON... |
5 years ago |
| USE enwiki_p;
SELECT MIN(rev_timestamp)
FROM page
INNER JOIN revision ON... |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*)
FROM page
WHERE
page_namespace = 10
AND... |
5 years ago |
| USE enwiki_p;
SELECT *
FROM page
WHERE
page_namespace = 10
AND... |
5 years ago |
