11-08-2026 06:07 |
0.7305s | 6.82Mo | PAGE 0 | VILLE 197799 |
MYSQL:30 |
URL:26 => SELECT *
FROM evenement_tarif
WHERE id_evenement = :id_evenement AND active = 1
ORDER BY ordre ASC
3 => SELECT id_dedicace as id, description_dedicace as texte
FROM dedicace
WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1
3 => SELECT data
FROM classement_historique
WHERE time >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 1 DAY) AND type = :type
ORDER BY time ASC LIMIT 1
2 => SELECT a.*, b.pays_id
FROM torahboxbeta.ville a
LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville
WHERE a.id_ville = :id_ville LIMIT 1
2 => SELECT texte FROM moussar_jour WHERE jour = '06-15' LIMIT 1
2 => SELECT nom
FROM evenement_tarif
WHERE id_evenement = :id_evenement AND active = 1 AND enfant = 1
ORDER BY ordre ASC LIMIT 1
2 => SELECT nom
FROM evenement_tarif
WHERE id_evenement = :id_evenement AND active = 1 AND bebe = 1
ORDER BY ordre ASC LIMIT 1
1 => SELECT key_calendrier, nom_calendrier FROM calendrier
1 => SELECT id_auteur, CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) as nom_auteur, celebre_auteur, date_deces_auteur, annee_deces_auteur, page_hiloula_auteur
FROM auteur
WHERE date_deces_auteur IN ('06-15','07-15') AND celebre_auteur = 1
ORDER BY date_deces_auteur ASC, celebre_auteur DESC
1 => SELECT a.cal_date, b.*, c.sect_titre
FROM torahboxbeta.echethayil_calendrier a
LEFT JOIN torahboxbeta.echethayil_contenu b ON b.cont_id = a.cal_num_dia
LEFT JOIN torahboxbeta.echethayil_section c ON c.sect_id = b.cont_sectionid
WHERE a.cal_date IN (20130225)
ORDER BY a.cal_date ASC, b.cont_id ASC
1 => SELECT * FROM histoire_juive WHERE date_histoire_juive LIKE '%-02-25' ORDER BY date_histoire_juive ASC
1 => SELECT photo_hiloula_auteur FROM auteur WHERE id_auteur = :id_auteur LIMIT 1
1 => SELECT a.*, a.pays_evenement as id_pays,
b.pays_titre as pays_evenement, b.pays_iso2 as iso_pays_evenement,
c.nom_etablissement, c.note_etablissement,
IF(a.id_etablissement>0,c.adresse_etablissement,a.adresse_evenement) as adresse_evenement,
IF(a.id_etablissement>0,c.cp_etablissement,a.cp_evenement) as cp_evenement,
IF(a.id_etablissement>0,c.ville_etablissement,a.ville_evenement) as ville_evenement
FROM evenement a
LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement
LEFT JOIN evenement_etablissement c ON c.id_etablissement = a.id_etablissement
WHERE (DATE(a.time_evenement) >= '2026-08-11' OR DATE(a.time_evenement_fin) >= '2026-08-11') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (2,3) AND DATE(a.time_evenement) >= '2026-08-11'
ORDER BY a.pinned_evenement DESC, a.time_evenement ASC
LIMIT 3
1 => SELECT a.*, a.pays_evenement as id_pays,
b.pays_titre as pays_evenement, b.pays_iso2 as iso_pays_evenement,
c.nom_etablissement, c.note_etablissement,
IF(a.id_etablissement>0,c.adresse_etablissement,a.adresse_evenement) as adresse_evenement,
IF(a.id_etablissement>0,c.cp_etablissement,a.cp_evenement) as cp_evenement,
IF(a.id_etablissement>0,c.ville_etablissement,a.ville_evenement) as ville_evenement
FROM evenement a
LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement
LEFT JOIN evenement_etablissement c ON c.id_etablissement = a.id_etablissement
WHERE (DATE(a.time_evenement) >= '2026-08-11' OR DATE(a.time_evenement_fin) >= '2026-08-11') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (1) AND DATE(a.time_evenement) >= '2026-08-11'
ORDER BY a.pinned_evenement DESC, a.time_evenement ASC
LIMIT 5
1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article,
(SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default
FROM classement a
RIGHT JOIN article b ON b.id_article = a.id_content
WHERE a.type = :type
ORDER BY a.rank ASC
LIMIT 9
1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article, b.id_auteur, (SELECT CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) FROM auteur WHERE id_auteur = b.id_auteur) as nom_auteur,
(SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default
FROM classement a
RIGHT JOIN article b ON b.id_article = a.id_content
WHERE a.type = :type
ORDER BY a.rank ASC
LIMIT 9
1 => SELECT a.id_content, b.id_question, b.titre_question as title, b.titre_question,
(SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'qr_question' AND default_categorie = 1) as id_categorie_default
FROM classement a
RIGHT JOIN qr_question b ON b.id_question = a.id_content
WHERE a.type = :type
ORDER BY a.rank ASC
LIMIT 9
1 => http://roger.stioui.free.fr/Torah-Box-tos/calendrier.php?jc=25&mc=02&ac=2013&nbr_j=100&mode=j&lat=48%C2%B051%27N&long=02%C2%B021%27E&gmt=1&chgt=no
1 => http://roger.stioui.free.fr/Torah-Box-tos/calendrier.php?jc=25&mc=02&ac=2013&nbr_j=100&mode=j&lat=39%C2%B057%27N&long=82%C2%B059%27O&gmt=-5&chgt=no
