Hi buger, Is this in production, or on the dev_appserver? In production, your app does not appear to have the necessary indexes to execute the second query.
-Nick Johnson On Thu, Jun 25, 2009 at 11:38 PM, buger<[email protected]> wrote: > > SELECT * FROM Video WHERE artist = Key > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > status = 2 > This query gives me 4 results > > But this gives only 1 result!, i'm just added order > SELECT * FROM Video WHERE artist = Key > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > status = 2 ORDER BY created_at desc > > created_at is DateTime property, and all this objects have it > > > -- Nick Johnson, App Engine Developer Programs Engineer Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number: 368047 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
