Untitled query #69099

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=0 and lt.lt_title in ("Eliteprospects")
    and page_title in ('Atte_Tiitinen')

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

Checking query status...
