diff options
author | Irving Gonzalez <ialexis93@gmail.com> | 2015-06-10 12:55:46 -0600 |
---|---|---|
committer | Irving Gonzalez <ialexis93@gmail.com> | 2015-06-10 12:55:46 -0600 |
commit | c83714bdec624771d45ac95a1f7824d0791e2d00 (patch) | |
tree | e437e84bf9ad2435ec18c7f4c6ac18c2eab711e4 | |
parent | a024db7609997039e71b5369496b3e8e687a130b (diff) | |
download | trackermap-server-c83714bdec624771d45ac95a1f7824d0791e2d00.tar.gz trackermap-server-c83714bdec624771d45ac95a1f7824d0791e2d00.tar.bz2 trackermap-server-c83714bdec624771d45ac95a1f7824d0791e2d00.zip |
changing "database.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'> |