+
+(defun find-usrl_freq-all ()
+ (let ((freqs '()))
+ (dolist (usrl (find-usrl-all))
+ (let ((freq (ensure-integer
+ (caar (mutex-sql-query
+ (format nil "select count(*) from MRSO where SAB='~a'"
+ (sab usrl)))))))
+ (push (make-instance 'usrl_freq :usrl usrl :freq freq) freqs)))
+ (sort freqs #'> :key #'usrl_freq-freq)))
+