SQL
AخA
use eswiki_p;
select concat('Artículo:',p.page_title) as TITLE, cl_to as CATEGORY
from categorylinks
inner join page cat on cat.page_namespace=10
and cat.page_title=cl_to
inner join page p on p.page_id=cl_from
where p.page_id=categorylinks.cl_from
and cl_to not like 'User_%'
AND .categorylinks.cl_to = "Wikiviajes_por_Venezuela_2014"
#and not exists(select * from page_props where pp_page=cat.page_id and pp_propname='Wikiviajes_por_Venezuela_2014')
order by cl_to;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.