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%') 10SELECT 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%') 114SELECT 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%') 77SELECT 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%') 17SELECT 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%') 9SELECT 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%') 29SELECT 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%') 8SELECT 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%') 286SELECT 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