Time : 18:52:45 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 '">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')='nvOpzp; AND 1=1 OR (<'">iKO)),