-----BEGIN PUBLIC KEY-----
MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAnfVpAAWl7OLR+bGj0VGV
9bYrkka/kravINeE0PBOD/ZjUjtfjqzZ258tvnnjV8MT9z66nOgCsNy027OxznbT
oovkCX5LHCBbqHIV4ytjQz5mrsKvAnPmwgh4BWj5h02rcRjQ3HeLkmczTzxzqDIa
fbJdmVt5s7KIq8/dBUNLqo5k8gFydtHqZuIehPIOtvYHd/wY2kaUyH0WF305iWkP
8bABiPYSKLz9WsBqUPu7NhZCojDAsfRohYVxHy/bOtas93cO6z2NI6eCiZwuBREs
pNxDuEtuqj1l9+2s4ecORjKSBb/Lc4+wFxLDa23frUMtrZiAfTrHD79vwssDsToF
IBVR/6yZp1ex9ljY/wDRDaTcYk5bcKVrsmseUvtcQ8HQdG/XR07dcU6Jr7/xpyLA
w8+M1fO4vP5vRQhH2b0lG3bJlxgFGs62LJzHscP7RZvcMRCeoDcyrrimk2FvOIiy
xKwTfnHQDcGKeWctBcn186AyTMk8YC9AMspA3eU/cmnlxtm9GrAfqEIbNp/6Bi2v
TqtHlTVb0nHXHV1q0Mz1oHRgTyXeRp0tjTcmuYUxFOaPh6GptoHbQv2hAODiuiji
1mJvU2MCY2u29qe/ZJv5J7l8PCDfTf+kQP0LKSPTNZNrMiYZDEqfSArAS2wCg36p
ykB8fCurdgX9OWB5mGY4CR8CAwEAAQ==
-----END PUBLIC KEY-----
2021-01-16T01:02:53+00:00
- Uid
-
937c2ebb50839e6e
- Nickname
-
rabuzarus
- Full_name
-
Rabuzarus
- Searchable
-
true
- First_name
-
Rabuzarus
- Family_name
-
- Url
-
https://friendica.kommune4.de/
- Photo
-
- Photo_medium
-
- Photo_small
-
Rabuzarus
Michael Vogel
Rabuzarus
Nearly everywhere where we deal with items. /mod/profile, /mod/display, /mod/network, /mod/notes, /mod/search and /mod/community
I haven't looked in these files. Instead I try to think about the question in which cases it would make sense to filter pending contacts. But no use case comes to my mind (as long as friendica doesn't get items which it shouldn't have because of its actual state of the connection -> meaning no established friendship connection).
Michael Vogel
Rabuzarus
so the query would be
AND NOT (`contact`.`blocked` AND NOT `contact`.`pending`)
Am I right?