Curso Autogestionado
Duración: 99 Milenios
Comienza: 18-07-2023
Comienza: 24-07-2023
Duración: 99 Semanas
Duración: 99 Días
Duración: 99 Siglos
Comienza: 06-07-2023
Duración: 90 Días
Duración: 20 Días
Duración: 900 Milenios
Duración: 30 Días
Comienza: 27-06-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 "education_levels" where "education_levels"."deleted_at" is null and "education_levels"."id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4'
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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' order by ordenamiento asc, "courses"."id" desc, "start_date_inscription" asc limit 12 offset 36
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('404', '403', '400', '401', '392', '382', '357', '360', '384', '383', '380')
select * from "duration_types" where "duration_types"."deleted_at" is null and "duration_types"."id" in ('6', '5', '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 ('357', '360', '380', '382', '383', '384', '392', '400', '401', '403', '404')
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 ('357', '360', '380', '382', '383', '384', '392', '400', '401', '403', '404')
select distinct "receivers"."id" as "id", "receivers"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_education_level" on "course_education_level"."course_id" = "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') and "course_education_level"."education_level_id" = '4' group by "receivers"."id", "receivers"."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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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_education_level" on "course_education_level"."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_education_level"."education_level_id" = '4' 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" = '404'
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" = '403'
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" = '400'
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" = '401'
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" = '392'
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" = '382'
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" = '357'
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" = '360'
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" = '384'
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" = '383'
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" = '380'
