MariaDB [mythconverg]> select chanid,channum,freqid,sourceid,callsign,name,xmltvid,mplexid,serviceid,visible,deleted from channel where sourceid=1 order by channum+0; +--------+---------+--------+----------+-------------------+-------------------+-------------------------------+---------+-----------+---------+---------------------+ | chanid | channum | freqid | sourceid | callsign | name | xmltvid | mplexid | serviceid | visible | deleted | +--------+---------+--------+----------+-------------------+-------------------+-------------------------------+---------+-----------+---------+---------------------+ | 1001 | 1 | 34 | 1 | TVNZ 1 | TVNZ 1 | tvnz1.freeviewnz.tv | 2 | 1200 | 1 | NULL | | 1002 | 2 | 34 | 1 | TVNZ 2 | TVNZ 2 | tvnz2.freeviewnz.tv | 2 | 1201 | 1 | NULL | | 1003 | 3 | 32 | 1 | Three | Three | three.freeviewnz.tv | 29 | 1300 | 1 | NULL | | 1004 | 4 | 32 | 1 | Bravo | Bravo | bravo.freeviewnz.tv | 29 | 1307 | 1 | NULL | | 1005 | 5 | 38 | 1 | Maori Television | Maori Television | maori-tv.freeviewnz.tv | 21 | 1600 | 1 | NULL | | 1013 | 6 | 34 | 1 | TVNZ DUKE | TVNZ DUKE | tvnz-duke.freeviewnz.tv | 2 | 1205 | 1 | NULL | | 1007 | 7 | 34 | 1 | TVNZ 2 +1 | TVNZ 2 +1 | tvnz2-plus1.freeviewnz.tv | 2 | 1207 | 1 | NULL | | 10800 | 8 | 32 | 1 | eden | eden | eden.freeviewnz.tv | 29 | 1303 | 1 | NULL | | 1009 | 9 | 32 | 1 | Bravo PLUS 1 | Bravo PLUS 1 | bravo-plus1.freeviewnz.tv | 29 | 1308 | 1 | NULL | | 1010 | 10 | 36 | 1 | PRIME | PRIME | prime.freeviewnz.tv | 4 | 1404 | 1 | NULL | | 1006 | 11 | 34 | 1 | TVNZ 1 +1 | TVNZ 1 +1 | tvnz1-plus1.freeviewnz.tv | 2 | 1206 | 1 | NULL | | 1011 | 11 | 32 | 1 | The Edge TV | The Edge TV | theedgetv.freeviewnz.tv | 3 | 1305 | 1 | 2022-03-21 05:47:28 | | 1012 | 12 | 36 | 1 | ChoiceTV | Choice TV | choice.freeviewnz.tv | 4 | 1407 | 1 | 2022-03-21 05:47:28 | | 1114 | 12 | 34 | 1 | TVNZ DUKE+1 | TVNZ DUKE+1 | tvnz-duke-plus1.freeviewnz.tv | 2 | 1208 | 0 | NULL | | 1008 | 13 | 32 | 1 | ThreePlus1 | ThreePlus1 | three-plus1.freeviewnz.tv | 29 | 1302 | 1 | NULL | | 11019 | 14 | 32 | 1 | Rush | Rush | rush.freeviewnz.tv | 29 | 1301 | 1 | NULL | | 1024 | 15 | 38 | 1 | Te Reo | Te Reo | te-reo.freeviewnz.tv | 21 | 1601 | 1 | NULL | | 11020 | 18 | 36 | 1 | eden+1 | eden+1 | eden-plus1.freeviewnz.tv | 4 | 1402 | 1 | NULL | | 1017 | 19 | 32 | 1 | HGTV | HGTV | hgtv.freeviewnz.tv | 1 | 1508 | 1 | NULL | | 1016 | 20 | 32 | 1 | Al Jazeera | Al Jazeera | aljazeera.freeviewnz.tv | 1 | 1502 | 1 | NULL | | 1021 | 25 | 36 | 1 | Shine TV | Shine TV | shine.freeviewnz.tv | 1 | 6002 | 1 | NULL | | 1026 | 26 | 36 | 1 | Firstlight | Firstlight | firstlight.freeviewnz.tv | 4 | 1414 | 1 | NULL | | 1027 | 27 | 32 | 1 | Hope Channel | Hope Channel | hope-channel.freeviewnz.tv | 1 | 1506 | 1 | NULL | | 1028 | 28 | 36 | 1 | ChineseTV | ChineseTV | chinesetv.freeviewnz.tv | 4 | 1403 | 1 | NULL | | 1022 | 31 | 36 | 1 | Parliament | Parliament | parliament.freeviewnz.tv | 4 | 1401 | 1 | NULL | | 1033 | 33 | 36 | 1 | C33 | C33 | c33.freeviewnz.tv | 4 | 1405 | 1 | NULL | | 1050 | 50 | 36 | 1 | Radio NZ National | Radio NZ National | rnz-national.freeviewnz.tv | 1 | 1507 | 1 | NULL | | 1051 | 51 | 36 | 1 | Radio NZ Concert | Radio NZ Concert | rnz-concert.freeviewnz.tv | 4 | 2001 | 1 | NULL | | 1071 | 71 | 36 | 1 | BaseFM | BaseFM | basefm.freeviewnz.tv | 4 | 2002 | 1 | NULL | | 1107 | 107 | 34 | 1 | TVNZ 7 | TVNZ 7 | tvnz7.freeviewnz.tv | 2 | 1203 | 1 | 2012-07-01 00:00:00 | | 1200 | 200 | 36 | 1 | CH200 | CH200 | ch200.freeviewnz.tv | 4 | 1400 | 1 | NULL | | 10500 | 500 | NULL | 1 | INFO CHANNEL | INFO CHANNEL | info-channel.freeviewnz.tv | 2 | 12500 | 1 | NULL | +--------+---------+--------+----------+-------------------+-------------------+-------------------------------+---------+-----------+---------+---------------------+ 32 rows in set (0.002 sec)