INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_sessions_data WHERE sessid='f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT sessid FROM xcart_sessions_data WHERE expiry < '1472499919'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT * FROM xcart_sessions_data WHERE sessid='f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:REPLACE INTO xcart_sessions_data (sessid, start, expiry, data) VALUES('f509e87e2eaa4805e8c05a82b68ed73e', '1472499919', '1472503519', 'a:1:{s:17:\"_saved_session_fg\";s:32:\"c4ce282ba646690265c3201d3e318e0e\";}')
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:2:{s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}}' WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:1:{s:22:\"antibot_validation_val\";a:4:{s:13:\"on_contact_us\";a:2:{s:4:\"code\";s:5:\"97794\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"98117\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"92717\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"53696\";s:4:\"used\";s:1:\"N\";}}}' WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_temporary_data' doesn't exist
SQL QUERY FAILURE:DELETE FROM xcart_temporary_data WHERE expire < 1472499919
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:25:{s:14:\"is_new_session\";b:1;s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:22:\"antibot_validation_val\";a:4:{s:13:\"on_contact_us\";a:2:{s:4:\"code\";s:5:\"97794\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"98117\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"92717\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"53696\";s:4:\"used\";s:1:\"N\";}}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:11:\"search_data\";s:0:\"\";s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:11:\"identifiers\";a:0:{}s:6:\"logged\";s:0:\"\";s:14:\"remember_login\";b:0;s:13:\"remember_data\";s:0:\"\";s:14:\"_remember_vars\";s:0:\"\";}' WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
Warning: Cannot modify header information - headers already sent by (output started at /home/civicun/public_html/include/func/func.db.php:207) in /home/civicun/public_html/include/get_language.php on line 155
Warning: Cannot modify header information - headers already sent by (output started at /home/civicun/public_html/include/func/func.db.php:207) in /home/civicun/public_html/include/func/func.core.php on line 1920
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_states' doesn't exist
SQL QUERY FAILURE:SELECT state FROM xcart_states WHERE country_code='US' AND code='CA'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_taxes' doesn't exist
SQL QUERY FAILURE:SELECT xcart_taxes.*, xcart_product_taxes.productid FROM xcart_taxes, xcart_product_taxes WHERE xcart_taxes.taxid=xcart_product_taxes.taxid AND xcart_product_taxes.productid IN ('677') AND xcart_taxes.active='Y' ORDER BY xcart_taxes.priority
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_variants' doesn't exist
SQL QUERY FAILURE:SELECT xcart_variants.*, MIN(xcart_pricing.price) as price, xcart_images_W.image_path as image_path_W, xcart_images_W.image_x as image_W_x, xcart_images_W.image_y as image_W_y, xcart_images_W.image_type as image_type_W FROM xcart_variants USE INDEX (productid) LEFT JOIN xcart_pricing ON xcart_variants.productid = xcart_pricing.productid AND xcart_pricing.variantid = xcart_variants.variantid AND xcart_pricing.membershipid = '0' AND xcart_pricing.quantity = '1' LEFT JOIN xcart_images_W ON xcart_images_W.id = xcart_variants.variantid WHERE xcart_variants.productid = '677' GROUP BY xcart_variants.variantid
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_variants' doesn't exist
SQL QUERY FAILURE:SELECT xcart_products.productid, xcart_products.provider, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, 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, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_product_taxes.taxid FROM xcart_product_links, xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' 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_product_taxes ON xcart_product_taxes.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' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' 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 = '677' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, product
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_variants' doesn't exist
SQL QUERY FAILURE:SELECT xcart_products.productid, xcart_products.provider, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, 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, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_product_taxes.taxid FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' 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_product_taxes ON xcart_product_taxes.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' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '0' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '0' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND xcart_products.productid IN ('1101','610','642','165','633','121','507','1028','923','479') GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby LIMIT 10
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_variants' doesn't exist
SQL QUERY FAILURE:SELECT xcart_products.productid, xcart_products.provider, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, 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, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_product_taxes.taxid FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' 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_product_taxes ON xcart_product_taxes.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' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND xcart_products_categories.categoryid IN ('25') AND xcart_products.sales_stats >= '0' GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
INVALID SQL: 1146 : Table 'civicun_xcart.xcart_sessions_data' doesn't exist
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:30:{s:14:\"is_new_session\";b:1;s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:22:\"antibot_validation_val\";a:4:{s:13:\"on_contact_us\";a:2:{s:4:\"code\";s:5:\"97794\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"98117\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"92717\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"53696\";s:4:\"used\";s:1:\"N\";}}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:11:\"search_data\";s:0:\"\";s:22:\"https_redirect_counter\";i:0;s:24:\"https_redirect_forbidden\";b:0;s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:11:\"identifiers\";a:0:{}s:6:\"logged\";s:0:\"\";s:14:\"remember_login\";b:0;s:13:\"remember_data\";s:0:\"\";s:14:\"_remember_vars\";s:0:\"\";s:7:\"old_lng\";s:0:\"\";s:20:\"is_switched_language\";s:0:\"\";s:4:\"cart\";s:0:\"\";s:23:\"require_change_password\";s:0:\"\";s:16:\"login_antibot_on\";s:0:\"\";}' WHERE sessid = 'f509e87e2eaa4805e8c05a82b68ed73e'
93-97 Honda Civic 1 Piece Crystal Headlights JDM Black Amber :: Civic Crystal Headlights :: Lighting :: 5th Gen Civic (92-95) :: Civic United

93-97 Honda Civic 1 Piece Crystal Headlights JDM Black Amber

93-97 Honda Civic 1 Piece Crystal Headlights JDM Black Amber

93-97 Honda Civic 1 Piece Crystal Headlights JDM Black Amber

SKU LCLH-DEL93AMJM1PC
Market price: $220.00
Our price: $169.00
Quantity Out of stock


Have Questions? Call us at 877-813-5337.

This is a pair of Black housing 1-Piece Crystal Headlights with Amber Corner Lights for 1993-1997 Honda Civic . These 1993-1997 Honda Civic Del-Sol crystal headlights come with crystal design which gives your Honda Civic Del-Sol a sporty JDM look. Package comes with left and right side headlights for direct replacement. Professional Installation is highly recommended.Bulb Size:Low H4


Dash Z Racing