büyük boyutlu adil kullanım dosyaları

SQL

USE trwiki_p;
set @minsz = 200;
SELECT   concat("tr.wikipedia.org/wiki?curid=",page_id) as url, page_title
,round(sqrt(img_width * img_height),2) as enboy, round(img_size/1024/1024,2) as MB, img_minor_mime, img_sha1
from image JOIN (SELECT
        page_id,
        page_title
      FROM page
      JOIN categorylinks
      ON cl_from = page_id
      WHERE cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri")
      AND page_namespace = 6) AS pgtmp
      on img_name = page_title
      where (img_width > @minsz or img_height > @minsz)
       -- and img_minor_mime not in ("jpeg", "png", "gif")
      --  and img_minor_mime like 'svg%'
order by enboy desc, img_size desc
limit 100;
SQL

Checking query status...
