I have two tables: `Objects` and `Properties`. Each object has some number of properties. This data is stored in a separate table `ObjectProperty`:

![dbSampleImages.jpg](/image?hash=4383a09c40b50c6538a4238257441ef034cbed10cbf04bb4c4e03149877b9f7f)

I want to collect full information about objects (`id`, `name`, and all its properties as well) by a given `value` of a property.

Sample:

<>https://dbfiddle.uk/?rdbms=sqlite_3.27&fiddle=014ebf64d5a99d834a12f5369deab0b7


I was able to write a query that returns data but I'm puzzled with applying a filter separately to each "group" of rows that describes one object.

For example, for `Property1` expected output will be:

```
Id	Name	pId	Value
1	Object1	1	Property1
1	Object1	2	Property2
1	Object1	3	Property3
2	Object2	1	Property1
2	Object2	4	Property4
2	Object2	5	Property5
4	Object4	1	Property1
4	Object4	4	Property4
4	Object4	5	Property5
```

and for `Property6`


```
Id	Name	pId	Value
3	Object3	2	Property2
3	Object3	6	Property6
```