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.gpoint > 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.gpoint > 0' at line 4

error file : /shop/module.php