redenumiri/redirecturi necesare p/u articole d/e localități

SQL

/*use rowiki_p;
select p.page_title, CONCAT("/",ll_title)
from page p, page_props, langlinks, wikidatawiki_p.page wdp
#join categorylinks on page_id=cl_from 
JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id 
AND (wdpl.pl_title = 'Q747074' AND wdpl.pl_namespace = 0)
where p.page_namespace=0 and pp_page=p.page_id AND pp_propname = 'wikibase_item' 
and p.page_id=ll_from and ll_lang="it"
AND wdp.page_title = pp_value AND wdp.page_namespace = 0 #and ll_title like "%,%" and page_title like "%,%"
#and cl_to like "Comune_din_provincia%"
AND ll_title != REPLACE(p.page_title, '_', ' ')
GROUP BY p.page_id*/
/*
use rowiki_p;
select p.page_title, CONCAT("/",ll_title)
from page p, page_props, langlinks, wikidatawiki_p.page wdp
#join categorylinks on page_id=cl_from 
JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id 
AND (wdpl.pl_title = 'Q484170' AND wdpl.pl_namespace = 0)
where p.page_namespace=0 and pp_page=p.page_id AND pp_propname = 'wikibase_item' 
and p.page_id=ll_from and ll_lang="fr"
AND wdp.page_title = pp_value AND wdp.page_namespace = 0 #and ll_title like "%,%" and page_title like "%,%"
#and cl_to like "Comune_din_provincia%"
AND ll_title != REPLACE(p.page_title, '_', ' ')
GROUP BY p.page_id
*/
#/*
use rowiki_p;
select page_title, CONCAT("/",ll_title)#ll_title
from page
join langlinks on page_id=ll_from and page_namespace=0 and ll_lang="en"
join categorylinks on page_id=cl_from 
join categorylinks c1 on page_id=c1.cl_from
join categorylinks c2 on page_id=c2.cl_from
where c1.cl_to = "Cioturi_legate_de_geografia_Algeriei" and c2.cl_to like "Comune%"
#where cl_to = "Localități_în_Slovenia" #and ll_title like "%,%" and page_title like "%,%"
and ll_title != REPLACE(page_title, '_', ' ')
group by ll_from
#*/
SQL

Checking query status...
