Saint-Genis d'Hiersac




____________________________________________________
zz_hs3d_ghiersac - attention, requête SQL impossible à réaliser...
Code : 1064
Message d'erreur : 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 ')' at line 1
select * from hs3d_param_etablissement where id_param_etablissement = '1'
select * from hs3d_param_lang where (pl_actif=1 and pl_code='fr') or (pl_actif=1 and pl_code<>'fr') order by if(pl_code='fr',1,0) + pl_actif desc limit 0,1
SELECT ee.*,veip.dd_filename,veip.dd_v_mini,veip.dd_v_medium,veip.dd_v_maxi FROM hs3d_view_elements ee left outer join hs3d_view_elements_imagemedaillon veip on (ee.id_elements_element=veip.id_fk_dd) where ee.id_elements_element='1041' and idlang='1'
select eet_meta_description from hs3d_elements_element_trad where fk_id_elements_element='1041'
select titre,ee_url from hs3d_view_elements where id_elements_cat=13 and idlang='1' and ee_actif = 1 order by ee_ordre,titre
SELECT id_elements_element, titre, texte, ee_url FROM hs3d_view_elements WHERE id_elements_cat=7 AND idlang=1 and ee_actif=1
SELECT * FROM hs3d_elements_element_caract eec INNER JOIN hs3d_elements_caract ec ON (eec.fk_id_elements_caract= ec.id_elements_caract) INNER JOIN hs3d_elements_element ee ON (eec.fk_id_elements_element=ee.id_elements_element) WHERE ec.caract_code='CARACT_VIE' order by ee_ordre
SELECT * FROM hs3d_elements_element_caract eec INNER JOIN hs3d_elements_caract ec ON (eec.fk_id_elements_caract= ec.id_elements_caract) INNER JOIN hs3d_elements_element ee ON (eec.fk_id_elements_element=ee.id_elements_element) WHERE ec.caract_code='CARACT_LOISIRS'
SELECT dd.dd_filename,dd.dd_v_mini,dd.dd_v_medium,dd.dd_v_maxi,dd_intitule,caract_code as bgPosY FROM hs3d_documents_document dd inner join hs3d_elements_element ee on (ee.id_elements_element = dd.id_fk_dd) left join hs3d_elements_element_caract eec on (eec.fk_id_elements_element=ee.id_elements_element) inner join hs3d_elements_caract ec on (ec.id_elements_caract=eec.fk_id_elements_caract and fk_id_elements_caract_type=9) where id_fk_dd='1041' and dd_typemime='image' and dd_inclusion like '%,3,%' and dd_table_fk='elements'
SELECT dd.dd_filename,dd.dd_v_mini,dd.dd_v_medium,dd.dd_v_maxi,dd_intitule FROM hs3d_documents_document dd where id_fk_dd='1041' and dd_typemime='image' and dd_inclusion like '%,1,%' and CONVERT(dd_v_maxi ,UNSIGNED INTEGER) >= 1500 and dd_table_fk='elements'
SELECT dd.dd_filename FROM hs3d_documents_document dd where id_fk_dd='864' and dd_typemime='image' and dd_inclusion like '%,3,%' and dd_table_fk='elements' order by rand() limit 0,1
SELECT * FROM hs3d_view_elements ve WHERE ve.id_elements_element='1041' and ve.idlang=1 AND ve.ee_actif=1
SELECT dd_filename,dd_intitule FROM hs3d_view_elements ee left outer join hs3d_documents_document dd on (ee.id_elements_element=dd.id_fk_dd) WHERE ee.id_elements_element='1041' and idlang=1 and dd_inclusion LIKE '%,,%'
SELECT dd_filename,dd_intitule FROM hs3d_view_elements ee left outer join hs3d_documents_document dd on (ee.id_elements_element=dd.id_fk_dd) WHERE ee.id_elements_element='1041' and idlang=1 and dd_inclusion LIKE '%,2,%'
SELECT dd_filename,dd_intitule FROM hs3d_view_elements ee left outer join hs3d_documents_document dd on (ee.id_elements_element=dd.id_fk_dd) WHERE ee.id_elements_element='1041' and idlang=1 and dd_inclusion LIKE '%,1,%'
select group_concat(ec.fk_id_elements_element_texte) from hs3d_elements_element_caract eec inner join hs3d_elements_caract ec on (ec.id_elements_caract=eec.fk_id_elements_caract) where fk_id_elements_element='1041'
select titre,ee_url from hs3d_view_elements where id_elements_element in ()
____________________________________________________


  La Mairie sera exceptionnellement fermée au public le Mercredi 7 Avril 2021

Les Actualités de la commune de Saint-Genis d'Hiersac
 
mairie-stgenis-hiersac@wanadoo.fr
Tel 05 45 21 46 06

Fax 05 45 21 99 02
11 route des Meulières
16570 SAINT-GENIS-d'HIERSAC
Lundi de 9h00 à 12h00 et de 14h00 à 17h30
Le Mercredi de 9h00 à 12h00 et de 14h00 à 17h30
Du Jeudi au Vendredi de 14h00 à 17h30
Contacter la Mairie de Saint-Genis d'Hiersac

N'hésitez pas à nous contacter pour toute demande d'informations !