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

SQL

USE trwiki_p;
set @minsz = 998;
SELECT *, round(MiB*1000000/enboy/enboy,2) as oran from(
SELECT  concat("[[:Dosya:",page_title,"]]") as ad
  ,  concat("http://tr.wikipedia.org/wiki?curid=",page_id) as url
,round(sqrt(img_width * img_height),2) as enboy, round(img_size/1024/1024,2) as MiB, img_minor_mime as mime, img_sha1
from image JOIN (SELECT
        page_id,
        page_title
      FROM page
      JOIN categorylinks cl
      ON cl.cl_from = page_id
      WHERE cl.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* img_height > @minsz*@minsz)
  and img_minor_mime not in ("ogg")
       -- and img_minor_mime not in ("jpeg", "png", "gif")
      --  and img_minor_mime like 'svg%'
  and page_id not in (select cl2.cl_from from categorylinks cl2 where cl2.cl_to rlike "küçültülmesi")
) as aaa
order by oran desc, MiB desc, enboy desc

;
SQL

Checking query status...
