Great Whiskies New Arrivals Priced over £500

Glen Grant 1948 (cask 1365) King Charles III Coronation Release (Gordo Single Malt Whisky

£ 25,000.00

Buy Online

Octomore Event Horizon 12 Year Old - Feis Ile 2019 Single Malt Whisky

£ 699.00

Buy Online

Glenfiddich Grand Yozakura 29 Year Old Single Malt Whisky

£ 1,495.95

Buy Online

Singleton of Glen Ord 40 Year Old Single Malt Whisky

£ 3,300.00

Buy Online

Rosebank 1988 (bottled 1997) - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky

£ 699.00

Buy Online

Glen Albyn 1966 (bottled 2005) - Connoisseurs Choice (Gordon & MacPhai Single Malt Whisky

£ 1,200.00

Buy Online

Suntory Hibiki 17 Year Old (Old Bottling) Blended Whisky

£ 999.00

Buy Online

Coleburn 1972 (bottled 2002) - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky

£ 699.00

Buy Online

The GlenDronach 27 Year Old 1993 (cask 6735) Single Malt Whisky

£ 999.00

Buy Online

The GlenDronach 26 Year Old 1993 (cask 5856) Single Malt Whisky

£ 699.00

Buy Online

Laphroaig 20 Year Old 1998 (cask 700392) - 30th Anniversary Gift Box ( Single Malt Whisky

£ 1,200.00

Buy Online

Macallan 21 Year Old 1997 (cask 628) - 30th Anniversary Gift Box (Sign Single Malt Whisky

£ 1,999.00

Buy Online

Suntory Hibiki 17 Year Old Blended Whisky

£ 1,200.00

Buy Online

Kilkerran Staff Exclusive Christmas 2008 Single Malt Whisky

£ 1,200.00

Buy Online

Bowmore 25 Year Old 1997 (cask 2422) - Cask Strength Collection (Signa Single Malt Whisky

£ 725.00

Buy Online

Laphroaig 25 Year Old 1997 (cask 3372) - Cask Strength Collection (Sig Single Malt Whisky

£ 725.00

Buy Online

Macallan 25 Year Old 1997 (cask 12/4) - Cask Strength Collection (Sign Single Malt Whisky

£ 1,550.00

Buy Online

The Macallan 10 Year Old - circa 1980 Single Malt Whisky

£ 1,200.00

Buy Online

Mortlach 33 Year Old 1989 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky

£ 1,100.00

Buy Online

Laphroaig 25 Year Old 1997 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky

£ 705.00

Buy Online

Highland Park 22 Year Old 2000 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky

£ 575.00

Buy Online

Dalmore 31 Year Old 1991 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky

£ 854.59

Buy Online

Springbank 31 Year Old 1991 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky

£ 2,696.05

Buy Online

Glen Albyn 18 Year Old 1963 - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky

£ 599.00

Buy Online

Coleburn 17 Year Old 1965 - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky

£ 599.00

Buy Online

Port Ellen 40 Year Old 1982 - Eidolon 2nd Release (Hunter Laing) Single Malt Whisky

£ 4,500.00

Buy Online

Yamazaki Mizunara Oak 2022 Single Malt Whisky

£ 2,500.00

Buy Online

Yamazaki Spanish Oak 2022 Single Malt Whisky

£ 1,500.00

Buy Online

View Scottish Single Malts by Distillery

OTHER WHISKIES OFFERS

Glenfarclas Family Cask Trunk Single Malt Whisky

£ 105,000.00

Buy Online

Glenfiddich 50 Year Old Simultaneous Time - Time Reimagined Single Malt Whisky

£ 37,716.23

Buy Online

Brora Triptych (3 x 50cl) Single Malt Whisky

£ 30,000.00

Buy Online

Dalmore 45 Year Old 1966 (cask 7) - Constellation Collection Single Malt Whisky

£ 28,999.00

Buy Online

Dalmore 43 Year Old 1969 (cask 1) - Constellation Collection Single Malt Whisky

£ 28,999.00

Buy Online

Glen Grant 1948 (cask 1365) King Charles III Coronation Release (Gordo Single Malt Whisky

£ 25,000.00

Buy Online

Bowmore 37 Year Old 1964 Fino Cask Single Malt Whisky

£ 25,000.00

Buy Online

Shirakawa 1958 Single Malt Whisky

£ 24,999.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 (0.33%)
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.001 seconds (0.92%)
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 
    mastersofmalt23 
where 
    Type = 'whisky' 
    and Company = 'masterofmalt' 
    and Name != '%Whisky Advent%' 
    and Price > '500' 
ORDER BY 
    myid desc 
LIMIT 
    28;

duration: 0.020 seconds (25.93%)
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
31871	masterofmalt	193871	Glen Grant 1948 (cask 1365) King Charles III Coronation Release (Gordo Single Malt Whisky	50.4	70	Single Malt	whisky	Glen Grant	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky.jpg	Yes	25000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
31858	masterofmalt	193583	Octomore Event Horizon 12 Year Old - Feis Ile 2019 Single Malt Whisky	55.7	70	Single Malt	whisky	Bruichladdich	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/bruichladdich/octomore-event-horizon-12-year-old-feis-ile-2019-whisky.jpg	Yes	699.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/bruichladdich/octomore-event-horizon-12-year-old-feis-ile-2019-whisky/?countryCodeShort=GB¤cyCode=GBP	12	Bruichladdich
31847	masterofmalt	193465	Glenfiddich Grand Yozakura 29 Year Old Single Malt Whisky	45.1	70	Single Malt	whisky	Glenfiddich	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glenfiddich/glenfiddich-grand-yozakura-29-year-old-whiskies.jpg	No	1495.95	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glenfiddich/glenfiddich-grand-yozakura-29-year-old-whiskies/?countryCodeShort=GB¤cyCode=GBP	29	Glenfiddich
31837	masterofmalt	193433	Singleton of Glen Ord 40 Year Old Single Malt Whisky	45.9	70	Single Malt	whisky	Glen Ord	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/glen-ord/singleton-of-glen-ord-40-year-old-whisky.jpg	Yes	3300.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glen-ord/singleton-of-glen-ord-40-year-old-whisky/?countryCodeShort=GB¤cyCode=GBP	40	Glen Ord
31832	masterofmalt	193407	Rosebank 1988 (bottled 1997) - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky	40	70	Single Malt	whisky	Rosebank	Scotland	Lowland	https://www.masterofmalt.com/Whiskies/p-2007/rosebank/rosebank-1988-bottled-1997-connoisseurs-choice-gordon-and-macphail-whisky.jpg	No	699.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/rosebank/rosebank-1988-bottled-1997-connoisseurs-choice-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
31830	masterofmalt	193404	Glen Albyn 1966 (bottled 2005) - Connoisseurs Choice (Gordon & MacPhai Single Malt Whisky	43	70	Single Malt	whisky	Glen Albyn	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/glen-albyn/glen-albyn-1966-bottled-2005-connoisseurs-choice-gordon-and-macphail-whisky.jpg	Yes	1200.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glen-albyn/glen-albyn-1966-bottled-2005-connoisseurs-choice-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
31826	masterofmalt	193397	Suntory Hibiki 17 Year Old (Old Bottling) Blended Whisky	43	70	Blended	whisky	Hibiki	Japan	Japanese	https://www.masterofmalt.com/Whiskies/p-2007/hibiki/suntory-hibiki-17-year-old-old-bottling-whisky.jpg	No	999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/hibiki/suntory-hibiki-17-year-old-old-bottling-whisky/?countryCodeShort=GB¤cyCode=GBP	17	Hibiki
31791	masterofmalt	193314	Coleburn 1972 (bottled 2002) - Connoisseurs Choice (Gordon & MacPhail) Single Malt Whisky	40	70	Single Malt	whisky	Coleburn	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/coleburn/coleburn-1972-bottled-2002-connoisseurs-choice-gordon-and-macphail-whisky.jpg	Yes	699.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/coleburn/coleburn-1972-bottled-2002-connoisseurs-choice-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
31779	masterofmalt	193280	The GlenDronach 27 Year Old 1993 (cask 6735) Single Malt Whisky	51	70	Single Malt	whisky	GlenDronach	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/glendronach/the-glendronach-27-year-old-1993-cask-6735-whisky.jpg	Yes	999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glendronach/the-glendronach-27-year-old-1993-cask-6735-whisky/?countryCodeShort=GB¤cyCode=GBP	27	GlenDronach
31778	masterofmalt	193279	The GlenDronach 26 Year Old 1993 (cask 5856) Single Malt Whisky	54	70	Single Malt	whisky	GlenDronach	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/glendronach/the-glendronach-26-year-old-1993-cask-5856-whisky.jpg	No	699.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glendronach/the-glendronach-26-year-old-1993-cask-5856-whisky/?countryCodeShort=GB¤cyCode=GBP	26	GlenDronach
31777	masterofmalt	193278	Laphroaig 20 Year Old 1998 (cask 700392) - 30th Anniversary Gift Box ( Single Malt Whisky	58.3	70	Single Malt	whisky	Laphroaig	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/laphroaig/laphroaig-20-year-old-1998-cask-700392-30th-anniversary-gift-box-signatory-whisky.jpg	No	1200.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/laphroaig/laphroaig-20-year-old-1998-cask-700392-30th-anniversary-gift-box-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	20	Laphroaig
31776	masterofmalt	193277	Macallan 21 Year Old 1997 (cask 628) - 30th Anniversary Gift Box (Sign Single Malt Whisky	54	75	Single Malt	whisky	The Macallan	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-21-year-old-1997-cask-628-30th-anniversary-gift-box-signatory-whisky.jpg	Yes	1999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-21-year-old-1997-cask-628-30th-anniversary-gift-box-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	21	Signatory
31734	masterofmalt	193095	Suntory Hibiki 17 Year Old Blended Whisky	43	70	Blended	whisky	Hibiki	Japan	Japanese	https://www.masterofmalt.com/Whiskies/p-2007/hibiki/suntory-hibiki-17-year-old-whisky.jpg	No	1200.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/hibiki/suntory-hibiki-17-year-old-whisky/?countryCodeShort=GB¤cyCode=GBP	17	Hibiki
31731	masterofmalt	193090	Kilkerran Staff Exclusive Christmas 2008 Single Malt Whisky	46	70	Single Malt	whisky	Kilkerran	Scotland	Campbeltown	https://www.masterofmalt.com/Whiskies/p-2007/kilkerran/kilkerran-staff-exclusive-christmas-2008-whisky.jpg	Yes	1200.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/kilkerran/kilkerran-staff-exclusive-christmas-2008-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Kilkerran
31727	masterofmalt	193082	Bowmore 25 Year Old 1997 (cask 2422) - Cask Strength Collection (Signa Single Malt Whisky	55.9	70	Single Malt	whisky	Bowmore	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-25-year-old-1997-cask-2422-cask-strength-collection-signatory-whisky.jpg	Yes	725.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-25-year-old-1997-cask-2422-cask-strength-collection-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	25	Signatory
31726	masterofmalt	193081	Laphroaig 25 Year Old 1997 (cask 3372) - Cask Strength Collection (Sig Single Malt Whisky	52.2	70	Single Malt	whisky	Laphroaig	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/laphroaig/laphroaig-25-year-old-1997-cask-3372-cask-strength-collection-signatory-whisky.jpg	No	725.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/laphroaig/laphroaig-25-year-old-1997-cask-3372-cask-strength-collection-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	25	Signatory
31725	masterofmalt	193080	Macallan 25 Year Old 1997 (cask 12/4) - Cask Strength Collection (Sign Single Malt Whisky	55	70	Single Malt	whisky	The Macallan	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/the-macallan/macallan-25-year-old-1997-cask-12/4-cask-strength-collection-signatory-whisky.jpg	No	1550.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/the-macallan/macallan-25-year-old-1997-cask-12/4-cask-strength-collection-signatory-whisky/?countryCodeShort=GB¤cyCode=GBP	25	Signatory
31562	masterofmalt	192893	The Macallan 10 Year Old - circa 1980 Single Malt Whisky	40	75	Single Malt	whisky	The Macallan	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/the-macallan/the-macallan-10-year-old-circa-1980-whisky.jpg	No	1200.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/the-macallan/the-macallan-10-year-old-circa-1980-whisky/?countryCodeShort=GB¤cyCode=GBP	10	The Macallan
31492	masterofmalt	192745	Mortlach 33 Year Old 1989 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky	52.9	70	Single Malt	whisky	Mortlach	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/mortlach/mortlach-33-year-old-1989-old-and-rare-platinum-hunter-laing-whisky.jpg	Yes	1100.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/mortlach/mortlach-33-year-old-1989-old-and-rare-platinum-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	33	Hunter Laing
31488	masterofmalt	192741	Laphroaig 25 Year Old 1997 - Old & Rare Platinum (Hunter Laing) Single Malt Whisky	54.4	70	Single Malt	whisky	Laphroaig	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/laphroaig/laphroaig-25-year-old-1997-old-and-rare-platinum-hunter-laing-whisky.jpg	Yes	705.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/laphroaig/laphroaig-25-year-old-1997-old-and-rare-platinum-hunter-laing-whisky/?countryCodeShort=GB¤cyCode=GBP	25	Hunter Laing

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt23	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 
    mastersofmalt23 
where 
    Type = 'whisky' 
    and Availability = 'Yes' 
    and Price > '300' 
ORDER BY 
    Price DESC 
limit 
    8;

duration: 0.030 seconds (38.23%)
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
16260	masterofmalt	154156	Glenfarclas Family Cask Trunk Single Malt Whisky	50.6	1000	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://www.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=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-family-cask-trunk-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Glenfarclas
28041	masterofmalt	186387	Glenfiddich 50 Year Old Simultaneous Time - Time Reimagined Single Malt Whisky	43.8	70	Single Malt	whisky	Glenfiddich	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glenfiddich/glenfiddich-50-year-old-time-reimagined-whisky.jpg	Yes	37716.23	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glenfiddich/glenfiddich-50-year-old-time-reimagined-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Glenfiddich
23786	masterofmalt	177707	Brora Triptych (3 x 50cl) Single Malt Whisky	46.3	150	Single Malt	whisky	Brora	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/brora/brora-triptych-3-x-50cl-whisky.jpg	Yes	30000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/brora/brora-triptych-3-x-50cl-whisky/?countryCodeShort=GB¤cyCode=GBP	48	Brora
7620	masterofmalt	110999	Dalmore 45 Year Old 1966 (cask 7) - Constellation Collection Single Malt Whisky	41.7	70	Single Malt	whisky	Dalmore	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/dalmore/dalmore-45-year-old-1966-cask-7-constellation-collection-whisky.jpg	Yes	28999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/dalmore/dalmore-45-year-old-1966-cask-7-constellation-collection-whisky/?countryCodeShort=GB¤cyCode=GBP	45	Dalmore
7621	masterofmalt	111000	Dalmore 43 Year Old 1969 (cask 1) - Constellation Collection Single Malt Whisky	49.9	70	Single Malt	whisky	Dalmore	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/dalmore/dalmore-43-year-old-1969-cask-1-constellation-collection-whisky.jpg	Yes	28999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/dalmore/dalmore-43-year-old-1969-cask-1-constellation-collection-whisky/?countryCodeShort=GB¤cyCode=GBP	43	Dalmore
31871	masterofmalt	193871	Glen Grant 1948 (cask 1365) King Charles III Coronation Release (Gordo Single Malt Whisky	50.4	70	Single Malt	whisky	Glen Grant	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky.jpg	Yes	25000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
3993	masterofmalt	88174	Bowmore 37 Year Old 1964 Fino Cask Single Malt Whisky	49.6	75	Single Malt	whisky	Bowmore	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-37-year-old-1964-fino-cask-whisky.jpg	Yes	25000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-37-year-old-1964-fino-cask-whisky/?countryCodeShort=GB¤cyCode=GBP	37	Bowmore
29275	masterofmalt	188843	Shirakawa 1958 Single Malt Whisky	49	70	Single Malt	whisky	Takara Shuzo	Japan	Japanese	https://www.masterofmalt.com/Whiskies/p-2007/takara-shuzo/shirakawa-1958-whisky.jpg	Yes	24999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/takara-shuzo/shirakawa-1958-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Takara Shuzo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt23	ALL					43920	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 
    mastersofmalt23 
where 
    Type = 'whisky' 
    and Availability = 'Yes' 
    and Price > '5000' 
ORDER BY 
    Price DESC 
limit 
    8;

duration: 0.027 seconds (34.59%)
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
16260	masterofmalt	154156	Glenfarclas Family Cask Trunk Single Malt Whisky	50.6	1000	Single Malt	whisky	Glenfarclas	Scotland	Speyside	https://www.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=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glenfarclas/glenfarclas-family-cask-trunk-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Glenfarclas
28041	masterofmalt	186387	Glenfiddich 50 Year Old Simultaneous Time - Time Reimagined Single Malt Whisky	43.8	70	Single Malt	whisky	Glenfiddich	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glenfiddich/glenfiddich-50-year-old-time-reimagined-whisky.jpg	Yes	37716.23	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glenfiddich/glenfiddich-50-year-old-time-reimagined-whisky/?countryCodeShort=GB¤cyCode=GBP	50	Glenfiddich
23786	masterofmalt	177707	Brora Triptych (3 x 50cl) Single Malt Whisky	46.3	150	Single Malt	whisky	Brora	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/brora/brora-triptych-3-x-50cl-whisky.jpg	Yes	30000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/brora/brora-triptych-3-x-50cl-whisky/?countryCodeShort=GB¤cyCode=GBP	48	Brora
7620	masterofmalt	110999	Dalmore 45 Year Old 1966 (cask 7) - Constellation Collection Single Malt Whisky	41.7	70	Single Malt	whisky	Dalmore	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/dalmore/dalmore-45-year-old-1966-cask-7-constellation-collection-whisky.jpg	Yes	28999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/dalmore/dalmore-45-year-old-1966-cask-7-constellation-collection-whisky/?countryCodeShort=GB¤cyCode=GBP	45	Dalmore
7621	masterofmalt	111000	Dalmore 43 Year Old 1969 (cask 1) - Constellation Collection Single Malt Whisky	49.9	70	Single Malt	whisky	Dalmore	Scotland	Highland	https://www.masterofmalt.com/Whiskies/p-2007/dalmore/dalmore-43-year-old-1969-cask-1-constellation-collection-whisky.jpg	Yes	28999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/dalmore/dalmore-43-year-old-1969-cask-1-constellation-collection-whisky/?countryCodeShort=GB¤cyCode=GBP	43	Dalmore
31871	masterofmalt	193871	Glen Grant 1948 (cask 1365) King Charles III Coronation Release (Gordo Single Malt Whisky	50.4	70	Single Malt	whisky	Glen Grant	Scotland	Speyside	https://www.masterofmalt.com/Whiskies/p-2007/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky.jpg	Yes	25000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/glen-grant/glen-grant-1948-cask-1365-king-charles-iii-coronation-release-gordon-and-macphail-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Gordon & MacPhail
3993	masterofmalt	88174	Bowmore 37 Year Old 1964 Fino Cask Single Malt Whisky	49.6	75	Single Malt	whisky	Bowmore	Scotland	Islay	https://www.masterofmalt.com/Whiskies/p-2007/bowmore/bowmore-37-year-old-1964-fino-cask-whisky.jpg	Yes	25000.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/bowmore/bowmore-37-year-old-1964-fino-cask-whisky/?countryCodeShort=GB¤cyCode=GBP	37	Bowmore
29275	masterofmalt	188843	Shirakawa 1958 Single Malt Whisky	49	70	Single Malt	whisky	Takara Shuzo	Japan	Japanese	https://www.masterofmalt.com/Whiskies/p-2007/takara-shuzo/shirakawa-1958-whisky.jpg	Yes	24999.00	https://scripts.affiliatefuture.com/AFClick.asp?affiliateID=345186&merchantID=7042&programmeID=25000&mediaID=0&tracking=&verac=0&afsource=61&url=https://www.masterofmalt.com/whiskies/takara-shuzo/shirakawa-1958-whisky/?countryCodeShort=GB¤cyCode=GBP	0	Takara Shuzo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mastersofmalt23	ALL					43920	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 (
  'USER' => 'greatwhiskies',
  'HOME' => '/var/www/vhosts/greatwhiskies.com',
  'SCRIPT_NAME' => '/newarrivals.html',
  'REQUEST_URI' => '/newarrivals.html',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/1.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REMOTE_PORT' => '44078',
  'SCRIPT_FILENAME' => '/var/www/vhosts/greatwhiskies.com/httpdocs/newarrivals.html',
  'SERVER_ADMIN' => '[no address given]',
  'CONTEXT_DOCUMENT_ROOT' => '/var/www/vhosts/greatwhiskies.com/httpdocs',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'https',
  'DOCUMENT_ROOT' => '/var/www/vhosts/greatwhiskies.com/httpdocs',
  'REMOTE_ADDR' => '3.142.201.222',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '194.164.121.211',
  'SERVER_NAME' => 'www.greatwhiskies.com',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_CONNECTION' => 'close',
  'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location',
  'HTTP_X_REAL_IP' => '3.142.201.222',
  'HTTP_HOST' => 'www.greatwhiskies.com',
  'proxy-nokeepalive' => '1',
  'HTTPS' => 'on',
  'SCRIPT_URI' => 'https://www.greatwhiskies.com/newarrivals.html',
  'SCRIPT_URL' => '/newarrivals.html',
  'UNIQUE_ID' => 'aBLuP8Ks84AW2SQpUbW9LQAAAAQ',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/newarrivals.html',
  'REQUEST_TIME_FLOAT' => 1746071103.210426,
  'REQUEST_TIME' => 1746071103,
)

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