surfersgarage.com
E-mail address:
 Password: 
Create a New Account         (password forgotten)
 
  Catalog » All Products Search:  
 
 
Categories
Black Sunnies
Funky Beanies
Groms & Lil Surfer Girls
Lion Coffee
Mellow Cali Beanies
New Skool Kings
Pin Up Lip Balm
SG's Tees for Guys & Dolls
Surfers Garage "Garage" Jacket
Surfers Garage Backpacks
Surfers Garage Hats
Our Killer License Plate Frames
Shopping Cart more
0 items
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search

Sign in
E-mail address:


Password:


(forgotten)


Create an Account
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Printable Catalog
Gift Voucher FAQ
Site Map
All Products
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | LIST ALL PRODUCTS
1054 - Unknown column 'p.manufacturers_id' in 'on clause'

select p.products_id, p.products_model ,pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and c.cshow > '0' and products_status = '1' order by pd.products_name

[TEP STOP]