mysql> 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 | +----------------------+------------------------------------------+