Honda MC18 NSR250
Upgrade your bike with TYGA Sprockets.
Designed and machined in house from super strong 7075 T6 aluminium, and then anodized in gold colour for superior corrosion and abrasion resistance.
Sprocket, Rear 41T, #520, Stock, Aluminium, (Gold), MC18 has been added to your Cart
1021 - Disk full (/var/tmp/#sql_7d74_12); 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 = '1071' order by p.products_sort_order , pd.products_name asc limit 0, 100
[TEP STOP]
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 = '1071' order by p.products_sort_order , pd.products_name asc limit 0, 100
[TEP STOP]