Advertisement
Guest User

Untitled

a guest
Aug 20th, 2023
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.16 KB | None | 0 0
  1. Hibernate:
  2.     /* <criteria> */ select
  3.         g1_0.id,
  4.         g1_0.name,
  5.         g1_0.nickname,
  6.         g1_0.user_uuid
  7.     from
  8.         general_accounts g1_0
  9.     where
  10.         g1_0.name=?
  11. Hibernate:
  12.     select
  13.         g1_0.name
  14.     from
  15.         general_account_name g1_0
  16.     where
  17.         g1_0.name=?
  18. Hibernate:
  19.     select
  20.         a1_0.general_account_id,
  21.         a1_1.number,
  22.         a1_2.id,
  23.         a1_2.money_type_id,
  24.         m1_0.id,
  25.         m1_0.name,
  26.         m1_0.pathToIcon,
  27.         a1_2.amount,
  28.         a1_2.number
  29.     from
  30.         general_account_mapping a1_0
  31.     join
  32.         accounts a1_2
  33.             on a1_2.id=a1_0.account_id
  34.     left join
  35.         money_type m1_0
  36.             on m1_0.id=a1_2.money_type_id
  37.     join
  38.         account_number a1_1
  39.             on a1_1.number=a1_2.number
  40.     where
  41.         array_contains(?,a1_0.general_account_id)
  42. Hibernate:
  43.     /* <criteria> */ select
  44.         c1_0.id,
  45.         c1_0.cooldown,
  46.         c1_0.description,
  47.         c1_0.name,
  48.         c1_0.money_type_id,
  49.         c1_0.price,
  50.         c1_0.visibleName
  51.     from
  52.         cases c1_0 offset ? rows fetch first ? rows only
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement