artikelen waar Februari en Edoderoo aan bewerkt hebben - Quarry

Fork of Untitled query #11441 by Natuur12

This query is marked as a draft This query has been published by Edoderoo.

SQL

USE nlwiki_p;
SELECT DISTINCT page_title,
page_namespace
FROM revision
INNER JOIN page
ON rev_page = page_id
WHERE rev_user_text = "Februari"
AND page_title IN (
SELECT DISTINCT page_title AS pageraw
FROM revision
INNER JOIN page
ON rev_page = page_id
WHERE rev_user_text = "Edoderoo")
;

AخA
 
USE nlwiki_p;SELECT DISTINCT page_title,page_namespaceFROM revisionINNER JOIN pageON rev_page = page_idWHERE rev_user_text = "Februari"AND page_title IN (SELECT DISTINCT page_title AS pagerawFROM revisionINNER JOIN pageON rev_page = page_idWHERE rev_user_text = "Edoderoo");

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...