commit | 889b01ca9e9a24950d15ff600567dd6b3ef39456 | [log] [tgz] |
---|---|---|
author | Sylvain Munaut <246tnt@gmail.com> | Mon Dec 21 01:09:57 2009 +0100 |
committer | Harald Welte <laforge@gnumonks.org> | Mon Dec 21 01:09:57 2009 +0100 |
tree | 06b4fcb9300b80b102e79bcca3fc23c5697766d0 | |
parent | b4cd15312ec8cd6b98e36bec117492b13dd23972 [diff] |
[db] Fix queries for unsent SMS - Need to use sms.id for the ORDER BY since 'subscriber' also has 'id' - Need to add the join clause between 'SMS' and 'subscriber' - Add a LIMIT 1 (probably no impact for the db size we're dealing with here, but with large DB and mysql/postgresql this can help the planner) - (fix a wrong comment in passing ...) Signed-off-by: Sylvain Munaut <tnt@246tNt.com>