SQL - Connexion MySQL : - db_link=Resource id #3
SQL - SELECT *,state.*,state.chrono as state,cat.nom as cat_name,elt.nom as nom,elt.description as description,elt.mot as keywords_site,DATE_FORMAT(elt.date_add,'%d/%m/%Y') AS date_for,DATE_FORMAT(elt.date_add,'%d/%m/%Y') AS date_add, DATE_FORMAT(elt.date_edited,'%d/%m/%Y') AS date_edited, IF((TO_DAYS(CURRENT_DATE)-TO_DAYS(elt.date_add))<14,'1','0') as new FROM 5nref_site as elt LEFT JOIN 5nref_state as state ON elt.id_state=state.id LEFT JOIN 5nref_user as user ON elt.id_user=user.id LEFT JOIN 5nref_cat as cat ON cat.id=elt.cat WHERE elt.id='118' AND state.chrono='1' LIMIT 0,1 - Resource id #8
Page générée en 0.047 seconde