#USE commonswiki_p;

​

SELECT /* SLOW_OK */ concat('[[:File:',image.img_name,']]') as File, image.img_media_type, image.img_height, image.img_width, (image.img_height * image.img_width) as size

    FROM image, page, categorylinks 

    WHERE page.page_id=categorylinks.cl_from

        AND image.img_name = page.page_title

        AND categorylinks.cl_to = "Media_from_WikiDaheim_2025_in_Austria/all" 

        and image.img_media_type NOT IN ('AUDIO', 'VIDEO') 

        and image.img_height * image.img_width < 2*1000*1000

        and NOT EXISTS( SELECT * FROM categorylinks AS categorylinks2 

            WHERE page.page_id=categorylinks2.cl_from 

                  and categorylinks2.cl_to = "Media_from_WikiDaheim_2025_in_Austria_not_for_prejury"

          )

    GROUP BY size;

​

SELECT /* SLOW_OK */ concat('[[:File:',image.img_name,']]') as File, image.img_media_type, image.img_height, image.img_width, (image.img_height * image.img_width) as size

    FROM image, page, categorylinks 

    WHERE page.page_id=categorylinks.cl_from

        AND image.img_name = page.page_title

        and image.img_media_type NOT IN ('AUDIO', 'VIDEO') 

        AND categorylinks.cl_to = "Media_from_WikiDaheim_2025_in_Austria/all" 

        and image.img_height * image.img_width >= 2*1000*1000

        and EXISTS( SELECT * FROM categorylinks AS categorylinks2 

            WHERE page.page_id=categorylinks2.cl_from 

                  and categorylinks2.cl_to = "Media_from_WikiDaheim_2025_in_Austria_questioned_by_prejury"

          )

    GROUP BY size;