DELETE `d`, `di`, `hb`, `hbc`
FROM `mn_zz_Doc` AS `d`
LEFT JOIN `mn_zz_DocItem` AS `di` ON `di`.`id_doc` = `d`.`id`
LEFT JOIN `mn_zz_DocTitle` AS `dt` ON `dt`.`id_parent` = `d`.`id`
LEFT JOIN `mn_zz_HTMLBlock` AS `hb` ON `hb`.`name` = `di`.`name` AND `di`.`type` = 'HTMLBlock/Show'
LEFT JOIN `mn_zz_HTMLBlockContent` AS `hbc` ON `hbc`.`id_parent` = `hb`.`id`
WHERE `d`.`alias` IN('propertysearch.htm');