Hibernate DetachedCriteria

qq_34354426 2017-09-05 09:19:16

像这种SQL DetachedCriteria能写吗？



select * from (

SELECT cms.id,u.headIcon,u.userName,cms.comment_time,t.likecount,cms.comment,cms.parent_id

FROM    cms_content_comments cms

        LEFT JOIN ( SELECT  parent_id ,

                            COUNT(1) AS likecount

                    FROM    cms_content_comments

                    WHERE   news_id = '1'

                            AND like_it = 1

                    GROUP BY parent_id

                  ) t ON cms.id = t.parent_id

       LEFT  JOIN user_center_app_userinfo u

		  ON u.id=cms.user_id  

		   LEFT  JOIN user_center_app_userinfo s

		  ON s.id=cms.parent_id  

WHERE   comment <> ''

        AND comment IS NOT NULL

ORDER BY t.likecount DESC,comment_time desc limit 3) as  t1

...全文

118 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

「已注销」 2017-09-05

打赏
举报

「已注销」 2017-09-05

打赏
举报

SELECT cms.id,u.headIcon,u.userName,cms.comment_time,t.likecount,cms.comment,cms.parent_id
FROM    cms_content_comments cms
        LEFT JOIN ( SELECT  parent_id ,
                            COUNT(1) AS likecount
                    FROM    cms_content_comments
                    WHERE   news_id = '1'
                            AND like_it = 1
                    GROUP BY parent_id
                  ) t ON cms.id = t.parent_id
       LEFT  JOIN user_center_app_userinfo u
		  ON u.id=cms.user_id  
		   LEFT  JOIN user_center_app_userinfo s
		  ON s.id=cms.parent_id  
WHERE   comment <> ''
        AND comment IS NOT NULL
ORDER BY t.likecount DESC,comment_time desc limit 3

「已注销」 2017-09-05