#1

SELECT ar_namespace, ar_title, ar_user, ar_page_id

#2

FROM archive;

#3

INNER JOIN commonswiki_p.categorylinks cl ON p.page_id = cl.cl_from 

#4

INNER JOIN commonswiki_p.revision r ON p.page_id = r.rev_page 

#5

WHERE p.page_namespace = 6 

#6

AND cl.cl_to IN ("Wikiviajes_por_Venezuela_2014") 

#7

AND r.rev_parent_id = 0;