Natura 2000 Site habitats list

SELECT h.code_2000,
    h.scientific_name,
    h.habitat_description,
    h.habitat_prioriy,
    h.habitat_category,
    h.number_sites,
    s.site_code,
    s.habitat_group,
    s.caves,
    s.coverage_ha,
    p.ThumbnailURL as picture_url
FROM BISE.latest.Site_Habitats_List s
LEFT JOIN BISE.latest.Habitat_Information h ON s.code_2000 = h.code_2000
JOIN EUNIS.latest.HDAnnexI_habitat_photos p ON h.code_2000 = p.code_2000 and p.main=1