select * from piece a, theme_link b where a.piece_key=b.piece_key and b.PPID=284 order by a.pay, a.piece_key limit 0, 20