SELECT
     this_.id as id9_1_,
     this_.name as name9_1_,
     this_.chance as chance9_1_,
     memberalia1_.memberId as memberId7_0_,
     memberalia1_.theftId as theftId7_0_,
     memberalia1_.availableTime as availabl3_7_0_
FROM thefts this_ left outer join memberThefts memberalia1_ on this_.id=memberalia1_.theftId
WHERE memberalia1_.memberId = 1 /* ?p0 */