SELECT `main_table`.* FROM `ves_blockbuilder_block` AS `main_table` WHERE (`alias` = 'no-route') AND (`status` = '1') AND (((((`show_from` < '1970-01-01') OR (`show_from` IS NULL) OR (`show_from` = ''))))) AND (((((`show_to` >= '1970-01-01') OR (`show_to` IS NULL) OR (`show_to` = '0000-00-00 00:00:00'))))) AND (`block_type` = 'page')