Question: I need some help with an SQL query. Let me describe the scenario

I have three tables, `dispensaries`, `goods` and `products`.

`products` records has two `fk`, `good_id` and `dispensary_id` that let me access from dispensaries to goods through products.
Also goods has an attribute called `name`

Now the situation i wanna resolve is the following:

For a provided set of goods names (`[good_name1, good_name2, etc]`) i want to get all the dispensaries that has ALL the goods in the array ( the goods that matches with those names ).

Let me add an example:

```
 good1 whose names is  good_1 belongs to dispensary1
 good1 whose names is  good_1 belongs to dispensary2
 good2 whose names is  good_2 belongs to dispensary1

```

so i need to create an SQL query that with a provided array of goods `[good1, good2]` returns the only the `dispesary1`

Thanks in advance.

Answer: 
The short answer is you can't currently do this. (Somewhat by design, I believe.) I've requested that we remove that recommendation from our best practices for now.

That said, I do like the idea of having some a few mail-merge-like flags that you could insert into the invitation email so that you can add some nice personalization to your outbound messages. I've filed a feature request with the team, so we'll see what happens.
Firebase Invites does not send bulk messages, so it doesn't have a mail-merge like template system. Instead of that your app's code is involved with every message that is being sent, so you can customize it there. 

For more information in how to do that and an example of how to use it, see the documentation for [Android](https://firebase.google.com/docs/invites/android#customize-the-invitation) or [iOS](https://firebase.google.com/docs/invites/ios#customize-the-invitation).