Hi people I have 3 table where in one table ( 'guests' ) i have registred ips of users guests from a site, in other table ( 'pages' ) i registred the pages of the site, and in other table ( 'page_guest' ), i registred how much and how page viewest by the the user.
So, i need to translate this query to DQL: SELECT mostviewed.page_id FROM ( SELECT pg.page_id as page_id , SUM(pg.quantity) AS total FROM page_guest AS pg GROUP BY pg.page_id ORDER BY total DESC ) AS mostviewed; Specifically , i need retrieve the entire page entity not only 'page_id' and not the 'total' of views. The 'total' is used only to sort the most viewest pages. I try to use the subqueries tecniques of doctrine 2 but always has errors. Because this i ask a hint of how to do it right. Thank you in advance. -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
