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
|
|