 |
Categories |
 |
|
 |
Manufacturers |
|
|
|
|
|
Quick Find |
|
|
|
Information |
|
|
|
Beach House Linens
Beach House Linens
PO Box 12990, New Bern, NC 28561-2990
PH(252)247-4788, FAX (888)247-5488
Email your questions anytime to decorate@beachhouselinens.com
Copyright 1996-2012
BeachHouseLinens
Email: decorate@beachhouselinens.com
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 |
|
|
|
 |
|
|
 |
Name |
|
|
Category |
|
|
Model |
|
|
Price |
|
|
1054 - Unknown column 'p.products_id' in 'on 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_price DESC, pd.products_name
[TEP STOP]
| | | |
BEDROOMS
SHELLS & SHELLS
