select * from students where state in ( 1, 2 ) order by state, bosyu desc, sno desc LIMIT 20 OFFSET 0
↑