udd-query: orphaned_without_o_bug: consider only the higher version instead of the latest upload date

this fixes a fpos of a package adopted in experimental, but with a later
qa upload in unstable.

Signed-off-by: Mattia Rizzolo <mattia@debian.org>

1 files changed, 9 insertions, 9 deletions

diff --git a/bin/udd-query.sh b/bin/udd-query.sh
index 7f5cc121..c8ad8cd2 100755
--- a/bin/udd-query.sh
+++ b/bin/udd-query.sh
@@ -69,16 +69,16 @@ orphaned_without_o_bug() {
 	WNPPRM=$(mktemp)
 	SORTED_UDD=$(mktemp)
 
-	SQL_QUERY="SELECT DISTINCT u.source
-		FROM upload_history AS u
+	SQL_QUERY="
+		SELECT DISTINCT s.source
+		FROM sources AS s
 		JOIN (
-				SELECT s.source, max(u.date) AS date
-				FROM upload_history AS u
-				JOIN sources AS s ON s.source=u.source
-				WHERE s.release = 'sid' OR s.release = 'experimental'
-				GROUP BY s.source
-			) AS foo ON foo.source=u.source AND foo.date=u.date
-		WHERE maintainer like '%packages@qa.debian.org%';"
+				SELECT source, max(version) AS version
+				FROM sources
+				WHERE release IN ('sid','experimental')
+				GROUP BY source
+			) AS foo ON foo.source=s.source AND foo.version=s.version
+		WHERE s.maintainer_email = 'packages@qa.debian.org';"
 
 	udd_query
 	cat $UDD | tr -d ' ' | sort | uniq > "$SORTED_UDD"