BiTel

INFO   08.06.2009 14:01:03  Starting [ 14:01:03; 7 ] bitel.billing.server.contract.ContractStatusSetter
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 01.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 4] time=1 ms.
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 01.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 01.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 01.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 01.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 31.12.2008
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 31.12.2008
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 20.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 20.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 20.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 20.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] Set contract null status 3 from 20.01.2009
INFO   08.06.2009 14:01:03  [14:01:03; 7] time=25 ms.

mysql> select s.* from contract_status as s left outer join contract as c on (s.cid = c.id) where c.id is null;
+----+-----+--------+-----+------------+-------+--------------------+
| id | cid | status | uid | date1      | date2 | comment            |
+----+-----+--------+-----+------------+-------+--------------------+
| 20 | 159 |      3 |   3 | 2008-12-31 | NULL  |                    |
| 21 | 158 |      3 |   3 | 2008-12-31 | NULL  |                    |
| 40 | 172 |      3 |   3 | 2009-01-20 | NULL  |                    |
| 41 | 173 |      3 |   3 | 2009-01-20 | NULL  |                    |
| 42 | 174 |      3 |   3 | 2009-01-20 | NULL  |                    |
| 43 | 175 |      3 |   3 | 2009-01-20 | NULL  |                    |
| 44 | 177 |      3 |   3 | 2009-01-20 | NULL  |                    |
| 50 | 134 |      3 |   3 | 2009-01-01 | NULL  | Договор расторгнут |
| 51 | 130 |      3 |   3 | 2009-01-01 | NULL  | Договор расторгнут |
| 52 | 131 |      3 |   3 | 2009-01-01 | NULL  | Договор расторгнут |
| 53 | 132 |      3 |   3 | 2009-01-01 | NULL  | Договор расторгнут |
| 54 | 133 |      3 |   3 | 2009-01-01 | NULL  | Договор расторгнут |
+----+-----+--------+-----+------------+-------+--------------------+
12 rows in set (0.00 sec)