Out of Area Postcodes

There's a number of postcodes which are not eligible for Named Day Delivery or Saturday delivery and these options will not show on Telesales for any delivery address with these postcodes, please see the lists below - 

No Named Day Delivery, but can have Saturday Delivery 

AB63
FK1
FK3
FK8
PA51
PA52
PA53
PA54
PA55
PA56
PA57
PA58
PA59
PA79
TR21
TR22
TR23
TR24
TR25

No Named Day or Saturday Delivery 

AB30
AB36
AB31
AB33
AB34
AB35
AB37
AB38
AB39
AB41
AB42
AB43
AB44
AB45
AB51
AB52
AB53
AB54
AB55
AB56
BT22
BT24
BT25
BT29
BT30
BT31
BT32
BT33
BT34
BT35
BT37
BT38
BT39
BT40
BT43
BT44
BT45
BT46
BT47
BT48
BT49
BT51
BT52
BT53
BT54
BT55
BT56
BT57
BT58
BT60
BT61
BT62
BT63
BT64
BT65
BT66
BT67
BT68
BT69
BT70
BT71
BT74
BT75
BT76
BT77
BT78
BT79
BT80
BT82
BT81
BT92
BT93
BT94
DD1
DD2
DD3
DD10
DD11
DD4
DD5
DD6
DD7
DD8
DD9
FK16
FK17
FK18
FK19
FK20
FK21
G63
HS1
HS2
HS3
HS4
HS5
HS7
HS6
HS8
HS9
IM1
IM2
IM4
IM5
IM6
IM7
IM8
IM3
IM9
IV1
IV10
IV11
IV12
IV13
IV14
IV15
IV16
IV17
IV2
IV18
IV19
IV20
IV21
IV22
IV23
IV24
IV25
IV26
IV3
IV27
IV28
IV29
IV30
IV31
IV32
IV33
IV34
IV35
IV4
IV36
IV37
IV38
IV39
IV40
IV41
IV42
IV43
IV44
IV5
IV45
IV46
IV47
IV48
IV49
IV50
IV51
IV52
IV53
IV6
IV54
IV55
IV57
IV58
IV59
IV60
IV61
IV62
IV56
IV7
IV63
IV64
IV65
IV66
IV67
IV68
IV69
IV70
IV71
IV72
IV73
IV8
IV74
IV75
IV76
IV77
IV78
IV79
IV80
IV81
IV82
IV9
IV83
IV84
IV85
IV86
IV87
IV88
IV89
IV90
IV91
IV92
IV93
IV94
IV95
IV96
IV97
IV98
IV99
KA10
KA11
KA12
KA13
KA14
KA15
KA16
KA17
KA18
KA19
KA20
KA21
KA6
KA7
KA22
KA23
KA24
KA25
KA26
KA27
KA28
KA29
KA8
KA9
KW1
KW10
KW11
KW12
KW13
KW14
KW15
KW16
KW2
KW3
KW4
KW5
KW6
KW7
KW8
KW9
KW17
KY10
KY9
KY13
KY14
KY15
KY16
ML11
ML12
PA20
PA21
PA22
PA23
PA24
PA25
PA26
PA27
PA28
PA29
PA30
PA31
PA32
PA33
PA34
PA35
PA36
PA37
PA38
PA39
PA40
PA41
PA42
PA43
PA44
PA45
PA46
PA47
PA48
PA49
PA50
PA60
PA61
PA62
PA63
PA64
PA65
PA66
PA67
PA68
PA69
PA70
PA71
PA72
PA73
PA74
PA75
PA76
PA77
PA78
PA80
PA81
PA82
PA83
PA84
PA85
PA86
PA87
PA88
PH1
PH10
PH11
PH12
PH2
PH13
PH14
PH15
PH16
PH17
PH18
PH19
PH20
PH21
PH22
PH23
PH24
PH25
PH26
PH3
PH4
PH27
PH28
PH29
PH30
PH31
PH32
PH33
PH34
PH35
PH36
PH37
PH38
PH39
PH5
PH6
PH7
PH8
PH9
PH40
PH41
PH42
PH43
PH44
PH45
PH46
PH47
PH48
PH49
PH50
TD15
ZE1
ZE2
ZE3
BT1
BT2
BT3
BT4
BT5
BT6
BT7
BT8
BT9
BT10
BT11
BT12
BT13
BT14
BT15
BT16
BT17
BT18
BT19
BT20
BT21
BT23
BT26
BT27
BT28
BT36
BT41
BT42
BT50
BT59
BT72
BT73
BT83
BT84
BT85
BT86
BT87
BT88
BT89
BT90
BT91

DHL 48 Hour

To find postcodes that were sent 48 hour via DHL:

select count(*), postcode
from sales_order_delivery delivery
join sales_order on delivery.sales_order_id = sales_order.id
join sales_order_attribute service on sales_order.id = service.sales_order_id and service.name = 'service'
join sales_order_attribute courier on sales_order.id = courier.sales_order_id and courier.name = 'courier'
where sales_order.created_on > subdate(now(), INTERVAL 1 MONTH)
and courier.value = 'DHL'
and service.value like '%48%'
group by postcode
order by count(*) desc;