I'm having table named asblocks
I use this query in controller and code in view to display this template..
Controller
$blocks = $this->model->getData("SELECT * ...
Source: