An Error Was Encountered

Error Number: 1054

Unknown column 'p.nfx' in 'where clause'

SELECT p.name pname ,p.price pprice ,p.expires pexpires ,p.packageid ppackageid ,p.description pdescription ,p.capperid pcapperid ,c.bname cname ,c.image cimage ,pcount.cpicks FROM packages as p join cappers c on c.capperid = p.capperid join (select count(*) cpicks,packageid,capperid from links where gamedate = curdate() group by packageid,capperid) pcount on (pcount.packageid = p.packageid and p.capperid = pcount.capperid) where p.packageid in (select distinct packageid from links where gamedate = curdate()) and p.expires = 1 and p.nfx = 1 order by p.expires desc, p.name