Unknown column 'user' in 'where clause': SQL - SELECT cnt FROM alerts WHERE weeknum = '201010' AND prodtype='GlobalPowerMall' AND user='' AND reason='FREE'