[Summary view] [Print] [Text view]

   1  UPDATE musique_links JOIN (
   2  SELECT f.feed AS true_feed, l.url as url FROM globes__feed f JOIN globes__link l ON l.id = f.linkid
   3  ) as true_feeds
   4  ON true_feeds.url = musique_links.link_url
   5  SET musique_links.link_rss = true_feeds.true_feed
   6  WHERE musique_links.link_url = true_feeds.url
   7  AND musique_links.link_rss = ''
   8  
   9  
  10  // ajouter les flux
  11  UPDATE sante_links JOIN (
  12  SELECT f.feed AS true_feed, l.url as url FROM moqs_feed f JOIN moqs_link l ON l.id = f.linkid
  13  ) as true_feeds
  14  ON true_feeds.url = sante_links.link_url
  15  SET sante_links.link_rss = true_feeds.true_feed
  16  WHERE sante_links.link_url = true_feeds.url
  17  AND sante_links.link_rss = ''
  18  
  19  
  20  // trouver les doublons
  21  SELECT DISTINCT(sante_links.link_id) FROM sante_links, sante_links as dtable   
  22  WHERE dtable.link_rss = sante_links.link_rss 
  23  AND sante_links.link_id > dtable.link_id 
  24  AND dtable.link_rss <> ''
  25  AND sante_links.link_rss <> '' 
  26  >> IDS 
  27  UPDATE sante_links SET link_rss = '' WHERE link_id IN (IDS);
  28  
  29  
  30