помогите составить sql запрос

DELETE `t1`

FROM `dle_users` AS `t1`

LEFT JOIN `dle_pm` AS `t2` ON `t2`.`user_from` = `t1`.`name`

WHERE `t1`.`lastdate` = `t1`.`reg_date` AND `t2`.`id` IS NULL

DELETE FROM dle_users WHERE dle_pm=0 AND lastdate < '2012-01-01'

---------- Добавлено 05.06.2014 в 10:26 ----------

DELETE FROM dle_users WHERE dle_pm=0 AND reg_date=lastdate AND lastdate < '2012-01-01'

DELETE FROM dle_users WHERE NOT EXISTS (SELECT user_from FROM dle_pm WHERE user_from=name) AND lastdate < '2012-01-01'

siv1987, столбца dle_pm в dle_users нет, соответственно

LovelAss, извините за мою необразованность :) почему проверяете id из dle_pm

???

Пардон, pm_all