MySQL Query : SELECT s.contentid,s.catid,s.title,s.url,s.areaid,s.thumb,s.description,s.listorder,s.authprice as lowestprice,s.isfinish,s.salenum,s.lxtype,s.status,s.typeid,p.ava_etime FROM cits_search_product as s LEFT JOIN cits_c_product as p on s.contentid=p.contentid WHERE ( MATCH(`somix`) AGAINST('+水舞' IN BOOLEAN MODE) OR title LIKE '%水舞間%' OR contentid IN(10325) ) and s.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') ORDER BY salenum DESC,listorder DESC LIMIT 20
MySQL Error : Column 'contentid' in where clause is ambiguous
MySQL Errno : 1052
Message : MySQL Query Error