Error: Could not execute query
SELECT
(select r.nombre_prov from provincia r where r.id_prov = P.PROV_ING) PROVINCIA,
count(*) TOTAL
FROM LABORATORIO P
WHERE P.TIPO_ACT_PREV IN (SELECT T.ID_ACT_PREV FROM TIPO_ACTIVIDAD_PREVENCION T
WHERE T.EST_ACT_PREV = 1 AND T.FORM_ACT_PREV = 'LAB' AND T.ROL_ACT_PREV IN ('LCLI','LTOX')) and P.PROV_ING <>25
AND TIENE_PLAN LIKE 'SI'
AND TO_CHAR(FECHA_PRU, 'mm')=11 and TO_CHAR(FECHA_PRU, 'yyyy')='2024'
group by P.PROV_ING
in db_query()
