I have a problem with Doctrine. I have a query like this: Doctrine_Query::create () ->select ( "u.user_id, wm.*, asi.*, ... " )->from ( "user u" ) ->leftJoin ( "u.member gm ON u.user_id = gm.member_id" ) // more x10 leftJoin ... ->where ( "u.user_id = ?", $user_id )->limit (5)->fetchArray ();
But limit(5) query not work. frontend_dev output: # SELECT DISTINCT u12.user_id FROM users bla bla bla LIMIT 5 # SELECT u.user_id bla bla bla WHERE u.user_id IN ('2') AND (u.user_id = '2') //limit shold be here! Queries are divided into two, the limit must be in second, while in only the first is run. What can i do? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en