Advertisement
Guest User

Untitled

a guest
Jun 2nd, 2013
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.53 KB | None | 0 0
  1. Hibernate:
  2.     SELECT
  3.         this_.id AS id4_5_,
  4.         this_.author_fk AS author7_4_5_,
  5.         this_.content AS content4_5_,
  6.         this_.DATE AS date4_5_,
  7.         this_.editor_fk AS editor8_4_5_,
  8.         this_.flagEditor AS flagEditor4_5_,
  9.         this_.flagWriter AS flagWriter4_5_,
  10.         this_.title AS title4_5_,
  11.         writer1_.USER_ID AS USER1_10_0_,
  12.         writer1_1_.banned AS banned10_0_,
  13.         writer1_1_.email AS email10_0_,
  14.         writer1_1_.login AS login10_0_,
  15.         writer1_1_.name AS name10_0_,
  16.         writer1_1_.password AS password10_0_,
  17.         writer1_1_.surname AS surname10_0_,
  18.         comments4_.article_fk AS article5_4_7_,
  19.         comments4_.id AS id6_7_,
  20.         comments4_.id AS id6_1_,
  21.         comments4_.article_fk AS article5_6_1_,
  22.         comments4_.author_fk AS author6_6_1_,
  23.         comments4_.content AS content6_1_,
  24.         comments4_.DATE AS date6_1_,
  25.         comments4_.flagShow AS flagShow6_1_,
  26.         user5_.USER_ID AS USER1_10_2_,
  27.         user5_.banned AS banned10_2_,
  28.         user5_.email AS email10_2_,
  29.         user5_.login AS login10_2_,
  30.         user5_.name AS name10_2_,
  31.         user5_.password AS password10_2_,
  32.         user5_.surname AS surname10_2_,
  33.         user5_3_.balance AS balance5_2_,
  34.         CASE
  35.             WHEN user5_1_.USER_ID IS NOT NULL THEN 1
  36.             WHEN user5_2_.USER_ID IS NOT NULL THEN 2
  37.             WHEN user5_3_.USER_ID IS NOT NULL THEN 3
  38.             WHEN user5_4_.USER_ID IS NOT NULL THEN 4
  39.             WHEN user5_5_.USER_ID IS NOT NULL THEN 5
  40.             WHEN user5_6_.USER_ID IS NOT NULL THEN 6
  41.             WHEN user5_.USER_ID IS NOT NULL THEN 0
  42.         END AS clazz_2_,
  43.         invoice6_.id AS id8_3_,
  44.         invoice6_.client_fk AS client6_8_3_,
  45.         invoice6_.flagAd AS flagAd8_3_,
  46.         invoice6_.flagPaid AS flagPaid8_3_,
  47.         invoice6_.price AS price8_3_,
  48.         invoice6_.productId AS productId8_3_,
  49.         editor7_.USER_ID AS USER1_10_4_,
  50.         editor7_1_.banned AS banned10_4_,
  51.         editor7_1_.email AS email10_4_,
  52.         editor7_1_.login AS login10_4_,
  53.         editor7_1_.name AS name10_4_,
  54.         editor7_1_.password AS password10_4_,
  55.         editor7_1_.surname AS surname10_4_
  56.     FROM
  57.         ARTICLES this_
  58.     INNER JOIN
  59.         WRITERS writer1_
  60.             ON this_.author_fk=writer1_.USER_ID
  61.     LEFT OUTER JOIN
  62.         USER writer1_1_
  63.             ON writer1_.USER_ID=writer1_1_.USER_ID
  64.     LEFT OUTER JOIN
  65.         COMMENTS comments4_
  66.             ON this_.id=comments4_.article_fk
  67.     LEFT OUTER JOIN
  68.         USER user5_
  69.             ON comments4_.author_fk=user5_.USER_ID
  70.     LEFT OUTER JOIN
  71.         ACCOUNTANTS user5_1_
  72.             ON user5_.USER_ID=user5_1_.USER_ID
  73.     LEFT OUTER JOIN
  74.         ADMINISTRATORS user5_2_
  75.             ON user5_.USER_ID=user5_2_.USER_ID
  76.     LEFT OUTER JOIN
  77.         CLIENT user5_3_
  78.             ON user5_.USER_ID=user5_3_.USER_ID
  79.     LEFT OUTER JOIN
  80.         EDITORS user5_4_
  81.             ON user5_.USER_ID=user5_4_.USER_ID
  82.     LEFT OUTER JOIN
  83.         MODERATORS user5_5_
  84.             ON user5_.USER_ID=user5_5_.USER_ID
  85.     LEFT OUTER JOIN
  86.         WRITERS user5_6_
  87.             ON user5_.USER_ID=user5_6_.USER_ID
  88.     LEFT OUTER JOIN
  89.         INVOICE invoice6_
  90.             ON user5_.USER_ID=invoice6_.client_fk
  91.     LEFT OUTER JOIN
  92.         EDITORS editor7_
  93.             ON this_.editor_fk=editor7_.USER_ID
  94.     LEFT OUTER JOIN
  95.         USER editor7_1_
  96.             ON editor7_.USER_ID=editor7_1_.USER_ID
  97.     WHERE
  98.         writer1_.USER_ID=?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement