All topo-guides
Comment
Adour P1
Descente effectuée le 16-06-2018 P0 !! On peut ( par bonnes eaux) embarquer à la confluence des 23 ruisseaux sousle lac de Payolle pour 32 km de 3/4. On débarque à la prise d'eau. Ca part tranquillement puis un peu de pente et des branches (mais tout est passé). Attention à la première passerelle qui ne peut se passer que la tête en bas !! Reco. Juste avant le planiol de la petite retenue , le dernier rapide est très encombré et mérite une reco (vraiment mal pavé!!). Amicalement. Laurent (falgayras.laurent@orange.fr)
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
qzfqze
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
drthgdhg
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
sdtfgswdhg
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
kjhfgkugf
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
qergsdg
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
last run comment
Adour P1
telsfgq:w
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 14.08.2023
Discover
WaterLevel Observation
Job
Evaluation : BE - 28 cm
Ca passe pour l'integrale mais on est au mini mini
France >> Occitanie >> Haute-Garonne (31)
punglas By punglas | 16.05.2023
Discover
last run comment
Lignon du Velay P2
0.86 à Pont Marie, niveau avec des trois et des vagues bien formées mais pas de troucasses.RAS sur la descente
France >> Auvergne-Rhône-Alpes >> Haute-Loire (43)
By bertmoul | 15.05.2023
Discover
last run comment
Semène P2
Fait à 10m3 au crouzet, niveau parfait pour tout faire Merci à Bertmoul pour avoir ouvert et en particuliers le IV+
France >> Auvergne-Rhône-Alpes >> Haute-Loire (43)
By MARC | 14.05.2023
Discover
last run comment
Doux P3
Avec 21 M3/s à la station de colombier http://www.rdbrmc.com/hydroreel2/station.php?codestation=234. Rapides volumes avec ce débit, attention aux moins aguerris..
France >> Auvergne-Rhône-Alpes >> Ardèche (07)
Fredo_07 By Fredo_07 | 13.05.2023
Discover
WaterLevel Observation
Sesia
Evaluation : HE -
Bons niveaux d'eau sur tout le bassin de la Sesia (Sermenza, Sermenzina, Gronda, Sorba, Mastallone, Landwasser et Artogna). Avec les prévisions de pluie pour les 15 prochaons jours, ça va tenir!
Italie >> Piemonte
By Fredgil | 10.05.2023
Discover
last run comment
Rivière enchantée P1
Fait le 10 Mai avec l'équipe du CKT, super niveau
France >> Occitanie >> Ariège (09)
punglas By punglas | 09.05.2023
Discover
last run comment
Tinée P4
Descente effectuée 0.90 m et 1.8 m3/s sur la station de Saint-Sauveur. Bien content de la découverte mais niveau trop bas. Un peu juste dans les grilles malgré quelques belles veines et trop juste sur certaines zones alluviales. Joli paysage engorgé. Le parcours reste dans la description du topo. Un petit seuil <0.8 m sur roche-mère en sortie de saint-sauveur. Des rapides présents en aval des principaux ravins et affluents à configuration sensible à l'érosion des ravins et crue de la Tinée, et le rapide de la Bolline. 20 cm de plus semble un minimum voir même 1.2 m à l'échelle.
France >> Provence-Alpes-Côte d'Azur >> Var (83)
By Ronn | 08.05.2023
Discover
last run comment
Giffre des Fonts P0
Navigué plusieurs fois ces derniers jours à 0,75 - 0,80 - 0,85m sur le Giffre (après le confluent), on à l'air d'être dans la fenêtre de travail intéressante (les 2 rivières ont un régime similaire) ! Le parcours est clean, un arbre barre la rivière à la moitié du P1 mais ça passe dessous à gauche. Attention ça va vite vous devrez débarquer/repérer les premiers 500m les plus costauds, ainsi que les travaux de la gravière sur le bas. Une échelle à poser sous le pont de Salles ?
France >> Auvergne-Rhône-Alpes >> Haute Savoie (74)
cedric73 By cedric73 | 08.05.2023
Discover
last run comment
Drac P2
Fait ce jour, niveau bien sympa, c'est très joueur.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
Fredo_07 By Fredo_07 | 08.05.2023
Discover
last run comment
Souloise P1
130 cm à l'échelle, RAS.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
Fredo_07 By Fredo_07 | 07.05.2023
Discover
last run comment
Onde P2
Niveau d'eau moyen, le rapide au départ est très encombré, branches en amont et à l'aval du pont. Une énorme souche dans le courant s'évite par une pissette rive gauche, attention avec moins d'eau. Un mélèze énorme est tombé à l'amont du pont précédent celui de l'arrivée, stop sur l'île centrale conseillé et portage facile par dessus l'arbre. Ne sachant pas si ça avait été nettoyé, nous avons passé du temps à repérer par sections, ça change un peu la donne pour cette rivière.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
FabAlès By FabAlès | 06.05.2023
Discover
last run comment
Bonne P4
65 cm à l'échelle au départ avec un bon apport de suite en rive gauche. très bon niveau. Plusieurs arbres gênants, d'autres risques aussi de l'être avec moins d'eau, prudence !
France >> Auvergne-Rhône-Alpes >> Isère (38)
Fredo_07 By Fredo_07 | 06.05.2023
Discover
last run comment
Dranse de Morzine P1
11 m3 à la station de La Baume [Pont de Couvaloup] - niveau nickel. Débarquement au pont en amont du tunnel des Tines. 3/4 arbres obligeant à débarquer, visibles depuis la route ou de loin sur l'eau mais ne gâchant pas le plaisir de naviguer. Gorge de Saint-Jean-d'Aulps propre.
France >> Auvergne-Rhône-Alpes >> Haute Savoie (74)
gromille By gromille | 05.05.2023
Discover
last run comment
Saine P1
Chute de 4 m (cascade du tunnel) infran, 2 arbres sont coincés dedans.
France >> Bourgogne-Franche-Comté >> Jura (39)
gromille By gromille | 02.05.2023
Discover
Forum
All topics
test manif
Eau vive
26.05.23
Un nouveau départ pour Eauxvives.org
A propos d'eauxvives.org
15.05.23
Maj des niveaux en direct
banque d'info eau vive et niveaux sur le web
13.05.23
HAUTE-LOIRE y a de l'EAU
RV et bons plans navigation
13.05.23
VERDON INFOS et LÂCHERS
RV et bons plans navigation
12.05.23
Pointe enfoncée
Discussion générale
11.05.23
publicité Passion Nature
Next Event
mer-sam
18-21
déc
fonto_2023_fonto-2023.jpg
18-21 déc
All topo-guides
Comment
Adour P1
Descente effectuée le 16-06-2018 P0 !! On peut ( par bonnes eaux) embarquer à la confluence des 23 ruisseaux sousle lac de Payolle pour 32 km de 3/4. On débarque à la prise d'eau. Ca part tranquillement puis un peu de pente et des branches (mais tout est passé). Attention à la première passerelle qui ne peut se passer que la tête en bas !! Reco. Juste avant le planiol de la petite retenue , le dernier rapide est très encombré et mérite une reco (vraiment mal pavé!!). Amicalement. Laurent (falgayras.laurent@orange.fr)
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
qzfqze
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
drthgdhg
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Adour P1
sdtfgswdhg
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
kjhfgkugf
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
qergsdg
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
Comment
Rivière enchantée P1
rtttt
France >> Occitanie >> Ariège (09)
punglas By punglas | 16.06.2023
Discover
last run comment
Adour P1
telsfgq:w
France >> Occitanie >> Haute-Pyrénées (65)
punglas By punglas | 14.08.2023
Discover
WaterLevel Observation
Job
Evaluation : BE - 28 cm
Ca passe pour l'integrale mais on est au mini mini
France >> Occitanie >> Haute-Garonne (31)
punglas By punglas | 16.05.2023
Discover
last run comment
Lignon du Velay P2
0.86 à Pont Marie, niveau avec des trois et des vagues bien formées mais pas de troucasses.RAS sur la descente
France >> Auvergne-Rhône-Alpes >> Haute-Loire (43)
By bertmoul | 15.05.2023
Discover
last run comment
Semène P2
Fait à 10m3 au crouzet, niveau parfait pour tout faire Merci à Bertmoul pour avoir ouvert et en particuliers le IV+
France >> Auvergne-Rhône-Alpes >> Haute-Loire (43)
By MARC | 14.05.2023
Discover
last run comment
Doux P3
Avec 21 M3/s à la station de colombier http://www.rdbrmc.com/hydroreel2/station.php?codestation=234. Rapides volumes avec ce débit, attention aux moins aguerris..
France >> Auvergne-Rhône-Alpes >> Ardèche (07)
Fredo_07 By Fredo_07 | 13.05.2023
Discover
WaterLevel Observation
Sesia
Evaluation : HE -
Bons niveaux d'eau sur tout le bassin de la Sesia (Sermenza, Sermenzina, Gronda, Sorba, Mastallone, Landwasser et Artogna). Avec les prévisions de pluie pour les 15 prochaons jours, ça va tenir!
Italie >> Piemonte
By Fredgil | 10.05.2023
Discover
last run comment
Rivière enchantée P1
Fait le 10 Mai avec l'équipe du CKT, super niveau
France >> Occitanie >> Ariège (09)
punglas By punglas | 09.05.2023
Discover
last run comment
Tinée P4
Descente effectuée 0.90 m et 1.8 m3/s sur la station de Saint-Sauveur. Bien content de la découverte mais niveau trop bas. Un peu juste dans les grilles malgré quelques belles veines et trop juste sur certaines zones alluviales. Joli paysage engorgé. Le parcours reste dans la description du topo. Un petit seuil <0.8 m sur roche-mère en sortie de saint-sauveur. Des rapides présents en aval des principaux ravins et affluents à configuration sensible à l'érosion des ravins et crue de la Tinée, et le rapide de la Bolline. 20 cm de plus semble un minimum voir même 1.2 m à l'échelle.
France >> Provence-Alpes-Côte d'Azur >> Var (83)
By Ronn | 08.05.2023
Discover
last run comment
Giffre des Fonts P0
Navigué plusieurs fois ces derniers jours à 0,75 - 0,80 - 0,85m sur le Giffre (après le confluent), on à l'air d'être dans la fenêtre de travail intéressante (les 2 rivières ont un régime similaire) ! Le parcours est clean, un arbre barre la rivière à la moitié du P1 mais ça passe dessous à gauche. Attention ça va vite vous devrez débarquer/repérer les premiers 500m les plus costauds, ainsi que les travaux de la gravière sur le bas. Une échelle à poser sous le pont de Salles ?
France >> Auvergne-Rhône-Alpes >> Haute Savoie (74)
cedric73 By cedric73 | 08.05.2023
Discover
last run comment
Drac P2
Fait ce jour, niveau bien sympa, c'est très joueur.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
Fredo_07 By Fredo_07 | 08.05.2023
Discover
last run comment
Souloise P1
130 cm à l'échelle, RAS.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
Fredo_07 By Fredo_07 | 07.05.2023
Discover
last run comment
Onde P2
Niveau d'eau moyen, le rapide au départ est très encombré, branches en amont et à l'aval du pont. Une énorme souche dans le courant s'évite par une pissette rive gauche, attention avec moins d'eau. Un mélèze énorme est tombé à l'amont du pont précédent celui de l'arrivée, stop sur l'île centrale conseillé et portage facile par dessus l'arbre. Ne sachant pas si ça avait été nettoyé, nous avons passé du temps à repérer par sections, ça change un peu la donne pour cette rivière.
France >> Provence-Alpes-Côte d'Azur >> Hautes-Alpes (05)
FabAlès By FabAlès | 06.05.2023
Discover
last run comment
Bonne P4
65 cm à l'échelle au départ avec un bon apport de suite en rive gauche. très bon niveau. Plusieurs arbres gênants, d'autres risques aussi de l'être avec moins d'eau, prudence !
France >> Auvergne-Rhône-Alpes >> Isère (38)
Fredo_07 By Fredo_07 | 06.05.2023
Discover
last run comment
Dranse de Morzine P1
11 m3 à la station de La Baume [Pont de Couvaloup] - niveau nickel. Débarquement au pont en amont du tunnel des Tines. 3/4 arbres obligeant à débarquer, visibles depuis la route ou de loin sur l'eau mais ne gâchant pas le plaisir de naviguer. Gorge de Saint-Jean-d'Aulps propre.
France >> Auvergne-Rhône-Alpes >> Haute Savoie (74)
gromille By gromille | 05.05.2023
Discover
last run comment
Saine P1
Chute de 4 m (cascade du tunnel) infran, 2 arbres sont coincés dedans.
France >> Bourgogne-Franche-Comté >> Jura (39)
gromille By gromille | 02.05.2023
Discover
Forum
All topics
test manif
Eau vive
26.05.23
Un nouveau départ pour Eauxvives.org
A propos d'eauxvives.org
15.05.23
Maj des niveaux en direct
banque d'info eau vive et niveaux sur le web
13.05.23
HAUTE-LOIRE y a de l'EAU
RV et bons plans navigation
13.05.23
VERDON INFOS et LÂCHERS
RV et bons plans navigation
12.05.23
Pointe enfoncée
Discussion générale
11.05.23
Next Event
mer-sam
18-21
déc
fonto_2023_fonto-2023.jpg
18-21 déc
Photo library
Picture of the day
Rivière enchantée P1
France >> Occitanie >> Ariège (09)
By punglas | 21.09.2023
Photo
Rivière enchantée P1
France >> Occitanie >> Ariège (09)
By punglas | 16.05.2023
Photo
Allier P6
France >> Auvergne-Rhône-Alpes >> Haute-Loire (43)
By mctony | 05.05.2023
Photo
Sutjeska P2
Bosnie
By cedric73 | 22.04.2023
Photo
Sutjeska P2
Bosnie
By mylo | 22.04.2023
Photo
Kir P2
Albanie
By mylo | 22.04.2023
Photo
Ourika P2
Maroc >> Maroc
By pascalou | 30.03.2023
Photo
Tiflout P2
Maroc
By pascalou | 29.03.2023
Photo
Rance P2
France >> Occitanie >> Aveyron (12)
By Ploof | 22.03.2023
Photo
Corrèze P3
France >> Nouvelle Aquitaine >> Corrèze (19)
By jacon | 19.03.2023
Photo
Rance P2
France >> Occitanie >> Aveyron (12)
By Ploof | 19.03.2023
Photo
Gouarège P1
France >> Occitanie >> Ariège (09)
By punglas | 12.02.2023
Photo
Cagne P2
France >> Provence-Alpes-Côte d'Azur >> Alpes-Maritimes (06)
By mylo | 14.01.2023
Photo
Gervanne P1
France >> Auvergne-Rhône-Alpes >> Drôme (26)
By riton07 | 23.12.2022
Photo
toulourenc P2
France >> Provence-Alpes-Côte d'Azur >> Vaucluse (84)
By pascalou | 18.12.2022
Photo
Members
All members
Raoul_Duck
Raoul_Duck
ANNECY
Registered on 31.05
G6plus
G6plus
GUIDEL
Registered on 11.05
AlanBreck
AlanBreck
Edinburgh
Registered on 07.05
Tmen
Tmen
Rennes
Registered on 05.05
Offers
All offers
Our Partners
canoe-kayak-mag
rivieres-sauvages.fr
aquaverdon.com
select-paddles.com
kayak-online.fr
canotier.com
eco-rafting.com
canoe-kayak-granhota.fr
easy-kayak.com
guigui-prod.com
water-style-consult.com
parcaquasports.fr
Last connexion : 2099-01-01 00:00:00
(default) 69 queries took 2127 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1 SELECT Topics.topic_id, Topics.topic_title, Forums.forum_name, Topics.topic_last_post_time, Topics.topic_last_post_id FROM phpbb_topics Topics INNER JOIN phpbb_forums Forums on Topics.forum_id = Forums.forum_id WHERE 1=1 ORDER BY Topics.topic_last_post_time DESC limit 1515151
2SELECT DISTINCT -- Tutu CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS type_icone, 'topos' AS type , CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS label_icone , TF.id AS id, TF.id as topo_id, TF.slug AS slug, CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE null END AS slug_riviere, CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE null END AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours, TF.nom as nom, TF.modified AS date, TF.user_id, U.username, U.user_avatar, TF.user_2_id, U2.username as username2 , TF.cotation as text, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM topos_facility TF LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON TF.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE TF.etat = 0 union all SELECT DISTINCT CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, TF.id AS id, TF.id as topo_id, TF.slug AS slug, CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE TF.slug END AS slug_riviere, CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE 0 END AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours, TF.nom as nom, TC.created AS date, TC.user_id, U.username, U.user_avatar, TF.user_2_id, U2.username as username2 , TC.commentaire as text, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM topo_commentaires TC INNER JOIN topos_facility TF ON TC.topo_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON TC.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE TF.etat = 0 union all SELECT DISTINCT 'Carto' AS type_icone, 'Carto' AS type , 'Carto' AS label_icone, CC.id AS id, TF.id as topo_id, TF.slug AS slug, TF.slug AS slug_riviere, 0 AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours, TF.nom as nom, CC.created AS date, CC.user_id as user_id, U.username, U.user_avatar, null as user_id_2, null as username2 , null as text, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id INNER JOIN topos_facility TF ON CC.objet_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON TF.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id GROUP BY CC.objet_id union all SELECT DISTINCT 'RefNiveau' AS type_icone, 'RefNiveau' AS type , 'Niveau calibrage' AS label_icone, RN.id AS id, TF.id as topo_id, TF.slug AS slug, TF.slug AS slug_riviere, TF.numero_ordre AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours, TF.nom as nom, RN.modified AS date, TF.user_id, U.username, U.user_avatar, TF.user_2_id, U2.username as username2 , IF (RN.min IS NOT NULL,IF (RN.max IS NOT NULL,concat( concat("Min:",RN.min), concat(" - Max:",RN.max)), concat("Min:",RN.min)),null) as text, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM `niveau_references_de_niveaux` RN INNER JOIN topos_facility TF ON RN.topo_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON TF.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id ORDER BY date desc LIMIT 1010101080
3SELECT id,parent_id,topo_type_id from topos_facility where id=2260;110
4SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=2260 ORDER BY rand() ASC LIMIT 1112
5SELECT id,parent_id,topo_type_id from topos_facility where id=3055;110
6SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=3055 ORDER BY rand() ASC LIMIT 1111
7SELECT 'Parcours' AS type_icone , 'dernieres_descentes' AS type , 'Dernière descente' AS label_icone , DD.id AS id, TF.id as topo_id, TF.slug AS slug, TF2.slug as slug_riviere, TF.numero_ordre as numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours, TF.nom AS nom, DD.quand AS date, TF.user_id, U.username, U.user_avatar, TF.user_2_id, U2.username as username2 , DD.commentaire as text, null as text2, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM dernieres_descentes DD INNER JOIN topos_facility TF ON DD.topo_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON DD.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE TF.topo_type_id=4 union all SELECT distinct CASE IF(TF.topo_type_id is NULL,0,TF.topo_type_id) WHEN 0 THEN 'Niveau' WHEN 1 THEN 'Riviere' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 4 THEN 'Parcours' ELSE 'Error' END as type_icone, 'niveaux' AS type , 'Relevé de niveau' as label_icone, N.id AS id, TF.id as topo_id, TF.slug AS slug, TF.slug AS slug_riviere, 0 AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours, CASE IF(TF.topo_type_id is NULL,0,TF.topo_type_id) WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) WHEN 0 THEN N.label_pas_topo ELSE TF.nom END as nom, N.quand AS date, TF.user_id, U.username, U.user_avatar, TF.user_2_id, U2.username as username2 , concat ( concat ("Evaluation : ",NE.name," - "), IF (N.valeur IS NOT NULL, IF (N.unite IS NOT NULL, concat( N.valeur , concat(" ",N.unite)), N.valeur ) ,null) ) as text, N.commentaire as text2, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom FROM niveaux N INNER JOIN niveau_evaluations NE on NE.id=N.niveau_evaluation_id LEFT JOIN topos_facility TF ON N.topo_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN phpbb_users U ON N.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id order by date desc limit 151515140
8SELECT id,parent_id,topo_type_id from topos_facility where id=295;110
9SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.parent_id=295 ORDER BY rand() ASC LIMIT 1112
10SELECT id,parent_id,topo_type_id from topos_facility where id=1099;110
11SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1099 ORDER BY rand() ASC LIMIT 1112
12SELECT id,parent_id,topo_type_id from topos_facility where id=1968;110
13SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1968 ORDER BY rand() ASC LIMIT 1111
14SELECT id,parent_id,topo_type_id from topos_facility where id=1597;110
15SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1597 ORDER BY rand() ASC LIMIT 1112
16SELECT id,parent_id,topo_type_id from topos_facility where id=21;110
17SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.parent_id=21 ORDER BY rand() ASC LIMIT 1112
18SELECT id,parent_id,topo_type_id from topos_facility where id=1491;110
19SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1491 ORDER BY rand() ASC LIMIT 1112
20SELECT id,parent_id,topo_type_id from topos_facility where id=1493;110
21SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1493 ORDER BY rand() ASC LIMIT 1001
22SELECT id,parent_id,topo_type_id from topos_facility where id=871;110
23SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=871 ORDER BY rand() ASC LIMIT 1112
24SELECT id,parent_id,topo_type_id from topos_facility where id=939;110
25SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=939 ORDER BY rand() ASC LIMIT 1112
26SELECT id,parent_id,topo_type_id from topos_facility where id=1078;110
27SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1078 ORDER BY rand() ASC LIMIT 1112
28SELECT id,parent_id,topo_type_id from topos_facility where id=805;110
29SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=805 ORDER BY rand() ASC LIMIT 1112
30SELECT id,parent_id,topo_type_id from topos_facility where id=1179;110
31SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1179 ORDER BY rand() ASC LIMIT 1112
32SELECT id,parent_id,topo_type_id from topos_facility where id=1029;110
33SELECT -- tata Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 AND TF.id=1029 ORDER BY rand() ASC LIMIT 1112
34SHOW FULL COLUMNS FROM `manifestations`12122
35SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
36SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
37SELECT `Manifestation`.`id`, `Manifestation`.`user_id`, `Manifestation`.`title`, `Manifestation`.`body`, `Manifestation`.`short`, `Manifestation`.`date_debut`, `Manifestation`.`date_fin`, `Manifestation`.`site_web`, `Manifestation`.`created`, `Manifestation`.`modified`, `Manifestation`.`slug`, `Manifestation`.`forum`, `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar` FROM `manifestations` AS `Manifestation` LEFT JOIN `phpbb_users` AS `Membre` ON (`Manifestation`.`user_id` = `Membre`.`user_id`) WHERE `date_fin` >= '2023-09-22' ORDER BY rand() ASC LIMIT 1112
38SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'manifestation' AND `Image`.`foreign_id` = (327) 1110
39SELECT `Manifestation`.`id`, `Manifestation`.`title` FROM `manifestations` AS `Manifestation` WHERE `Manifestation`.`id` = 327 LIMIT 1110
40SELECT distinct CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' END AS type_icone, 'Photo' AS type, CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' END AS label_icone , TF.id AS id, TF.id as topo_id, TF.slug AS slug, CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE null END AS slug_riviere, CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE null END AS numero_ordre, CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours, TF.nom as nom, TF.modified AS date, TF.user_id, CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom, U.username, U.user_id, CAF.departement_code, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom, date_format(ATT.created,'%Y-%m-%d') as date FROM attachments ATT -- Toto -- Topos INNER JOIN topos_facility TF ON ATT.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id -- Users INNER JOIN phpbb_users U ON ATT.user_id=U.user_id LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id WHERE ATT.class='Topo' and TF.topo_type_id in (4,2,3) ORDER BY ATT.created DESC LIMIT 15 1515505
41SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3055 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3055 and date_format(ATT.created,'%Y-%m-%d')= '2023-09-21' ) ORDER BY RAND() ASC LIMIT 15112
42SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3055 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3055 and date_format(ATT.created,'%Y-%m-%d')= '2023-05-16' ) ORDER BY RAND() ASC LIMIT 15112
43SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 1285 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 1285 and date_format(ATT.created,'%Y-%m-%d')= '2023-05-05' ) ORDER BY RAND() ASC LIMIT 15112
44SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3053 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3053 and date_format(ATT.created,'%Y-%m-%d')= '2023-04-22' ) ORDER BY RAND() ASC LIMIT 15662
45SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3051 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3051 and date_format(ATT.created,'%Y-%m-%d')= '2023-04-22' ) ORDER BY RAND() ASC LIMIT 15882
46SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3047 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3047 and date_format(ATT.created,'%Y-%m-%d')= '2023-03-30' ) ORDER BY RAND() ASC LIMIT 15332
47SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 1461 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 1461 and date_format(ATT.created,'%Y-%m-%d')= '2023-03-29' ) ORDER BY RAND() ASC LIMIT 15772
48SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2920 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2920 and date_format(ATT.created,'%Y-%m-%d')= '2023-03-22' ) ORDER BY RAND() ASC LIMIT 15222
49SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 929 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 929 and date_format(ATT.created,'%Y-%m-%d')= '2023-03-19' ) ORDER BY RAND() ASC LIMIT 1512122
50SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2920 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2920 and date_format(ATT.created,'%Y-%m-%d')= '2023-03-19' ) ORDER BY RAND() ASC LIMIT 15112
51SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2915 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2915 and date_format(ATT.created,'%Y-%m-%d')= '2023-02-12' ) ORDER BY RAND() ASC LIMIT 15222
52SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3042 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 3042 and date_format(ATT.created,'%Y-%m-%d')= '2023-01-14' ) ORDER BY RAND() ASC LIMIT 15772
53SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2702 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2702 and date_format(ATT.created,'%Y-%m-%d')= '2022-12-23' ) ORDER BY RAND() ASC LIMIT 15552
54SELECT -- tata ATT.* FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2083 AND DATE(ATT.created) =( SELECT MAX(DATE(ATT.created)) AS DATE FROM `attachments` AS ATT INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id INNER JOIN topos_facility TF ON AL.foreign_id = TF.id WHERE ATT.`mimetype` LIKE 'image%' AND ATT.`class` = 'Topo' AND AL.`class` = 'Topo' AND ATT.peut_illustrer = 1 AND TF.id = 2083 and date_format(ATT.created,'%Y-%m-%d')= '2022-12-18' ) ORDER BY RAND() ASC LIMIT 15112
55SELECT TT.nom, TF.slug, TF.nom, TF2.slug, TF2.nom, TF.id, TF.numero_ordre, TF.topo_type_id, Image.* FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id -- INNER JOIN topos Topo ON AL.foreign_id=Topo.id -- LEFT JOIN topos T2 ON Topo.parent_id=T2.id -- LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id -- LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id INNER JOIN topos_facility TF ON AL.foreign_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id INNER JOIN topo_types TT on TF.topo_type_id=TT.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 ORDER BY rand() ASC LIMIT 111275
56SELECT `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar`, `Profil`.`user_id`, `Profil`.`pf_prenom`, `Profil`.`pf_nom`, `Profil`.`pf_ville`, `Profil`.`pf_bateau`, `Profil`.`pf_pratique`, `Profil`.`pf_region`, `Profil`.`pf_departement`, `Profil`.`pf_club`, `Profil`.`pf_infos_rivieres`, `Profil`.`pf_photo`, `Profil`.`pf_autres_infos`, `Profil`.`pf_phpbb_interests`, `Profil`.`pf_phpbb_occupation`, `Profil`.`pf_phpbb_icq`, `Profil`.`pf_phpbb_website`, `Profil`.`pf_phpbb_yahoo`, `Profil`.`pf_phpbb_aol`, `Profil`.`pf_phpbb_location`, `Profil`.`pf_phpbb_facebook`, `Profil`.`pf_phpbb_googleplus`, `Profil`.`pf_phpbb_skype`, `Profil`.`pf_phpbb_twitter`, `Profil`.`pf_phpbb_youtube` FROM `phpbb_users` AS `Membre` LEFT JOIN `phpbb_profile_fields_data` AS `Profil` ON (`Membre`.`user_id` = `Profil`.`user_id`) WHERE 1 = 1 ORDER BY `user_regdate` DESC LIMIT 15151537
57SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified`, `Membre`.`user_id`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_avatar`, `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`action`, `PetiteAnnonceType`.`petite_annonce_categorie_id`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`id`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonces` AS `PetiteAnnonce` LEFT JOIN `phpbb_users` AS `Membre` ON (`PetiteAnnonce`.`user_id` = `Membre`.`user_id`) LEFT JOIN `petite_annonce_types` AS `PetiteAnnonceType` ON (`PetiteAnnonce`.`petite_annonce_type_id` = `PetiteAnnonceType`.`id`) LEFT JOIN `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` ON (`PetiteAnnonce`.`petite_annonce_matos_type_id` = `PetiteAnnonceMatosType`.`id`) WHERE 1 = 1 ORDER BY `modified` DESC LIMIT 1010103
58SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'PetiteAnnonce' AND `Image`.`foreign_id` IN (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) 8812
59SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16302 LIMIT 1110
60SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16302 LIMIT 1110
61SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16306 LIMIT 1110
62SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16309 LIMIT 1110
63SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16309 LIMIT 1110
64SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16310 LIMIT 1110
65SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16311 LIMIT 1110
66SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16310 LIMIT 1110
67SELECT `PetiteAnnonceCommentaire`.`id`, `PetiteAnnonceCommentaire`.`petite_annonce_id`, `PetiteAnnonceCommentaire`.`auteur_id`, `PetiteAnnonceCommentaire`.`commentaire`, `PetiteAnnonceCommentaire`.`created`, `PetiteAnnonceCommentaire`.`modified` FROM `petite_annonce_commentaires` AS `PetiteAnnonceCommentaire` WHERE `PetiteAnnonceCommentaire`.`petite_annonce_id` IN (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) 000
68SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` JOIN `petite_annonces_petite_annonce_disciplines` AS `PetiteAnnoncesPetiteAnnonceDiscipline` ON (`PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id` IN (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) 10101
69SELECT `AnnuaireLien`.`id`, `AnnuaireLien`.`annu_lien_time`, `AnnuaireLien`.`annu_lien_url`, `AnnuaireLien`.`annu_lien_description`, `AnnuaireLien`.`annu_lien_active`, `AnnuaireLien`.`annuaire_cat_id`, `AnnuaireLien`.`user_id`, `AnnuaireLien`.`name`, `AnnuaireLien`.`annu_lien_thumb`, `AnnuaireLien`.`coordonnees_administrative_id`, `AnnuaireLien`.`annu_lien_backlink`, `AnnuaireLien`.`created`, `AnnuaireLien`.`updated`, `AnnuaireCat`.`id`, `AnnuaireCat`.`parent_id`, `AnnuaireCat`.`lft`, `AnnuaireCat`.`rght`, `AnnuaireCat`.`annu_cat_parents`, `AnnuaireCat`.`name`, `AnnuaireCat`.`annu_cat_desc`, `AnnuaireCat`.`annu_cat_links`, `AnnuaireCat`.`annu_cat_icon`, `AnnuaireCat`.`annu_cat_desc_bitfield`, `AnnuaireCat`.`annu_cat_desc_options`, `AnnuaireCat`.`annu_cat_desc_uid`, `AnnuaireCat`.`annu_display_subcat_list`, `AnnuaireCat`.`annu_cat_allow_comments`, `AnnuaireCat`.`annu_cat_allow_votes`, `AnnuaireCat`.`annu_cat_must_describe`, `AnnuaireCat`.`annu_cat_link_back`, `AnnuaireCat`.`annu_cat_cron_enable`, `AnnuaireCat`.`annu_cat_cron_next`, `AnnuaireCat`.`annu_cat_cron_freq`, `AnnuaireCat`.`annu_cat_cron_nb_check`, `PhpbbUser`.`user_id`, `PhpbbUser`.`username`, `CoordonneesAdministrative`.`id`, `CoordonneesAdministrative`.`nom`, `CoordonneesAdministrative`.`slug`, `CoordonneesAdministrative`.`code`, `CoordonneesAdministrative`.`coordonnee_administrative_type_id`, `CoordonneesAdministrative`.`parent_id`, `CoordonneesAdministrative`.`lft`, `CoordonneesAdministrative`.`rght`, `CoordonneesAdministrative`.`Migration` FROM `annuaire_liens` AS `AnnuaireLien` LEFT JOIN `annuaire_cats` AS `AnnuaireCat` ON (`AnnuaireLien`.`annuaire_cat_id` = `AnnuaireCat`.`id`) LEFT JOIN `phpbb_users` AS `PhpbbUser` ON (`AnnuaireLien`.`user_id` = `PhpbbUser`.`user_id`) LEFT JOIN `coordonnees_administratives` AS `CoordonneesAdministrative` ON (`AnnuaireLien`.`coordonnees_administrative_id` = `CoordonneesAdministrative`.`id`) WHERE 1 = 1 ORDER BY `created` DESC LIMIT 1515152
Page rendered in 7340ms.