Advertisement
Guest User

Untitled

a guest
Aug 20th, 2023
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.68 KB | None | 0 0
  1. Hibernate:
  2.     /* <criteria> */ select
  3.         g1_0.id,
  4.         g1_0.name,
  5.         n1_0.name,
  6.         g1_0.nickname,
  7.         g1_0.user_uuid
  8.     from
  9.         general_accounts g1_0
  10.     join
  11.         general_account_name n1_0
  12.             on n1_0.name=g1_0.name
  13.     where
  14.         g1_0.name=?
  15. Hibernate:
  16.     /* <criteria> */ select
  17.         c1_0.id,
  18.         c1_0.cooldown,
  19.         c1_0.description,
  20.         c1_0.name,
  21.         c1_0.money_type_id,
  22.         c1_0.price,
  23.         c1_0.visibleName
  24.     from
  25.         cases c1_0 offset ? rows fetch first ? rows only
  26. ______________________________________________________________________________________________________
  27. Hibernate:
  28.     /* <criteria> */ select
  29.         g1_0.id,
  30.         g1_0.name,
  31.         n1_0.name,
  32.         g1_0.nickname,
  33.         g1_0.user_uuid
  34.     from
  35.         general_accounts g1_0
  36.     join
  37.         general_account_name n1_0
  38.             on n1_0.name=g1_0.name
  39.     where
  40.         g1_0.name=?
  41. Hibernate:
  42.     /* <criteria> */ select
  43.         c1_0.id,
  44.         c1_0.cooldown,
  45.         c1_0.description,
  46.         c1_0.name,
  47.         c1_0.money_type_id,
  48.         c1_0.price,
  49.         c1_0.visibleName
  50.     from
  51.         cases c1_0 offset ? rows fetch first ? rows only
  52. Hibernate:
  53.     select
  54.         m1_0.id,
  55.         m1_0.name,
  56.         m1_0.pathToIcon
  57.     from
  58.         money_type m1_0
  59.     where
  60.         m1_0.id=?
  61. Hibernate:
  62.     /* <criteria> */ select
  63.         t1_0.case_id,
  64.         max(t1_0.created_on)
  65.     from
  66.         twistes t1_0
  67.     where
  68.         t1_0.general_account_id=?
  69.         and t1_0.case_id>=?
  70.         and t1_0.case_id<=?
  71.     group by
  72.         t1_0.case_id
  73.     order by
  74.         1 desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement