nothing - test

SELECT entry_name, COUNT(DISTINCT tp_name) AS num_use
FROM s51071__templatetiger_p.lvwiki_para
WHERE tp_name LIKE '% infokaste'
GROUP BY entry_name
ORDER BY num_use
limit 100;

SQL

use arwiki_p;
SELECT concat('* [[Template:',p.page_title,']]')
from page p
where p.page_id in (SELECT  eu_page_id
					from wbc_entity_usage wb
					GROUP BY eu_page_id)
and p.page_title not like "%/%"
#p.page_title like "Izmeklēti_notikumi%"
and p.page_namespace=10 and p.page_is_redirect=0# and p.page_id not in (select cl_from
												#				from categorylinks
												#				where cl_to="Nozīmju_atdalīšana")
and p.page_id not in (select ll_from from langlinks ll )
order by p.page_title asc
#limit 800;
/*
use lvwiki_p;
SELECT
  *
FROM pagelinks pl
join page p ON pl.pl_title = p.page_title
join wbc_entity_usage wb on p.page_id = wb.eu_page_id
#JOIN pagelinks pl ON pl.pl_from = p.page_id
WHERE  pl.pl_namespace = 0 AND p.page_namespace=0 and
pl.pl_from = 290249
GROUP BY eu_page_id
limit 10;
*/

SQL

Checking query status...