1109 - Unknown table 'p' in field list

select count(p.products_id) as total order by p.products_sort_order, pd.products_name

[TEP STOP]