What does this error mean:

1109 Unknown table 'p' in field list
in:
[select count(p.products_id) as total ]


I get this when ever I click on a product to view it's details? How can I fix this?