postgresql7.4 SELECT blog.title, entry_id, to_char(blog.entry_date, 'FMMonth FMDDth, YYYY') AS pretty_date FROM pinds_blog_entries blog, apm_packages pkg WHERE pkg.package_key = 'lars-blogger' AND pkg.package_id IN ([join $list_of_package_ids ,]) AND blog.package_id = pkg.package_id ORDER BY blog.entry_date DESC