| 2 |
1.08 ms |
SELECT a0_.id AS id_0, a0_.ajuste_horas AS ajuste_horas_1, a0_.ajuste_precio AS ajuste_precio_2, a0_.capacidad AS capacidad_3, a0_.fecha AS fecha_4, a0_.precio_especial AS precio_especial_5, a1_.id AS id_6, a1_.fecha_sometida AS fecha_sometida_7, a1_.fecha_inicial AS fecha_inicial_8, a1_.codigo_asignado AS codigo_asignado_9, a1_.horas_sometidas AS horas_sometidas_10, a1_.precio_regular AS precio_regular_11, a1_.duracion AS duracion_12, a1_.codigo_inicial AS codigo_inicial_13, a1_.codigo_final AS codigo_final_14, a1_.is_active AS is_active_15, a2_.id AS id_16, a2_.aprobacion AS aprobacion_17, a2_.is_modulo AS is_modulo_18, a2_.is_active AS is_active_19, a3_.id AS id_20, a3_.status AS status_21, a3_.orden AS orden_22, a3_.label_color AS label_color_23, j4_.id AS id_24, j4_.horas_aprobadas AS horas_aprobadas_25, j4_.fecha_aprobada AS fecha_aprobada_26, p5_.id AS id_27, p5_.profesion AS profesion_28, p5_.siglas AS siglas_29, p5_.codigo_profesion AS codigo_profesion_30, p5_.horas_requeridas_total AS horas_requeridas_total_31, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32, p5_.is_default AS is_default_33, p5_.is_featured AS is_featured_34, p5_.slug AS slug_35, a0_.aprobacion_id AS aprobacion_id_36, a0_.actividad_status_id AS actividad_status_id_37, a0_.codigo_id AS codigo_id_38, a1_.aprobacion_name_id AS aprobacion_name_id_39, j4_.aprobacion_id AS aprobacion_id_40, j4_.profesion_id AS profesion_id_41, j4_.junta_status_id AS junta_status_id_42 FROM actividad a0_ LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id WHERE a0_.fecha > ? AND j4_.horas_aprobadas > 0 ORDER BY a0_.fecha ASC, a2_.aprobacion ASC
Parameters: [
"2025-11-08 08:36:22"
]
SELECT
a0_.id AS id_0,
a0_.ajuste_horas AS ajuste_horas_1,
a0_.ajuste_precio AS ajuste_precio_2,
a0_.capacidad AS capacidad_3,
a0_.fecha AS fecha_4,
a0_.precio_especial AS precio_especial_5,
a1_.id AS id_6,
a1_.fecha_sometida AS fecha_sometida_7,
a1_.fecha_inicial AS fecha_inicial_8,
a1_.codigo_asignado AS codigo_asignado_9,
a1_.horas_sometidas AS horas_sometidas_10,
a1_.precio_regular AS precio_regular_11,
a1_.duracion AS duracion_12,
a1_.codigo_inicial AS codigo_inicial_13,
a1_.codigo_final AS codigo_final_14,
a1_.is_active AS is_active_15,
a2_.id AS id_16,
a2_.aprobacion AS aprobacion_17,
a2_.is_modulo AS is_modulo_18,
a2_.is_active AS is_active_19,
a3_.id AS id_20,
a3_.status AS status_21,
a3_.orden AS orden_22,
a3_.label_color AS label_color_23,
j4_.id AS id_24,
j4_.horas_aprobadas AS horas_aprobadas_25,
j4_.fecha_aprobada AS fecha_aprobada_26,
p5_.id AS id_27,
p5_.profesion AS profesion_28,
p5_.siglas AS siglas_29,
p5_.codigo_profesion AS codigo_profesion_30,
p5_.horas_requeridas_total AS horas_requeridas_total_31,
p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32,
p5_.is_default AS is_default_33,
p5_.is_featured AS is_featured_34,
p5_.slug AS slug_35,
a0_.aprobacion_id AS aprobacion_id_36,
a0_.actividad_status_id AS actividad_status_id_37,
a0_.codigo_id AS codigo_id_38,
a1_.aprobacion_name_id AS aprobacion_name_id_39,
j4_.aprobacion_id AS aprobacion_id_40,
j4_.profesion_id AS profesion_id_41,
j4_.junta_status_id AS junta_status_id_42
FROM
actividad a0_
LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id
LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id
LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id
LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id
LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id
WHERE
a0_.fecha > ?
AND j4_.horas_aprobadas > 0
ORDER BY
a0_.fecha ASC,
a2_.aprobacion ASC
SELECT a0_.id AS id_0, a0_.ajuste_horas AS ajuste_horas_1, a0_.ajuste_precio AS ajuste_precio_2, a0_.capacidad AS capacidad_3, a0_.fecha AS fecha_4, a0_.precio_especial AS precio_especial_5, a1_.id AS id_6, a1_.fecha_sometida AS fecha_sometida_7, a1_.fecha_inicial AS fecha_inicial_8, a1_.codigo_asignado AS codigo_asignado_9, a1_.horas_sometidas AS horas_sometidas_10, a1_.precio_regular AS precio_regular_11, a1_.duracion AS duracion_12, a1_.codigo_inicial AS codigo_inicial_13, a1_.codigo_final AS codigo_final_14, a1_.is_active AS is_active_15, a2_.id AS id_16, a2_.aprobacion AS aprobacion_17, a2_.is_modulo AS is_modulo_18, a2_.is_active AS is_active_19, a3_.id AS id_20, a3_.status AS status_21, a3_.orden AS orden_22, a3_.label_color AS label_color_23, j4_.id AS id_24, j4_.horas_aprobadas AS horas_aprobadas_25, j4_.fecha_aprobada AS fecha_aprobada_26, p5_.id AS id_27, p5_.profesion AS profesion_28, p5_.siglas AS siglas_29, p5_.codigo_profesion AS codigo_profesion_30, p5_.horas_requeridas_total AS horas_requeridas_total_31, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32, p5_.is_default AS is_default_33, p5_.is_featured AS is_featured_34, p5_.slug AS slug_35, a0_.aprobacion_id AS aprobacion_id_36, a0_.actividad_status_id AS actividad_status_id_37, a0_.codigo_id AS codigo_id_38, a1_.aprobacion_name_id AS aprobacion_name_id_39, j4_.aprobacion_id AS aprobacion_id_40, j4_.profesion_id AS profesion_id_41, j4_.junta_status_id AS junta_status_id_42 FROM actividad a0_ LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id WHERE a0_.fecha > '2025-11-08 08:36:22' AND j4_.horas_aprobadas > 0 ORDER BY a0_.fecha ASC, a2_.aprobacion ASC;
|