So, on the heels of a 70+ site migration to a single Drupal codebase, one our next tasks is to create an event management system (so, a Drupal installation) that can be used to manage our annual conference.
A host that we refer a number of clients to recently decided it was a good idea to upgrade to PHP 5.3.x on one of our client's VPS's without informing us.
About a week ago we launched the Drupal News application for Android. We only worked few days on it, and it's still not perfect, but it does give a wonderful service to Drupal users.
First of all a disclaimer, part of the intention of this blog post is to see if anyone else has a better solution. This is something I came up with but I'm not entirely happy with the solution as it involves running the sql query twice. :(