Error
Database Error: Illegal mix of collations for operation 'concat'
SQL:
SELECT SQL_CALC_FOUND_ROWS CONCAT('
<table style="width:700px">
<tr>
<td colspan="2">
',IF(url IS NULL,'',CONCAT('
<a target="_blank" href="',url,'" style="text-decoration:none">
')),'
<h3>',name,'</h3>
',IF(url IS NULL,'',CONCAT('
</a>
')),'
</td>
</tr>
<tr>
<td colspan="2">
<span class="display">Company:</span> <a target="_blank" href="public/viewExhibitorProfile.php?__id=',exhibitors.__id,'">',company_name,'</a>',IF(booth_num IS NULL,'',CONCAT(', Booth: ',booth_num,'')),'
</td>
</tr>
<tr style="vertical-align:top">
',IF(image1 IS NULL,'',CONCAT('
<td style="padding-right:10px">
',IF(url IS NULL,'',CONCAT('
<a target="_blank" href="',url,'">
')),'
<img alt="',name,'" src="',image1,'" border="0" />
',IF(url IS NULL,'',CONCAT('
</a>
')),'
</td>
')),'
<td style="width:70%">
',REPLACE(exhibitor_products.description,'
','<br/>'),'
',IF(url IS NULL,'',CONCAT('
<div style="margin-top:10px;">
<a target="_blank" href="',url,'">More Information</a>
</div>
')),'
</td>
</tr>
',IF(price IS NULL,'',CONCAT('
<tr>
<td colspan="2">
<span class="display">Price:</span> $',price,'
</td>
</tr>
')),'
',IF(exhibitor_products.categories IS NULL,'',CONCAT('
<tr>
<td colspan="2">
<span class="display">Related Categories:</span> ',REPLACE(REPLACE(exhibitor_products.categories,'\\,',', '),',',', '),'
</td>
</tr>
')),'
</table>
') AS 'Product Preview' FROM ge_hdaw_exhibitor_products as exhibitor_products,ge_hdaw_exhibitors as exhibitors WHERE exhibitors.contact_id=exhibitor_products.contact_id ORDER BY showcase_product DESC, IF(image1 IS NULL,'0','1') DESC, exhibitor_products.__inserted_on ASC LIMIT 0, 20