Buy Used Colorsun 200S by Ayrton

Looking for a used, new, second-hand or ex-hire Colorsun 200S? We may be able to help. Click here to see if we can help you find it.

Brand Ayrton
Category Moving Lights
Family/Series
Model #

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, 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') && items.ID_REG_MODEL = '9694' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'NEW','FOR_SALE','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','9','0'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 40
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
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, 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') && items.ID_REG_MODEL = '9694' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'NEW','FOR_SALE','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','9','0'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 40
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s

Browse all Moving Lights from Ayrton

Newsletter Sign Up

Receive our Latest Deals
Sign Up Here

Featured Deals

Our Best Deals
View All

Can't Find it?

We can source it for you.
Tell Us What You Need
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, 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 && items.CATEGORY_MAIN = 64 && STATUSS IN ('FOR_SALE','BSTOCK') && items.CATEGORY_MAIN = '64' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'FOR_SALE','NEW','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','0','9'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 8
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
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, 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') GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'FOR_SALE','NEW','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','0','9'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 8
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Thursday, November 23, 2017 at 7:09:25 PM
Script:/products/ayrton/colorsun-200s

Ayrton | Solaris

Used Lighting Equipment Lighting Rentals