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')='2015-05-13' 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')='2015-05-12' 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')='2015-05-11' 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')='2015-05-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')='2015-05-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')='2015-05-08' 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')='2015-05-07' 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')='2015-05-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')='2015-05-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')='2015-05-04' 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')='2015-05-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')='2015-05-02' 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')='2015-05-01' 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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-25' 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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-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')='2015-04-17' 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')='2015-04-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')='2015-04-15' order by vue desc limit 1