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 'order by id desc' at line 1
[SQL]select count(*) from jqgrid where 1=1 ORDER BY order by id desc
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 'order by id desc limit 0,40' at line 1
[SQL]select * from jqgrid where 1=1 ORDER BY order by id desc limit 0,40
SQLSTATE[42000]: Syntax error or access violation: 1248 Every derived table must have its own alias
[SQL]select name from (select * from jqgrid where 1=1) where id=1 limit 0,1
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'
[SQL]select name from (select * from product_cate where 1=1) t_ where id=1 limit 0,1
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select count(*) from product_cate where 1=1 ORDER BY id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select * from product_cate where 1=1 ORDER BY id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select count(*) from product_cate where 1=1 ORDER BY id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select * from product_cate where 1=1 ORDER BY id asc limit 0,40
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 (select * from product_cate where 1=1) t_ where pc_id='2' limit 0,1' at line 1
[SQL]select  from (select * from product_cate where 1=1) t_ where pc_id='2' limit 0,1
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]UPDATE product_cate SET pc_parent_id = '2' WHERE id=2
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 'WHERE' at line 1
[SQL]UPDATE product_cate SET  WHERE 
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 '' at line 1
[SQL]UPDATE product_cate SET Array = 'pc_id=2' WHERE 
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause'
[SQL]UPDATE product_cate SET pc_parent_id = '6' WHERE Array
SQLSTATE[HY000]: General error: 1364 Field 'pc_name' doesn't have a default value
[SQL]INSERT INTO product_cate () VALUES ()
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select count(*) from product_cate where 1=1 ORDER BY id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select * from product_cate where 1=1 ORDER BY id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select count(*) from product_cate where 1=1 ORDER BY id desc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause'
[SQL]select * from product_cate where 1=1 ORDER BY id desc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select count(*) from product_cate where 1=1 AND id like '%1%' ORDER BY pc_id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select * from product_cate where 1=1 AND id like '%1%' ORDER BY pc_id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select count(*) from product_cate where 1=1 AND id like '%1%' ORDER BY pc_id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select * from product_cate where 1=1 AND id like '%1%' ORDER BY pc_id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select count(*) from product_cate where 1=1 AND id like '%2%' ORDER BY pc_id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause'
[SQL]select * from product_cate where 1=1 AND id like '%2%' ORDER BY pc_id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pc_id' in 'order clause'
[SQL]select count(*) from product where 1=1 ORDER BY pc_id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pc_id' in 'order clause'
[SQL]select * from product where 1=1 ORDER BY pc_id asc limit 0,40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p_parent' in 'where clause'
[SQL]select count(*) from product where p_parent=0 ORDER BY p_id asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p_parent' in 'where clause'
[SQL]select * from product where p_parent=0 ORDER BY p_id asc limit 0,40