aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-06-11 09:04:28 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2015-06-11 09:04:28 +1200
commitc7500c72b18c8a794cc6c2853a39b3617586396a (patch)
treee437e84bf9ad2435ec18c7f4c6ac18c2eab711e4
parentae56bc9e1f212bf96c3573b43fb8b11983bbb3e1 (diff)
parentc83714bdec624771d45ac95a1f7824d0791e2d00 (diff)
downloadtraccar-server-c7500c72b18c8a794cc6c2853a39b3617586396a.tar.gz
traccar-server-c7500c72b18c8a794cc6c2853a39b3617586396a.tar.bz2
traccar-server-c7500c72b18c8a794cc6c2853a39b3617586396a.zip
Merge pull request #1242 from al3x1s/master
Changing 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'>