store_attribute | ActiveRecord extension | Web Framework library

I need to display a product with its price, and current stock (if any) of that product with a specific color and attributes. It does what it should, partially. This is the explanation of the query (or at least what it should be doing):

• Get basic information about the product from store_product
• A product has a stock. That stock is connected to a color ID, and an attribute detail ID.
• A product stock that's associated with a color ID can have multiple attribute detail IDs. So for example, a red shirt stock value from poliester material can be different than a red shirt stock value from M size.

For this particular example, i'm trying to receive the stock value for product ID 59 that meet these specific values

• id_color must be 1 (1 = red, which has a custom name called red deadpool)
• id_detail must be 4 in one row, and 50 in another row (4 = Size M / 50 = Material Poliester)

This is what i'm currently receiving:

The query is partially correct because:

• I'm getting 2 rows, one for each color/attribute combination
• I'm getting the correct id_stock ID for each row, and i'm also getting the correct stock value for the color/attribute combination.

The issue is that, although the stock information is correct, the id_attribute / attribute / id_detail / detail information is wrong.

This is what i would need to receive (i've marked the correction in bold):