select a.* from shop_goods a left join shop_goods_type b on (a.index_no=b.it_id) where b.mb_id = 'bany' and b. = '1' order by a.index_no desc

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 '= '1' order by a.index_no desc' at line 4

error file : /shop/module.php