Time : 16:52:31 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 '(SUBSTR(code, 1, 6),'000000') = '001002000000' AND code NOT LIKE '%000000' AN...' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001002000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 16:52:28 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 '(SUBSTR(code, 1, 6),'000000') = '001001000000' AND code NOT LIKE '%000000' AN...' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001001000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 03:19:41 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 ''nvOpzp; AND 1=1 OR (<'">iKO)),' 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'nvOpzp; AND 1=1 OR (<'">iKO)), Time : 03:19:41 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 ''nvOpzp; AND 1=1 OR (<'">iKO)),' at line 1 Raw SQL : SELECT * FROM totalweb_brand WHERE brandcode=20040010000001'nvOpzp; AND 1=1 OR (<'">iKO)), Time : 03:19:41 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 ''nvOpzp; AND 1=1 OR (<'">iKO)),' at line 1 Raw SQL : SELECT count(*) FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002003000000'nvOpzp; AND 1=1 OR (<'">iKO)), Time : 03:19:41 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 ''nvOpzp; AND 1=1 OR (<'">iKO)), ORDER BY brandcode' at line 1 Raw SQL : SELECT * FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002003000000'nvOpzp; AND 1=1 OR (<'">iKO)), ORDER BY brandcode