mysql> select * from channel where callsign like 'ZDF' -> \G *************************** 1. row *************************** chanid: 5102 channum: 002 freqid: NULL sourceid: 5 callsign: ZDF name: ZDF icon: /home/mythtv/.mythtv//channels/zdf_de.jpg finetune: NULL videofilters: xmltvid: recpriority: 0 contrast: 32768 brightness: 32768 colour: 32768 hue: 32768 tvformat: Default commfree: 0 visible: 1 outputfilters: useonairguide: 1 mplexid: 43 serviceid: 28006 atscsrcid: NULL tmoffset: 0 atsc_major_chan: 0 atsc_minor_chan: 0 last_record: 0000-00-00 00:00:00 default_authority: commmethod: -1 1 row in set (0.00 sec) mysql> SELECT * FROM `dtv_multiplex` WHERE `mplexid` = 43 -> \G *************************** 1. row *************************** mplexid: 43 sourceid: 5 transportid: 1079 networkid: 1 frequency: 394000000 inversion: a symbolrate: 6900000 fec: none polarity: NULL modulation: qam_256 bandwidth: NULL lp_code_rate: NULL transmission_mode: NULL guard_interval: NULL visible: 0 constellation: NULL hierarchy: NULL hp_code_rate: NULL sistandard: dvb serviceversion: 30 updatetimestamp: 2009-04-19 22:17:58 1 row in set (0.00 sec)