SCOTTISH COUNTRY SHOP 1450 SE Powell Blvd. Portland, Oregon 97202 USA 503-238-2528 * 1-800-550-3568 FAX - 503-238-5152

Top » Catalog » FREE SHIPPING ALL ORDERS $50+

My Account  |  Cart Contents  |  Checkout

Categories   FREE SHIPPING ALL ORDERS $50+   SPECIALS!!    APPAREL  (1)   BAGPIPE SUPPLIES / BOOKS / MUSIC    BOOKS    CLAN ITEMS   FOOD    GIFTS    INSTRUMENTS Incl Pipes & Drums    JEWELRY    MUSIC / CDs / DVDs    SHORTBREAD PANS Manufacturers Please SelectArt PewterGaelic ThemesJacob'sLochcarronMcCallum Bagpip..McVitiesPearl DrumsSt. JustinWalkers What's New? Ghillie Brogue Laces & Tassels $8.95 Quick Find   Use keywords to find the product you are looking for. Advanced Search Information Shipping & Returns Privacy Notice Conditions of Use Contact Us

Let's See What We Have Here 1054 - Unknown column 'p.products_id' in 'on clause' select count(*) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '97' [TEP STOP]