1054 - Unbekanntes Tabellenfeld 'r.products_id' in on clause Details

select rd.reviews_text, r.reviews_rating, r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, p.products_id, pd.products_name, p.products_image from reviews r, reviews_description rd left join products p on (r.products_id = p.products_id) left join products_description pd on (p.products_id = pd.products_id and pd.language_id = '2') where r.reviews_id = '39' and r.reviews_id = rd.reviews_id and p.products_status = '1'

[OLC-SQL-Error] --> Forum

  Information ARRAY: $_SESSION:
array(11) { ["SESSION_USER_AGENT"]=> string(48) "CCBot/1.0 (+http://www.commoncrawl.org/bot.html)" ["SESSION_IP_ADDRESS"]=> string(13) "38.107.191.85" ["cart"]=> object(shoppingCart)#2 (4) { ["contents"]=> array(0) { } ["total"]=> int(0) ["weight"]=> int(0) ["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) "1" ["customers_status_payment_unallowed"]=> string(0) "" ["customers_status_shipping_unallowed"]=> string(0) "" ["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(13) "38.107.191.85" ["user_host"]=> string(13) "38.107.191.85" ["advertiser"]=> NULL ["referer_url"]=> NULL } ["account_type"]=> string(1) "0" ["actual_content"]=> array(1) { [""]=> array(1) { ["qty"]=> int(0) } } } ARRAY: $_REQUEST:
array(2) { ["products_id"]=> string(5) "14978" ["reviews_id"]=> string(2) "39" }