1054 - Unbekanntes Tabellenfeld 'p.manufacturers_id' in on clause Details

select count(distinct p.products_id) as total from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by p.products_date_added DESC

[OLC-SQL-Error] --> Forum

  Information ARRAY: $_SESSION:
array(9) { ["cart"]=> object(shoppingCart)#2 (5) { ["contents"]=> array(0) { } ["total"]=> int(0) ["weight"]=> int(0) ["cartID"]=> NULL ["content_type"]=> bool(false) } ["language"]=> string(6) "german" ["languages_id"]=> string(1) "2" ["language_charset"]=> string(11) "iso-8859-15" ["currency"]=> string(3) "EUR" ["customers_status"]=> array(16) { ["customers_status_id"]=> string(1) "1" ["customers_status_name"]=> string(4) "Gast" ["customers_status_image"]=> string(16) "guest_status.gif" ["customers_status_discount"]=> string(4) "0.00" ["customers_status_public"]=> string(1) "1" ["customers_status_ot_discount_flag"]=> string(1) "0" ["customers_status_ot_discount"]=> string(4) "0.00" ["customers_status_graduated_prices"]=> string(1) "0" ["customers_status_show_price"]=> string(1) "1" ["customers_status_show_price_tax"]=> string(1) "1" ["customers_status_add_tax_ot"]=> string(1) "0" ["customers_status_payment_unallowed"]=> string(12) "banktransfer" ["customers_status_shipping_unallowed"]=> string(10) "selfpickup" ["customers_status_discount_attributes"]=> string(1) "0" ["customers_fsk18"]=> string(1) "1" ["customers_fsk18_display"]=> string(1) "1" } ["user_info"]=> array(4) { ["user_ip"]=> string(14) "38.107.191.115" ["user_host"]=> string(14) "38.107.191.115" ["advertiser"]=> NULL ["referer_url"]=> NULL } ["account_type"]=> string(1) "0" ["actual_content"]=> array(1) { [""]=> array(1) { ["qty"]=> int(0) } } } ARRAY: $_REQUEST:
array(2) { ["OLCsid"]=> string(32) "b71a4536c7b6521a411f9ca2ac264923" ["cookie_test"]=> string(25) "please_accept_for_session" }