Untitled query #42208

This query is marked as a draft This query has been published by Maximilianklein.

SQL

use commonswiki_p;
SELECT (select actor_name from actor where actor_id=img_actor) as user_name,
                              (select actor_user from actor where actor_id=img_actor) as user_id,
                              img_name 
                        FROM image, page, categorylinks
                        WHERE page.page_id=categorylinks.cl_from 
                        AND image.img_name = page.page_title
                        and image.img_name = 'Musa_with_wheelbarrow.jpg'
                        AND .categorylinks.cl_to = 'Images_from_Wiki_Loves_Africa_2017'
                        limit 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...