1109 - Unknown table 'p' in field list

select count(p.properties_id) as total

[XT SQL Error]