Holger Hans Peter Freyther | 1293f04 | 2010-12-23 22:12:57 +0100 | [diff] [blame] | 1 | "Query for one SMS" |
2 | |||||
3 | Eval [ | ||||
4 | 1 to: 100 do: [:each | | ||||
5 | Transcript show: 'SELECT SMS.* FROM SMS | ||||
6 | JOIN Subscriber ON SMS.receiver_id = Subscriber.id | ||||
7 | WHERE SMS.id >= 1 AND SMS.sent IS NULL AND Subscriber.lac > 0 | ||||
8 | ORDER BY SMS.id LIMIT 1;'; nl. | ||||
9 | ]. | ||||
10 | ] |