Men Hiking Shoes Dark Grey

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