1054 - Unknown column 'f.status' in 'where clause'

select count(p.products_id) as total from products_description pd, products p left join specials_retail_prices srp on p.products_id = srp.products_id left join products_authors a on p.authors_id = a.authors_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id where ( p.parent_1 = 10000303 OR p.parent_2 = 10000303 OR p.parent_3 = 10000303 OR p.parent_4 = 10000303 OR p.parent_5 = 10000303 ) and pd.products_id = p.products_id and pd.language_id = '1' and p.parent_1 = '10000306' and 1=1 and f.status = 1 and m.manufacturers_id = 4000032

[TEP STOP]