SELECT img_width,

       img_height,

       img_name,

       img_major_mime,

       img_minor_mime,

       actor_user AS img_user,

       actor_name AS img_user_text,

       img_actor,

       img_timestamp

FROM commonswiki_p.image

LEFT JOIN actor ON img_actor=actor.actor_id

JOIN page ON page_namespace = 6

AND page_title = img_name

JOIN categorylinks ON cl_from = page_id

AND cl_type = 'file'

AND cl_to = 'Category:Larus_occidentalis_heads';