Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, MINIMUM_ORDER, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && EXTRA_VAR_3 IN ('1','2','3') && STATUSS IN ('FOR_SALE','BSTOCK') && registered_manufacturers.ID_REG_MANUF IN ('246') GROUP BY ID_ITEM ORDER BY MANUFACTURER ASC, MODEL ASC
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 2:59:38 PM
Script:/brand/professional-audio-systems
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 2:59:38 PM
Script:/brand/professional-audio-systems
Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, MINIMUM_ORDER, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && STATUSS IN ('FOR_SALE','BSTOCK') && registered_manufacturers.ID_REG_MANUF IN ('246') GROUP BY ID_ITEM ORDER BY MANUFACTURER ASC, MODEL ASC
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 2:59:38 PM
Script:/brand/professional-audio-systems
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 2:59:38 PM
Script:/brand/professional-audio-systems
Used Professional Audio Systems | Solaris

Used Professional Audio Systems

Professional Audio Systems (PAS) is celebrating its 25th year of designing and manufacturing technologically superior loudspeaker systems and components for the professional audio industry. In the early 1970s, Larry Doran, founder of PAS, saw a professional audio industry that was hungry for new ideas, particularly in the area of tour sound. Back then, most portable, high SPL sound reinforcement loudspeaker systems consisted of multi-box packages of separate Low Frequency, Mid-Bass, Mid-Range, ...

Featured Deals

Our Best Deals
View All

We Sell Brand New

Competitive Pricing
View All

Recently Added

Just Added or Updated
View All

Wanted

Serious Buyers for...
View All
View:

Newsletter Sign Up

Receive our Latest Deals
Sign Up Here

Can't Find it?

We can source it for you.
Tell Us What You Need

Category

Type




Price

$ to

Condition

Used Lighting Equipment Lighting Rentals