MySQL Query : select sino_bid_palo.id,sino_bid_palo.title,sino_bid_palo.thumbs,sino_bid_palo.cur_price,sino_bid_palo.userid,sino_bid_palo.enddate,sino_bid_palo.hits,count(sino_bid.id) as total from sino_bid_palo left outer join sino_bid on sino_bid_palo.id = sino_bid.paloid where sino_bid_palo.userid=42867 and flag=1 group by sino_bid_palo.id limit 4
MySQL Error : Column 'flag' in where clause is ambiguous
MySQL Errno : 1052
Message : MySQL Query Error