rendered paste bodymysql> SELECT callsign, xmltvid FROM channel;
+----------------------+------------------------------------------+
| callsign | xmltvid |
+----------------------+------------------------------------------+
| BBC ONE | north-west.bbc1.bbc.co.uk |
| BBC TWO | north-west.bbc2.bbc.co.uk |
| BBC THREE | choice.bbc.co.uk |
| BBC NEWS 24 | news-24.bbc.co.uk |
| BBCi | |
| 1005 | men.granadatv.co.uk |
| ITV1 | granadatv.co.uk |
| ITV3 | itv3.itv.co.uk |
| ITV2 | itv2.itv.co.uk |
| Channel 4 | channel4.com |
| E4 | e4.channel4.com |
| 705 | |
| five | channel5.co.uk |
| abc1 | abc1.disney.com |
| Teachers' TV | |
| BBC PARLMNT | |
| BBC FOUR | knowledge.bbc.co.uk |
| Adventure One | adventure-one.nationalgeographic.co.uk |
| Sky News | sky-news.sky.com |
| Sky Spts News | news.sports.sky.com |
| Sky Three | sky-three.sky.com |
| UKTV History | ukhistory.tv |
| E4+1 | plus-1.e4.channel4.com |
| The HITS | the-hits.emap.com |
| TMF | tmf.nl |
| UKTV Br'tIdeas | ukbrightideas.tv |
| f tn | ftn.tv |
| More 4 | more4.channel4.com |
| ITV4 | itv4.itv.co.uk |
| Scuzz | scuzz.tv |
| Sky Travel Extra | travel-extra.sky.co.uk |
| 1041 | sky-three.sky.com |
| Sky Travel | travel.sky.co.uk |
| Classic FM TV | tv.classicfm.com |
| Toonami | Toonami.cartoonnetwork.com |
| Boomerang | boomerang.cartoonnetwork.com |
| CNN International | europe.cnn.com |
| Cartoon Network | uk.cartoonnetwork.com |
| Film4 +1 | plus-1.filmfour.channel4.com |
| Film4 | filmfour.channel4.com |
| History Channel | thehistorychannel.co.uk |
| Men & Motors | men.granadatv.co.uk |
| Disney Channel | disneychannel.disney.co.uk |
| CNBC | europe.cnbc.com |
| Sky Sports 1 | 1.sports.sky.com |
| UKTV History | ukhistory.tv |
| UKTV Gold | uk-gold.flextech.telewest.co.uk |
| UKTV Style | uk-style.flextech.telewest.co.uk |
| UKTV Drama | uk-drama.flextech.telewest.co.uk |
| Nicktoons TV | toons.nickelodeon.co.uk |
| UKTV Gold +1 | plus-1.uk-gold.flextech.telewest.co.uk |
| Eurosport 2 | 2.british.eurosport.com |
| Discovery Wings | wings.discoveryeurope.com |
| Discovery Kids | kids.discoveryeurope.com |
| Discovery Home & Hea | health.discovery.com |
| UKTV Style+1 | plus-1.uk-style.flextech.telewest.co.uk |
| UKTV Food | uk-food.flextech.telewest.co.uk |
| Zone Horror | horrorchannel.com |
| Motors TV | motors.tv |
| UKTV Style Gardens | gardens.uk-style.flextech.telewest.co.uk |
| Disney Cinemagic | cinemagic.disney.co.uk |
| Disney Channel+1 | plus-1.disneychannel.disney.co.uk |
| Playhouse Disney | playhouse.disney.co.uk |
| Sky Sports Xtra | extra.sports.sky.com |
| PremPlus | premiership-plus.sports.sky.com |
| The Hallmark Channel | hallmarkchannelint.com |
| Nickelodeon | nickelodeon.co.uk |
| Sky Movies 9 | 4.moviemax.sky.com |
| Sky Movies 8 | 5.moviemax.sky.com |
| Sky Sports 3 | 3.sports.sky.com |
| MTV Dance | dance.mtv.co.uk |
| Turner Classic Movie | tcm.turner.com |
| film4 | filmfour.channel4.com |
| Five US | us.channel5.co.uk |
| Five Life | life.channel5.co.uk |
| Sky Movies 7 | 4.premier.sky.com |
| Sky Movies 6 | 3.moviemax.sky.com |
| Sky Movies 5 | 3.premier.sky.com |
| LIVINGtv+1 | plus-1.livingtv.co.uk |
| ChannelM | channelm.co.uk |
| Sky Sports 2 | 2.sports.sky.com |
| UKTV Documentary | uk-documentary.flextech.telewest.co.uk |
| UKTV G2 | plus-1.g2.uktv.flextech.telewest.co.uk |
| UKTV People | uk-people.flextech.telewest.co.uk |
| E! Entertainment | eentertainment.com |
| Sky Cinema 1 | cinema.sky.com |
| Sky Cinema 2 | 2.cinema.sky.com |
| Heart | |
| BBC Radio 1 | |
| BBC Radio 2 | |
| BBC Radio 3 | |
| BBC Radio 4 | |
| heat | |
| MOJO | |
| 1Xtra BBC | |
| BBC 7 | |
| BBC 6 Music | |
| BBC 5L SportsX | |
| BBC R5 Live | |
| Virgin Radio | |
| 3C | |
| talkSPORT | |
| Kiss | |
| Smash Hits! | |
| Kerrang! | |
| smooth fm | |
| oneword | |
| BBC World Sv. | |
| The Hits Radio | |
| Magic | |
| Q | |
| Smash Hits | smashhits.net |
| TV5 | tv5.org |
| Magic | magictv.co.uk |
| Kerrang | kerrang.com |
| Boomerang+1 | boomerang.cartoonnetwork.com |
| The Box | thebox.co.uk |
| National Geographic | nationalgeographic.co.uk |
| Sky Movies 3 | sky-two.sky.com |
| Sky Movies 4 | sky-two.sky.com |
| Sky Movies 1 | ondigital.premier.sky.com |
| Sky Movies 2 | moviemax.sky.com |
| Sky One | sky-one.sky.com |
| CITV | citv.itv.co.uk |
| Sky Sports News | news.sports.sky.com |
| Q | q4music.com |
| Kiss | kiss-tv.kiss100.com |
| FX | fxuk.tv |
| VH1 Classic | classic.vh1online.co.uk |
| MTV Base | base.mtv.co.uk |
| MTV Hits | hits.mtv.co.uk |
| MTV2 | mtv2europe.com |
| VH1 | vh1.co.uk |
| MTV UK | mtv.co.uk |
| Nick Junior | jr.nickelodeon.co.uk |
| UKTV Bright Ideas | ukbrightideas.tv |
| NASN - American Spor | nasn.com |
| SetantaSports1 | 1.setanta.com |
| Sky Two | sky-two.sky.com |
| 301 | |
| 302 | |
| 303 | |
| 305 | |
| Five US | us.channel5.co.uk |
| British Eurosport | british.eurosport.com |
| Sci-Fi Channel | uk.scifi.com |
| Flaunt | flaunt.tv |
| Paramount Comedy 2 | 2.paramountcomedy.com |
| Paramount Comedy | paramountcomedy.com |
| LIVINGtv 2 | 2.livingtv.co.uk |
| Bravo +1 | plus-1.bravo.co.uk |
| Challenge+1 | plus-1.challengetv.co.uk |
| UKTV G2 +1 | plus-1.g2.uktv.flextech.telewest.co.uk |
| Extreme Sports | extreme.com |
| Discovery Channel | discoveryeurope.com |
| Animal Planet | animalplanet.discoveryeurope.com |
| Disc Realtime | home.discoveryeurope.com |
| Discovery Chan +1 | plus-1.discoveryeurope.com |
| Disc Travel & Living | travel.discoveryeurope.com |
| Discovery Science | sci-trek.discoveryeurope.com |
| Disc Civilisations | civilisations.discoveryeurope.com |
| ABC1 | abc1.disney.com |
| Bravo | bravo.co.uk |
| Trouble | trouble.co.uk |
| LIVINGtv | livingtv.co.uk |
| Challenge | challengetv.co.uk |
| Phoenix CNE | phoenixcne.com |
| Nick Replay | replay.nickelodeon.co.uk |
| National Geographic+ | plus-1.nationalgeographic.co.uk |
| The Biography Channe | biography-channel.biography.com |
| History Channel+1 | plus-1.thehistorychannel.co.uk |
+----------------------+------------------------------------------+