SELECT img_name, actor_user as img_user, actor_name as img_user_text

    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'

    LIMIT 10;