package Ġio . h azel net . community . persistence Ċ Ċ import Ġio . h azel net . community . data . claim . Claim List Ċ import Ġorg . springframework . data . jpa . repository . Query Ċ import Ġorg . springframework . data . repository . Crud Repository Ċ import Ġorg . springframework . data . repository . query . Param Ċ import Ġorg . springframework . stereotype . Repository Ċ Ċ @ Repository Ċ interface ĠClaim List Repository Ġ: ĠCr ud Repository < Claim List , ĠInt > Ġ{ ĊĠĠĠ Ġ@ Query ( ĊĠĠĠĠĠĠĠ Ġvalue Ġ= Ġ" SELECT Ġc .* ĠFROM Ġclaim _ lists Ġc ĠJOIN Ġdiscord _ claim _ lists Ġd cl Ġon Ġc . claim _ list _ id Ġ= Ġd cl . claim _ list _ id ĠWHERE Ġd cl . discord _ server _ id =: discord Server Id ", ĊĠĠĠĠĠĠĠ Ġnative Query Ġ= Ġtrue ĊĠĠĠ Ġ) ĊĠĠĠ Ġfun ĠfindBy Discord Server (@ Param (" discord Server Id ") Ġdiscord Server Id : ĠInt ): ĠList < Claim List > Ċ }