move order by and rewrite similar in update_queue_item()

2 files changed, 3 insertions, 3 deletions

diff --git a/include/queue_fn.php b/include/queue_fn.php
index f7e2922c6..85f98aaf9 100644
--- a/include/queue_fn.php
+++ b/include/queue_fn.php
@@ -13,7 +13,7 @@ function update_queue_item($id, $add_priority = 0) {
 		return;
 
 
-	$y = q("select min(outq_created) as earliest from outq where outq_posturl = '%s'",
+	$y = q("select outq_created as earliest from outq where outq_posturl = '%s' order by earliest limit 1",
 		dbesc($x[0]['outq_posturl'])
 	);
 
@@ -311,4 +311,4 @@ function queue_deliver($outq, $immediate = false) {
 		return;
 	}
 
-}
\ No newline at end of file
+}
diff --git a/include/zot.php b/include/zot.php
index 7467eccde..df54f2b27 100644
--- a/include/zot.php
+++ b/include/zot.php
@@ -4959,7 +4959,7 @@ function zot_reply_pickup($data) {
 	// It's possible that we have more than 100 messages waiting to be sent.
 
 	// See if there are any more messages in the queue.
-        $x = q("select * from outq order by outq_created where outq_posturl = '%s' limit 1",
+        $x = q("select * from outq where outq_posturl = '%s' order by outq_created limit 1",
 		dbesc($data['callback'])
         );