In this category, hopefully you will find some bargain parts for your project build. Some of these parts have come off our project bikes and have done very little work and are now surplus to requirements. Others, we picked up along the way or took off bikes and have no further use for. Condition is described as accurately as we can but used parts by their very nature may have the odd blemish and we can not accept returns due to the expense of international shipping. Happy shopping!
1021 - Disk full (/var/tmp/#sql_678_1); waiting for someone to free some space...
select p.sold_in_bundle_only, p.products_image, p.products_quantity, p.products_model, pd.products_name, p.products_sort_order, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c 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 p2c.categories_id = '1185' order by p.products_sort_order, pd.products_name limit 0, 45