Untitled query #38135

SQL

USE wikidatawiki_p;

SELECT count(page.page_title) as pages, DATE_FORMAT(revision.rev_timestamp, '%Y-%m-%d') AS date
FROM page
JOIN revision ON page.page_id=revision.rev_page
JOIN pagelinks ON page.page_id=pagelinks.pl_from
WHERE page.page_namespace=146
	AND revision.rev_parent_id=0 # No parent rev = page creation
    AND pagelinks.pl_title="Q9027" # Swedish
GROUP BY date
UNION ALL
SELECT count(page.page_title) as pagesD
FROM page
JOIN revision ON page.page_id=revision.rev_page
JOIN pagelinks ON page.page_id=pagelinks.pl_from
WHERE page.page_namespace=146
	AND revision.rev_parent_id=0 # No parent rev = page creation
    AND pagelinks.pl_title="Q9035" # Danish

ORDER BY date
SQL

Checking query status...
