DELETE
`creature_template`.`lootid`
FROM
`creature_template` ,
`creature_loot_template` ,
`item_template`
WHERE
`creature_template`.`lootid` =  `creature_loot_template`.`entry` AND
`creature_loot_template`.`item` =  `item_template`.`entry` AND
`creature_template`.`maxlevel` <  '40' AND
`item_template`.`ItemLevel` >  '45' AND
`creature_template`.`faction` =  '32';