Index: ../netpub_models/lib/netpub_models/tleo_service.rb
===================================================================
--- ../netpub_models/lib/netpub_models/tleo_service.rb  (revision 51483)
+++ ../netpub_models/lib/netpub_models/tleo_service.rb  (working copy)
@@ -19,14 +19,14 @@

     def sync_recents
       TleoService.update_all(
-        ["tleo_services.recent = (SELECT SUM(bc.is_recent) " \
+        ["tleo_services.recent = COALESCE( (SELECT SUM(bc.is_recent) " \
         "FROM programmes_all p " \
         "INNER JOIN programmes_all e ON e.root_id = p.id " \
         "INNER JOIN versions_all v ON v.programme_id = e.id " \
         "INNER JOIN broadcasts bc ON bc.version_id = v.id " \
         "INNER JOIN services sv ON sv.id = bc.service_id " \
         "WHERE p.depth = 1 AND p.id = ? AND sv.parent_service_id = ? " \
-        "GROUP BY p.id, sv.parent_service_id)", self.programme, self.service],
+        "GROUP BY p.id, sv.parent_service_id), 0)", self.programme, self.service],
         ["tleo_services.programme_id = ? AND tleo_services.service_id = ?", self.programme, self.service])
     end