diff options
-rwxr-xr-x | lib/mysql-functions | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions index bf66a73..548ee00 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -1526,6 +1526,7 @@ mysql_load_min_and_max_versions() { { printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)' printf ' FROM `versions`' + printf ' WHERE `versions`.`order` IS NOT NULL' printf ' ORDER BY `versions`.`order`' printf ' LIMIT 1' } | \ @@ -1538,6 +1539,7 @@ mysql_load_min_and_max_versions() { { printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)' printf ' FROM `versions`' + printf ' WHERE `versions`.`order` IS NOT NULL' printf ' ORDER BY `versions`.`order` DESC' printf ' LIMIT 1' } | \ @@ -1550,6 +1552,7 @@ mysql_load_min_and_max_versions() { { printf 'SELECT `versions`.`id`' printf ' FROM `versions`' + printf ' WHERE `versions`.`order` IS NOT NULL' printf ' ORDER BY `versions`.`order`' printf ' LIMIT 1' } | \ @@ -1562,6 +1565,7 @@ mysql_load_min_and_max_versions() { { printf 'SELECT `versions`.`id`' printf ' FROM `versions`' + printf ' WHERE `versions`.`order` IS NOT NULL' printf ' ORDER BY `versions`.`order` DESC' printf ' LIMIT 1' } | \ |