Paul Smeeton's Bitz for Bikes

Motorcycle Spares, Accessories and Clothing

Shopping Basket

including UK postage

  • Call 01706 344899
  • friend us on facebook
  • follow us on twitter
  • watch us on youtube
Live Support online

chat now

Kawasaki ()

Filter Results by:

Database : Jan 26 20:24:13 : Error in query: SELECT producttype.* FROM ( SELECT lvl0.ProdTypeID as ProdTypeID, lvl0.depth as depth, lvl1.ProdTypeID as id_1, lvl2.ProdTypeID as id_2, lvl3.ProdTypeID as id_3, lvl4.ProdTypeID as id_4, lvl5.ProdTypeID as id_5, concat_ws(",", cast(ifnull(lvl1.ProdTypeID, "") as CHAR), cast(ifnull(lvl2.ProdTypeID, "") as CHAR), cast(ifnull(lvl3.ProdTypeID, "") as CHAR), cast(ifnull(lvl4.ProdTypeID, "") as CHAR), cast(ifnull(lvl5.ProdTypeID, "") as CHAR)) as id_list, ifnull( elt(lvl0.depth - 1, cast(ifnull(lvl1.ProdTypeID, "") as CHAR), cast(ifnull(lvl2.ProdTypeID, "") as CHAR), cast(ifnull(lvl3.ProdTypeID, "") as CHAR), cast(ifnull(lvl4.ProdTypeID, "") as CHAR), cast(ifnull(lvl5.ProdTypeID, "") as CHAR) ), cast(lvl0.ProdTypeID as CHAR) ) as level2_id from bike_products left join products on products.id = product_id left join producttype as lvl0 on products.product_type_id = lvl0.ProdTypeID left join producttype as lvl1 on lvl0.parent = lvl1.ProdTypeID left join producttype as lvl2 on lvl1.parent = lvl2.ProdTypeID left join producttype as lvl3 on lvl2.parent = lvl3.ProdTypeID left join producttype as lvl4 on lvl3.parent = lvl4.ProdTypeID left join producttype as lvl5 on lvl4.parent = lvl5.ProdTypeID where bike_year_id = ) as level left join producttype on producttype.ProdTypeID = level.level2_id group by ProdTypeID : 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 ') as level left join producttype on producttype.ProdTypeID = level.level2_id ' at line 36
Database : Jan 26 20:24:13 : Error in query: SELECT * FROM ( SELECT products.*, concat_ws(",", "", cast(ifnull(lvl1.ProdTypeID, "") AS CHAR), cast(ifnull(lvl2.ProdTypeID, "") AS CHAR), cast(ifnull(lvl3.ProdTypeID, "") AS CHAR), cast(ifnull(lvl4.ProdTypeID, "") AS CHAR), cast(ifnull(lvl5.ProdTypeID, "") AS CHAR), "") AS cat_id_list FROM bike_products LEFT JOIN products ON products.id = product_id LEFT JOIN producttype AS lvl0 ON products.product_type_id = lvl0.ProdTypeID LEFT JOIN producttype AS lvl1 ON lvl0.parent = lvl1.ProdTypeID LEFT JOIN producttype AS lvl2 ON lvl1.parent = lvl2.ProdTypeID LEFT JOIN producttype AS lvl3 ON lvl2.parent = lvl3.ProdTypeID LEFT JOIN producttype AS lvl4 ON lvl3.parent = lvl4.ProdTypeID LEFT JOIN producttype AS lvl5 ON lvl4.parent = lvl5.ProdTypeID WHERE bike_year_id = AND in_stock != "D") AS products_ancestor_cats LEFT JOIN producttype ON ProdTypeID = product_type_id WHERE producttype.hidden = "no" ORDER BY ProdTypeName ASC : 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 'AND in_stock != "D") AS products_ancestor_cats LEFT JOIN producttype ' at line 17

Sorry, no products were found for this year.