Hocam. şu şekilde denermisin.
$get = $this->registry->db->query_read_slave("SELECT * FROM  `attachment` WHERE  `filename` LIKE  '%.zip%' or `filename` LIKE  '%.rar%' ORDER BY `attachment`.`counter` DESC LIMIT 0 , 20");