Time : 11:50:54
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 ''A=0' 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')=002003000000'A=0

Time : 11:50:54
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 ''A=0' at line 1
Raw SQL : SELECT count(*) FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002003000000'A=0

Time : 11:50:54
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 ''A=0 ORDER BY brandcode' at line 1
Raw SQL : SELECT * FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002003000000'A=0 ORDER BY brandcode