Invalid query : select *, CASE WHEN (dptrade3 != 0) THEN 'trade3' WHEN (dptrade3 = 0 AND dptrade2 != 0) THEN 'trade2' WHEN (dptrade3 = 0 AND dptrade2 = 0 AND dptrade != 0) THEN 'trade' ELSE 'notrade' END AS trade from draft_picks where dpsID = AND dpover = 0 order by dpno, dpslot asc