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 s_id asc' at line 1
[SQL]select * from subject where 1=1 AND  ORDER BY s_id asc
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 s_id asc limit 0,20' at line 1
[SQL]select * from subject where 1=1 AND  ORDER BY s_id asc limit 0,20
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 'AND  ORDER BY s_id asc' at line 1
[SQL]select * from subject AND  ORDER BY s_id asc
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 'AND  ORDER BY s_id asc limit 0,20' at line 1
[SQL]select * from subject AND  ORDER BY s_id asc limit 0,20
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lft' in 'order clause'
[SQL]select * from subject where 1=1 ORDER BY lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lft' in 'order clause'
[SQL]select * from subject where 1=1 ORDER BY lft asc limit 0,10000
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]select * from bank where 1=1 ORDER BY s_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]select * from bank where 1=1 ORDER BY s_lft asc limit 0,10000
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]SELECT * FROM (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) T_ WHERE 1=1 ORDER BY s_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]SELECT * FROM (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) T_ WHERE 1=1 ORDER BY s_lft asc limit 0,10000
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]SELECT * FROM (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) T_ WHERE 1=1 ORDER BY s_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_lft' in 'order clause'
[SQL]SELECT * FROM (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) T_ WHERE 1=1 ORDER BY s_lft asc limit 0,10000
SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
[SQL]SELECT *,(SELECT count(1) FROM `` WHERE s_parent_id=s.`s_id`) children FROM `` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
[SQL]SELECT *,(SELECT count(1) FROM `` WHERE s_parent_id=s.`s_id`) children FROM `` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
[SQL]SELECT *,(SELECT count(1) FROM `` WHERE s_parent_id=s.`s_id`) children FROM `` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
[SQL]SELECT *,(SELECT count(1) FROM `` WHERE s_parent_id=s.`s_id`) children FROM `` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'money.s_id' doesn't exist
[SQL]SELECT * FROM s_id where 1=1 or s like '%aa%' limit 0,200
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'money.s_id' doesn't exist
[SQL]SELECT * FROM s_id where 1=1 or s like '%aa%' limit 0,200