INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT COUNT(*) FROM xcart_sessions_data WHERE sessid='0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT sessid FROM xcart_sessions_data WHERE expiry < '1544451875'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT * FROM xcart_sessions_data WHERE sessid='0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:REPLACE INTO xcart_sessions_data (sessid, start, expiry, data) VALUES('0d45768e716a87ea4eb3b02f67461e58', '1544451875', '1544455475', 'a:1:{s:17:\"_saved_session_fg\";s:32:\"506a3e1ea419768f760541e2b7eaa9e4\";}')
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
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 = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
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:\"JNHHY\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"V44P5\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"PYZDL\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"CJ1II\";s:4:\"used\";s:1:\"N\";}}}' WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
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:\"JNHHY\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"V44P5\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"PYZDL\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"CJ1II\";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 = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:1:{s:11:\"search_data\";a:1:{s:8:\"products\";a:7:{s:10:\"categoryid\";i:212;s:23:\"search_in_subcategories\";s:0:\"\";s:13:\"category_main\";s:1:\"Y\";s:14:\"category_extra\";s:1:\"Y\";s:7:\"forsale\";s:1:\"Y\";s:10:\"sort_field\";s:7:\"orderby\";s:14:\"sort_direction\";i:0;}}}' WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:1:{s:11:\"search_data\";a:1:{s:8:\"products\";a:7:{s:12:\"add_page_url\";s:11:\"&featured=Y\";s:7:\"forsale\";s:1:\"Y\";s:14:\"sort_condition\";s:37:\"xcart_featured_products.product_order\";s:1:\"_\";a:1:{s:11:\"inner_joins\";a:1:{s:17:\"featured_products\";a:1:{s:2:\"on\";s:141:\"xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail=\'Y\' AND xcart_featured_products.categoryid=\'212\'\";}}}s:10:\"sort_field\";s:7:\"orderby\";s:14:\"sort_direction\";i:0;s:4:\"page\";i:1;}}}' WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
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:\"JNHHY\";s:4:\"used\";s:1:\"N\";}s:8:\"on_login\";a:2:{s:4:\"code\";s:5:\"V44P5\";s:4:\"used\";s:1:\"N\";}s:10:\"on_reviews\";a:2:{s:4:\"code\";s:5:\"PYZDL\";s:4:\"used\";s:1:\"N\";}s:13:\"on_news_panel\";a:2:{s:4:\"code\";s:5:\"CJ1II\";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\";a:1:{s:8:\"products\";N;}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 = '0d45768e716a87ea4eb3b02f67461e58'
Clearance Items :: ALPHA Sound & Lighting Co.
Phone Number: 1-800-523-8195

Clearance Items

Clearance Items

For a complete list of available clearance items download the ALPHA Sound & Lighting, Co. Clearance Stock pdf.
This list is updated frequently, so check back often for some great deals!

All items from our Clearance Stock are guaranteed to be in working condition. These items can be new units that have been discontinued from a manufacturer, open box items, out of box items, returned units, demo units, rental stock, or just plain old!

Clearance Stock is available in limited quantities, first come, first served.

To place an order for an item on the list, or to inquire on the condition of any of the items, call us at (800) 523-8195.

Brands

 
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:SELECT data FROM xcart_sessions_data WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'
INVALID SQL: 144 : Table './xcart/xcart_sessions_data' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data = 'a:5:{s:12:\"stats_pageid\";s:4:\"1230\";s:15:\"stats_page_time\";i:1544451877;s:18:\"stats_pages_string\";s:4:\"1230\";s:19:\"stats_transactionid\";s:0:\"\";s:22:\"stats_transaction_step\";s:0:\"\";}' WHERE sessid = '0d45768e716a87ea4eb3b02f67461e58'