test wikidata - Quarry

SQL

USE rowiki_p;
#select * from page /*join categorylinks*/ where page_id = "39407";
#select * from category /*join categorylinks*/ where cat_title = "Juan Albín";
/*
show columns from category;
show columns from categorylinks;*/
SELECT *
FROM page join categorylinks ON cl_from = page_id where page_title = "Juan_Albín";
/*JOIN category
ON cat_title = page_title AND page_namespace = 14/*
left JOIN templatelinks
ON tl_from = page_id
and tl_namespace = 10
WHERE tl_title not IN ("redcat", "RedCat", "redirect_categorie") 
AND cat_pages = 0;*/#*/*/
SQL

Checking query status...
