Биллинговая система Nodeny

DELETE FROM dopvalues WHERE revision NOT IN (SELECT rev FROM rev_users) AND revision NOT IN (SELECT rev FROM rev_equip)

mysql> DELETE FROM dopvalues WHERE revision NOT IN (SELECT rev FROM rev_users) AND revision NOT IN (SELECT rev FROM rev_equip);
Query OK, 0 rows affected (1 min 29.53 sec)

mysql>

SELECT parent_id AS id, template_num, MAX(revision) AS rev FROM (SELECT * FROM dopfields f JOIN dopvalues v ON f.id=v.dopfield_id) d WHERE parent_type=0 GROUP BY parent_id,template_num

SELECT parent_id AS id, template_num, MAX(revision) AS rev FROM dopfields f JOIN dopvalues v ON f.id=v.dopfield_id WHERE parent_type=0 GROUP BY parent_id, template_num

	Основной запрос:
SELECT SQL_CALC_FOUND_ROWS id FROM users WHERE grp IN (2,3,4,10,20,29,33,32,37,38,45,47,48,49,50,56,57,58,59,61,62,63,64,65,66,67,68,69,0) AND id IN (SELECT DISTINCT parent_id AS id FROM dopvalues WHERE revision IN (SELECT revision FROM dopvalues WHERE revision IN (SELECT rev FROM rev_users WHERE template_num=2) AND dopfield_id=8 AND field_value LIKE '32') AND dopfield_id=7 AND field_value LIKE '6') LIMIT 0,60
Время выполнения sql: 31.93646 сек
Всего строк: 27

SELECT SQL_CALC_FOUND_ROWS id FROM users
WHERE grp IN (2,3,4,10,20,29,33,32,37,38,45,47,48,49,50,56,57,58,59,61,62,63,64,65,66,67,68,69,0)
    AND EXISTS(
  SELECT * FROM dopvalues d1 JOIN dopvalues d2 ON d1.revision=d2.revision
  WHERE d1.dopfield_id=8 AND d1.field_value LIKE '32' AND d2.dopfield_id=7 AND d2.field_value LIKE '6'
  AND EXISTS (SELECT rev FROM rev_users WHERE template_num=2 AND rev=d1.revision)
  AND d1.parent_id=users.id
)