Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Hibernate:
- SELECT
- this_.id AS id4_5_,
- this_.author_fk AS author7_4_5_,
- this_.content AS content4_5_,
- this_.DATE AS date4_5_,
- this_.editor_fk AS editor8_4_5_,
- this_.flagEditor AS flagEditor4_5_,
- this_.flagWriter AS flagWriter4_5_,
- this_.title AS title4_5_,
- writer1_.USER_ID AS USER1_10_0_,
- writer1_1_.banned AS banned10_0_,
- writer1_1_.email AS email10_0_,
- writer1_1_.login AS login10_0_,
- writer1_1_.name AS name10_0_,
- writer1_1_.password AS password10_0_,
- writer1_1_.surname AS surname10_0_,
- comments4_.article_fk AS article5_4_7_,
- comments4_.id AS id6_7_,
- comments4_.id AS id6_1_,
- comments4_.article_fk AS article5_6_1_,
- comments4_.author_fk AS author6_6_1_,
- comments4_.content AS content6_1_,
- comments4_.DATE AS date6_1_,
- comments4_.flagShow AS flagShow6_1_,
- user5_.USER_ID AS USER1_10_2_,
- user5_.banned AS banned10_2_,
- user5_.email AS email10_2_,
- user5_.login AS login10_2_,
- user5_.name AS name10_2_,
- user5_.password AS password10_2_,
- user5_.surname AS surname10_2_,
- user5_3_.balance AS balance5_2_,
- CASE
- WHEN user5_1_.USER_ID IS NOT NULL THEN 1
- WHEN user5_2_.USER_ID IS NOT NULL THEN 2
- WHEN user5_3_.USER_ID IS NOT NULL THEN 3
- WHEN user5_4_.USER_ID IS NOT NULL THEN 4
- WHEN user5_5_.USER_ID IS NOT NULL THEN 5
- WHEN user5_6_.USER_ID IS NOT NULL THEN 6
- WHEN user5_.USER_ID IS NOT NULL THEN 0
- END AS clazz_2_,
- invoice6_.id AS id8_3_,
- invoice6_.client_fk AS client6_8_3_,
- invoice6_.flagAd AS flagAd8_3_,
- invoice6_.flagPaid AS flagPaid8_3_,
- invoice6_.price AS price8_3_,
- invoice6_.productId AS productId8_3_,
- editor7_.USER_ID AS USER1_10_4_,
- editor7_1_.banned AS banned10_4_,
- editor7_1_.email AS email10_4_,
- editor7_1_.login AS login10_4_,
- editor7_1_.name AS name10_4_,
- editor7_1_.password AS password10_4_,
- editor7_1_.surname AS surname10_4_
- FROM
- ARTICLES this_
- INNER JOIN
- WRITERS writer1_
- ON this_.author_fk=writer1_.USER_ID
- LEFT OUTER JOIN
- USER writer1_1_
- ON writer1_.USER_ID=writer1_1_.USER_ID
- LEFT OUTER JOIN
- COMMENTS comments4_
- ON this_.id=comments4_.article_fk
- LEFT OUTER JOIN
- USER user5_
- ON comments4_.author_fk=user5_.USER_ID
- LEFT OUTER JOIN
- ACCOUNTANTS user5_1_
- ON user5_.USER_ID=user5_1_.USER_ID
- LEFT OUTER JOIN
- ADMINISTRATORS user5_2_
- ON user5_.USER_ID=user5_2_.USER_ID
- LEFT OUTER JOIN
- CLIENT user5_3_
- ON user5_.USER_ID=user5_3_.USER_ID
- LEFT OUTER JOIN
- EDITORS user5_4_
- ON user5_.USER_ID=user5_4_.USER_ID
- LEFT OUTER JOIN
- MODERATORS user5_5_
- ON user5_.USER_ID=user5_5_.USER_ID
- LEFT OUTER JOIN
- WRITERS user5_6_
- ON user5_.USER_ID=user5_6_.USER_ID
- LEFT OUTER JOIN
- INVOICE invoice6_
- ON user5_.USER_ID=invoice6_.client_fk
- LEFT OUTER JOIN
- EDITORS editor7_
- ON this_.editor_fk=editor7_.USER_ID
- LEFT OUTER JOIN
- USER editor7_1_
- ON editor7_.USER_ID=editor7_1_.USER_ID
- WHERE
- writer1_.USER_ID=?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement