Comienza: 11-09-2023
Duración: 99 Días
Curso Autogestionado
Duración: 99 Siglos
Comienza: 14-08-2023
Duración: 87 Meses
Duración: 99 Semanas
Duración: 99 Meses
Comienza: 28-08-2023
Comienza: 04-09-2023
Comienza: 25-09-2023
courses
educationLevels
receivers
modalities
dynamicTypes
areaTematica
categoria
evaluationTypes
certificationTypes
providers
filtersApplied
provider
obLevel
__env
app
errors
title
filters
key
current
course
today
endDate
left
diffDays
legend
style
start
paginator
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '27' limit 1
SELECT *
LIMIT
ORDER BY
select count(*) as aggregate from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27'
select distinct "courses".*, case WHEN (current_timestamp BETWEEN start_date_inscription and end_date_inscription) AND (inscribed < quota) THEN 999998 ELSE 999999 END ordenamiento from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' order by ordenamiento asc, "courses"."id" desc, "start_date_inscription" asc limit 12 offset 0
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('461', '458', '457', '451', '447', '438', '432', '431')
select * from "duration_types" where "duration_types"."deleted_at" is null and "duration_types"."id" in ('5', '4', '3', '2')
select "areas_tematicas".*, "model_course_area"."model_course_id" as "pivot_model_course_id", "model_course_area"."area_tematica_id" as "pivot_area_tematica_id", "model_course_area"."created_at" as "pivot_created_at", "model_course_area"."updated_at" as "pivot_updated_at" from "areas_tematicas" inner join "model_course_area" on "areas_tematicas"."id" = "model_course_area"."area_tematica_id" where "areas_tematicas"."deleted_at" is null and "model_course_area"."model_course_id" in ('431', '432', '438', '447', '451', '457', '458', '461')
select "categorias".*, "model_course_categoria"."model_course_id" as "pivot_model_course_id", "model_course_categoria"."categoria_id" as "pivot_categoria_id", "model_course_categoria"."created_at" as "pivot_created_at", "model_course_categoria"."updated_at" as "pivot_updated_at" from "categorias" inner join "model_course_categoria" on "categorias"."id" = "model_course_categoria"."categoria_id" where "categorias"."deleted_at" is null and "model_course_categoria"."model_course_id" in ('431', '432', '438', '447', '451', '457', '458', '461')
select distinct "education_levels"."id" as "id", "education_levels"."description" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_education_level" on "course_education_level"."course_id" = "courses"."id" inner join "education_levels" on "education_levels"."id" = "course_education_level"."education_level_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "education_levels"."id", "education_levels"."description"
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
select distinct "modalities"."id" as "id", "modalities"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_modality" on "course_modality"."course_id" = "courses"."id" inner join "modalities" on "modalities"."id" = "course_modality"."modality_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "modalities"."id", "modalities"."description"
select distinct "dynamic_types"."id" as "id", "dynamic_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "dynamic_types" on "model_courses"."dynamic_type_id" = "dynamic_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "dynamic_types"."id", "dynamic_types"."description"
select distinct "areas_tematicas"."id" as "id", "areas_tematicas"."titulo" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "model_course_area" on "model_course_area"."model_course_id" = "model_courses"."id" inner join "areas_tematicas" on "areas_tematicas"."id" = "model_course_area"."area_tematica_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "areas_tematicas"."id", "areas_tematicas"."titulo"
select distinct "categorias"."id" as "id", "categorias"."titulo" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_categoria" on "course_categoria"."course_id" = "courses"."id" inner join "categorias" on "categorias"."id" = "course_categoria"."categoria_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "categorias"."id", "categorias"."titulo"
select distinct "evaluation_types"."id" as "id", "evaluation_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "evaluation_types" on "model_courses"."evaluation_type_id" = "evaluation_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "evaluation_types"."id", "evaluation_types"."description"
select distinct "certification_types"."id" as "id", "certification_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "certification_types" on "model_courses"."certification_type_id" = "certification_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' and "courses"."certifiable" = '1' group by "certification_types"."id", "certification_types"."description"
select distinct "provinces"."id" as "id", "provinces"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_province" on "course_province"."course_id" = "courses"."id" inner join "provinces" on "provinces"."id" = "course_province"."province_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "provinces"."id", "provinces"."description" order by "provinces"."description" asc
select distinct "providers"."id" as "id", "providers"."name", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "providers" on "model_courses"."provider_id" = "providers"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '27' group by "providers"."id", "providers"."name"
select * from "providers" where "providers"."deleted_at" is null and "providers"."id" is null limit 1
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '461'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '458'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '457'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '451'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '447'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '438'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '432'
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '431'
