Ver originalSELECT *, FROM internaciones WHERE (fecha BETWEEN TIMESTAMP('$fecha1') AND TIMESTAMP('$fecha2')) AND idinternacion IN (SELECT idinternacion FROM internaciones WHERE MATCH (apellido,nombre) AGAINST ('$buscar'))