rendered paste bodymysql> 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)