CREATE TEMPORARY TABLE IF NOT EXISTS tmp_media ( medId MEDIUMINT(4) )
INSERT INTO tmp_media ( medId )
SELECT medId
FROM media
SELECT m.medId, medType, medWidth, medHeight, medSize, TRUNCATE( nbNow, 0 ), progression, pourcentage, medDesc
FROM media m
INNER JOIN tmp_media tm ON m.medId = tm.medId
LEFT JOIN _synthese_consultation sc ON ( m.medId = sc.id AND type = 4 )
WHERE 1 = 1
SELECT m.medId, medType, medWidth, medHeight, medSize, TRUNCATE( nbNow, 0 ), progression, pourcentage, medDesc
FROM media m
INNER JOIN tmp_media tm ON m.medId = tm.medId
LEFT JOIN _synthese_consultation sc ON ( m.medId = sc.id AND type = 4 )
WHERE 1 = 1
ORDER BY medDesc ASC LIMIT 0, 20
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
Médiathèque
«« Premier « Précédent| 1 / 1 |Suivant »Dernier »»
SELECT mfMedId, rewriterules, titre, annee, genre
FROM film
LEFT JOIN media_film ON ( id = mfFiId AND mfDefault = '1' )
WHERE id =