INSERT INTO log_script ( file, querystring, ip, datecreation ) VALUES ('news/news.php', 'from=29&typeNews=5', '54.81.45.122', 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 news

SELECT neId, neChapo, neContenu, netLibelle, DATE_FORMAT( neDatecreation, '%d/%m/%Y' ) AS neDatecreationFormated, neType FROM news INNER JOIN news_type ON netId = neType WHERE netId = 5 ORDER BY neDatecreation DESC

 


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