Darn, now I get the following error:

1054 Unknown column 'pd.products_description2' in 'field list'
in:
[SELECT p.products_weight, pd.products_description2 FROM zen_products p, zen_products_description pd WHERE p.products_id = 4 AND p.products_id = pd.products_id AND pd.language_id = '1' LIMIT 1]

What could I be missing?