mysql> select chanid, channum, freqid, callsign, xmltvid, channel.mplexid, frequency, transportid, networkid
    -> from channel join dtv_multiplex on channel.mplexid = dtv_multiplex.mplexid;
+--------+---------+--------+--------------+---------+---------+-----------+-------------+-----------+
| chanid | channum | freqid | callsign     | xmltvid | mplexid | frequency | transportid | networkid |
+--------+---------+--------+--------------+---------+---------+-----------+-------------+-----------+
|   1000 | 102     | NULL   | ABC HD       | 71      |       1 | 205625000 |         529 |      4112 | 
|   1001 | 2       | NULL   | ABC          | 57      |       1 | 205625000 |         529 |      4112 | 
|   1002 | 22      | NULL   | ABC2         | 58      |       1 | 205625000 |         529 |      4112 | 
|   1003 | 222     | NULL   | ABC TV       |         |       1 | 205625000 |         529 |      4112 | 
|   1004 | 103     | NULL   | SBS HD       | 73      |       2 | 543500000 |         848 |     12802 | 
|   1005 | 3       | NULL   | SBS          | 59      |       2 | 543500000 |         848 |     12802 | 
|   1006 | 33      | NULL   | SBSNews      | 60      |       2 | 543500000 |         848 |     12802 | 
|   1007 | 31      | NULL   | SBS EPG      |         |       2 | 543500000 |         848 |     12802 | 
|   1008 | 9       | NULL   | WIN          | 54      |       3 | 219500000 |       12922 |     12915 | 
|   1009 | 109     | NULL   | WIN HD       | 75      |       3 | 219500000 |       12922 |     12915 | 
|   1010 | 7       | NULL   | 7            | 56      |       4 | 226500000 |        2462 |     12929 | 
|   1011 | 107     | NULL   | Prime HD     | 72      |       4 | 226500000 |        2462 |     12929 | 
|   1012 | 2401    | NULL   | PRIME View 1 |         |       4 | 226500000 |        2462 |     12929 | 
|   1013 | 2402    | NULL   | PRIME View 2 |         |       4 | 226500000 |        2462 |     12929 | 
|   1014 | 2403    | NULL   | PRIME View 3 |         |       4 | 226500000 |        2462 |     12929 | 
|   1015 | 10      | NULL   | Ten          | 55      |       5 | 177500000 |        2055 |     12812 | 
|   1016 | 110     | NULL   | Ten HD       | 74      |       5 | 177500000 |        2055 |     12812 | 
+--------+---------+--------+--------------+---------+---------+-----------+-------------+-----------+
17 rows in set (0.01 sec)