{"status":"OK","detail":[],"id":null,"sql":"SELECT pap_sub_eje.*, entregable.* ,\n  (SELECT count(id_spec) FROM entregable_spec WHERE entregable_spec.id_actividad = entregable.id_entregable ) AS numSpecs,\n  (SELECT count(id_spec) FROM entregable_spec WHERE entregable_spec.id_actividad = entregable.id_entregable AND entregable_spec.spec_estatus = 'true' ) AS numComplete,\n  (SELECT count(id) FROM comentario WHERE comentario.activity_id = pap_sub_eje.id ) AS numComments\n  FROM pap_sub_eje INNER JOIN entregable ON pap_sub_eje.id = entregable.id_actividad WHERE entregable.id_ruta = '' AND cuenta = ''"}