</td></tr></table><b>Database error:</b> Invalid SQL: SELECT DISTINCT 
                    brand.brand_id, 
                    trim(brand.brand_name) brand_name, 
                    brl.descr brand_desc 
                FROM srv_a_brand brand

                LEFT JOIN srv_a_language brl 
                ON brl.table_id = 'srv_a_brand' and brl.table_pk_int = brand.brand_id 
                AND brl.language_id = 'en'

                WHERE lower(trim(brand.brand_name)) = lower(trim('CAFE' NOIR'))<br />
<b>PostgreSQL Error</b>: 1 (ERROR:  syntax error at or near "NOIR"
LINE 11: ...RE lower(trim(brand.brand_name)) = lower(trim('CAFE' NOIR'))
                                                                 ^)<br />
Session halted.