Poissons de fond

Poissons présents sur le fond apportant une plus-value non négligeable au paysage
Limpact paysager nest valable que si les espèces sont permanentes ou du moins très régulières sur le site (donc quasiment toujours observables)
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%listeListeDepartement":"06%') 10
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"13%') 114
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"83%') 77
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"34%') 17
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"66%') 9
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"20%') 29
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%bf_code_postal":"9%') 8
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"8"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) AND ( body LIKE '%id_typeannonce":"8%') 286
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"4"%' AND body LIKE '%"statut_fiche":"1"%' AND tag IN (SELECT resource FROM yeswiki_medobssub2015__triples WHERE value = "fiche_bazar" AND property = "http://outils-reseaux.org/_vocabulary/type" ORDER BY resource ASC) 68