WikiDaheim Constraints 2021

SQL

#USE commonswiki_p;
#describe page;
#describe image;
#describe user;
#describe actor;

/*
SELECT DISTINCT actor_name as u, user.user_email_authenticated, user.user_email
    FROM actor, user, revision, image, page, categorylinks 
    WHERE page.page_id=categorylinks.cl_from
        AND actor.actor_id = revision.rev_actor
        and user.user_name = actor.actor_name
        AND image.img_name = page.page_title
        and revision.rev_page = page.page_id
        and revision.rev_parent_id = 0
        # LOWER does not work
        AND actor_name NOT LIKE "%bot%" AND actor_name NOT LIKE "%Bot%"
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2021_in_Austria/all" 
    GROUP BY u;
*/

SELECT /* SLOW_OK */ image.img_name, image.img_width, image.img_height, (image.img_width * image.img_height) as size
    from image, page, categorylinks 
    WHERE page.page_id=categorylinks.cl_from
        AND image.img_name = page.page_title
        and image.img_width * image.img_height < 2*1024*1024
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2021_in_Austria/all" 
    ORDER BY image.img_size asc limit 200;
SQL

Checking query status...
