| 0.0410 |
SELECT `OA`.*, 7 AS `carte`, `OA`.`id_organisation_agenda` AS `id`, `OAM`.`media` as `media`, `OACO`.`telephone`, `OACO`.`email`, `OACO`.`email_afficher`, `OACO`.`telephone_afficher`, `O`.`id_organisation` as `org_id`, `O`.`date_creation` as `org_datecreation`, `O`.`nom` AS `org_nom`, `O`.`date_modification` AS `org_datemodification`, `OM`.`logo` AS `org_image`, `O`.`categorie` AS `org_categorie`, `AV`.`commune` AS `org_ville_commune`, `OAI`.`id` AS `import_id`, `OAI`.`reseau` AS `import_reseau`, `OAS1`.`url` AS `url_site`, `OAS2`.`url` AS `url_billeterie`, `OU`.`dts_agendas_modifier` AS `droit`, (SELECT COUNT(OAS.id_organisation_agenda) FROM organisations_agendas_stats AS OAS WHERE OAS.id_organisation_agenda=OA.id_organisation_agenda AND OAS.date_creation <= (SUBDATE(NOW(), INTERVAL 24 HOUR))) AS nb_visites, (SELECT GROUP_CONCAT(OAT.id_tag SEPARATOR ', ') FROM organisations_agendas_tags AS OAT WHERE OAT.id_organisation_agenda=OA.id_organisation_agenda) AS tags, (SELECT PAA.id_paiement_agenda_alaune FROM paiements_agendas_alaune AS PAA WHERE OA.id_organisation_agenda=PAA.id_organisation_agenda AND PAA.date_expiration >= '2025-04-28') AS alaune, (SELECT MIN(OAAD.date_debut) from organisations_agendas_dates AS OAAD WHERE OA.id_organisation_agenda=OAAD.id_organisation_agenda) AS date_debut, (SELECT COUNT(OAFF.id_organisation_agenda_favoris) FROM organisations_agendas_favoris AS OAFF WHERE OA.id_organisation_agenda=OAFF.id_organisation_agenda AND OAFF.id_utilisateur='0') AS favoris_existe, (SELECT COUNT(OAC.id_organisation_agenda_commentaire) FROM organisations_agendas_commentaires AS OAC WHERE OAC.id_organisation_agenda=OA.id_organisation_agenda) AS commentaires_existe, (SELECT COUNT(OAP.id_organisation_agenda_partenaire) FROM organisations_agendas_partenaires AS OAP WHERE OAP.id_organisation_agenda=OA.id_organisation_agenda) AS partenaires_existe, (SELECT COUNT(SA.id_sortie_agenda) FROM sorties_agendas AS SA WHERE SA.id_organisation_agenda=OA.id_organisation_agenda) AS sorties_existe, (SELECT COUNT(OAP.id_organisation_agenda_photo) FROM organisations_agendas_photos AS OAP WHERE OAP.id_organisation_agenda=OA.id_organisation_agenda) AS photos_existe, (SELECT COUNT(OAA.id_organisation_actualite_agenda) FROM organisations_actualites_agendas AS OAA WHERE OAA.id_organisation_agenda=OA.id_organisation_agenda) AS actualites_existe, (SELECT COUNT(OAC.id_organisation_agenda_commentaire) FROM organisations_agendas_commentaires AS OAC WHERE OAC.id_organisation_agenda=OA.id_organisation_agenda) AS commentaires_existe, (SELECT COUNT(id_signalement) FROM signalements AS S WHERE S.id=OA.id_organisation_agenda AND S.id_utilisateur='0' AND S.typologie=7) AS signalement_existe
FROM `organisations_agendas` AS `OA`
LEFT JOIN `organisations_agendas_medias` AS `OAM` ON `OAM`.`id_organisation_agenda`=`OA`.`id_organisation_agenda` AND `OAM`.`typologie`=1
LEFT JOIN `organisations_agendas_contacts` AS `OACO` ON `OACO`.`id_organisation_agenda`=`OA`.`id_organisation_agenda`
LEFT JOIN `organisations_agendas_imports` AS `OAI` ON `OA`.`id_organisation_agenda` = `OAI`.`id_organisation_agenda`
LEFT JOIN `organisations` AS `O` ON `O`.`id_organisation`=`OA`.`id_organisation` AND `O`.`statut`=1
LEFT JOIN `organisations_utilisateurs` AS `OU` ON `O`.`id_organisation` = `OU`.`id_organisation` AND `OU`.`id_utilisateur` =0
LEFT JOIN `annexes_villes` AS `AV` ON `AV`.`id_ville`=`O`.`id_ville`
LEFT JOIN `organisations_medias` AS `OM` ON `O`.`id_organisation`=`OM`.`id_organisation`
LEFT JOIN `organisations_agendas_sites` AS `OAS1` ON `OA`.`id_organisation_agenda`=`OAS1`.`id_organisation_agenda` AND `OAS1`.`typologie`=1
LEFT JOIN `organisations_agendas_sites` AS `OAS2` ON `OA`.`id_organisation_agenda`=`OAS2`.`id_organisation_agenda` AND `OAS2`.`typologie`=2
WHERE `OA`.`id_organisation_agenda` = 1200
AND `OA`.`statut` = 1
ORDER BY `OA`.`id_organisation_agenda` DESC
|
| 0.0004 |
SELECT *
FROM `organisations_agendas_stats` AS `OAS`
WHERE `OAS`.`id_organisation_agenda` = '1200'
AND `OAS`.`ip` = '18.222.22.193'
|
| 0.0037 |
INSERT INTO `organisations_agendas_stats` (`id_organisation_agenda`, `id_utilisateur`, `date_creation`, `id_ville`, `ip`, `robot`) VALUES ('1200', NULL, '2025-04-28 18:00:42', NULL, '18.222.22.193', NULL)
|
| 0.0015 |
UPDATE `organisations_agendas` SET `affichage` = 62, `derniere_visite` = '2025-04-28 18:00:42'
WHERE `id_organisation_agenda` = '1200'
|
| 0.0043 |
SELECT `OAF`.*, (SELECT MIN(OAD1.date_debut) FROM organisations_agendas_formulaires AS OAD1 WHERE OAF.id_organisation_agenda=OAD1.id_organisation_agenda) AS date_start_min, (SELECT MAX(OAD2.date_fin) FROM organisations_agendas_formulaires AS OAD2 WHERE OAF.id_organisation_agenda=OAD2.id_organisation_agenda) AS date_end_max, CONCAT(V.code_postal, ', ', V.commune) AS ville
FROM `organisations_agendas_formulaires` AS `OAF`
JOIN `annexes_villes` AS `V` ON `V`.`id_ville`=`OAF`.`id_ville`
WHERE `OAF`.`id_organisation_agenda` = 1200
GROUP BY `OAF`.`date_debut`
ORDER BY `OAF`.`date_debut` ASC
|
| 0.0003 |
SELECT `OAC`.*, `U`.`id_utilisateur` AS `user_id`, `U`.`nom` AS `user_nom`, `U`.`prenom` AS `user_prenom`, `U`.`date_creation` AS `user_datecreation`, `U`.`date_connexion` AS `user_dateconnexion`, `U`.`date_modification` AS `user_datemodification`, `U`.`avatar` AS `user_avatar`, `U`.`visibilite` AS `user_visibilite`
FROM `organisations_agendas_commentaires` AS `OAC`
JOIN `utilisateurs` AS `U` ON `U`.`id_utilisateur` = `OAC`.`id_utilisateur`
WHERE `OAC`.`statut` = 1
AND `OAC`.`id_organisation_agenda` = '1200'
ORDER BY `OAC`.`id_organisation_agenda_commentaire` ASC
|
| 0.0003 |
SELECT `PB`.`id_paiement_publicite`, `PB`.`date_creation`, `PB`.`image`, `PB`.`affichage`, `PB`.`lien`
FROM `paiements_publicites` AS `PB`
RIGHT JOIN `annexes_villes` AS `AV` ON `AV`.`id_ville`=`PB`.`id_ville`
WHERE `PB`.`date_expiration` >= '2025-04-28 18:00'
AND `PB`.`date_diffusion` <= '2025-04-28 18:00'
AND `PB`.`statut` = 1
AND `PB`.`lien` != ''
ORDER BY RAND()
LIMIT 1
|
| 0.0329 |
SELECT 7 AS `c_carte`, '' AS c_id_utilisateur, `OA`.`id_organisation_agenda` AS `c_id`, `OA`.`titre` AS `c_titre`, `OA`.`date_creation` AS `c_datecreation`, `OA`.`date_modification` AS `c_datemodification`, (SELECT OOAD.date_debut FROM organisations_agendas_dates AS OOAD WHERE OOAD.id_organisation_agenda=OA.id_organisation_agenda AND OOAD.date_debut >= '2025-04-28' ORDER BY OOAD.date_debut ASC LIMIT 1) AS c_datediffusion, `OAM`.`media` AS `c_image`, `OA`.`accroche` AS `c_description`, `OA`.`id_theme` AS `c_info1`, `OA`.`id_fete` AS `c_info2`, `OA`.`id_institutionnel` AS `c_info3`, (SELECT COUNT(OAP.id_organisation_agenda_partenaire) FROM organisations_agendas_partenaires AS OAP WHERE OAP.id_organisation_agenda=OA.id_organisation_agenda AND OAP.relation = 1) AS c_info4, '' AS c_info5, '' AS c_info6, '' AS c_info7, (SELECT OP.id_organisation_projet FROM organisations_projets AS OP INNER JOIN organisations_projets_agendas AS OPAG ON OPAG.id_organisation_projet=OP.id_organisation_projet WHERE OPAG.id_organisation_agenda=OA.id_organisation_agenda AND OP.id_organisation=OA.id_organisation) AS c_projet, (SELECT OL.id_organisation_label FROM organisations_labels AS OL INNER JOIN organisations_labels_agendas AS OLAG ON OLAG.id_organisation_label=OL.id_organisation_label WHERE OLAG.id_organisation_agenda=OA.id_organisation_agenda AND OL.id_organisation=OA.id_organisation) AS c_label, (SELECT COUNT(OAC.id_organisation_agenda_commentaire) FROM organisations_agendas_commentaires AS OAC WHERE OAC.id_organisation_agenda=OA.id_organisation_agenda AND OAC.id_utilisateur=0) AS c_commentaires_existe, (SELECT COUNT(OAFF.id_organisation_agenda_favoris) FROM organisations_agendas_favoris AS OAFF WHERE OAFF.id_organisation_agenda=OA.id_organisation_agenda AND OAFF.id_utilisateur=0) AS c_favoris_existe, (SELECT COUNT(id_signalement) FROM signalements AS S WHERE S.id=OA.id_organisation_agenda AND S.id_utilisateur=0 AND S.typologie=7) AS c_signalement_existe, (SELECT PAA.id_paiement_agenda_alaune FROM paiements_agendas_alaune AS PAA WHERE OA.id_organisation_agenda=PAA.id_organisation_agenda AND PAA.date_expiration >= '2025-04-28') AS c_alaune, `OU`.`dts_agendas_modifier` AS `c_droit`, `AV`.`code_postal` AS `c_loc_cp`, `AV`.`commune` AS `c_loc_commune`, 2 AS `posteur_type`, `O`.`id_organisation` AS `posteur_id`, `O`.`nom` AS `posteur_nom`, '' AS posteur_prenom, `O`.`date_creation` AS `posteur_datecreation`, `O`.`date_modification` AS `posteur_datemodification`, '' AS posteur_dateconnexion, '' AS posteur_visibilite, `OM`.`logo` AS `posteur_image`, `O`.`categorie` AS `posteur_categorie`, `O`.`typologie` AS `posteur_typologie`
FROM `paiements_agendas_alaune` AS `PAA`
RIGHT JOIN `organisations_agendas` AS `OA` ON `PAA`.`id_organisation_agenda`=`OA`.`id_organisation_agenda`
LEFT JOIN `organisations_agendas_medias` AS `OAM` ON `OA`.`id_organisation_agenda` = `OAM`.`id_organisation_agenda` AND `OAM`.`typologie`=1
JOIN `organisations_agendas_dates` AS `OAD` ON `OA`.`id_organisation_agenda`=`OAD`.`id_organisation_agenda`
JOIN `annexes_villes` AS `AV` ON `AV`.`id_ville`=`OAD`.`id_ville`
JOIN `organisations` AS `O` ON `O`.`id_organisation`=`OA`.`id_organisation`
LEFT JOIN `organisations_utilisateurs` AS `OU` ON `O`.`id_organisation` = `OU`.`id_organisation` AND `OU`.`id_utilisateur` =0
LEFT JOIN `organisations_medias` AS `OM` ON `O`.`id_organisation` = `OM`.`id_organisation`
WHERE `OA`.`statut` = 1
AND `O`.`statut` = 1
AND `OA`.`date_publication` <= '2025-04-28 18:00'
AND `PAA`.`date_expiration` >= '2025-04-28 18:00'
GROUP BY `OA`.`id_organisation_agenda`
ORDER BY RAND()
|
| 0.0036 |
SELECT `OA`.`id_organisation_agenda`, `OA`.`titre`, `OA`.`date_creation`, `OA`.`date_modification`, `OAD`.`date_debut` AS `date_debut`, `V`.`commune` AS `ville_commune`, `OAM`.`media` AS `image`
FROM `organisations_agendas` AS `OA`
RIGHT JOIN `organisations_agendas_dates` AS `OAD` ON `OA`.`id_organisation_agenda`=`OAD`.`id_organisation_agenda` AND `OA`.`statut`=1 AND `OAD`.`date_debut` >= '2025-04-28'
JOIN `annexes_villes` AS `V` ON `V`.`id_ville`=`OAD`.`id_ville`
JOIN `organisations` AS `O` ON `O`.`id_organisation`=`OA`.`id_organisation`
LEFT JOIN `organisations_agendas_medias` AS `OAM` ON `OA`.`id_organisation_agenda` = `OAM`.`id_organisation_agenda` AND `OAM`.`typologie`=1
WHERE `OA`.`statut` = 1
AND `O`.`statut` = 1
AND `OA`.`id_organisation` = '351'
AND `OA`.`id_organisation_agenda` != '1200'
AND `OA`.`date_publication` <= '2025-04-28 18:00'
AND (SELECT MIN(OAAD.date_debut) from organisations_agendas_dates AS OAAD WHERE OA.id_organisation_agenda = `OAAD`.`id_organisation_agenda` AND `OA`.`statut` = 1 AND OAAD.date_debut >= '2025-04-28') >= '2025-04-28'
GROUP BY `OA`.`id_organisation_agenda`, `OA`.`id_organisation_agenda`
ORDER BY `OAD`.`date_debut` ASC
LIMIT 5
|
| 0.0083 |
SELECT `OA`.`id_organisation_agenda`, `OA`.`titre`, `OA`.`date_creation`, `OA`.`date_modification`, `OAD`.`date_debut` AS `date_debut`, `V`.`commune` AS `ville_commune`, `OAM`.`media` AS `image`
FROM `organisations_agendas` AS `OA`
RIGHT JOIN `organisations_agendas_dates` AS `OAD` ON `OA`.`id_organisation_agenda`=`OAD`.`id_organisation_agenda` AND `OA`.`statut`=1 AND `OAD`.`date_debut` >= '2025-04-28'
JOIN `annexes_villes` AS `V` ON `V`.`id_ville`=`OAD`.`id_ville`
JOIN `organisations` AS `O` ON `O`.`id_organisation`=`OA`.`id_organisation`
LEFT JOIN `organisations_agendas_medias` AS `OAM` ON `OA`.`id_organisation_agenda` = `OAM`.`id_organisation_agenda` AND `OAM`.`typologie`=1
WHERE `OA`.`statut` = 1
AND `O`.`statut` = 1
AND `OA`.`id_theme` = '0'
AND `OA`.`id_organisation_agenda` != '1200'
AND `OA`.`date_publication` <= '2025-04-28 18:00'
AND (SELECT MIN(OAAD.date_debut) from organisations_agendas_dates AS OAAD WHERE OA.id_organisation_agenda = `OAAD`.`id_organisation_agenda` AND `OA`.`statut` = 1 AND OAAD.date_debut >= '2025-04-28') >= '2025-04-28'
GROUP BY `OA`.`id_organisation_agenda`
ORDER BY `OAD`.`date_debut` ASC
LIMIT 5
|
| 0.0055 |
SELECT `OA`.`id_organisation_agenda`, `OA`.`titre`, `OA`.`date_creation`, `OA`.`date_modification`, `OAD`.`date_debut` AS `date_debut`, `V`.`commune` AS `ville_commune`, `OAM`.`media` AS `image`
FROM `organisations_agendas` AS `OA`
RIGHT JOIN `organisations_agendas_dates` AS `OAD` ON `OA`.`id_organisation_agenda`=`OAD`.`id_organisation_agenda` AND `OA`.`statut`=1 AND `OAD`.`date_debut` >= '2025-04-28'
JOIN `annexes_villes` AS `V` ON `V`.`id_ville`=`OAD`.`id_ville`
LEFT JOIN `organisations_agendas_tags` AS `OAT` ON `OAT`.`id_organisation_agenda`=`OA`.`id_organisation_agenda`
JOIN `organisations` AS `O` ON `O`.`id_organisation`=`OA`.`id_organisation`
LEFT JOIN `organisations_agendas_medias` AS `OAM` ON `OA`.`id_organisation_agenda` = `OAM`.`id_organisation_agenda` AND `OAM`.`typologie`=1
WHERE `OA`.`statut` = 1
AND `O`.`statut` = 1
AND OAT.id_tag IN(261, 370, 108, 1184, 906)
AND `OA`.`id_organisation_agenda` != '1200'
AND `OA`.`date_publication` <= '2025-04-28 18:00'
AND (SELECT MIN(OAAD.date_debut) from organisations_agendas_dates AS OAAD WHERE OA.id_organisation_agenda = `OAAD`.`id_organisation_agenda` AND `OA`.`statut` = 1 AND OAAD.date_debut >= '2025-04-28') >= '2025-04-28'
GROUP BY `OA`.`id_organisation_agenda`
ORDER BY `OAD`.`date_debut` ASC
LIMIT 5
|
