Great Whiskies New Arrivals Priced over £500

Bowmore 33 Year Old - The Kinship (Hunter Laing) Single Malt Whisky

£ 585.00

Buy Online

Laphroaig 23 Year Old - The Kinship (Hunter Laing) Single Malt Whisky

£ 540.00

Buy Online

Ardbeg 19 Year Old - The Kinship (Hunter Laing) Single Malt Whisky

£ 510.00

Buy Online

Caol Ila 40 Year Old - The Kinship (Hunter Laing) Single Malt Whisky

£ 1,495.00

Buy Online

Bruichladdich 29 Year Old - The Kinship (Hunter Laing) Single Malt Whisky

£ 535.00

Buy Online

Bunnahabhain 31 Year Old -The Kinship (Hunter Laing) Single Malt Whisky

£ 510.00

Buy Online

Macallan 30 Year Old 1990 - The Scottish Gantry Single Malt Whisky

£ 7,995.00

Buy Online

The Last Drop 50 Year Old Signature Blend Blended Whisky

£ 3,250.00

Buy Online

Brora Triptych (3 x 50cl) Single Malt Whisky

£ 30,000.00

Buy Online

Glen Grant 67 Year Old 1953 - Mr. George Legacy (Gordon & MacPhail) Single Malt Whisky

£ 4,995.00

Buy Online

Sullivans Cove French Oak (cask #HH0399) Single Malt Whisky

£ 795.00

Buy Online

The Macallan 30 Year Old Fine Oak (Old Bottling) Single Malt Whisky

£ 3,995.00

Buy Online

Blair Athol 32 Year Old 1976 - Old & Rare Platinum (Douglas Laing) Single Malt Whisky

£ 995.00

Buy Online

Springbank 25 Year Old - Millennium Collection Single Malt Whisky

£ 3,495.00

Buy Online

Loch Lomond 45 Year Old - Remarkable Stills Series Single Malt Whisky

£ 3,450.00

Buy Online

Macallan 18 Year Old - 18 (UKSF) Signal Regiment Single Malt Whisky

£ 995.00

Buy Online

Convalmore 1984 (bottled 2010) - Connoisseurs Choice (Gordon & MacPhai Single Malt Whisky

£ 595.00

Buy Online

The Macallan 35 Year Old 1965 (cask 4402) - Fine & Rare Single Malt Whisky

£ 18,995.00

Buy Online

Teaninich 35 Year Old 1983 (cask 8070) - 30th Anniversary Gift Box (Si Single Malt Whisky

£ 550.00

Buy Online

Glenlivet 45 Year Old 1973 (cask 12/1) - 30th Anniversary Gift Box (Si Single Malt Whisky

£ 1,295.00

Buy Online

GlenAllachie 31 Year Old 1989 (cask 4011) - Single Cask Single Malt Whisky

£ 535.00

Buy Online

Teaninich 45 Year Old 1975 (cask 14547) - Xtra Old Particular The Blac Single Malt Whisky

£ 950.00

Buy Online

Glenury Royal 1972 (bottled 2002) - Rare Old (Gordon & MacPhail) Single Malt Whisky

£ 799.95

Buy Online

Tomatin 36 Year Old - Batch 7 Single Malt Whisky

£ 599.00

Buy Online

Invergordon 54 Year Old 1966 (cask 13718) - Xtra Old Particular (Dougl Grain Whisky

£ 855.00

Buy Online

"The Macallan Sir Peter Blake: An Estate, A Community, and A Distillery Single Malt Whisky"

£ 750.00

Buy Online

Dalmore 21 Year Old Single Malt Whisky

£ 550.00

Buy Online

Rosebank 20 Year Old 1981 (cask 411) - First Cask Single Malt Whisky

£ 795.00

Buy Online

View Scottish Single Malts by Distillery

OTHER WHISKIES OFFERS

Glenfarclas Family Cask Trunk Single Malt Whisky

£ 105,000.00

Buy Online

The Macallan 48 Year Old 1969 - The Rarest of the Rare Collection (Dun Single Malt Whisky

£ 38,995.00

Buy Online

Balvenie 56 Year Old 1962 (cask 5575) - The Balvenie DCS Compendium Ch Single Malt Whisky

£ 38,465.03

Buy Online

Balvenie 50 Year Old - Marriage 0614 Single Malt Whisky

£ 31,500.00

Buy Online

Glenfiddich 50 Year Old Single Malt Whisky

£ 23,847.38

Buy Online

Bowmore Black 31 Year Old 1964 - Final Edition Single Malt Whisky

£ 22,000.00

Buy Online

Glenfarclas 60 Year Old (cask 1820) Single Malt Whisky

£ 19,500.00

Buy Online

Macallan 1938 (bottled 1980s) - Gordon & MacPhail Single Malt Whisky

£ 17,995.00

Buy Online

Great Whiskies, Dumbarton

+44 07811 287 483

contact@greatwhiskies.com

001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

duration: 0.000 seconds (26.86%)
affected rows: 0
backtrace
to the top
close all

File	Function	Line
/var/www/vhosts/greatwhiskies.com/httpdocs/db/Zebra_Database.php	query()	3683
/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html	set_charset()	5

002

select 
    * 
from 
    greatwhiskieslogos 
ORDER BY 
    distillery

duration: 0.000 seconds (17.09%)
returned rows: 10
explain
backtrace
to the top
close all

id	distillery	image	link	live
7	Aberlour Speyside Scottish Single Malts	/images/logos/aberlour.jpg	/scottishmalts/aberlour.html	1
4	Benromach Scottish Single Malts	/images/logos/benromach.jpg	/scottishmalts/benromach.html	1
1	Bowmore Scottish Single Malts	/images/logos/bowmore.jpg	/scottishmalts/bowmore.html	1
10	Glenfiddich Speyside Scottish Single Malts	/images/logos/glenfiddich.jpg	/scottishmalts/glenfiddich.html	1
9	Highland Park Scottish Single Malts	/images/logos/highlandpark.jpg	/scottishmalts/highland-park.html	1
5	Laphroaig Islay Scottish Single Malts	/images/logos/laphroaig.jpg	/scottishmalts/laphroaig.html	1
3	The Balvenie Scottish Single Malts	/images/logos/balvenie.jpg	/scottishmalts/balvenie.html	1
6	The Glenlivet Speyside Scottish Single Malts	/images/logos/glenlivet.jpg	/scottishmalts/glenlivet.html	1
2	The Macallan Scottish Single Malts	/images/logos/macallan.jpg	/scottishmalts/macallan.html	1
8	Tomatin Highland Scottish Single Malts	/images/logos/tomatin.jpg	/scottishmalts/tomatin.html	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	greatwhiskieslogos	ALL					10	100.00	Using filesort

File	Function	Line
/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html	query()	9

003

select 
    * 
from 
    mastersofmalt16 
where 
    Type = 'whisky' 
    and Company = 'masterofmalt' 
    and Name != '%Whisky Advent%' 
    and Price > '500' 
ORDER BY 
    myid desc 
LIMIT 
    28;

duration: 0.000 seconds (26.23%)
returned rows: 28
explain
backtrace
to the top
close all

myid	company	Reference	Name	ABV	Size	Style	Type	Distillery	Country	Region	ImageURL	Availability	Price	ProductPageURL	Age	Bottler
68878	masterofmalt	178773	Bowmore 33 Year Old - The Kinship (Hunter Laing) Single Malt Whisky	51.2	70	Single Malt	whisky	Bowmore	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-33-year-old-the-kinship-hunter-laing-whisky.jpg	No	585.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-33-year-old-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	33	Hunter Laing
68877	masterofmalt	178772	Laphroaig 23 Year Old - The Kinship (Hunter Laing) Single Malt Whisky	50.5	70	Single Malt	whisky	Laphroaig	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/laphroaig/laphroaig-23-year-old-the-kinship-hunter-laing-whisky.jpg	Yes	540.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/laphroaig/laphroaig-23-year-old-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	23	Hunter Laing
68876	masterofmalt	178771	Ardbeg 19 Year Old - The Kinship (Hunter Laing) Single Malt Whisky	47.8	70	Single Malt	whisky	Ardbeg	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/ardbeg/ardbeg-19-year-old-the-kinship-hunter-laing-whisky.jpg	Yes	510.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/ardbeg/ardbeg-19-year-old-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	19	Hunter Laing
68875	masterofmalt	178770	Caol Ila 40 Year Old - The Kinship (Hunter Laing) Single Malt Whisky	51.8	70	Single Malt	whisky	Caol Ila	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/caol-ila/caol-ila-40-year-old-2021-the-kinship-hunter-laing-whisky.jpg	Yes	1495.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/caol-ila/caol-ila-40-year-old-2021-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	40	Hunter Laing
68874	masterofmalt	178769	Bruichladdich 29 Year Old - The Kinship (Hunter Laing) Single Malt Whisky	45.4	70	Single Malt	whisky	Bruichladdich	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/bruichladdich/bruichladdich-29-year-old-the-kinship-hunter-laing-whisky.jpg	Yes	535.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/bruichladdich/bruichladdich-29-year-old-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	29	Hunter Laing
68873	masterofmalt	178768	Bunnahabhain 31 Year Old -The Kinship (Hunter Laing) Single Malt Whisky	46.9	70	Single Malt	whisky	Bunnahabhain	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/bunnahabhain/bunnahabhain-31-year-old-the-kinship-hunter-laing-whisky.jpg	Yes	510.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/bunnahabhain/bunnahabhain-31-year-old-the-kinship-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	31	Hunter Laing
68718	masterofmalt	178093	Macallan 30 Year Old 1990 - The Scottish Gantry Single Malt Whisky	46.7	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-30-year-old-the-scottish-gantry-whisky.jpg	Yes	7995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-30-year-old-the-scottish-gantry-whisky/?countryCodeShort=GB¤cyCode=GBP	30	The Macallan
68717	masterofmalt	178091	The Last Drop 50 Year Old Signature Blend Blended Whisky	48.7	75	Blended	whisky	The Last Drop	Scotland	Scotch	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-last-drop/the-last-drop-50-year-old-signature-blend-whisky.jpg	Yes	3250.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-last-drop/the-last-drop-50-year-old-signature-blend-whisky/?countryCodeShort=GB¤cyCode=GBP	50	The Last Drop
68525	masterofmalt	177707	Brora Triptych (3 x 50cl) Single Malt Whisky	46.3	150	Single Malt	whisky	Brora	Scotland	Highland	https://cdn1.masterofmalt.com/Whiskies/p-2007/brora/brora-triptych-3-x-50cl-whisky.jpg	No	30000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/brora/brora-triptych-3-x-50cl-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Brora
68450	masterofmalt	177510	Glen Grant 67 Year Old 1953 - Mr. George Legacy (Gordon & MacPhail) Single Malt Whisky	59.4	70	Single Malt	whisky	Glen Grant	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glen-grant/glen-grant-67-year-old-1953-mr-george-legacy-gordon-and-macphail-whisky.jpg	No	4995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glen-grant/glen-grant-67-year-old-1953-mr-george-legacy-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	67	Gordon & MacPhail
68392	masterofmalt	177378	Sullivans Cove French Oak (cask #HH0399) Single Malt Whisky	47.5	70	Single Malt	whisky	Tasmania Distillery	Australia	Australian	https://cdn1.masterofmalt.com/Whiskies/p-2007/tasmania-distillery/sullivans-cove-french-oak-cask-hh0399-whisky.jpg	No	795.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/tasmania-distillery/sullivans-cove-french-oak-cask-hh0399-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Tasmania Distillery
68389	masterofmalt	177374	The Macallan 30 Year Old Fine Oak (Old Bottling) Single Malt Whisky	43	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/the-macallan-30-year-old-fine-oak-old-bottling-whisky.jpg	Yes	3995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/the-macallan-30-year-old-fine-oak-old-bottling-whisky/?countryCodeShort=GB¤cyCode=GBP	30	The Maltman
68388	masterofmalt	177373	Blair Athol 32 Year Old 1976 - Old & Rare Platinum (Douglas Laing) Single Malt Whisky	55.4	70	Single Malt	whisky	Blair Athol	Scotland	Highland	https://cdn1.masterofmalt.com/Whiskies/p-2007/blair-athol/blair-athol-32-year-old-1976-old-rare-platinum-douglas-laing-whisky.jpg	No	995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/blair-athol/blair-athol-32-year-old-1976-old-rare-platinum-douglas-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	32	Douglas Laing
68379	masterofmalt	177363	Springbank 25 Year Old - Millennium Collection Single Malt Whisky	46	70	Single Malt	whisky	Springbank	Scotland	Campbeltown	https://cdn1.masterofmalt.com/Whiskies/p-2007/springbank/springbank-25-year-old-millennium-collection-whisky.jpg	Yes	3495.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/springbank/springbank-25-year-old-millennium-collection-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Springbank
68322	masterofmalt	177235	Loch Lomond 45 Year Old - Remarkable Stills Series Single Malt Whisky	42.2	70	Single Malt	whisky	Loch Lomond	Scotland	Highland	https://cdn1.masterofmalt.com/Whiskies/p-2007/loch-lomond/loch-lomond-45-year-old-remarkable-stills-series-whisky.jpg	Yes	3450.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/loch-lomond/loch-lomond-45-year-old-remarkable-stills-series-whisky/?countryCodeShort=GB¤cyCode=GBP	45	Loch Lomond
68254	masterofmalt	177077	Macallan 18 Year Old - 18 (UKSF) Signal Regiment Single Malt Whisky	52.6	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-18-year-old-18-uksf-signal-regiment-whisky.jpg	No	995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-18-year-old-18-uksf-signal-regiment-whisky/?countryCodeShort=GB¤cyCode=GBP	18	The Macallan
68238	masterofmalt	177057	Convalmore 1984 (bottled 2010) - Connoisseurs Choice (Gordon & MacPhai Single Malt Whisky	43	70	Single Malt	whisky	Convalmore	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/convalmore/convalmore-1984-bottled-2010-connoisseurs-choice-gordon-macphail-whisky.jpg	Yes	595.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/convalmore/convalmore-1984-bottled-2010-connoisseurs-choice-gordon-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
68166	masterofmalt	176932	The Macallan 35 Year Old 1965 (cask 4402) - Fine & Rare Single Malt Whisky	56.3	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/the-macallan-35-year-old-1965-cask-4402-fine-rare-whisky.jpg	No	18995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/the-macallan-35-year-old-1965-cask-4402-fine-rare-whisky/?countryCodeShort=GB¤cyCode=GBP	35	The Macallan
68160	masterofmalt	176920	Teaninich 35 Year Old 1983 (cask 8070) - 30th Anniversary Gift Box (Si Single Malt Whisky	57.5	70	Single Malt	whisky	Teaninich	Scotland	Highland	https://cdn1.masterofmalt.com/Whiskies/p-2007/teaninich/teaninich-35-year-old-1983-cask-8070-30th-anniversary-gift-box-signatory-whisky.jpg	Yes	550.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/teaninich/teaninich-35-year-old-1983-cask-8070-30th-anniversary-gift-box-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	35	Signatory
68159	masterofmalt	176919	Glenlivet 45 Year Old 1973 (cask 12/1) - 30th Anniversary Gift Box (Si Single Malt Whisky	43.1	70	Single Malt	whisky	The Glenlivet	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-glenlivet/glenlivet-45-year-old-1973-cask-12-1-30th-anniversary-gift-box-signatory-whisky.jpg	Yes	1295.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-glenlivet/glenlivet-45-year-old-1973-cask-12-1-30th-anniversary-gift-box-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	45	Signatory

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt16	index		PRIMARY	4		28	100.00	Using where

File	Function	Line
/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html	query()	17

004

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

select 
    * 
from 
    mastersofmalt16 
where 
    Type = 'whisky' 
    and Availability = 'Yes' 
    and Price > '300' 
ORDER BY 
    Price DESC 
limit 
    8;

duration: 0.000 seconds (15.61%)
returned rows: 8
explain
backtrace
to the top
close all

myid	company	Reference	Name	ABV	Size	Style	Type	Distillery	Country	Region	ImageURL	Availability	Price	ProductPageURL	Age	Bottler
38237	masterofmalt	154156	Glenfarclas Family Cask Trunk Single Malt Whisky	50.6	1000	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfarclas/glenfarclas-family-cask-trunk-whisky.jpg	Yes	105000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-family-cask-trunk-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Glenfarclas
39389	masterofmalt	156712	The Macallan 48 Year Old 1969 - The Rarest of the Rare Collection (Dun Single Malt Whisky	40	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-48-year-old-1969-the-rarest-of-the-rare-collection-duncan-taylor-whisky.jpg	Yes	38995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-48-year-old-1969-the-rarest-of-the-rare-collection-duncan-taylor-whisky/?countryCodeShort=GB¤cyCode=GBP	48	Duncan Taylor
42118	masterofmalt	165681	Balvenie 56 Year Old 1962 (cask 5575) - The Balvenie DCS Compendium Ch Single Malt Whisky	42.1	70	Single Malt	whisky	Balvenie	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/balvenie/balvenie-56-year-old-1962-cask-5575-the-balvenie-dcs-compendium-chapter-five-whisky.jpg	Yes	38465.03	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/balvenie/balvenie-56-year-old-1962-cask-5575-the-balvenie-dcs-compendium-chapter-five-whisky/?countryCodeShort=GB¤cyCode=GBP	56	Balvenie,
67027	masterofmalt	174945	Balvenie 50 Year Old - Marriage 0614 Single Malt Whisky	46	70	Single Malt	whisky	Balvenie	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/balvenie/balvenie-50-year-old-marriage-0614-whisky.jpg	Yes	31500.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/balvenie/balvenie-50-year-old-marriage-0614-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Balvenie
11418	masterofmalt	97537	Glenfiddich 50 Year Old Single Malt Whisky	46.1	70	Single Malt	whisky	Glenfiddich	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfiddich/glenfiddich-50-year-old-whisky.jpg	Yes	23847.38	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfiddich/glenfiddich-50-year-old-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Glenfiddich
38919	masterofmalt	155796	Bowmore Black 31 Year Old 1964 - Final Edition Single Malt Whisky	49	70	Single Malt	whisky	Bowmore	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-black-31-year-old-1964-final-edition-whisky.jpg	Yes	22000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-black-31-year-old-1964-final-edition-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Bowmore
66318	masterofmalt	173484	Glenfarclas 60 Year Old (cask 1820) Single Malt Whisky	40.9	70	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfarclas/glenfarclas-60-year-old-cask-1820-whisky.jpg	Yes	19500.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-60-year-old-cask-1820-whisky/?countryCodeShort=GB¤cyCode=GBP	60	Glenfarclas
39429	masterofmalt	156791	Macallan 1938 (bottled 1980s) - Gordon & MacPhail Single Malt Whisky	43	75	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-1938-bottled-1980s-gordon-and-macphail-whisky.jpg	Yes	17995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-1938-bottled-1980s-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt16	ALL					51324	100.00	Using where; Using filesort

File	Function	Line
/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html	query()	22

005

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

select 
    * 
from 
    mastersofmalt16 
where 
    Type = 'whisky' 
    and Availability = 'Yes' 
    and Price > '5000' 
ORDER BY 
    Price DESC 
limit 
    8;

duration: 0.000 seconds (14.21%)
returned rows: 8
explain
backtrace
to the top
close all

myid	company	Reference	Name	ABV	Size	Style	Type	Distillery	Country	Region	ImageURL	Availability	Price	ProductPageURL	Age	Bottler
38237	masterofmalt	154156	Glenfarclas Family Cask Trunk Single Malt Whisky	50.6	1000	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfarclas/glenfarclas-family-cask-trunk-whisky.jpg	Yes	105000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-family-cask-trunk-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Glenfarclas
39389	masterofmalt	156712	The Macallan 48 Year Old 1969 - The Rarest of the Rare Collection (Dun Single Malt Whisky	40	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-48-year-old-1969-the-rarest-of-the-rare-collection-duncan-taylor-whisky.jpg	Yes	38995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-48-year-old-1969-the-rarest-of-the-rare-collection-duncan-taylor-whisky/?countryCodeShort=GB¤cyCode=GBP	48	Duncan Taylor
42118	masterofmalt	165681	Balvenie 56 Year Old 1962 (cask 5575) - The Balvenie DCS Compendium Ch Single Malt Whisky	42.1	70	Single Malt	whisky	Balvenie	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/balvenie/balvenie-56-year-old-1962-cask-5575-the-balvenie-dcs-compendium-chapter-five-whisky.jpg	Yes	38465.03	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/balvenie/balvenie-56-year-old-1962-cask-5575-the-balvenie-dcs-compendium-chapter-five-whisky/?countryCodeShort=GB¤cyCode=GBP	56	Balvenie,
67027	masterofmalt	174945	Balvenie 50 Year Old - Marriage 0614 Single Malt Whisky	46	70	Single Malt	whisky	Balvenie	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/balvenie/balvenie-50-year-old-marriage-0614-whisky.jpg	Yes	31500.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/balvenie/balvenie-50-year-old-marriage-0614-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Balvenie
11418	masterofmalt	97537	Glenfiddich 50 Year Old Single Malt Whisky	46.1	70	Single Malt	whisky	Glenfiddich	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfiddich/glenfiddich-50-year-old-whisky.jpg	Yes	23847.38	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfiddich/glenfiddich-50-year-old-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Glenfiddich
38919	masterofmalt	155796	Bowmore Black 31 Year Old 1964 - Final Edition Single Malt Whisky	49	70	Single Malt	whisky	Bowmore	Scotland	Islay	https://cdn1.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-black-31-year-old-1964-final-edition-whisky.jpg	Yes	22000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-black-31-year-old-1964-final-edition-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Bowmore
66318	masterofmalt	173484	Glenfarclas 60 Year Old (cask 1820) Single Malt Whisky	40.9	70	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/glenfarclas/glenfarclas-60-year-old-cask-1820-whisky.jpg	Yes	19500.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-60-year-old-cask-1820-whisky/?countryCodeShort=GB¤cyCode=GBP	60	Glenfarclas
39429	masterofmalt	156791	Macallan 1938 (bottled 1980s) - Gordon & MacPhail Single Malt Whisky	43	75	Single Malt	whisky	The Macallan	Scotland	Speyside	https://cdn1.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-1938-bottled-1980s-gordon-and-macphail-whisky.jpg	Yes	17995.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&afsource=20&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-1938-bottled-1980s-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt16	ALL					51324	100.00	Using where; Using filesort

File	Function	Line
/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html	query()	26

001	$_POST array ( )

001	$_GET array ( )

001	$_SESSION NULL

001	$_FILES array ( )

001

$_SERVER

array (
  'PATH' => '/usr/local/bin:/usr/bin:/bin',
  'REDIRECT_STATUS' => '200',
  'SCRIPT_URL' => '/newarrivals.html',
  'SCRIPT_URI' => 'https://www.greatwhiskies.com/newarrivals.html',
  'HTTPS' => 'on',
  'HTTP_HOST' => 'www.greatwhiskies.com',
  'HTTP_X_REAL_IP' => '3.238.125.76',
  'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location',
  'HTTP_CONNECTION' => 'close',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_IF_MODIFIED_SINCE' => 'Sat, 22 Jan 2022 21:30:33 GMT',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_NAME' => 'www.greatwhiskies.com',
  'SERVER_ADDR' => '77.68.7.68',
  'SERVER_PORT' => '443',
  'REMOTE_ADDR' => '3.238.125.76',
  'DOCUMENT_ROOT' => '/var/www/vhosts/greatwhiskies.com/httpdocs',
  'SERVER_ADMIN' => '[no address given]',
  'SCRIPT_FILENAME' => '/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html',
  'REMOTE_PORT' => '39646',
  'REDIRECT_URL' => '/newarrivals.html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/newarrivals.html',
  'SCRIPT_NAME' => '/newarrivals.html',
  'ORIG_SCRIPT_FILENAME' => '/var/www/cgi-bin/cgi_wrapper/cgi_wrapper',
  'ORIG_PATH_INFO' => '/newarrivals.html',
  'ORIG_PATH_TRANSLATED' => '/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html',
  'ORIG_SCRIPT_NAME' => '/phppath/cgi_wrapper',
  'PHP_SELF' => '/newarrivals.html',
  'REQUEST_TIME_FLOAT' => 1656707657.523186,
  'REQUEST_TIME' => 1656707657,
)

Great Whiskies New Arrivals Priced over £500

View Scottish Single Malts by Distillery

OTHER WHISKIES OFFERS

ABOUT GREAT WHISKIES

KEY WHISKY PAGES

Policies

CONTACT US