Mountain Gems & Healing Crystals
  Top » Catalog » Printable Catalog    My Account  |  Cart Contents  |  Checkout  
Mountain Gems & Healing Crystals
Mountain Gems & Healing Crystals
38 Greenbough, Suite 105
Irvine CA 92614
USA
Toll Free 877-785-5372 sales@healingcrystals.net
Email: sales@healingcrystals.net
Note: All prices are subject to change without notice. All products will be billed in our shop Currency only.
          The Currency feature is just for your convenience. This catalog is current on the day of printing.
Currencies
1054 - Unknown column 'p.products_upc' in 'order clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name from (products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c ) left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by p.products_upc DESC

[TEP STOP]

 
  		Image
 
  		Options
Sort Asending
Sort Desending		 Date added
Sort Asending
Sort Desending		 Manufacturer
Sort Asending
Sort Desending		 Name
Sort Asending
Sort Desending		 Description
Sort Asending
Sort Desending		 Category
Sort Asending
Sort Desending		 Model
Sort Asending
Sort Desending		 UPC
Sort Asending
Sort Desending		 Quantity
Sort Asending
Sort Desending		 Weight
Sort Asending
Sort Desending		 Price