SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
1 year ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
SELECT
DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
COUNT(log_id) AS... |
2 years ago |
SELECT
page_title,
il_to
FROM page
JOIN imagelinks
ON page_id =... |
2 years ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
LEFT JOIN... |
2 years ago |
SELECT
page_title,
COUNT(*)
FROM revision
JOIN page ON page_id =... |
2 years ago |
SELECT
page_title,
COUNT(*)
FROM revision
JOIN page ON page_id =... |
2 years ago |
SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
2 years ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
2 years ago |
SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE page_len >... |
2 years ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |