Erreur d'execution SQL :
SELECT bloc, img, img_alt, url_sponsor
FROM article
INNER JOIN sponso_rub_eo sp ON (sp.article_id_article = id_article)
INNER JOIN arbo ON (arbo.id_arbo = sp.arbo_id_arbo)
WHERE arbo.id_arbo =
AND ( CURRENT_DATE() BETWEEN date_debut AND date_fin )
ORDER BY date_debut DESC
LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( CURRENT_DATE() BETWEEN date_debut AND date_fin )
ORDER BY date_debut DES' at line 6 - 1064
Erreur d'execution SQL :
SELECT titre, img, txt, url, img_alt
FROM publi_info_eo
INNER JOIN arbo ON (id_arbo = arbo_id_arbo)
WHERE id_arbo =
AND ( CURRENT_DATE() BETWEEN date_debut AND date_fin )
ORDER BY date_debut DESC
LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( CURRENT_DATE() BETWEEN date_debut AND date_fin )
ORDER BY date_debut DES' at line 5 - 1064
Erreur d'execution SQL :
SELECT id_sous_secteur, nom, texte, img, img_alt
FROM sous_secteur
WHERE secteur_id_secteur =
ORDER BY nom
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY nom' at line 4 - 1064
Erreur d'execution SQL :
SELECT DISTINCT sigle, logo, urlrewriting, te.nom, geo.nom_region
FROM ecole
INNER JOIN fecole_eorient ON (id_ecole = ecole_id_ecole)
INNER JOIN asso_secteur_ecole ase ON (ase.ecole_id_ecole = id_ecole)
INNER JOIN sous_secteur ss ON (id_sous_secteur = ase.secteur_id_secteur)
LEFT JOIN asso_ecole_type aet ON (aet.ecole_id_ecole = id_ecole)
LEFT JOIN type_ecole te ON (aet.type_ecole_id_type_ecole = id_type_ecole)
LEFT JOIN adr_ecole ae ON (id_ecole = ae.ecole_id_ecole)
LEFT JOIN geo ON (dep_nb = SUBSTRING(cp, 1, 2))
WHERE etat = 1
AND presentation != ''
AND ss.secteur_id_secteur =
GROUP BY ecole.nom
ORDER BY RAND()
LIMIT 12
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY ecole.nom
ORDER BY RAND()
LIMIT 12' at line 13 - 1064
Erreur d'execution SQL :
SELECT actu.urlrewriting, id_article, titre, DATE(date_crea)
FROM actu
INNER JOIN article ON (actu.article_id_article = id_article)
WHERE arbo_id_arbo =
AND DATE( date_crea ) >= DATE_ADD( NOW() , INTERVAL -12 MONTH)
ORDER BY date_crea DESC
LIMIT 10
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DATE( date_crea ) >= DATE_ADD( NOW() , INTERVAL -12 MONTH)
ORDER BY date_c' at line 5 - 1064
