SELECT ProductTypeJoinID,ProductIdentID,ProductName,PPERegCat FROM akeneo_productsx WHERE ProductLang = 'US' AND StyleCode = 'PS04'