SELECT products_name as pName FROM `peoducts_description` WHERE products_id='334' AND language_id='1' LIMIT 1