SELECT d.filename, t.tag
FROM img_filedata AS d, img_tags AS t, img_link as l
WHERE d.id = l.file_id AND t.id = l.tags_id AND t.tag = "solo"