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) 67
SELECT body FROM yeswiki_medobssub2015__pages WHERE latest="Y" AND comment_on = '' AND body LIKE '%"id_typeannonce":"3"%' 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) 199