| USE enwiki_p;
SET @year_ago = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT... |
5 years ago |
| USE enwiki_p;
SET @year_ago = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT... |
5 years ago |
| USE enwiki_p;
SET @year_ago = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT... |
5 years ago |
| SELECT page_title, page_len, COUNT(DISTINCT afl_id) AS afl_count
FROM... |
5 years ago |
| SELECT page_title, page_len, COUNT(afl_id) AS afl_count
FROM... |
5 years ago |
| SELECT page_title, page_len, COUNT(afl_id) AS afl_count
FROM... |
5 years ago |
| SELECT page_title, cl_to
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON... |
5 years ago |
| SELECT *
FROM enwiki_p.categorylinks
LIMIT 5; |
5 years ago |
| SELECT page_title, cl_to
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON... |
5 years ago |
| SELECT page_title, cl_to
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON... |
5 years ago |
| SELECT page_title, cl_to
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON... |
5 years ago |
| SELECT page_title, cl_to
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON... |
5 years ago |
| SELECT *
FROM geo_tags
WHERE gt_type = 'event'
LIMIT 1; |
5 years ago |
| DESCRIBE geo_tags; |
5 years ago |
| SELECT page_title, page_len, COUNT(*), gt_lat, gt_lon
FROM... |
5 years ago |
| DESCRIBE geo_tags; |
5 years ago |
| SHOW TABLES; |
5 years ago |
| DESCRIBE enwiki_p; |
5 years ago |
