Time : 17:59:00 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION btocbto_jung.ROW_NUMBER does not exist Raw SQL : SELECT *, ROW_NUMBER() FROM totalweb_bbs WHERE code = 'board2' ORDER BY grp DESC, stp ASC LIMIT 0, 10 Time : 17:58:42 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM totalweb_bbs WHERE code = 'board2' ORDER BY grp DESC, stp ASC LIMIT 0, 10' at line 1 Raw SQL : SELECT *, ROW_NUMBER(), FROM totalweb_bbs WHERE code = 'board2' ORDER BY grp DESC, stp ASC LIMIT 0, 10 Time : 15:02:46 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 15:02:13 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 10:02:52 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'code' in on clause is ambiguous Raw SQL : SELECT *, SUBSTR(a.brandcode, 1, 6) as bcode, b.code, b.category_name as `name`, SUBSTR(c.code,1,6) as code, 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 bcode = code WHERE category LIKE '002%' ORDER BY a.wdate DESC LIMIT 0, 10 Time : 10:00:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.category_name' in 'field list' Raw SQL : SELECT *, SUBSTR(a.brandcode, 1, 6) as bcode, b.code as code, b.category_name as `name`, c.category_name as cate FROM totalweb_brand a LEFT OUTER JOIN totalweb_category b ON a.category = b.code WHERE category LIKE '002%' ORDER BY a.wdate DESC LIMIT 0, 10 Time : 10:00:15 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c.category_name as cate FROM totalweb_brand a LEFT OUTER JOIN totalweb_' at line 1 Raw SQL : SELECT *, SUBSTR(a.brandcode, 1, 6) as bcode, b.code as code, b.category_name as `name` c.category_name as cate FROM totalweb_brand a LEFT OUTER JOIN totalweb_category b ON a.category = b.code WHERE category LIKE '002%' ORDER BY a.wdate DESC LIMIT 0, 10 Time : 09:56:03 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'wdate' in order clause is ambiguous Raw SQL : SELECT *, b.code as code, b.category_name as `name` FROM totalweb_brand a LEFT OUTER JOIN totalweb_category b ON a.category = b.code WHERE category LIKE '002%' ORDER BY wdate DESC LIMIT 0, 10