aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--setup/default.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/default.xml b/setup/default.xml
index e251fbeee..971d923a8 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -190,7 +190,7 @@
</entry>
<entry key='database.selectLatestPositions'>
- SELECT * FROM positions WHERE id IN (SELECT positionId FROM devices)
+ SELECT positions.* FROM positions INNER JOIN devices ON positions.id = devices.positionid;
</entry>
<entry key='database.updateLatestPosition'>