Удаление "мертвых душ"

DELETE `u`,`a`,`l`
FROM `users` `u`, `anketa` `a`, `logi` `l`
WHERE
    `u`.`activation` = `a`.`activation` AND
    `a`.`activation` = `l`.`activation` AND
    `u`.`date` = `a`.`date` AND
    `a`.`date` = `l`.`date` AND
    `u`.`activation`='0' AND
    UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`u`.`date`) > 86400

DELETE `u`,`a`,`l`
FROM `users` `u`
JOIN `anketa` `a` USING(`activation`, `date`)
JOIN `logi` `l` USING(`activation`, `date`)
WHERE
    `u`.`activation`='0' AND
    UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`u`.`date`) > 86400

mysql> USE `test`;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> SELECT * FROM `test` LIMIT 3;
+----+------+------------+
| id | name | activation |
+----+------+------------+
|  7 |    7 |          0 |
|  8 |    8 |          0 |
+----+------+------------+
2 rows in set (0.00 sec)
 
mysql> SELECT * FROM `test2` LIMIT 3;
+----+------+------------+
| id | name | activation |
+----+------+------------+
|  7 | 7    |          0 |
|  8 | 8    |          0 |
|  9 | 9    |          0 |
+----+------+------------+
3 rows in set (0.00 sec)
 
mysql> SELECT * FROM `test3` LIMIT 3;
+----+------+------------+
| id | name | activation |
+----+------+------------+
|  7 | 7    |          0 |
|  8 | 8    |          0 |
|  9 | 9    |          0 |
+----+------+------------+
3 rows in set (0.00 sec)
 
mysql> DELETE `u`,`a`,`l`
    -> FROM `test` `u`, `test2` `a`, `test3` `l`
    -> WHERE
    -> `u`.`activation` = `a`.`activation` AND
    -> `a`.`activation` = `l`.`activation` AND
    -> `u`.`name` = `a`.`name` AND
    -> `a`.`name` = `l`.`name` AND
    -> `u`.`activation`='0' AND `u`.`name` < 10;
Query OK, 6 rows affected (34.03 sec)
 
mysql> SELECT * FROM `test` LIMIT 3;
Empty set (0.00 sec)
 
mysql> SELECT * FROM `test2` LIMIT 3;+----+------+------------+
| id | name | activation |
+----+------+------------+
|  9 | 9    |          0 |
| 10 | 10   |          0 |
| 11 | 11   |          0 |
+----+------+------------+
3 rows in set (0.00 sec)
 
mysql> SELECT * FROM `test3` LIMIT 3;
+----+------+------------+
| id | name | activation |
+----+------+------------+
|  9 | 9    |          0 |
| 10 | 10   |          0 |
| 11 | 11   |          0 |
+----+------+------------+
3 rows in set (0.00 sec)
 
mysql>