SELECT doId, doTitre, doChapeau, doEdito, dotId, dotLibelle FROM dossier INNER JOIN dossier_type ON doType = dotId WHERE doId = 69

SELECT COUNT(*) FROM avis WHERE avType = 2 AND avRefId = 69

SELECT film.id, titre, annee, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ), mfMedId, rewriterules, genre, DATE_FORMAT( sortie, '%d/%m/%Y' ), resume, avIsCritique FROM film_dossier INNER JOIN film ON idFilm=id AND idDossier = 69 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 = 1 ) LEFT JOIN media_film ON ( id = mfFiId AND mfDefault = '1' ) WHERE fiActif = '1' AND peType & 2 AND fpType = 'r' ORDER BY titre ASC

: - ToBeFred Cinéma

INSERT INTO log_script ( file, querystring, ip, datecreation ) VALUES ('dossier/dossier.php', 'doId=69&from=28', '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




:

Sommaire de "" | Ajouter un commentaire

film

SELECT film.id, titre, annee, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ), mfMedId, rewriterules, genre, DATE_FORMAT( sortie, '%d/%m/%Y' ), resume, avIsCritique FROM film_dossier INNER JOIN film ON idFilm=id AND idDossier = 69 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 = 1 ) LEFT JOIN media_film ON ( id = mfFiId AND mfDefault = '1' ) WHERE fiActif = '1' AND peType & 2 AND fpType = 'r' ORDER BY titre ASC

 



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

 

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