Project

General

Profile

Bug #5967 » itv_sql.txt

ITV/ITV HD by region as seen by my scanner - Tony Houghton, 2020-10-26 16:22

 
1
sqlite> SELECT DISTINCT lcns.lcn, regions.name, services.service_id, services.ts_id FROM lcns INNER JOIN services ON service_name = 'ITV' AND services.source = 2 AND services.service_id = lcns.service_id INNER JOIN regions ON regions.region = lcns.region;
2
111|W Mids/Central W|10100|2044
3
111|W Mids/Central SW|10100|2044
4
111|E Midlands/Central W|10100|2044
5
103|N West/Granada|10080|2044
6
103|Isle of Man|10080|2044
7
111|N West/Granada|10080|2044
8
111|Isle of Man|10080|2044
9
103|London/London|10060|2044
10
103|East (E)/London|10060|2044
11
103|S East/London|10060|2044
12
103|South/London|10060|2044
13
103|Oxford/London|10060|2044
14
111|London/London|10060|2044
15
111|East (E)/London|10060|2044
16
111|S East/London|10060|2044
17
111|South/London|10060|2044
18
111|Oxford/London|10060|2044
19
103|East (W)/Anglia W|10090|2044
20
103|East (E)/Anglia S|10090|2044
21
103|East (E)/Anglia E|10090|2044
22
111|East (W)/Anglia W|10090|2044
23
111|East (E)/Anglia S|10090|2044
24
111|East (E)/Anglia E|10090|2044
25
103|Channel Islands/Channel Islands|10200|2054
26
103|South/W Country|10240|2054
27
103|S West/W Country|10240|2054
28
111|South/W Country|10240|2054
29
111|S West/W Country|10240|2054
30
103|E Midlands/Central E|12145|2059
31
111|E Midlands/Central E|12145|2059
32
103|West/West|12170|2059
33
103|West/Central S|12170|2059
34
111|West/West|12170|2059
35
111|West/Central S|12170|2059
36
103|East (W)/Central S|10140|2053
37
103|West/Meridian N|10140|2053
38
103|S East/Meridian S|10140|2053
39
103|South/Meridian S|10140|2053
40
103|South/Meridian SE|10140|2053
41
103|South/Meridian N|10140|2053
42
103|Oxford/Central S|10140|2053
43
111|East (W)/Central S|10140|2053
44
111|West/Meridian N|10140|2053
45
111|S East/Meridian S|10140|2053
46
111|South/Meridian S|10140|2053
47
111|South/Meridian SE|10140|2053
48
111|South/Meridian N|10140|2053
49
111|Oxford/Central S|10140|2053
50
103|S East/Meridian SE|10150|2053
51
103|S East/Meridian E|10150|2053
52
111|S East/Meridian SE|10150|2053
53
111|S East/Meridian E|10150|2053
54
103|Yorkshire/Tyne Tees S|10130|2053
55
103|NE & C/Tyne Tees N|10130|2053
56
103|NE & C/Tyne Tees S|10130|2053
57
111|Yorkshire/Tyne Tees S|10130|2053
58
111|NE & C/Tyne Tees N|10130|2053
59
111|NE & C/Tyne Tees S|10130|2053
60
103|EYrks&Lin/Yorkshire E|10160|2053
61
103|Yorkshire/Yorkshire W|10160|2053
62
103|E Midlands/Yorkshire E|10160|2053
63
103|Yorkshire/Yorkshire E|10160|2053
64
111|EYrks&Lin/Yorkshire E|10160|2053
65
111|Yorkshire/Yorkshire W|10160|2053
66
111|E Midlands/Yorkshire E|10160|2053
67
111|Yorkshire/Yorkshire E|10160|2053
68
sqlite> SELECT DISTINCT lcns.lcn, regions.name, services.service_id, services.ts_id FROM lcns INNER JOIN services ON service_name = 'ITV HD' AND services.source = 2 AND services.service_id = lcns.service_id INNER JOIN regions ON regions.region = lcns.region;
69
103|Yorkshire/Tyne Tees S|20750|2063
70
103|NE & C/Tyne Tees N|20750|2063
71
103|NE & C/Tyne Tees S|20750|2063
72
103|N West/Granada|20740|2063
73
103|Isle of Man|20740|2063
74
103|West/West|20770|2063
75
103|West/Central S|20770|2063
76
103|South/W Country|20760|2063
77
103|S West/W Country|20760|2063
78
103|W Mids/Central W|5109|2024
79
103|W Mids/Central SW|5109|2024
80
103|E Midlands/Central W|5109|2024
81
103|S East/Meridian SE|5107|2034
82
103|S East/Meridian E|5107|2034
83
103|London/London|5106|2034
84
103|East (E)/London|5106|2034
85
103|S East/London|5106|2034
86
103|South/London|5106|2034
87
103|Oxford/London|5106|2034
88
103|Default|5106|2034
89
103|-|5106|2034
90
1965|N West/Granada|5106|2034
91
1965|N West/BorderEng|5106|2034
92
1965|EYrks&Lin/Yorkshire E|5106|2034
93
1965|Yorkshire/Yorkshire W|5106|2034
94
1965|Yorkshire/Tyne Tees S|5106|2034
95
1965|E Midlands/Yorkshire E|5106|2034
96
1965|NE & C/BorderEng|5106|2034
97
1965|NE & C/Tyne Tees N|5106|2034
98
1965|NE & C/Tyne Tees S|5106|2034
99
1965|Yorkshire/Yorkshire E|5106|2034
100
1965|Isle of Man|5106|2034
101
1965|Scotland/BorderSco|5106|2034
102
103|East (W)/Central S|21010|2066
103
103|West/Meridian N|21010|2066
104
103|South/Meridian N|21010|2066
105
103|Oxford/Central S|21010|2066
106
103|East (W)/Anglia W|21070|2066
107
103|S East/Meridian S|21015|2066
108
103|South/Meridian S|21015|2066
109
103|South/Meridian SE|21015|2066
110
103|E Midlands/Central E|21080|2066
111
103|Yorkshire/Yorkshire W|21040|2066
112
103|Yorkshire/Yorkshire E|21040|2066
113
103|EYrks&Lin/Yorkshire E|20820|2064
114
103|Yorkshire/Yorkshire W|20820|2064
115
103|E Midlands/Yorkshire E|20820|2064
116
103|N West/BorderEng|20850|2064
117
103|NE & C/BorderEng|20850|2064
118
111|Scotland/BorderSco|20850|2064
119
103|East (E)/Anglia S|20840|2064
120
103|East (E)/Anglia E|20840|2064
121

    
(2-2/2)