aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorIrving Gonzalez <ialexis93@gmail.com>2015-06-10 12:55:46 -0600
committerIrving Gonzalez <ialexis93@gmail.com>2015-06-10 12:55:46 -0600
commitc83714bdec624771d45ac95a1f7824d0791e2d00 (patch)
treee437e84bf9ad2435ec18c7f4c6ac18c2eab711e4
parenta024db7609997039e71b5369496b3e8e687a130b (diff)
downloadtraccar-server-c83714bdec624771d45ac95a1f7824d0791e2d00.tar.gz
traccar-server-c83714bdec624771d45ac95a1f7824d0791e2d00.tar.bz2
traccar-server-c83714bdec624771d45ac95a1f7824d0791e2d00.zip
changing "database.selectDevices" query
-rw-r--r--debug.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/debug.xml b/debug.xml
index b058cd184..8762825ea 100644
--- a/debug.xml
+++ b/debug.xml
@@ -170,7 +170,7 @@
</entry>
<entry key='database.selectDevices'>
- SELECT * FROM device WHERE id IN (SELECT deviceId FROM user_device WHERE userId = :userId);
+ SELECT * FROM device d INNER JOIN user_device ud ON d.id = ud.deviceId WHERE ud.userId = :userId;
</entry>
<entry key='database.insertDevice'>