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, count(*)
FROM externallinks join page on page_id = el_from

where (el_to rlike 'en.wikip' OR el_to rlike 'es.wikip' OR el_to rlike 'de.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...
