LEFT JOIN [dbo].[Translations] ts ON ts.TRA_PHRID = p.PHR_ID
                    LEFT JOIN [dbo].[Translations] td ON td.TRA_PHRID = p.PHR_ID AND td.TRA_CULID = (SELECT CUL_ID FROM [dbo].[Cultures] WHERE CUL_Code = @0) AND td.TRA_CUSID = 1
                    LEFT JOIN [dbo].[Translations] tc ON tc.TRA_PHRID = p.PHR_ID AND tc.TRA_CULID = (SELECT CUL_ID FROM [dbo].[Cultures] WHERE CUL_Code = @0)