Natura 2000 species carousel

SELECT 
ltrim(str(e_species.id_eunis,10)) as id_eunis,
    e_species.code_2000,
    e_species.scientific_name,
    species.common_name,
    species.common_name_list,
    e_species.species_group_name,
    species.number_sites,
    species.number_countries,
    e_species.author,
    pictures.file_name,
    pictures.description,
    pictures.source,
    pictures.source_url,
    pictures.license,
    pictures.picture_url,
    e_species.scientific_name_accepted as e_scientific_name_accepted,
    e_species.id_eunis_accepted as e_id_eunis_accepted,
    e_species.status_name as e_status_name
FROM EUNIS.latest.Species_Information as e_species
LEFT JOIN BISE.latest.Species_Information as species on (species.id_eunis = e_species.id_eunis or species.id_eunis = e_species.id_eunis_accepted)
LEFT JOIN BISE.latest.Species_Pictures as pictures
ON (e_species.id_eunis LIKE pictures.id_eunis or e_species.id_eunis_accepted LIKE pictures.id_eunis)