2
1.77 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 , a0_ . slug AS slug_6 , a1_ . id AS id_7 , a1_ . fecha_sometida AS fecha_sometida_8 , a1_ . fecha_inicial AS fecha_inicial_9 , a1_ . codigo_asignado AS codigo_asignado_10 , a1_ . horas_sometidas AS horas_sometidas_11 , a1_ . precio_regular AS precio_regular_12 , a1_ . duracion AS duracion_13 , a1_ . codigo_inicial AS codigo_inicial_14 , a1_ . codigo_final AS codigo_final_15 , a1_ . is_active AS is_active_16 , a1_ . aprobacion_status AS aprobacion_status_17 , a1_ . added_juntas AS added_juntas_18 , a1_ . fecha_aprobada AS fecha_aprobada_19 , a2_ . id AS id_20 , a2_ . title AS title_21 , a2_ . is_modulo AS is_modulo_22 , a2_ . is_active AS is_active_23 , a2_ . image_name AS image_name_24 , a2_ . image_size AS image_size_25 , a2_ . pdf_name AS pdf_name_26 , a2_ . pdf_size AS pdf_size_27 , a2_ . updated_at AS updated_at_28 , a2_ . description AS description_29 , a3_ . id AS id_30 , a3_ . status AS status_31 , a3_ . orden AS orden_32 , a3_ . label_color AS label_color_33 , j4_ . id AS id_34 , j4_ . horas_aprobadas AS horas_aprobadas_35 , j4_ . fecha_aprobada AS fecha_aprobada_36 , j4_ . fecha_sometida AS fecha_sometida_37 , j4_ . fecha_no_aprobada AS fecha_no_aprobada_38 , j4_ . horas_sometidas AS horas_sometidas_39 , j4_ . horas_aprobadas_override AS horas_aprobadas_override_40 , p5_ . id AS id_41 , p5_ . profesion AS profesion_42 , p5_ . siglas AS siglas_43 , p5_ . codigo_profesion AS codigo_profesion_44 , p5_ . horas_requeridas_total AS horas_requeridas_total_45 , p5_ . horas_requeridas_presencial AS horas_requeridas_presencial_46 , p5_ . is_default AS is_default_47 , p5_ . is_featured AS is_featured_48 , p5_ . slug AS slug_49 , p5_ . is_public AS is_public_50 , p5_ . icon AS icon_51 , a0_ . aprobacion_id AS aprobacion_id_52 , a0_ . actividad_status_id AS actividad_status_id_53 , a0_ . codigo_id AS codigo_id_54 , a0_ . actividad_class_id AS actividad_class_id_55 , a1_ . aprobacion_name_id AS aprobacion_name_id_56 , a1_ . aprobacion_class_id AS aprobacion_class_id_57 , j4_ . aprobacion_id AS aprobacion_id_58 , j4_ . profesion_id AS profesion_id_59 , j4_ . junta_status_id AS junta_status_id_60 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 :
[
"2026-02-25 14:17:41 "
]
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 ,
a0_ . slug AS slug_6 ,
a1_ . id AS id_7 ,
a1_ . fecha_sometida AS fecha_sometida_8 ,
a1_ . fecha_inicial AS fecha_inicial_9 ,
a1_ . codigo_asignado AS codigo_asignado_10 ,
a1_ . horas_sometidas AS horas_sometidas_11 ,
a1_ . precio_regular AS precio_regular_12 ,
a1_ . duracion AS duracion_13 ,
a1_ . codigo_inicial AS codigo_inicial_14 ,
a1_ . codigo_final AS codigo_final_15 ,
a1_ . is_active AS is_active_16 ,
a1_ . aprobacion_status AS aprobacion_status_17 ,
a1_ . added_juntas AS added_juntas_18 ,
a1_ . fecha_aprobada AS fecha_aprobada_19 ,
a2_ . id AS id_20 ,
a2_ . title AS title_21 ,
a2_ . is_modulo AS is_modulo_22 ,
a2_ . is_active AS is_active_23 ,
a2_ . image_name AS image_name_24 ,
a2_ . image_size AS image_size_25 ,
a2_ . pdf_name AS pdf_name_26 ,
a2_ . pdf_size AS pdf_size_27 ,
a2_ . updated_at AS updated_at_28 ,
a2_ . description AS description_29 ,
a3_ . id AS id_30 ,
a3_ . status AS status_31 ,
a3_ . orden AS orden_32 ,
a3_ . label_color AS label_color_33 ,
j4_ . id AS id_34 ,
j4_ . horas_aprobadas AS horas_aprobadas_35 ,
j4_ . fecha_aprobada AS fecha_aprobada_36 ,
j4_ . fecha_sometida AS fecha_sometida_37 ,
j4_ . fecha_no_aprobada AS fecha_no_aprobada_38 ,
j4_ . horas_sometidas AS horas_sometidas_39 ,
j4_ . horas_aprobadas_override AS horas_aprobadas_override_40 ,
p5_ . id AS id_41 ,
p5_ . profesion AS profesion_42 ,
p5_ . siglas AS siglas_43 ,
p5_ . codigo_profesion AS codigo_profesion_44 ,
p5_ . horas_requeridas_total AS horas_requeridas_total_45 ,
p5_ . horas_requeridas_presencial AS horas_requeridas_presencial_46 ,
p5_ . is_default AS is_default_47 ,
p5_ . is_featured AS is_featured_48 ,
p5_ . slug AS slug_49 ,
p5_ . is_public AS is_public_50 ,
p5_ . icon AS icon_51 ,
a0_ . aprobacion_id AS aprobacion_id_52 ,
a0_ . actividad_status_id AS actividad_status_id_53 ,
a0_ . codigo_id AS codigo_id_54 ,
a0_ . actividad_class_id AS actividad_class_id_55 ,
a1_ . aprobacion_name_id AS aprobacion_name_id_56 ,
a1_ . aprobacion_class_id AS aprobacion_class_id_57 ,
j4_ . aprobacion_id AS aprobacion_id_58 ,
j4_ . profesion_id AS profesion_id_59 ,
j4_ . junta_status_id AS junta_status_id_60
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
Copy
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 , a0_ . slug AS slug_6 , a1_ . id AS id_7 , a1_ . fecha_sometida AS fecha_sometida_8 , a1_ . fecha_inicial AS fecha_inicial_9 , a1_ . codigo_asignado AS codigo_asignado_10 , a1_ . horas_sometidas AS horas_sometidas_11 , a1_ . precio_regular AS precio_regular_12 , a1_ . duracion AS duracion_13 , a1_ . codigo_inicial AS codigo_inicial_14 , a1_ . codigo_final AS codigo_final_15 , a1_ . is_active AS is_active_16 , a1_ . aprobacion_status AS aprobacion_status_17 , a1_ . added_juntas AS added_juntas_18 , a1_ . fecha_aprobada AS fecha_aprobada_19 , a2_ . id AS id_20 , a2_ . title AS title_21 , a2_ . is_modulo AS is_modulo_22 , a2_ . is_active AS is_active_23 , a2_ . image_name AS image_name_24 , a2_ . image_size AS image_size_25 , a2_ . pdf_name AS pdf_name_26 , a2_ . pdf_size AS pdf_size_27 , a2_ . updated_at AS updated_at_28 , a2_ . description AS description_29 , a3_ . id AS id_30 , a3_ . status AS status_31 , a3_ . orden AS orden_32 , a3_ . label_color AS label_color_33 , j4_ . id AS id_34 , j4_ . horas_aprobadas AS horas_aprobadas_35 , j4_ . fecha_aprobada AS fecha_aprobada_36 , j4_ . fecha_sometida AS fecha_sometida_37 , j4_ . fecha_no_aprobada AS fecha_no_aprobada_38 , j4_ . horas_sometidas AS horas_sometidas_39 , j4_ . horas_aprobadas_override AS horas_aprobadas_override_40 , p5_ . id AS id_41 , p5_ . profesion AS profesion_42 , p5_ . siglas AS siglas_43 , p5_ . codigo_profesion AS codigo_profesion_44 , p5_ . horas_requeridas_total AS horas_requeridas_total_45 , p5_ . horas_requeridas_presencial AS horas_requeridas_presencial_46 , p5_ . is_default AS is_default_47 , p5_ . is_featured AS is_featured_48 , p5_ . slug AS slug_49 , p5_ . is_public AS is_public_50 , p5_ . icon AS icon_51 , a0_ . aprobacion_id AS aprobacion_id_52 , a0_ . actividad_status_id AS actividad_status_id_53 , a0_ . codigo_id AS codigo_id_54 , a0_ . actividad_class_id AS actividad_class_id_55 , a1_ . aprobacion_name_id AS aprobacion_name_id_56 , a1_ . aprobacion_class_id AS aprobacion_class_id_57 , j4_ . aprobacion_id AS aprobacion_id_58 , j4_ . profesion_id AS profesion_id_59 , j4_ . junta_status_id AS junta_status_id_60 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 > '2026-02-25 14:17:41' AND j4_ . horas_aprobadas > 0 AND j4_ . junta_status_id = 3 ORDER BY a0_ . fecha ASC , a2_ . title ASC ;
Copy