mysql> select mplexid, frequency, networkid, transportid from dtv_multiplex; +---------+-----------+-----------+-------------+ | mplexid | frequency | networkid | transportid | +---------+-----------+-----------+-------------+ | 90 | 505833330 | 9018 | 4100 | | 91 | 481833330 | 9018 | 8197 | | 92 | 561833330 | 9018 | 12290 | | 93 | 529833330 | 9018 | 16384 | | 94 | 578166670 | 9018 | 20480 | | 95 | 537833330 | 9018 | 24576 | | 96 | 482000000 | NULL | NULL | | 97 | 482000000 | NULL | NULL | | 98 | 506000000 | NULL | NULL | | 99 | 530000000 | NULL | NULL | | 100 | 538000000 | NULL | NULL | | 101 | 562000000 | NULL | NULL | | 102 | 578000000 | NULL | NULL | +---------+-----------+-----------+-------------+ 13 rows in set (0.00 sec)