SELECT `main_table`.* FROM `ves_blockbuilder_block` AS `main_table` WHERE (`alias` = 'no-route') AND (`status` = '1') AND (`block_type` = 'page')