select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name like '%galway%' and DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= FROM_UNIXTIME(o.ss_date) group by p.ss_sku order by c desc limit 1

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name like '%galway%' and DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= FROM_UNIXTIME(o.ss_date) group by p.ss_sku order by c desc limit 1


Most Popular

By Category:



By Pattern:


Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Galway Crystal Golf Bag Hanging Ornament
Galway Crystal Golf Bag Hanging OrnamentNew
Item # 24061
Now Only $15.95
Galway Crystal Longford Makeup Bell
Galway Crystal Longford Makeup BellSale
Item # 24096
Now Only $19.95
Belleek China Galway Weave 15 oz. Mug, Pair
Belleek China Galway Weave 15 oz. Mug, PairNew
Item # B4125
Pair Now Only $45.00
Galway Crystal Ashford Salt and Pepper
Galway Crystal Ashford Salt and PepperSale
Item # 57402
Now Only $29.95
Galway Crystal Symphony 6" Bowl
Galway Crystal Symphony 6" BowlSale
Item # 64006
Now Only $19.95
Galway Crystal Vanity Ashford Ring Holder
Galway Crystal Vanity Ashford Ring HolderSale
Item # 23578
Now Only $19.95
Galway Crystal Claddagh Bell
Galway Crystal Claddagh BellNew
Item # 24091
$50.00
Galway Crystal Galway Celtic Cross
Galway Crystal Galway Celtic CrossSale
Item # 34002
Now Only $59.95
Galway Crystal Irish Coffee, Pair
Galway Crystal Irish Coffee, PairSale
Item # 200062
Pair Now Only $39.99
Galway Crystal Latte Mugs, Pair
Galway Crystal Latte Mugs, PairNew
Item # 200072
Pair Now Only $25.00
Galway Crystal Dune Flared 14" Crystal Vase
Galway Crystal Dune Flared 14" Crystal VaseSale
Item # 45014
Now Only $95.95
Galway Crystal Symphony 8" Vase
Galway Crystal Symphony 8" VaseSale
Item # 64008
Now Only $29.95
Galway Crystal Kells Decanter Set
Galway Crystal Kells Decanter SetSale
Item # 30180
Now Only $119.95
Galway Crystal Dune Square 10" Crystal Vase
Galway Crystal Dune Square 10" Crystal VaseSale
Item # 45010
Now Only $49.95
Galway Crystal Dune 10" Crystal Bowl
Galway Crystal Dune 10" Crystal BowlSale
Item # 45016
Now Only $49.95
Galway Crystal Longford Brandy, Pair
Galway Crystal Longford Brandy, PairNew
Item # 222572A
Pair $80.00
Galway Crystal 7" Slipper
Galway Crystal 7" SlipperNew
Item # 25312
$40.00
Galway Crystal Trinity Knot Flute, Pair
Galway Crystal Trinity Knot Flute, PairNew
Item # 203102A
Pair $90.00
Galway Crystal Dune Flared 12" Crystal Vase
Galway Crystal Dune Flared 12" Crystal VaseSale
Item # 45013
Now Only $75.95
Galway Crystal Dune 4 1/2" Bowl
Galway Crystal Dune 4 1/2" BowlSale
Item # 45076
Now Only $15.95
Galway Crystal Longford Goblet, Pair
Galway Crystal Longford Goblet, PairNew
Item # 222502A
Pair $80.00
Galway Crystal Longford Ships Decanter
Galway Crystal Longford Ships DecanterSale
Item # 25200
Now Only $250.00
Galway Crystal Trinity Knot Goblet, Pair
Galway Crystal Trinity Knot Goblet, PairNew
Item # 203122A
Pair $90.00
Galway Crystal Dune Square 12" Crystal Vase
Galway Crystal Dune Square 12" Crystal VaseSale
Item # 45012
Now Only $75.95
Galway Crystal Atlantic 13" Vase
Galway Crystal Atlantic 13" VaseSale
Item # 11612
Now Only $70.00
Galway Crystal Atlantic Large Bowl
Galway Crystal Atlantic Large BowlSale
Item # 11613
Now Only $60.00
Galway Crystal Atlantic Small Bowl
Galway Crystal Atlantic Small BowlSale
Item # 11614
Now Only $25.00
Galway Crystal Renmore DOF, Set of 4
Galway Crystal Renmore DOF, Set of 4New
Item # 350064
Set $39.95
Galway Crystal Renmore Goblet, Set of 4
Galway Crystal Renmore Goblet, Set of 4New
Item # 350004
Set $39.95
Galway Crystal Irish Blessing Latte, Pair
Galway Crystal Irish Blessing Latte, PairSale
Item # 200502US
Pair $40.00
Galway Crystal Longford Wine, Pair
Galway Crystal Longford Wine, PairNew
Item # 222512A
Pair $80.00
Galway Crystal Longford Flute, Pair
Galway Crystal Longford Flute, PairNew
Item # 222652A
Pair $80.00
Galway Crystal Longford Hiball, Pair
Galway Crystal Longford Hiball, PairNew
Item # 222582A
Pair $70.00
Galway Crystal Dune Votive
Galway Crystal Dune VotiveSale
Item # 45075
Now Only $24.95
Galway Crystal Abbey Goblet, Set of 4
Galway Crystal Abbey Goblet, Set of 4Sale
Item # 309004
Set of Four Only $39.95
Galway Crystal Ashford 4" Candlestick, Pair
Galway Crystal Ashford 4" Candlestick, PairSale
Item # 57405
Pair Now Only $29.95
Galway Crystal Ashford Bud Vase
Galway Crystal Ashford Bud VaseSale
Item # 57406
Now Only $19.95
Galway Crystal Ashford Trinket Box
Galway Crystal Ashford Trinket BoxSale
Item # 57404
Now Only $24.95
Galway Crystal Celtic Pillar Hurricane Lamp
Galway Crystal Celtic Pillar Hurricane LampNew
Item # 21555
Now Only $135.00
Galway Crystal Trinity Knot Wine, Pair
Galway Crystal Trinity Knot Wine, PairNew
Item # 203112A
Pair $90.00

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name like '%Galway%' group by p.ss_sku order by c desc


^ Back to Top