Question: I'm really, really struggling with what should otherwise be a straightforward query in anything other than LINQ (for example SQL!)

I have two entities:

```
Product
ProductApprover

```

The Product entity has a one to many relationship on the ProductApprover entity, e.g:

Product.ProductApprovers gives me all ProductApprover entities relating to the Product.

Getting a Product and associated ProductApprover data is simple enough when querying by my ProductID column on my Product entity as the ProductApprover data associated is bundled into the result automatically, but my problem comes when I want to alter my query by querying data WITHIN my associated ProductApprover entities. I have tried all sorts with use of the 'Where', 'Contains' and 'Any', functions, etc, to perform a subquery, but cannot seem to get the result I want.

The query I want to perform is:

```
SELECT * FROM Product p
INNER JOIN ProductApprover pa ON p.ProductId = pa.ProductId
WHERE p.ProductId = @id AND pa.Version = @version

```

Can anybody help me out please? Thank you kindly in advance.

Answer: 
```
fill="#044B9466"

```

This is an [RGBA color](https://en.wikipedia.org/wiki/RGBA_color_space) in hex notation inside the SVG, defined with hex values. This is valid, but not all programs can display it properly...

You can find the browser support for this syntax here: <https://caniuse.com/#feat=css-rrggbbaa>

As of August 2017: RGBA fill colors will display properly on Mozilla Firefox (54), Apple Safari (10.1) and Mac OS X Finder's "Quick View". However Google Chrome did not support this syntax until version 62 (was previously supported from version 54 with the Experimental Platform Features flag enabled).

As of April 2021, [Inkscape](https://inkscape.org/) version 1.0.2 cannot read this format in SVG files, and instead converts any RGBA color to opaque black. The bug report is here: <https://gitlab.com/inkscape/inbox/-/issues/1195>
I am sharing a related tip that you might come across when you want the SVG to inherit the container's styles like normal state, hover state and visited state :
use fill='currentColor' on the path. This is how the SVG's produced by font awesome icons could take any fore color applied to fonts!