SQL
AخA
USE tewiki_p;
SELECT i.img_name, i.img_user_text
FROM image i
INNER JOIN page p ON p.page_title = i.img_name AND p.page_namespace = 6
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_free_media'#Fișiere sub drepturi de autor'
and p.page_id not in (select distinct cl_from from categorylinks
where cl_to = "Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept")
WHERE i.img_width * i.img_height > 1e+6
LIMIT 550;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.