Time : 20:32:26
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' at line 4
Raw SQL : SELECT *, b.code, b.category_name as `name`, c.code as code1, c.category_name as cate FROM totalweb_brand a
    LEFT OUTER JOIN totalweb_category b ON a.category = b.code
    LEFT OUTER JOIN totalweb_category c ON CONCAT(SUBSTR(a.brandcode, 1, 6),'000000') = c.code
    WHERE CONCAT(SUBSTR(brandcode, 1, 6),'000000')='