Error in sqlite query with SELECT CASE

CREATE TEMP TABLE var(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255));
CREATE TEMP TABLE param(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255));
INSERT INTO param (nombre,texto) VALUES('criterio','');
INSERT INTO param (nombre,entero) VALUES('pagina',1);
INSERT INTO param (nombre,entero) VALUES('numRegistros',10);
INSERT INTO var (nombre,entero) VALUES('indiceinicial',( (SELECT entero FROM param WHERE nombre='pagina') - 1 ) * (SELECT entero FROM param WHERE nombre='numRegistros'));
SELECT CASE (SELECT texto FROM param WHERE nombre='criterio') 
    WHEN '' THEN (SELECT * FROM clientes ORDER BY id ASC LIMIT (SELECT entero FROM param WHERE nombre='numRegistros') OFFSET (SELECT entero FROM var WHERE nombre='indiceinicial'))
    ELSE
        (SELECT * FROM clientes
        WHERE id LIKE '%'||(SELECT texto FROM param WHERE nombre='criterio')||'%'
        OR nombre LIKE '%'||(SELECT texto FROM param WHERE nombre='criterio')||'%'
        OR fecha_inicio = (SELECT texto FROM param WHERE nombre='criterio')
        OR fecha_final = (SELECT texto FROM param WHERE nombre='criterio')
        OR dni LIKE '%'||(SELECT texto FROM param WHERE nombre='criterio')||'%'
        ORDER BY id ASC LIMIT (SELECT entero FROM param WHERE nombre='numRegistros') OFFSET (SELECT entero FROM var WHERE nombre='indiceinicial'))
    END;
DROP TABLE var;
DROP TABLE param;

The query returns the following error

  

[10:04:02] Error while executing SQL query on database 'spartan': only a single result allowed for a SELECT that is part of an expression

The tables var Y param simulate to be a variable and the parameters of a function in MySQL, if I execute each one of the subqueries if I throw a single result, the problem is when I execute it all in block.