in:
[SELECT pd.products_name, p.products_image FROM products p left join products_description pd on p.products_id = pd.products_id WHERE p.products_status = 1 and p.products_id = 65454 and pd.language_id = 1 ]