select count(a.index_no) as cnt FROM shop_goods_search AS a LEFT JOIN shop_goods AS b ON a.gs_no=b.index_no where (mb_id='SC00006340' OR seller_code_dp='SC00006340') AND b.isopen = 1

1052 : Column 'mb_id' in where clause is ambiguous

error file : /shop/search.php