Child to parent relationship queries and data sharing
121635
Does SOQL join not respect OWD /sharing settings?
148437
Relationships and Lazy Loading in SubSonic 3.0
16107
JOIN queries vs multiple queries
107260
What are the options for storing hierarchical data in a relational database?
37071
SOQL: Comparing two custom relationship fields in a nested query
138284
Are individual queries faster than joins?
24009
How do I bulkify queries for directly or indirectly related records?
92687
Join vs. sub-query
104128
SOQL Query of lookup relationship
80046
Entity Component System: system and components relation
18217
Does Foreign Key improve query performance?
40331
Optimizing a CTE hierarchy
92816
How do I find the child relationship name?
141510
Querying from Multiple Objects
65385
Determining child index in it's parent
37420
Restricting child/field access with security rules
71937
Get the name of a row's source table when querying the parent it inherits from