| 2 |
1.23 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, a1_.added_juntas AS added_juntas_16, a2_.id AS id_17, a2_.title AS title_18, a2_.is_modulo AS is_modulo_19, a2_.is_active AS is_active_20, a2_.image_name AS image_name_21, a2_.image_size AS image_size_22, a2_.updated_at AS updated_at_23, a3_.id AS id_24, a3_.status AS status_25, a3_.orden AS orden_26, a3_.label_color AS label_color_27, j4_.id AS id_28, j4_.horas_aprobadas AS horas_aprobadas_29, j4_.fecha_aprobada AS fecha_aprobada_30, p5_.id AS id_31, p5_.profesion AS profesion_32, p5_.siglas AS siglas_33, p5_.codigo_profesion AS codigo_profesion_34, p5_.horas_requeridas_total AS horas_requeridas_total_35, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36, p5_.is_default AS is_default_37, p5_.is_featured AS is_featured_38, p5_.slug AS slug_39, a0_.aprobacion_id AS aprobacion_id_40, a0_.actividad_status_id AS actividad_status_id_41, a0_.codigo_id AS codigo_id_42, a1_.aprobacion_name_id AS aprobacion_name_id_43, a1_.aprobacion_status_id AS aprobacion_status_id_44, a1_.aprobacion_class_id AS aprobacion_class_id_45, j4_.aprobacion_id AS aprobacion_id_46, j4_.profesion_id AS profesion_id_47, j4_.junta_status_id AS junta_status_id_48 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 AND j4_.junta_status_id = 3 ORDER BY a0_.fecha ASC, a2_.title ASC
Parameters: [
"2025-12-08 15:29:25"
]
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,
a1_.added_juntas AS added_juntas_16,
a2_.id AS id_17,
a2_.title AS title_18,
a2_.is_modulo AS is_modulo_19,
a2_.is_active AS is_active_20,
a2_.image_name AS image_name_21,
a2_.image_size AS image_size_22,
a2_.updated_at AS updated_at_23,
a3_.id AS id_24,
a3_.status AS status_25,
a3_.orden AS orden_26,
a3_.label_color AS label_color_27,
j4_.id AS id_28,
j4_.horas_aprobadas AS horas_aprobadas_29,
j4_.fecha_aprobada AS fecha_aprobada_30,
p5_.id AS id_31,
p5_.profesion AS profesion_32,
p5_.siglas AS siglas_33,
p5_.codigo_profesion AS codigo_profesion_34,
p5_.horas_requeridas_total AS horas_requeridas_total_35,
p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36,
p5_.is_default AS is_default_37,
p5_.is_featured AS is_featured_38,
p5_.slug AS slug_39,
a0_.aprobacion_id AS aprobacion_id_40,
a0_.actividad_status_id AS actividad_status_id_41,
a0_.codigo_id AS codigo_id_42,
a1_.aprobacion_name_id AS aprobacion_name_id_43,
a1_.aprobacion_status_id AS aprobacion_status_id_44,
a1_.aprobacion_class_id AS aprobacion_class_id_45,
j4_.aprobacion_id AS aprobacion_id_46,
j4_.profesion_id AS profesion_id_47,
j4_.junta_status_id AS junta_status_id_48
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
AND j4_.junta_status_id = 3
ORDER BY
a0_.fecha ASC,
a2_.title 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, a1_.added_juntas AS added_juntas_16, a2_.id AS id_17, a2_.title AS title_18, a2_.is_modulo AS is_modulo_19, a2_.is_active AS is_active_20, a2_.image_name AS image_name_21, a2_.image_size AS image_size_22, a2_.updated_at AS updated_at_23, a3_.id AS id_24, a3_.status AS status_25, a3_.orden AS orden_26, a3_.label_color AS label_color_27, j4_.id AS id_28, j4_.horas_aprobadas AS horas_aprobadas_29, j4_.fecha_aprobada AS fecha_aprobada_30, p5_.id AS id_31, p5_.profesion AS profesion_32, p5_.siglas AS siglas_33, p5_.codigo_profesion AS codigo_profesion_34, p5_.horas_requeridas_total AS horas_requeridas_total_35, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36, p5_.is_default AS is_default_37, p5_.is_featured AS is_featured_38, p5_.slug AS slug_39, a0_.aprobacion_id AS aprobacion_id_40, a0_.actividad_status_id AS actividad_status_id_41, a0_.codigo_id AS codigo_id_42, a1_.aprobacion_name_id AS aprobacion_name_id_43, a1_.aprobacion_status_id AS aprobacion_status_id_44, a1_.aprobacion_class_id AS aprobacion_class_id_45, j4_.aprobacion_id AS aprobacion_id_46, j4_.profesion_id AS profesion_id_47, j4_.junta_status_id AS junta_status_id_48 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-12-08 15:29:25' AND j4_.horas_aprobadas > 0 AND j4_.junta_status_id = 3 ORDER BY a0_.fecha ASC, a2_.title ASC;
|