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

SQL

USE trwiki_p;
set @minsz = 200;
SELECT  page_id, concat("tr.wikipedia.org/wiki/Dosya:",replace(page_title," ","_")) as baslik
, round(sqrt(img_width * img_height),2) as enboy, img_size, 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 = 'svg'
order by enboy desc, img_size desc
limit 100;

SQL

Checking query status...