Злой запрос

Это наверное очень злой запрос. Давно не писал ничего подобного

DELETE FROM `tt_srch_keywords` WHERE `id` in
(
SELECT `id`
FROM
  (
    SELECT
       `id`,
       `doc_id` AS 'dd',
       (
          SELECT
             count( `id` )
          FROM
             `tt_srch_keywords`
          WHERE
             `doc_id` = `dd`
       ) AS 'count_dd',
       (
          SELECT
             max( `count` )
          FROM
             `tt_srch_keywords`
          WHERE
             `doc_id` = `dd`
       ) AS 'max_dd',
       `srch_keyword`,
       `count`
    FROM
      `tt_srch_keywords`
  ) `tmptable`
WHERE
  (
    (`count_dd` > 5*`count`)
     AND
    (`count` < `max_dd`)
  )

)