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;
111|W Mids/Central W|10100|2044
111|W Mids/Central SW|10100|2044
111|E Midlands/Central W|10100|2044
103|N West/Granada|10080|2044
103|Isle of Man|10080|2044
111|N West/Granada|10080|2044
111|Isle of Man|10080|2044
103|London/London|10060|2044
103|East (E)/London|10060|2044
103|S East/London|10060|2044
103|South/London|10060|2044
103|Oxford/London|10060|2044
111|London/London|10060|2044
111|East (E)/London|10060|2044
111|S East/London|10060|2044
111|South/London|10060|2044
111|Oxford/London|10060|2044
103|East (W)/Anglia W|10090|2044
103|East (E)/Anglia S|10090|2044
103|East (E)/Anglia E|10090|2044
111|East (W)/Anglia W|10090|2044
111|East (E)/Anglia S|10090|2044
111|East (E)/Anglia E|10090|2044
103|Channel Islands/Channel Islands|10200|2054
103|South/W Country|10240|2054
103|S West/W Country|10240|2054
111|South/W Country|10240|2054
111|S West/W Country|10240|2054
103|E Midlands/Central E|12145|2059
111|E Midlands/Central E|12145|2059
103|West/West|12170|2059
103|West/Central S|12170|2059
111|West/West|12170|2059
111|West/Central S|12170|2059
103|East (W)/Central S|10140|2053
103|West/Meridian N|10140|2053
103|S East/Meridian S|10140|2053
103|South/Meridian S|10140|2053
103|South/Meridian SE|10140|2053
103|South/Meridian N|10140|2053
103|Oxford/Central S|10140|2053
111|East (W)/Central S|10140|2053
111|West/Meridian N|10140|2053
111|S East/Meridian S|10140|2053
111|South/Meridian S|10140|2053
111|South/Meridian SE|10140|2053
111|South/Meridian N|10140|2053
111|Oxford/Central S|10140|2053
103|S East/Meridian SE|10150|2053
103|S East/Meridian E|10150|2053
111|S East/Meridian SE|10150|2053
111|S East/Meridian E|10150|2053
103|Yorkshire/Tyne Tees S|10130|2053
103|NE & C/Tyne Tees N|10130|2053
103|NE & C/Tyne Tees S|10130|2053
111|Yorkshire/Tyne Tees S|10130|2053
111|NE & C/Tyne Tees N|10130|2053
111|NE & C/Tyne Tees S|10130|2053
103|EYrks&Lin/Yorkshire E|10160|2053
103|Yorkshire/Yorkshire W|10160|2053
103|E Midlands/Yorkshire E|10160|2053
103|Yorkshire/Yorkshire E|10160|2053
111|EYrks&Lin/Yorkshire E|10160|2053
111|Yorkshire/Yorkshire W|10160|2053
111|E Midlands/Yorkshire E|10160|2053
111|Yorkshire/Yorkshire E|10160|2053
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;
103|Yorkshire/Tyne Tees S|20750|2063
103|NE & C/Tyne Tees N|20750|2063
103|NE & C/Tyne Tees S|20750|2063
103|N West/Granada|20740|2063
103|Isle of Man|20740|2063
103|West/West|20770|2063
103|West/Central S|20770|2063
103|South/W Country|20760|2063
103|S West/W Country|20760|2063
103|W Mids/Central W|5109|2024
103|W Mids/Central SW|5109|2024
103|E Midlands/Central W|5109|2024
103|S East/Meridian SE|5107|2034
103|S East/Meridian E|5107|2034
103|London/London|5106|2034
103|East (E)/London|5106|2034
103|S East/London|5106|2034
103|South/London|5106|2034
103|Oxford/London|5106|2034
103|Default|5106|2034
103|-|5106|2034
1965|N West/Granada|5106|2034
1965|N West/BorderEng|5106|2034
1965|EYrks&Lin/Yorkshire E|5106|2034
1965|Yorkshire/Yorkshire W|5106|2034
1965|Yorkshire/Tyne Tees S|5106|2034
1965|E Midlands/Yorkshire E|5106|2034
1965|NE & C/BorderEng|5106|2034
1965|NE & C/Tyne Tees N|5106|2034
1965|NE & C/Tyne Tees S|5106|2034
1965|Yorkshire/Yorkshire E|5106|2034
1965|Isle of Man|5106|2034
1965|Scotland/BorderSco|5106|2034
103|East (W)/Central S|21010|2066
103|West/Meridian N|21010|2066
103|South/Meridian N|21010|2066
103|Oxford/Central S|21010|2066
103|East (W)/Anglia W|21070|2066
103|S East/Meridian S|21015|2066
103|South/Meridian S|21015|2066
103|South/Meridian SE|21015|2066
103|E Midlands/Central E|21080|2066
103|Yorkshire/Yorkshire W|21040|2066
103|Yorkshire/Yorkshire E|21040|2066
103|EYrks&Lin/Yorkshire E|20820|2064
103|Yorkshire/Yorkshire W|20820|2064
103|E Midlands/Yorkshire E|20820|2064
103|N West/BorderEng|20850|2064
103|NE & C/BorderEng|20850|2064
111|Scotland/BorderSco|20850|2064
103|East (E)/Anglia S|20840|2064
103|East (E)/Anglia E|20840|2064