11
DELETE FROM xxx_block_instance WHERE instanceid = 39
( 0.000161)
DELETE FROM xxx_block_module_link WHERE block_id = 40
( 0.000112)
DELETE FROM xxx_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_itemid = '40')
( 0.000345)
DELETE FROM xxx_block_instance WHERE instanceid = 40
( 0.000132)
SELECT * FROM xxx_tplfile WHERE (tpl_tplset = 'myLatest' AND tpl_refid = '40' AND tpl_type = 'block') ORDER BY tpl_refid
( 0.000523)
DELETE FROM xxx_tplfile WHERE tpl_id = 1109
( 0.000215)
DELETE FROM xxx_tplsource WHERE tpl_id = 1109
( 0.007534)
DELETE FROM xxx_newblocks WHERE bid = 40
It does seem that it deletes the block instance, deletes the visible-on-pages, deletes group permissions and deletes the block instance.
Then it looks for the template, finds it (tpl_id=1109) and deletes tplfile and tplsource before deleting the block...
Why is there still a template left? It does seem to delete the template from the current selected template set and not the default template set, so maybe that's it...
Sometimes I hate the templating system.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."
Cusix Software