{"status":"OK","detail":[],"sql":"SELECT pap_sub_eje.*, (SELECT count(id_entregable) FROM entregable WHERE entregable.id_ruta = pap_sub_eje.id ) AS numActivities\n    , (SELECT count(id_entregable) FROM entregable WHERE entregable.id_ruta = pap_sub_eje.id AND entregable.actividad_estatus = 'true' ) AS numComplete\n    FROM pap_sub_eje WHERE cuenta = '' AND type = 'ruta_plan'"}