for harvesttemplates

SQL

SELECT enp.page_title
FROM page enp
join externallinks enel on enel.el_from = enp.page_id
join templatelinks tpl on enp.page_id=tpl.tl_from
join linktarget lt ON tpl.tl_target_id = lt.lt_id

WHERE enp.page_namespace = 0 AND enp.page_is_redirect=0 -- and (enel.el_index LIKE 'https://com.eliteprospects%' or enel.el_index LIKE 'http://com.eliteprospects%')
	
    and lt_namespace = 10 and tl_from_namespace=6 and lt.lt_title in ("Ice_hockey_stats")




group by enp.page_title
having count(enel.el_index)=1
limit 10
SQL

Checking query status...
