This is a wrap-up on how to create a proper podcast feed on Drupal 5.7 (will probably work on 6.2 as well), based on a particular content type, valid for the iTunes Music Store and redirected via Feedburner.
We use the Views UI a lot to create custom pages, blocks, etc. Sometimes it does not give us exactly what we want and we would like to modify the generated sql query. It's possible to achieve this through the 'views_query_alter' hook.