Categories

The make, model, year finder located below can be used with as little as one selection made. It is not necessary to populate all of the drop downs for filtering of products within this section. 

Payment methods

  1. Aprilia
  2. Beta
  3. Honda
  4. Kawasaki
  5. Suzuki
  6. Universal
  7. Yamaha
Shop By
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10798, 83674, 11004, 83675, 11080, 83676, 20822, 83678, 385, 20836, 83679, 5804, 20837, 83680, 5805, 76473, 83682, 5806, 76474, 5808, 77249, 5809, 77250, 6688, 82915, 6689, 82916, 6690, 82917, 6694, 82918, 7384, 83672, 10776, 83673)) AND (t_d.attribute_id IN (71, 86, 87, 97, 112, 113, 114, 119, 226, 243, 293, 376, 394, 396, 430, 431, 432, 433, 472, 493, 533, 565, 636, 652, 653, 669)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10798, 83674, 11004, 83675, 11080, 83676, 20822, 83678, 385, 20836, 83679, 5804, 20837, 83680, 5805, 76473, 83682, 5806, 76474, 5808, 77249, 5809, 77250, 6688, 82915, 6689, 82916, 6690, 82917, 6694, 82918, 7384, 83672, 10776, 83673)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10798, 83674, 11004, 83675, 11080, 83676, 20822, 83678, 385, 20836, 83679, 5804, 20837, 83680, 5805, 76473, 83682, 5806, 76474, 5808, 77249, 5809, 77250, 6688, 82915, 6689, 82916, 6690, 82917, 6694, 82918, 7384, 83672, 10776, 83673)) AND (t_d.attribute_id IN (76, 120)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10798, 83674, 11004, 83675, 11080, 83676, 20822, 83678, 385, 20836, 83679, 5804, 20837, 83680, 5805, 76473, 83682, 5806, 76474, 5808, 77249, 5809, 77250, 6688, 82915, 6689, 82916, 6690, 82917, 6694, 82918, 7384, 83672, 10776, 83673)) AND (t_d.attribute_id IN (77, 78)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (10798, 83674, 11004, 83675, 11080, 83676, 20822, 83678, 385, 20836, 83679, 5804, 20837, 83680, 5805, 76473, 83682, 5806, 76474, 5808, 77249, 5809, 77250, 6688, 82915, 6689, 82916, 6690, 82917, 6694, 82918, 7384, 83672, 10776, 83673)) AND (t_d.attribute_id IN (92, 96, 124, 126, 127, 128, 129, 132, 219, 221, 222, 223, 224, 234, 235, 237, 241, 242, 250, 251, 252, 253, 254, 259, 269, 292, 296, 300, 301, 324, 328, 329, 355, 356, 368, 370, 372, 377, 395, 397, 414, 415, 435, 436, 437, 439, 440, 441, 476, 492, 503, 506, 515, 516, 517, 525, 526, 547, 548, 550, 635)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))