SELECT xcart_products.productid, xcart_products.provider, xcart_products.productcode, xcart_products.avail, xcart_products.min_amount, xcart_products.list_price, xcart_products.distribution, xcart_products_lng_en.product, xcart_pricing.price, xcart_quick_prices.variantid, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_images_T.image_path, xcart_images_T.imageid, xcart_product_taxes.taxid FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' AND xcart_products.forsale='Y' INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_pricing.membershipid = '0' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND xcart_products.productcode LIKE 'KTN006%' GROUP BY xcart_products.productid ORDER BY xcart_products.productcodeSELECT ib_custom_options.productmodel, xcart_products.productid, xcart_products.provider, xcart_products.productcode, xcart_products.avail, xcart_products.min_amount, xcart_products.list_price, xcart_products.distribution, xcart_products_lng_en.product, xcart_pricing.price, xcart_quick_prices.variantid, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_images_T.image_path, xcart_images_T.imageid, xcart_product_taxes.taxid FROM xcart_product_links, ib_custom_options, xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.quantity = '1' AND xcart_products.forsale='Y' INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_pricing.membershipid = '0' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND xcart_products.productid = xcart_product_links.productid2 AND xcart_product_links.productid1 = '58465' AND ib_custom_options.productid = xcart_product_links.productid2 AND ib_custom_options.producttype != 'tires' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, rand() LIMIT 16
*Note: Our experts will contact you to verify precise fitment after you complete your order.
After you complete your purchase, one of our experts will contact you to verify proper fitment.
The vehicle information you provided will be saved.
WHEEL SPECS |
|
ITEM # |
KTN006-1 |
BRAND |
Katana Racing |
MODEL |
KR02 |
AVAILABLE SIZES |
17x7.5 |
BOLT PATTERN |
4x100 / 4x108 / 4x114 / 5x100 / 5x108 / 5x110 / 5x112 / 5x114 / 5x115 / 5x120 (According to Vehicle) |
OFFSET |
+40mm |
FINISH |
Gloss Silver |
CONDITION |
Brand New |
QUANTITY |
4 pcs (1 set) |
LUGS and LOCKS |
Not Included |
· Available custom color combinations (optional).
· Some vehicles may require additional modifications or parts.
· Wheels and Tires package (FREE Mount and Balance)