flickr files on enwiki

SQL

use enwiki_p;
SELECT page_title#CONCAT("[[File:",img_name,"]]") as File, img_user_text, img_width, img_height, img_size
FROM page/*
JOIN image
ON page_title = img_name*/
JOIN externallinks ON page_id = el_from
JOIN categorylinks
ON cl_from = page_id
AND cl_type = "file"
AND cl_to = "All_free_media"
WHERE page_namespace = 6 AND page_is_redirect = 0 
AND el_to LIKE '%flickr.com%'
/*LEFT JOIN imagelinks
ON il_to = img_name*/
#WHERE il_to IS NULL
#where page_id not in (select cl_from from categorylinks where cl_to like "%Common%")
#where img_sha1 in (select img_sha1 from ruwiki_p.image)
GROUP BY page_title
ORDER BY page_title
SQL

Checking query status...
