- erreur_sql: Array
- fichier: /home/runce/public_html/php/controleurs/partenaires.php
- ligne: 325
- sql: SELECT t1.id
, t1.titre
, t1.note
, t1.sha1_id sha1_partenaire
,IF(t1.banniere = "", "", CONCAT("https://runce.re/upload/users/",t5.sha1_id,"/compresser/", t1.banniere)) banniere
, CONCAT(t1.titre, " | ", t2.titre, " | Réunion") seo_title
, t1.seo_description
, t1.slug
, t1.contenu
, IF(t1.logo = "", "", CONCAT("https://runce.re/upload/users/",t5.sha1_id,"/450/", t1.logo)) image
, t1.image1
, t1.alt1
, t1.image2
, t1.image3
, t1.image4
, t1.image5
, t1.image6
, t1.image7
, t1.image8
, t1.image9
, t1.image10
, t1.alt2
, t1.alt3
, t1.alt4
, t1.alt5
, t1.alt6
, t1.alt7
, t1.alt8
, t1.alt9
, t1.alt10
, t1.url
, t1.id_membres
, t1.contenu_carte_public
, t1.contenu_carte_entreprise
, t1.carte_public
, t1.carte_entreprise
, CONCAT("https://runce.re/compte/entreprises/", t1.sha1_id, ".html") url_modifier
, afficher_horaire
, TIME_FORMAT(t1.lundi_debut, "%Hh%i") lundi_debut_formater
, TIME_FORMAT(t1.lundi_fin, "%Hh%i") lundi_fin_formater
, TIME_FORMAT(t1.lundi_debut2, "%Hh%i") lundi_debut2_formater
, TIME_FORMAT(t1.lundi_fin2, "%Hh%i") lundi_fin2_formater
, TIME_FORMAT(t1.mardi_debut, "%Hh%i") mardi_debut_formater
, TIME_FORMAT(t1.mardi_fin, "%Hh%i") mardi_fin_formater
, TIME_FORMAT(t1.mardi_debut2, "%Hh%i") mardi_debut2_formater
, TIME_FORMAT(t1.mardi_fin2, "%Hh%i") mardi_fin2_formater
, TIME_FORMAT(t1.mercredi_debut, "%Hh%i") mercredi_debut_formater
, TIME_FORMAT(t1.mercredi_fin, "%Hh%i") mercredi_fin_formater
, TIME_FORMAT(t1.mercredi_debut2, "%Hh%i") mercredi_debut2_formater
, TIME_FORMAT(t1.mercredi_fin2, "%Hh%i") mercredi_fin2_formater
, TIME_FORMAT(t1.jeudi_debut, "%Hh%i") jeudi_debut_formater
, TIME_FORMAT(t1.jeudi_fin, "%Hh%i") jeudi_fin_formater
, TIME_FORMAT(t1.jeudi_debut2, "%Hh%i") jeudi_debut2_formater
, TIME_FORMAT(t1.jeudi_fin2, "%Hh%i") jeudi_fin2_formater
, TIME_FORMAT(t1.vendredi_debut, "%Hh%i") vendredi_debut_formater
, TIME_FORMAT(t1.vendredi_fin, "%Hh%i") vendredi_fin_formater
, TIME_FORMAT(t1.vendredi_debut2, "%Hh%i") vendredi_debut2_formater
, TIME_FORMAT(t1.vendredi_fin2, "%Hh%i") vendredi_fin2_formater
, TIME_FORMAT(t1.samedi_debut, "%Hh%i") samedi_debut_formater
, TIME_FORMAT(t1.samedi_fin, "%Hh%i") samedi_fin_formater
, TIME_FORMAT(t1.samedi_debut2, "%Hh%i") samedi_debut2_formater
, TIME_FORMAT(t1.samedi_fin2, "%Hh%i") samedi_fin2_formater
, TIME_FORMAT(t1.dimanche_debut, "%Hh%i") dimanche_debut_formater
, TIME_FORMAT(t1.dimanche_fin, "%Hh%i") dimanche_fin_formater
, TIME_FORMAT(t1.dimanche_debut2, "%Hh%i") dimanche_debut2_formater
, TIME_FORMAT(t1.dimanche_fin2, "%Hh%i") dimanche_fin2_formater
, t1.lundi_debut
, t1.lundi_fin
, t1.lundi_debut2
, t1.lundi_fin2
, t1.lundi_fermer
, t1.mardi_debut
, t1.mardi_fin
, t1.mardi_debut2
, t1.mardi_fin2
, t1.mardi_fermer
, t1.mercredi_debut
, t1.mercredi_fin
, t1.mercredi_debut2
, t1.mercredi_fin2
, t1.mercredi_fermer
, t1.jeudi_debut
, t1.jeudi_fin
, t1.jeudi_debut2
, t1.jeudi_fin2
, t1.jeudi_fermer
, t1.vendredi_debut
, t1.vendredi_fin
, t1.vendredi_debut2
, t1.vendredi_fin2
, t1.vendredi_fermer
, t1.samedi_debut
, t1.samedi_fin
, t1.samedi_debut2
, t1.samedi_fin2
, t1.samedi_fermer
, t1.dimanche_debut
, t1.dimanche_fin
, t1.dimanche_debut2
, t1.dimanche_fin2
, t1.dimanche_fermer
, t1.slogan
, t1.video
, t2.titre ville
, "PARTENAIRES_LISTE" page
, "partenaire_fiche" body_id
, CONCAT("https://runce.re/partenaires/", t1.slug) lien
, t1.titre titre_de_la_page
, t1.slogan sous_titre
, t3.nom_de_la_voie
, t3.n_de_la_voie
, t3.adresse_complementaire
, t3.code_postal
, FORMATER_TEL(t3.telephone, "#### ## ## ##") telephone
, IF(t4.id = 4 || t4.id = 5, "", t4.titre) type_de_voie
, t5.sha1_id
FROM partenaires_liste t1
LEFT JOIN partenaires_adresses t3 ON t1.id = t3.id_partenaires_liste
LEFT JOIN villes t2 ON t3.id_villes = t2.id
LEFT JOIN type_de_voie t4 ON t4.id = t3.id_type_de_voie
LEFT JOIN membres t5 ON t5.id = t1.id_membres
WHERE t1.visible = 1
AND t1.slug = "thim-loc-reunion.html"
AND t5.suspendu = 0
AND t5.supprimer = 0
AND t5.desactiver = 0
AND t5.visible = 1
ORDER BY t3.siege_social DESC
- msg: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column ``.``.`unformatted_value` at row 1
- valider: