SELECT COUNT(*) AS article_count
FROM (
SELECT
page_title
FROM page
... |
1 year ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(*) AS article_count
FROM (
... |
1 year ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(*) AS article_count
FROM (
... |
1 year ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(*) AS article_count
FROM (
... |
1 year ago |
SELECT
a.actor_name, COUNT(*) as count
FROM
page p, revision rf,... |
1 year ago |