vikilere bağlantılar

SQL

USE trwiki_p;
SET @N = 1;
SELECT page_title, concat("tr.wikipedia.org/wiki?curid=",page_id) as url, substring(el_to,1,50) as elto50, page_latest, rev_timestamp, count(*)
FROM externallinks join page on page_id = el_from
join revision_userindex on rev_id = page_latest
where (el_to rlike 'n.wikip' OR el_to rlike 's.wikip' OR el_to rlike 'e.wikip' OR el_to rlike 't.wikip') and page_namespace = 0 
and el_to not rlike 'wikisky'  and el_to not rlike 'wikimap'
and el_to not rlike 'irc.'
and el_to not rlike 'commons.w'
group by 1 having count(*) <= @N
order by count(*) asc, page_latest
#limit 100
;
SQL

Checking query status...
