select a.* from shop_goods a left join shop_goods_type b on (a.index_no=b.it_id) where b.mb_id = 'lennyalice' and b.it_type2 = '1' order by a.index_no desc and (a.saccount > a.account and a.account > 0)

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 (a.saccount > a.account and a.account > 0)' at line 4

error file : /shop/module.php