crowerperformance.com
Crower Performance, LLC •
42387 Avenida Alvarado #112
Temecula Ca, 92590 •
951-296-9669
Email: dan@crowerperformance.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. |
|
 |
|
|
 |
Name |
|
|
Description |
|
|
Category |
|
|
Price |
|
|
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 'show' 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, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, p.products_date_added, IF(s.status = 1, s.specials_new_products_price, NULL) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd left join products_groups pg on pg.products_id = pd.products_id and pg.customers_group_id = '0', products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id and s.customers_group_id = '0', products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_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 cd.categories_name, pd.products_name LIMIT 0, show
[TEP STOP]
| | | |
CAMSHAFT REGRINDING
PISTONS
