include("../include/_connection.php"); $aujourdhui = getdate(); $thisYear = $aujourdhui['year']; $hereIs = ORIGIN_IS_COUPDECOEUR; $annee = GetValDefault( "annee", $thisYear ); $query = " SELECT film.id, titre, annee, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ), mfMedId, rewriterules, genre, DATE_FORMAT( sortie, '%d/%m/%Y' ), resume, avIsCritique FROM coupdecoeur INNER JOIN film ON ccidfilm = id INNER JOIN _film_personne fp ON fp.fpIdFilm = film.id INNER JOIN personne ON fp.fpIdPers = peId LEFT JOIN avis ON ( id = avRefId AND avIsCritique = '1' AND avType = ".AVIS_FILM." ) LEFT JOIN media_film ON ( id = mfFiId AND mfDefault = '1' ) WHERE annee = '".$annee."' AND fiActif = '1' ORDER BY ccDate DESC "; PutHtmlHeader( "Coup de coeur" ); ?>