INSERT INTO log_script ( file, querystring, ip, datecreation ) VALUES ('avis/lastavis.php', 'from=35', '54.198.134.127', Now())


   

Erreur de requête à la base : Server is running in --secure-auth mode, but 'fred'@'localhost' has a password in the old format; please change the password to the new format (1275).
Si celà a provoqué une anomalie dans votre compte. Veuillez nous contacter à webmaster@tobefred.net

SELECT peId , COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ) AS label , peType, peSexe , CASE WHEN peDatedeces IS NOT NULL THEN DATE_FORMAT( FROM_DAYS( TO_DAYS( peDatedeces ) - TO_DAYS( peDatenaiss ) ), '%y' ) ELSE DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW() ) - TO_DAYS( peDatenaiss ) ), '%y' ) END AS age , mpMedId FROM personne INNER JOIN media_personne ON ( mpPeId = peId AND mpDefault = '1' ) WHERE peDatedeces IS NULL AND peDatenaiss IS NOT NULL AND MONTH( peDatenaiss ) = MONTH( NOW() ) AND DAYOFMONTH( peDatenaiss ) = DAYOFMONTH( NOW() )


SELECT peId, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ) AS label FROM personne ORDER BY peDatecreation DESC, peNom, pePrenom LIMIT 0, 10


SELECT pos, idfilm, film.titre, moyenne, nbvote, film.rewriterules, avIsCritique FROM classement_film INNER JOIN film ON idfilm = id LEFT JOIN avis ON ( id = avRefId AND avIsCritique = '1' AND avType = 1 ) WHERE pos > 0 AND idfilm <> 184 ORDER BY pos ASC LIMIT 0, 10


Les derniers commentaires postés par les internautes

SELECT avId, avRefId, avType, avChapo, avTexte, COALESCE( uLogin, avAuteur ), DATE_FORMAT(avDatecreation, '%d/%m/%Y %H:%i:%s'), COALESCE( titre, doTitre, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ) ), vote.note, rewriterules, uId, avIsCritique FROM avis LEFT JOIN film ON ( avRefId = id and avType = 1 ) LEFT JOIN dossier ON ( avRefid = doId and avType = 2 ) LEFT JOIN personne ON ( avRefId = peId and avType = 3 ) LEFT JOIN utilisateur ON avUId = uId LEFT JOIN vote ON ( avis.avRefId = vote.id_film AND avis.avIp = vote.ip AND avType = 1 ) WHERE 1 = 1 AND avIsCritique = '0' ORDER BY avDatecreation DESC LIMIT 0, 20

 


SELECT id, titre, avIsCritique, rewriterules FROM film LEFT JOIN avis ON ( id = avRefId AND avIsCritique = '1' AND avType = 1 ) WHERE en_exploitation = '1' AND fiActif = '1' ORDER BY sortie DESC LIMIT 0, 10


SELECT mfMedId, rewriterules, titre, annee, genre FROM film LEFT JOIN media_film ON ( id = mfFiId AND mfDefault = '1' ) WHERE id =

Un film au hasard

Affiche de

SELECT id, titre, avIsCritique, rewriterules FROM film LEFT JOIN avis ON ( id = avRefId AND avIsCritique = '1' AND avType = 1 ) WHERE fiActif = '1' ORDER BY datemaj DESC LIMIT 0, 10

 

tobefred.zoy.org est valide XHTML 1.0 Strict! | Haut de page | Contact | Politique d'accessibilité | Conception : Frédéric Bernier-Malcoiffe | Mentions légales