You can do something using subqueries (but if you're quering the same table on main and sub query, it will not perform well)
I recommend to do two queries instead. Regards, Pablo Viojo [email protected] http://pviojo.net ¿Que necesitas? http://needish.com On Mon, Nov 2, 2009 at 8:49 PM, Chad Casselman <[email protected]> wrote: > > Is there anyway to get all the row information with all those ids or > does it require another query to get row details for returned ids? > > Thanks, > Chad > > On Mon, Nov 2, 2009 at 6:36 PM, Pablo Viojo <[email protected]> wrote: > > Something like this may help: > > SELECT domain_id, search_engine_id, MAX(id) FROM table GROUP > BY domain_id, > > search_engine_id > > Regards, > > > > Pablo Viojo > > [email protected] > > http://pviojo.net > > > > ¿Que necesitas? > > http://needish.com > > > > > > On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <[email protected]> > wrote: > >> > >> I have a table that looks like: > >> > >> id created modified domain_id pages > >> search_engine_id > >> 92 2009-11-02 14:32:11 2009-11-02 14:32:11 2 19990 > 3 > >> 90 2009-11-02 14:32:11 2009-11-02 14:32:11 2 725 > 1 > >> 89 2009-11-02 14:32:10 2009-11-02 14:32:10 1 1250 > 1 > >> 88 2009-11-02 10:00:07 2009-11-02 10:00:07 2 19995 > 3 > >> 87 2009-11-02 10:00:07 2009-11-02 10:00:07 1 9612 > 3 > >> 86 2009-11-02 10:00:07 2009-11-02 10:00:07 2 725 > 1 > >> 85 2009-11-02 10:00:07 2009-11-02 10:00:07 1 1250 > 1 > >> 84 2009-11-02 09:59:47 2009-11-02 09:59:47 2 19995 > 3 > >> 83 2009-11-02 09:59:47 2009-11-02 09:59:47 1 9609 > 3 > >> 82 2009-11-02 09:59:47 2009-11-02 09:59:47 2 725 > 1 > >> 81 2009-11-02 09:59:47 2009-11-02 09:59:47 1 1250 > 1 > >> 80 2009-11-02 09:59:39 2009-11-02 09:59:39 2 19995 > 3 > >> 79 2009-11-02 09:59:39 2009-11-02 09:59:39 1 9609 > 3 > >> 78 2009-11-02 09:59:39 2009-11-02 09:59:39 2 725 > 1 > >> 77 2009-11-02 09:59:39 2009-11-02 09:59:39 1 1250 > 1 > >> > >> I have spent over half the day trying to figure out how to pull the > >> last inserted row for each domain_id, search_engine_id pair in > >> CakePHP. > >> > >> Can anyone help me figure out how to do this within CakePHP? > >> > >> I really appreciate your time. > >> Chad > >> > >> > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
