aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--src/libhydra/plugins/attr_sql/pool_attributes.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/libhydra/plugins/attr_sql/pool_attributes.c b/src/libhydra/plugins/attr_sql/pool_attributes.c
index 7e3cb8607..5f7afdfcd 100644
--- a/src/libhydra/plugins/attr_sql/pool_attributes.c
+++ b/src/libhydra/plugins/attr_sql/pool_attributes.c
@@ -586,7 +586,9 @@ void status_attr(bool hexout)
"LEFT OUTER JOIN identities "
"ON attributes.identity = identities.id "
"LEFT OUTER JOIN attribute_pools "
- "ON attributes.pool = attribute_pools.id",
+ "ON attributes.pool = attribute_pools.id "
+ "ORDER BY attributes.type, attribute_pools.name, "
+ "identities.type, identities.data, attributes.value",
DB_INT, DB_TEXT, DB_INT, DB_BLOB, DB_BLOB);
if (enumerator)
{