Natura 2000 species pictures

SELECT *
FROM (
    SELECT *, eunis_id as id_eunis
    FROM [EUNIS].[latest].[species_photos]
) as species_photos
ORDER BY sort_order