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 ('29') GROUP BY ID_ITEM ORDER BY MANUFACTURER ASC, MODEL ASC
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 4:17:56 AM
Script:/brand/american-harlequin
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 4:17:56 AM
Script:/brand/american-harlequin
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 ('29') GROUP BY ID_ITEM ORDER BY MANUFACTURER ASC, MODEL ASC
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 4:17:56 AM
Script:/brand/american-harlequin
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 4:17:56 AM
Script:/brand/american-harlequin
Used American Harlequin | Solaris

Used American Harlequin

Harlequin Floors is a world wide source of the finest dance floors and dance floor systems for the professional dancer and stage performer. With offices in London, Luxembourg, Philadelphia, Los Angeles, Ft. Worth and Sydney we provide the best quality dance flooring available. American Harlequin is based in the Philadelphia area, and serves both North and South America.

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