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: 5 Días
Comienza: 10-08-2023
Duración: 20 Días
Duración: 99 Semanas
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 count(*) as aggregate from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_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')
select "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" 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') 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', '456', '455', '453', '451', '452', '450', '449')
SELECT *
select * from "duration_types" where "duration_types"."deleted_at" is null and "duration_types"."id" in ('2', '3', '4', '5')
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 ('449', '450', '451', '452', '453', '455', '456', '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 ('449', '450', '451', '452', '453', '455', '456', '457', '458', '461')
select "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" 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') 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 "receivers"."id" as "id", "receivers"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" inner join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "receivers" on "receivers"."id" = "course_receiver"."receiver_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') group by "receivers"."id", "receivers"."description"
select "modalities"."id" as "id", "modalities"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_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') group by "modalities"."id", "modalities"."description"
select "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" 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') group by "dynamic_types"."id", "dynamic_types"."description"
select "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" 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') group by "areas_tematicas"."id", "areas_tematicas"."titulo"
select "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" 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') group by "categorias"."id", "categorias"."titulo"
select "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" 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') group by "evaluation_types"."id", "evaluation_types"."description"
select "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" 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 "courses"."certifiable" = '1' group by "certification_types"."id", "certification_types"."description"
select "provinces"."id" as "id", "provinces"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_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') group by "provinces"."id", "provinces"."description" order by "provinces"."description" asc
select "providers"."id" as "id", "providers"."name", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_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') group by "providers"."id", "providers"."name"
select * from "providers" where "providers"."deleted_at" is null and "providers"."id" is null limit 1
LIMIT
ORDER BY
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" = '456'
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" = '455'
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" = '453'
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" = '452'
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" = '450'
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" = '449'
