Database Error

query log: Property:getTypeOptions, Property:getAreaOptions, Property:getPropertyCount, Property:getFeatured, Property:getLocationOptions, Property:getTypeOptions

mysql error: SELECT ptid, ptname_en, ptcname_en, ptcid FROM lkp_property_type, lkp_property_type_class LEFT JOIN properties_opp ON type = ptid WHERE class = ptcid AND propertyid IS NOT NULL GROUP BY ptid ORDER BY ptcname_en ASC, ptname_en ASC [nativecode=1054 ** Unknown column 'ptid' in 'on clause']

PEAR::DB error: DB Error: no such field