English
Currencies:
Shopping Cart
(4) items
Site Search
 Specials  Search  Contact Us  Create an account  Customer Login
Browse by Department
  Accessories
  Allied Degrees
  Ball Charms
  Books
  Case
  Coats
  Craft
  Cufflinks
  Furnishings
  Gift Ware
  Knights Of Malta
  Knights Templar
  Knights/Preceptors
  London Grand Rank
  Mark
  O.S.M.
  Red Cross Of Costantine
  Rings
  Rituals
  Rose Croix
  Royal & Select
  Royal Arch
  Royal Mariner
  Royal Order Of Scotland
  St John The Evangelist
  Watches
 
 
1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) 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 = '50'

[TEP STOP]