SELECT ee . * ,eet.eet_texte,eet.eet_titre,eet.eet_titre_html_suite, eet2.eet_titre as titre_prestation, dd_filename
FROM hs3d_elements_element ee
INNER JOIN hs3d_elements_element ee2 ON ( ee2.fk_id_elements_cat =6
AND ee2.ee_url = ee.ee_url_externe )
INNER JOIN hs3d_elements_element_trad eet2 ON ( ee2.id_elements_element = eet2.fk_id_elements_element
AND eet2.fk_id_param_lang = ) left outer join hs3d_elements_element_trad eet on (ee.id_elements_element=eet.fk_id_elements_element and eet.fk_id_param_lang=) left outer join hs3d_documents_document dd on (ee.id_elements_element=dd.id_fk_dd and dd_typemime='image' and dd_inclusion like '%,4,%') where ee.fk_id_elements_cat=15 and ee.ee_titre not like '11%' order by rand()
