Grandpa's General Store, Unique Gifts & Metaphysical Supplies
  •  My Account  •  View Your Shopping Cart   •  Go To Checkout     •  Shopping Info     •  My Wishlist     •  UPS Tracking     •  Your Guarantee     •  Customer Service/Help  
Home      Shop   Fun  Learn   Community   Contact
All Orders Shipped In Plain Discreet Packaging
   GRANDPA'S IS CLOSED (Temporarily)!
Click Here, For Links To Find What You Seek...
Google
 
Shopping
Aromatherapy
Bags
Bath-Body
Bells-Chimes
Book-Store
Candles
Craft-Supplies
Crystals-Stones
Feng-Shui
Gifts
Herbs
Home-Decor
Incense
Accessories
Burners
Cones
Dhoop
Grandpa's-Sticks
Herbs
Incense-Kits
Mini-Sticks
Nag-Champa
Namaste-Incense
Powders
Resins
Smudge
Song-Of-India
Jewelry
Oils-Perfume
Psychic-Tools
Ritual-Tools
Spellcraft
Stocking-Stuffers
Tapestries
Tarot
Toys-n-Gags
Gift-Certificates
Bargains
 
Spiritual Cinema Circle
“It’s not often you can combine entertainment with personal growth but that is exactly what The Spiritual Cinema Circle offers. These engaging films provide important messages about life, love and the world we live in.” — Jack Canfield
 
Hot Links
 
 
Tell A Friend About Grandpa's!
 
Tell someone you know about this product.
1054 - Unknown column 'p.products_id' in 'on clause'

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '376' and pd.products_id = '376' and pd.language_id = '1'

[TEP STOP]