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 'WW141%' 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 = '57447' 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
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 # |
WW141-3 |
BRAND |
LA Wire |
AVAILABLE SIZES |
14x7 |
OFFSET |
Reverse |
BACK SPACING |
43mm |
SPOKE |
100 Spoke |
SPOKE STYLE |
Straight Lace |
BOLT PATTERN |
4x100 / 4x108 / 4x114 5x100 / 5x112 / 5x114 / 5x115 / 5x120 / 5x127 6x135 / 6x139 (According to Vehicle) |
FINISH |
Chrome with Hot Pink Spoke or Chrome with Any Custom Color Spoke |
ACCESSORIES |
Full Set Included (4 Adapters, 4 Knock-Offs, 1 Wrench or 1 Lead Hammer) |
CONDITION |
Brand New |
QUANTITY |
4 pcs (1 set) |
AVAILABLE CUSTOM FINISH PARTS |
Spoke / Nipple / Knock Off (Spinner) / Hub / Outer * Gold Plating & Custom Coloring Available (Optional) * Please give us call for detail & price |
Available custom color combinations (optional).
Some vehicles may require additional modifications or parts.
Wheels and Tires package (FREE Mount and Balance)