SQL
AخA
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 6+7 desc , count(*), page_len asc limit 25;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.