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