Untitled query #18209

SQL

USE trwiki_p;
SET @N= 2;
select pif_user, pif_edits, user_name, user_editcount  from pif_edits join user on pif_user = user_id order by pif_edits desc limit 5;
select page_title, count(*), concat("tr.wikipedia.org/wiki?curid=",page_id) as url
, avg(gt_lat), avg(gt_lon), abs(gt_lat-avg(gt_lat)) as farklt, abs(gt_lon-avg(gt_lon)) as farkln
, gt_dim, gt_type, gt_country, page_len, page_latest, gt_region from geo_tags join page on page_id = gt_page_id 
where page_namespace = 0 and page_title not rlike "liste" and page_title not rlike "meridyen"
group by gt_page_id having count(*)=@N order by farklt+farkln desc, count(*), page_len asc limit 25;
SQL

Checking query status...
