Huntsville Blueprint & Supply Co.
www.surveyorsplace.com
1201 University Ave
Huntsville, TX
77340, USA
Email: huntsvillebp@yahoo.com
Phone: 936-291-2661
Fax: 936-291-2003
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.
|
|
|
|
 |
| Image |
Products |
Model |
Quantity |
Price |
|
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_id, p.products_image, p.products_model, p.products_quantity, pd.products_name, p.manufacturers_id, p.products_price, 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 = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by pd.products_name
[TEP STOP]
| | |
