MySQL Query : SELECT COUNT(*) AS count FROM cits_search_product as s left join cits_c_product p on s.contentid=p.contentid WHERE catid=68 AND status=99 AND avadate LIKE '%2009-%' AND p.isfinish=0 AND (DATE_ADD(p.ava_etime,INTERVAL 1 DAY)>now() or p.ava_etime='0000-00-00') AND (DATE_ADD(p.avadate,INTERVAL 1 DAY)>now() or p.avadate='0000-00-00')
MySQL Error : Column 'avadate' in where clause is ambiguous
MySQL Errno : 1052
Message : MySQL Query Error