0
Scotch
Following the success of the Arran Distillery at Lochranza, Arran Distillers opened the Lagg Distillery in 2019. Located at the southern tip of the Island, they produce a range of heavily peated, modern characterful single malt whiskies. Their Limited Edition Inaugural whiskies were bottled in 2022, followed by their flagship Kilmory Single Malt in June 2023.
Error:
Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
SELECT DISTINCT P.productID,P.avg_rating,P.tot_reviews, P.free_shipping,P.seo_parameter, P.productTitle, P.mom_price, P.mom_url, P.mom_img_url,
P.mom_id,P.productDesc, P.retailPrice, P.dealPrice, P.productImage, P.mom_size,
P.quantity, P.regionID, IF(P.dealPrice>0, P.dealPrice, P.retailPrice) AS price, P.itemCode, P.psource
FROM products AS P
INNER JOIN product_categories PC ON (PC.productID=P.productID)
INNER JOIN categories C ON (C.categoryID=PC.categoryID)
LEFT JOIN product_promotions PROM ON (PROM.productID = P.productID)
WHERE 1 AND P.outdated ='0' AND (P.usa='1' OR P.both_versions = '1') and P.status=1 AND P.quantity > 0 AND P.productTitle!='' AND ( FIND_IN_SET(PC.categoryID,'22,30,159,181,375,557,581,591,686,702,746,837,839,806,807,853,854,855,856,857,858,859,860,861,862,863,864,865,906,1033,1260,1333,1273,1316,1347,669,1459,1537,1532,1556,1562,1487') OR FIND_IN_SET(C.parentID,'22,30,159,181,375,557,581,591,686,702,746,837,839,806,807,853,854,855,856,857,858,859,860,861,862,863,864,865,906,1033,1260,1333,1273,1316,1347,669,1459,1537,1532,1556,1562,1487') )
AND (P.psource IN (1,92,70,80,90,21,105) OR P.both_versions = '1') AND P.brand_id = '7398'
GROUP BY P.productID ORDER BY featured DESC LIMIT 12 OFFSET 0
