UPDATE musique_links JOIN ( SELECT f.feed AS true_feed, l.url as url FROM globes__feed f JOIN globes__link l ON l.id = f.linkid ) as true_feeds ON true_feeds.url = musique_links.link_url SET musique_links.link_rss = true_feeds.true_feed WHERE musique_links.link_url = true_feeds.url AND musique_links.link_rss = '' // ajouter les flux UPDATE sante_links JOIN ( SELECT f.feed AS true_feed, l.url as url FROM moqs_feed f JOIN moqs_link l ON l.id = f.linkid ) as true_feeds ON true_feeds.url = sante_links.link_url SET sante_links.link_rss = true_feeds.true_feed WHERE sante_links.link_url = true_feeds.url AND sante_links.link_rss = '' // trouver les doublons SELECT DISTINCT(sante_links.link_id) FROM sante_links, sante_links as dtable WHERE dtable.link_rss = sante_links.link_rss AND sante_links.link_id > dtable.link_id AND dtable.link_rss <> '' AND sante_links.link_rss <> '' >> IDS UPDATE sante_links SET link_rss = '' WHERE link_id IN (IDS);