fetching Item label attribute from the fusion base table

Hi,

I have been trying to generate a query which can fetch Item's attributes details(EFF) from fusion transaction DB using the below base table. Attached is the query. Now due to structure of the attribute table, we need to create alias of table for every attributes. Let’s say if we want to fetch 3 attributes column then we have to create 3 alias of the table and all of them will be outer joined to each other. This cost me so much time and it is taking forever.

Is there any other approach by which i can fetch those items attribute?