API tools faq
paste
Guest User

Untitled

a guest
Nov 7th, 2013
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.55 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT channum, substring_index(channum,"_",1) as majornum, substring_index(channum,"_",2) as minornum, name FROM channel ORDER BY LENGTH(majornum), majornum, minornum;
  2. +---------+----------+----------+------------------------------------------+
  3. | channum | majornum | minornum | name |
  4. +---------+----------+----------+------------------------------------------+
  5. | 1_1 | 1 | 1_1 | WhatsOn |
  6. | 1_10 | 1 | 1_10 | Coastal |
  7. | 1_11 | 1 | 1_11 | Jewelry |
  8. | 1_12 | 1 | 1_12 | Peanut |
  9. | 1_13 | 1 | 1_13 | QH Radi |
  10. | 1_14 | 1 | 1_14 | C-Music |
  11. | 1_15 | 1 | 1_15 | La-Voz |
  12. | 1_2 | 1 | 1_2 | QH-TV |
  13. | 1_3 | 1 | 1_3 | TF-TV |
  14. | 1_4 | 1 | 1_4 | Cool TV |
  15. | 1_5 | 1 | 1_5 | DiyaTV |
  16. | 1_6 | 1 | 1_6 | Viet.TD |
  17. | 1_7 | 1 | 1_7 | Family |
  18. | 1_8 | 1 | 1_8 | i2TV |
  19. | 1_9 | 1 | 1_9 | Corner |
  20. | 2_1 | 2 | 2_1 | KTVU-TV |
  21. | 2_2 | 2 | 2_2 | KTVU-SD |
  22. | 4 | 4 | 4 | |
  23. | 4_1 | 4 | 4_1 | KRON-SD |
  24. | 4_2 | 4 | 4_2 | KRON-HD |
  25. | 5_1 | 5 | 5_1 | KPIX-DT |
  26. | 7_1 | 7 | 7_1 | KGO-HD |
  27. | 7_2 | 7 | 7_2 | LIVWELL |
  28. | 7_3 | 7 | 7_3 | KGOACCU |
  29. | 8 | 8 | 8 | |
  30. | 9 | 9 | 9 | |
  31. | 9_1 | 9 | 9_1 | KQED-HD |
  32. | 9_2 | 9 | 9_2 | KTEH-DT |
  33. | 9_3 | 9 | 9_3 | WORLD |
  34. | 11_1 | 11 | 11_1 | KNTV-HD |
  35. | 11_2 | 11 | 11_2 | NBC+ |
  36. | 11_3 | 11 | 11_3 | US |
  37. | 14_1 | 14 | 14_1 | Univision |
  38. | 14_2 | 14 | 14_2 | KFSF-DT |
  39. | 20_1 | 20 | 20_1 | KOFY-HD |
  40. | 20_4 | 20 | 20_4 | Azteca |
  41. | 22_1 | 22 | 22_1 | KRCB-DT |
  42. | 22_2 | 22 | 22_2 | KRCB-C |
  43. | 22_3 | 22 | 22_3 | KRCB-FM |
  44. | 26_1 | 26 | 26_1 | 26 San Francisco, CA |
  45. | 26_2 | 26 | 26_2 | 26 San Francisco, CA |
  46. | 26_3 | 26 | 26_3 | KTSF-D3 |
  47. | 26_4 | 26 | 26_4 | KTSF-D4 |
  48. | 36_1 | 36 | 36_1 | KICU-TV |
  49. | 36_2 | 36 | 36_2 | KICU-SD |
  50. | 36_3 | 36 | 36_3 | KICUSD2 |
  51. | 38_1 | 38 | 38_1 | KCNS |
  52. | 38_2 | 38 | 38_2 | KCNS-2 |
  53. | 38_3 | 38 | 38_3 | KCNS-3 |
  54. | 44_1 | 44 | 44_1 | KBCW-DT |
  55. | 48_1 | 48 | 48_1 | KSTS-HD |
  56. | 48_2 | 48 | 48_2 | KSTS-SD |
  57. | 54_1 | 54 | 54_1 | KTEH |
  58. | 54_2 | 54 | 54_2 | KQED |
  59. | 54_3 | 54 | 54_3 | LIFE |
  60. | 54_4 | 54 | 54_4 | KIDS |
  61. | 54_5 | 54 | 54_5 | V-me |
  62. | 60_1 | 60 | 60_1 | KCSM |
  63. | 60_2 | 60 | 60_2 | KCSMMHz |
  64. | 60_3 | 60 | 60_3 | Jazz-TV |
  65. | 65_1 | 65 | 65_1 | KKPX Digital Television |
  66. | 65_2 | 65 | 65_2 | KKPX qubo |
  67. | 65_3 | 65 | 65_3 | KKPX ION Life |
  68. | 66_1 | 66 | 66_1 | TeleFutura |
  69. | 66_2 | 66 | 66_2 | Univision |
  70. | 68_1 | 68 | 68_1 | KTLN-DT |
  71. | 104 | 104 | 104 | Local Origination - LOOR104 |
  72. | 105 | 105 | 105 | USA Network HD |
  73. | 106 | 106 | 106 | TV Land |
  74. | 107 | 107 | 107 | Comedy Central HD |
  75. | 107 | 107 | 107 | Comedy Central |
  76. | 108 | 108 | 108 | Lifetime |
  77. | 108 | 108 | 108 | Lifetime HD |
  78. | 109 | 109 | 109 | Lifetime Movie Network HD |
  79. | 109 | 109 | 109 | Lifetime Movie Network |
  80. | 110 | 110 | 110 | Food HD |
  81. | 110 | 110 | 110 | Food Network |
  82. | 111 | 111 | 111 | Do-It-Yourself Network HD |
  83. | 112 | 112 | 112 | Home & Garden Television |
  84. | 112 | 112 | 112 | HGTV HD (HGHD) |
  85. | 113 | 113 | 113 | Cooking Channel HD |
  86. | 114 | 114 | 114 | E! Entertainment Television HD |
  87. | 115 | 115 | 115 | Style HD |
  88. | 116 | 116 | 116 | GSN HD |
  89. | 117 | 117 | 117 | TV Guide Network |
  90. | 118 | 118 | 118 | A&E HD East |
  91. | 118 | 118 | 118 | A & E Network |
  92. | 119 | 119 | 119 | The Biography Channel HD |
  93. | 120 | 120 | 120 | History |
  94. | 120 | 120 | 120 | History HD |
  95. | 121 | 121 | 121 | History International HD |
  96. | 122 | 122 | 122 | Syfy |
  97. | 123 | 123 | 123 | Satellite Response Network |
  98. | 124 | 124 | 124 | BET |
  99. | 124 | 124 | 124 | Black Entertainment Television HD |
  100. | 127 | 127 | 127 | Oxygen Media Inc. |
  101. | 128 | 128 | 128 | WE tv |
  102. | 129 | 129 | 129 | Bravo HD |
  103. | 129 | 129 | 129 | Bravo |
  104. | 130 | 130 | 130 | Independent Film Channel |
  105. | 131 | 131 | 131 | AMC HD |
  106. | 132 | 132 | 132 | Turner Classic Movies HD |
  107. | 133 | 133 | 133 | Fox Movie Channel |
  108. | 135 | 135 | 135 | BBC America HD |
  109. | 136 | 136 | 136 | FX Networks Inc. |
  110. | 138 | 138 | 138 | TNTHD (TNT-HD) |
  111. | 138 | 138 | 138 | Turner Network TV |
  112. | 139 | 139 | 139 | TBS HD |
  113. | 139 | 139 | 139 | Turner Broadcasting System |
  114. | 155 | 155 | 155 | Fuel TV |
  115. | 157 | 157 | 157 | Ovation: The Arts Network |
  116. | 158 | 158 | 158 | Fuse |
  117. | 159 | 159 | 159 | Si TV |
  118. | 160 | 160 | 160 | MTV - Music Television HD |
  119. | 160 | 160 | 160 | MTV - Music Television |
  120. | 161 | 161 | 161 | MTV2: Music Television |
  121. | 162 | 162 | 162 | VH1 HD |
  122. | 162 | 162 | 162 | VH1 - Video Hits One |
  123. | 163 | 163 | 163 | VH1 Classic |
  124. | 166 | 166 | 166 | Country Music Television |
  125. | 166 | 166 | 166 | Country Music Television HD |
  126. | 167 | 167 | 167 | Great American Country |
  127. | 168 | 168 | 168 | SPIKE TV |
  128. | 168 | 168 | 168 | Spike TV HD |
  129. | 169 | 169 | 169 | Noggin |
  130. | 170 | 170 | 170 | Nickelodeon HD |
  131. | 170 | 170 | 170 | Nickelodeon |
  132. | 171 | 171 | 171 | Nickelodeon (Pacific) |
  133. | 172 | 172 | 172 | Disney Channel |
  134. | 172 | 172 | 172 | Disney Channel HD |
  135. | 173 | 173 | 173 | Disney Channel (Pacific) |
  136. | 174 | 174 | 174 | Disney XD HD |
  137. | 175 | 175 | 175 | Boomerang |
  138. | 176 | 176 | 176 | Cartoon Network |
  139. | 176 | 176 | 176 | Cartoon Network HD |
  140. | 177 | 177 | 177 | Cartoon Network (Pacific) |
  141. | 178 | 178 | 178 | Nicktoons Network |
  142. | 179 | 179 | 179 | HUBHD |
  143. | 180 | 180 | 180 | ABC Family Channel HD |
  144. | 180 | 180 | 180 | ABC Family |
  145. | 181 | 181 | 181 | The N |
  146. | 182 | 182 | 182 | The Discovery Channel HD |
  147. | 182 | 182 | 182 | The Discovery Channel |
  148. | 183 | 183 | 183 | The Learning Channel |
  149. | 183 | 183 | 183 | The Learning Channel HD |
  150. | 184 | 184 | 184 | Animal Planet HD |
  151. | 184 | 184 | 184 | Animal Planet |
  152. | 185 | 185 | 185 | Hallmark Channel HD |
  153. | 188 | 188 | 188 | SoapNet |
  154. | 188 | 188 | 188 | GOSPEL MUSIC CHANNEL |
  155. | 189 | 189 | 189 | Discovery Health |
  156. | 190 | 190 | 190 | National Geographic Wild HD |
  157. | 191 | 191 | 191 | G4 HD |
  158. | 195 | 195 | 195 | The Military Channel |
  159. | 196 | 196 | 196 | Current TV |
  160. | 197 | 197 | 197 | The Documentary Channel (US Feed) |
  161. | 198 | 198 | 198 | Cloo |
  162. | 199 | 199 | 199 | Chiller |
  163. | 200 | 200 | 200 | Cable News Network |
  164. | 200 | 200 | 200 | CNN HD |
  165. | 202 | 202 | 202 | HLN HD |
  166. | 203 | 203 | 203 | Bloomberg Business Television |
  167. | 204 | 204 | 204 | truTV HD |
  168. | 205 | 205 | 205 | Fox News Channel HD |
  169. | 206 | 206 | 206 | Fox Business HD |
  170. | 207 | 207 | 207 | CNBC World |
  171. | 208 | 208 | 208 | CNBC |
  172. | 208 | 208 | 208 | CNBC HD |
  173. | 209 | 209 | 209 | MSNBC |
  174. | 210 | 210 | 210 | Cable Satellite Public Affairs Network |
  175. | 211 | 211 | 211 | Cable Satellite Public Affairs Network 2 |
  176. | 212 | 212 | 212 | Local Orgination |
  177. | 213 | 213 | 213 | NASA TV |
  178. | 214 | 214 | 214 | The Weather Channel |
  179. | 214 | 214 | 214 | The Weather Channel HD |
  180. | 215 | 215 | 215 | The Travel Channel |
  181. | 215 | 215 | 215 | The Travel Channel HD |
  182. | 216 | 216 | 216 | C&T |
  183. | 217 | 217 | 217 | ION Television Satellite Feed (Pacific) |
  184. | 217 | 217 | 217 | DISH |
  185. | 218 | 218 | 218 | Veria HD |
  186. | 218 | 218 | 218 | Mercury Media (DISH) |
  187. | 219 | 219 | 219 | ALIVE |
  188. | 223 | 223 | 223 | Satellite Response Network |
  189. | 230 | 230 | 230 | InCite TV |
  190. | 231 | 231 | 231 | RFD TV |
  191. | 239 | 239 | 239 | WGN SAT HD |
  192. | 264 | 264 | 264 | Kids and Teens Television |
  193. | 265 | 265 | 265 | CCTV9 |
  194. | 280 | 280 | 280 | ION Television Satellite Feed East |
  195. | 292 | 292 | 292 | Epix Drive-in |
  196. | 299 | 299 | 299 | ReelzChannel |
  197. | 300 | 300 | 300 | Home Box Office Digital |
  198. | 301 | 301 | 301 | HBO 2 HD |
  199. | 302 | 302 | 302 | Home Box Office Signature HD |
  200. | 303 | 303 | 303 | Home Box Office Digital Pacific Feed |
  201. | 304 | 304 | 304 | Home Box Office Plus (Pacific) |
  202. | 305 | 305 | 305 | HBO Family HD |
  203. | 307 | 307 | 307 | Home Box Office Comedy HD |
  204. | 308 | 308 | 308 | Home Box Office Zone HD |
  205. | 310 | 310 | 310 | CineMAX High Definition |
  206. | 311 | 311 | 311 | CineMAX High Definition (Pacific) |
  207. | 312 | 312 | 312 | MoreMAX |
  208. | 313 | 313 | 313 | ActionMAX HD East |
  209. | 314 | 314 | 314 | 5 StarMAX HD East |
  210. | 329 | 329 | 329 | The Movie Channel (Pacific) |
  211. | 330 | 330 | 330 | The Movie Channel Extra (Pacific) |
  212. | 340 | 340 | 340 | ENCORE 1 HD |
  213. | 341 | 341 | 341 | Encore (Pacific) |
  214. | 342 | 342 | 342 | Encore Westerns |
  215. | 343 | 343 | 343 | Encore Action |
  216. | 344 | 344 | 344 | Encore Mystery |
  217. | 345 | 345 | 345 | Encore Drama |
  218. | 346 | 346 | 346 | Encore Love |
  219. | 347 | 347 | 347 | Encore Wam |
  220. | 350 | 350 | 350 | STARZ HD |
  221. | 351 | 351 | 351 | STARZ HD PST |
  222. | 352 | 352 | 352 | STARZ EDGE HD |
  223. | 353 | 353 | 353 | STARZ CINEMA EST |
  224. | 354 | 354 | 354 | STARZ COMEDY HD |
  225. | 355 | 355 | 355 | STARZ IN BLACK |
  226. | 356 | 356 | 356 | STARZ KIDS HD |
  227. | 362 | 362 | 362 | HDNet |
  228. | 364 | 364 | 364 | HD Theater |
  229. | 369 | 369 | 369 | PALLADIA |
  230. | 377 | 377 | 377 | MoviePlex |
  231. | 396 | 396 | 396 | Outdoor Channel |
  232. | 410 | 410 | 410 | Altitude Sports HD |
  233. | 411 | 411 | 411 | Fox HD Channel (Prime HD) |
  234. | 414 | 414 | 414 | Fox Sports Rocky Mountain HD |
  235. | 415 | 415 | 415 | Fox Sports Net Arizona HD |
  236. | 416 | 416 | 416 | Fox Sports South HD |
  237. | 418 | 418 | 418 | Fox Sports Midwest HD |
  238. | 419 | 419 | 419 | Comcast SportsNet Bay Area HD |
  239. | 420 | 420 | 420 | Fox Sports South HD |
  240. | 421 | 421 | 421 | Cox Sports Television HD |
  241. | 422 | 422 | 422 | Sun Sports North Florida HD |
  242. | 423 | 423 | 423 | Fox Sports Florida HD |
  243. | 424 | 424 | 424 | Comcast Sportnet HD |
  244. | 425 | 425 | 425 | Fox Sports Ohio HD (Zone 1) |
  245. | 426 | 426 | 426 | Fox Sports NW Seattle HD |
  246. | 427 | 427 | 427 | Fox Sports Cincinnati HD |
  247. | 428 | 428 | 428 | Fox Sports Pittsburgh HD |
  248. | 429 | 429 | 429 | Comcast Sportsnet Chicago HD |
  249. | 430 | 430 | 430 | Fox Sports Detroit HD |
  250. | 431 | 431 | 431 | Sportstime Ohio |
  251. | 434 | 434 | 434 | New England Sports Network (Digital) |
  252. | 435 | 435 | 435 | Comcast Sportsnet New England HD |
  253. | 436 | 436 | 436 | Fox Sports Net North HD |
  254. | 437 | 437 | 437 | Fox Sports South HD |
  255. | 438 | 438 | 438 | Sportsnet NY HD |
  256. | 574 | 574 | 574 | NDTV Imagine |
  257. | 575 | 575 | 575 | SAB UK |
  258. | 578 | 578 | 578 | Bridges TV |
  259. | 579 | 579 | 579 | Inter Plus (DISH) |
  260. | 580 | 580 | 580 | Information Channel - INFO580 |
  261. | 712 | 712 | 712 | RTR Planeta |
  262. | 784 | 784 | 784 | Euro News |
  263. | 801 | 801 | 801 | Kairali |
  264. | 814 | 814 | 814 | Rede Globo TV Internacional |
  265. | 827 | 827 | 827 | Univision Network |
  266. | 828 | 828 | 828 | Univision Network (Pacific) |
  267. | 831 | 831 | 831 | Telefutura West Satellite Feed |
  268. | 833 | 833 | 833 | Galavision Cable Network |
  269. | 838 | 838 | 838 | Mun2 |
  270. | 847 | 847 | 847 | Disney XD |
  271. | 867 | 867 | 867 | BandaMax US Feed |
  272. | 884 | 884 | 884 | CCTV -E&F |
  273. | 900 | 900 | 900 | Euro News |
  274. | 901 | 901 | 901 | Euro News |
  275. | 988 | 988 | 988 | Information Channel - INFO988 |
  276. | 998 | 998 | 998 | Information Channel - INFO998 |
  277. | 28.1 | 28.1 | 28.1 | KFTL DT |
  278. | 32.1 | 32.1 | 32.1 | KMTP Digital Television |
  279. | 32.2 | 32.2 | 32.2 | KMTP Digital Television |
  280. | 32.4 | 32.4 | 32.4 | KMTP Digital Television |
  281. | 32.5 | 32.5 | 32.5 | KMTP Digital Television |
  282. | 42.1 | 42.1 | 42.1 | KTNC DIGITAL TELEVISION |
  283. | 9400 | 9400 | 9400 | ResearchChannel |
  284. | 9401 | 9401 | 9401 | HITN |
  285. | 9402 | 9402 | 9402 | Health and Human Services Network |
  286. | 9405 | 9405 | 9405 | The Pentagon Channel |
  287. | 9406 | 9406 | 9406 | Classic Arts Showcase |
  288. | 9407 | 9407 | 9407 | CoLours TV |
  289. | 9408 | 9408 | 9408 | Starfish Television Network |
  290. | 9409 | 9409 | 9409 | RFD TV |
  291. | 9410 | 9410 | 9410 | Link TV |
  292. | 9411 | 9411 | 9411 | Universityhouse Channel |
  293. | 9412 | 9412 | 9412 | University of California Channel(UCTVD) |
  294. | 9415 | 9415 | 9415 | Free Speech TV |
  295. | 9417 | 9417 | 9417 | EducatorTV |
  296. | 9418 | 9418 | 9418 | FEC: Florida Educational Consortium |
  297. | 9419 | 9419 | 9419 | A&E HD East |
  298. | 9420 | 9420 | 9420 | TNTHD (TNT-HD) |
  299. | 9421 | 9421 | 9421 | HD Theater |
  300. | 9422 | 9422 | 9422 | HDNet |
  301. | 9423 | 9423 | 9423 | HDNet Movies |
  302. | 9427 | 9427 | 9427 | Universal HD |
  303. | 9429 | 9429 | 9429 | National Geographic HD |
  304. | 9431 | 9431 | 9431 | USA Network HD |
  305. | 9432 | 9432 | 9432 | Sci-Fi Channel HD |
  306. | 9433 | 9433 | 9433 | Disney Channel HD |
  307. | 9434 | 9434 | 9434 | ABC Family Channel HD |
  308. | 9435 | 9435 | 9435 | STARZ HD |
  309. | 9436 | 9436 | 9436 | CNN HD |
  310. | 9437 | 9437 | 9437 | The Travel Channel HD |
  311. | 9438 | 9438 | 9438 | The Weather Channel HD |
  312. | 9439 | 9439 | 9439 | CNBC HD |
  313. | 9440 | 9440 | 9440 | CineMAX High Definition (Pacific) |
  314. | 9441 | 9441 | 9441 | 5 StarMAX HD East |
  315. | 9444 | 9444 | 9444 | Hallmark Movie Channel HD |
  316. | 9446 | 9446 | 9446 | WGN SAT HD |
  317. | 9449 | 9449 | 9449 | Disney XD HD |
  318. | 9451 | 9451 | 9451 | Home Box Office Comedy HD |
  319. | 9452 | 9452 | 9452 | Home Box Office Zone HD |
  320. | 9453 | 9453 | 9453 | HBO Family HD |
  321. | 9454 | 9454 | 9454 | Home Box Office Signature HD |
  322. | 9455 | 9455 | 9455 | HBO 2 HD |
  323. | 9456 | 9456 | 9456 | Home Box Office Digital |
  324. | 9457 | 9457 | 9457 | Planet Green HD |
  325. | 9458 | 9458 | 9458 | CineMAX High Definition |
  326. | 9461 | 9461 | 9461 | HGTV HD (HGHD) |
  327. | 9462 | 9462 | 9462 | Food HD |
  328. | 9463 | 9463 | 9463 | Cartoon Network HD |
  329. | 9469 | 9469 | 9469 | PALLADIA |
  330. | 9470 | 9470 | 9470 | Lifetime HD |
  331. | 9471 | 9471 | 9471 | Lifetime Movie Network HD |
  332. | 9478 | 9478 | 9478 | Home Box Office Digital Pacific Feed |
  333. | 9479 | 9479 | 9479 | ActionMAX HD East |
  334. | 9480 | 9480 | 9480 | Showtime 2 HD |
  335. | 9480 | 9480 | 9480 | The Learning Channel HD |
  336. | 9481 | 9481 | 9481 | The Movie Channel (Digital) |
  337. | 9486 | 9486 | 9486 | STARZ COMEDY HD |
  338. | 9487 | 9487 | 9487 | The Discovery Channel HD |
  339. | 9488 | 9488 | 9488 | The Learning Channel HD |
  340. | 9489 | 9489 | 9489 | Animal Planet HD |
  341. | 9490 | 9490 | 9490 | Science Channel HD |
  342. | 9491 | 9491 | 9491 | History HD |
  343. | 9492 | 9492 | 9492 | Bravo HD |
  344. | 9496 | 9496 | 9496 | STARZ EDGE HD |
  345. | 9497 | 9497 | 9497 | STARZ KIDS HD |
  346. | 9498 | 9498 | 9498 | STARZ HD PST |
  347. | 9499 | 9499 | 9499 | TBS HD |
  348. | 9500 | 9500 | 9500 | Local Weather |
  349. | 9505 | 9505 | 9505 | ENCORE 1 HD |
  350. | 9513 | 9513 | 9513 | Showtime Showcase HD |
  351. | 9575 | 9575 | 9575 | Veria |
  352. | 9632 | 9632 | 9632 | Traders Television Network |
  353. | 9645 | 9645 | 9645 | Local Origination - LOOR9645 |
  354. | 9710 | 9710 | 9710 | 3 Angels Broadcasting Network |
  355. | 9715 | 9715 | 9715 | Golden Eagle Broadcasting |
  356. | 9719 | 9719 | 9719 | World Harvest Television |
  357. | 9790 | 9790 | 9790 | Science Channel HD |
  358. | 9850 | 9850 | 9850 | KBS America |
  359. | 28.10 | 28.10 | 28.10 | KEAR-FM |
  360. +---------+----------+----------+------------------------------------------+
  361. 355 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!