# HG changeset patch
# User dwinter
# Date 1367482492 -7200
# Node ID d452fff7c52e959fc39db8868552b335d45ca0c0
# Parent  09900782c855b653f725f00e3a5836b005bab7ed
getLastArrivals changed

diff -r 09900782c855 -r d452fff7c52e MPIWGStaff.py
--- a/MPIWGStaff.py	Thu May 02 09:57:54 2013 +0200
+++ b/MPIWGStaff.py	Thu May 02 10:14:52 2013 +0200
@@ -1141,9 +1141,9 @@
     def getLastArrivals(self,limit=None):
         """getlast arrivals"""
         if not limit:
-            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC"
+            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' and date_from < CURRENT_DATE order by date_from DESC"
         else:
-            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC limit %s"%limit  
+            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' and date_from < CURRENT_DATE order by date_from DESC limit %s"%limit  
         
         res=self.members.executeZSQL(selectStr)