1054 - Unknown column 'pd.products_id' in 'where clause'

select count(distinct p.products_id) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join inventory i on p.products_id=i.products_id left join posim_items pi on i.products_barcode=pi.ItemId, products_to_categories p2c where p.products_status = '1' and p.new_arrival=1 and p.products_date_added >= '2013-04-22' and Available>0 and i.status=1 and WebPrice is not null and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p2c.categories_id not in (305,367,370,365,307,308,309,327,306,368,369,371,372,301,302,303,304,313,314,321,310)

[TEP STOP]