Index: trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl
===================================================================
--- trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl	(revision 42449)
+++ trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl	(revision 42452)
@@ -77,5 +77,8 @@
 
     # select and advance nights not yet running
-    $sql_get_run = "SELECT dateobs from nights where state = 'new'";
+#   $sql_get_run = "SELECT dateobs from nights where state = 'new'";
+
+    $sql_get_run = "SELECT dateobs FROM (SELECT dateobs, rand() AS myrand FROM nights WHERE (state = 'new')) AS tmp ORDER BY myrand";
+
     $runref   = $raw_dbh->selectall_arrayref( $sql_get_run );
     @runarray = @$runref;