diff options
author | Anton Tananaev <anton.tananaev@gmail.com> | 2015-06-11 09:04:28 +1200 |
---|---|---|
committer | Anton Tananaev <anton.tananaev@gmail.com> | 2015-06-11 09:04:28 +1200 |
commit | c7500c72b18c8a794cc6c2853a39b3617586396a (patch) | |
tree | e437e84bf9ad2435ec18c7f4c6ac18c2eab711e4 | |
parent | ae56bc9e1f212bf96c3573b43fb8b11983bbb3e1 (diff) | |
parent | c83714bdec624771d45ac95a1f7824d0791e2d00 (diff) | |
download | traccar-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.xml | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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'> |