http://lol.net/Le Gourou du divertissementsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-10' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-09' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-08' order by vue desc limit 1 LoLGuruhttp://feedburner.google.comVoici la nouvelle bande annonce de The Amazing Spiderman aka Spiderman 4. Superbes images et personnage..Wed, 08 Feb 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-spiderman-4-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-07' order by vue desc limit 1 Voici la bande annonce complète présentée au Superbowl pour The Avengers. On rentre enfin dans le vif..Tue, 07 Feb 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-avengers-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-06' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-05' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-04' order by vue desc limit 1 Voici la bande annonce spéciale des Avengers pour le Superbowl 2012. C'est court, mais qu'est..Sat, 04 Feb 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-avengers-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-03' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-02' order by vue desc limit 1 Voici le Streaming d'American Pie 10 ans après en VF. Belle bande annonce qui nous fait retrouver..Thu, 02 Feb 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-american-pie-4-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-02-01' order by vue desc limit 1 Voici une interview de Jean Jacques Launier à propos de John Carter. Une bien belle réalisation devrait..Wed, 01 Feb 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-john-carter-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-31' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-30' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-29' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-28' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-27' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-26' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-25' order by vue desc limit 1 Voici quelques nouvelles images du tournage de Men in Black 3. On peut y voir plusieurs des belles..Wed, 25 Jan 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-men-in-black-3-vf-francais-vostfr-vo-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-24' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-23' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-22' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-21' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-20' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-19' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-18' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-17' order by vue desc limit 1 Voici une interview de Rihanna sur le tournage de BattleShip, bataille navale qui opposera les humains..Tue, 17 Jan 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-battleship-hd.htmsqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-16' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-15' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-14' order by vue desc limit 1 sqla SELECT idconcert,concert,DATE_FORMAT(date, '%d/%m/%Y'), descConcert, urlconcert FROM (concert c LEFT JOIN salle s on s.idsalle=c.idsalle LEFT JOIN ville v on v.idville=c.idville LEFT JOIN tournee t on t.idtournee=c.idtournee) , artiste a where c.idartiste=a.idartiste and valide=1 and DATE_FORMAT(date_add(creation, INTERVAL 1 DAY), '%Y-%m-%d')='2012-01-13' order by vue desc limit 1 Voici la bande annonce des infidèles, comédies qui vous montrera la réalité de certains hommes, ainsi..Fri, 13 Jan 2012 00:00:00 +0200http://bande-annonce.lol.net/bande-annonce-les-infideles-hd.htm