INVALID SQL: 1104 : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
SQL QUERY FAILURE:SELECT DISTINCT EFV.fieldid FROM xcart_extra_field_values AS EFV LEFT JOIN xcart_extra_fields AS EF ON EF.fieldid = EFV.fieldid LEFT JOIN xcart_products_categories AS PC ON PC.productid = EFV.productid INNER JOIN xcart_products AS P ON P.productid = PC.productid AND P.forsale = 'Y' LEFT JOIN xcart_categories AS C ON C.categoryid = PC.categoryid WHERE EF.active = 'Y' AND EFV.value <> '' AND C.lpos BETWEEN 2644 AND 2869
Authorized Kramer Reseller Cables, Audio and Accessories. Highest Quality Products plus Full Warranty

Kramer

Kramer

About Kramer:

Our Mission Statement is: Kramer Electronics is committed to developing creative, reliable and value-oriented audio, video and computer signal processing solutions and distributing them worldwide with an uncompromising level of service and support. Following this philosophy guided us to celebrate our 28th anniversary in 2009, and by keeping our eyes on these goals we have successfully navigated often tumultuous industry waters throughout those 28 years. By continuing to follow this philosophy we will no doubt be successful for many years to come.

When our customers purchase our products, they know they are getting value for their money, with performance, reliability and quality. We have products in our line that have been in constant use for 20 years. We claim credit for technologies like automatic video noise gates, color processorscreen splitters, and high bandwidth CAT 5 products. We have pioneered powerful product lines like the ProScale™ Digital Scaler/Switchers that will endure for many years. All of these resulted from our insistence on uncompromising R&D and quality assurance at every step – from the actual invention, to the individual components used.

A personal connection with our customers is crucial to our success. We have offices all over the world able to serve the local market, with local support and expertise. Today, there are over one million Kramer Electronics products in use worldwide. Every two minutes, a Kramer product is sold somewhere around the world. Every product carries our personal guarantee and service commitment. Our team stands behind every product we sell – even years after it is installed. We now offer a seven-year warranty on all Kramer products, covering parts and labor.

Government, military, corporate, education, religion, transportation, hospitals, home cinema and retail markets rely on our technology every day. We enjoy these successes thanks both to the loyalty of our customers and to the Kramer customer commitment.

Our acquisition of Sierra Video in 2003 strengthened our leadership position, allowing us to bring more resources to our customers, and more complete solutions. Now we sit on the cusp of a migration to a digital world. There are more and more digital formats, and digital processing technologies pop up every day – DVI, HDMI, HDV, HD-SDI, SDI, MPEG and more. These technologies bring new challenges.

The world will keep changing. Kramer Electronics will master these challenges making the changes easier.

Connect with us

Join our community! Stay on top of all the latest technology, industry events, and consumer electronics content from around the web.

Sales & expert advice 1.888.660.2962

Live chat