Erreur

La page demandée n'est pas disponible ou a été supprimée

Revenir à l'accueil

SELECT t1.id_adherent, t1.genre, t1.name, t1.visite, t1.capacite,t1.maxCapacite, t1.totCapacite,t1.prestation, t1.label, t1.type_classement, t1.classement, t1.annonce, t1.descriptif, t1.situation,t1.latitude, t1.longitude, t1.tarif, t2.adresse_ligne1, t2.adresse_ligne2, t2.adresse_ligne3, t2.code_postal, t2.ville, t3.id_dossier, t3.id_rubrique, t3.genre AS type, t3.repertoire, t4.nom, t4.prenom, t4.bio, (SELECT id_dispo FROM tbl_dispo WHERE id_hebergement = 407 LIMIT 1) AS dispo, (SELECT id_promo FROM tbl_promo WHERE id_structure = 407 AND date_suppr > NOW() LIMIT 1 ) AS promo, (SELECT GROUP_CONCAT(CONCAT(t7.id_telechargement,"|",t7.fichier,"|",t7.titre,"|",t7.maj) ORDER BY t7.maj DESC SEPARATOR "##" ) FROM tbl_telechargement AS t7 WHERE t7.id_hebergement = 407 GROUP BY t7.id_hebergement ) AS telechargement, (SELECT GROUP_CONCAT(t8.id_activite SEPARATOR ",") FROM tbl_activite_structure AS t8 WHERE t8.id_hebergement = 407) AS activ FROM tbl_hebergement AS t1 INNER JOIN tbl_adresse AS t2 ON t1.id_hebergement = t2.id_hebergement INNER JOIN tbl_genre AS t3 ON t1.genre = t3.id_genre INNER JOIN tbl_adherent AS t4 ON t1.id_adherent = t4.id_adherent WHERE t1.id_hebergement = 407 AND t4.actif IN(2,3) AND t1.page_web = 1