1054 - Unknown column 'p.products_id' in 'on clause'
SELECT p.products_id, pd.products_name FROM products p, products_description pd left join products_status ps on (p.products_id = ps.products_id and ps.org_id = '0') WHERE p.products_id = pd.products_id AND ps.org_status = 1 AND pd.language_id = 1 ORDER BY pd.products_name