UltraBond
UltraBond
UltraBond
2458 E Main Unit B 1
Grand Junction, CO 81501
800-398-2663 or
970-256-0200
Email: info@ultrabond.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.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9999, 9999' at line 1

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 and ((expires_date = '0000-00-00 00:00:00') or (expires_date >= '2013-06-17 23:12:51'))), s.specials_new_products_price, NULL) as specials_new_products_price, IF((s.status and ((expires_date = '0000-00-00 00:00:00') or (expires_date >= '2013-06-17 23:12:51'))), s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id 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, categories c 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' and p2c.categories_id = c.categories_id and c.status_categ = '1' order by cd.categories_name, pd.products_name LIMIT -9999, 9999

[TEP STOP]

Sort Asending
Sort Desending
Name
Sort Asending
Sort Desending
Category
Sort Asending
Sort Desending
Model
Sort Asending
Sort Desending
Price