Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.edad_minima AS edad_minima_3,
  t0.edad_maxima AS edad_maxima_4,
  t0.sexo AS sexo_5,
  t0.hcp_min AS hcp_min_6,
  t0.hcp_max AS hcp_max_7,
  t0.fecha_inicio AS fecha_inicio_8,
  t0.fecha_fin AS fecha_fin_9,
  t0.minimo_pruebas AS minimo_pruebas_10,
  t0.pruebas_puntuables AS pruebas_puntuables_11,
  t0.mejores_pruebas AS mejores_pruebas_12,
  t0.puntos_extra_participacion AS puntos_extra_participacion_13,
  t0.desempate AS desempate_14,
  t0.desempate2 AS desempate2_15,
  t0.activo AS activo_16,
  t0.parejas AS parejas_17,
  t0.federadosRegionales AS federadosRegionales_18,
  t0.modalidad AS modalidad_19,
  t0.titulo_competicion AS titulo_competicion_20,
  t0.generated_at AS generated_at_21,
  t0.tipo_final AS tipo_final_22,
  t0.excluir_final AS excluir_final_23,
  t0.observations AS observations_24,
  t0.ranking_type AS ranking_type_25,
  t0.include_special_tee AS include_special_tee_26,
  t0.agrupation AS agrupation_27,
  t0.only_club_players AS only_club_players_28,
  t0.Nivel_id AS Nivel_id_29,
  t30.id AS id_31,
  t30.puntos AS puntos_32,
  t30.Ranking_id AS Ranking_id_33,
  t0.Cliente_id AS Cliente_id_34,
  t35.id AS id_36,
  t35.normativa AS normativa_37,
  t35.ranking_id AS ranking_id_38,
  t0.Competicion_id AS Competicion_id_39,
  t0.club_id AS club_id_40,
  t0.ranking_point_position_template_id AS ranking_point_position_template_id_41
FROM
  Ranking t0
  LEFT JOIN ParScratch t30 ON t30.Ranking_id = t0.id
  LEFT JOIN RankingNormativa t35 ON t35.ranking_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.edad_minima AS edad_minima_3, t0.edad_maxima AS edad_maxima_4, t0.sexo AS sexo_5, t0.hcp_min AS hcp_min_6, t0.hcp_max AS hcp_max_7, t0.fecha_inicio AS fecha_inicio_8, t0.fecha_fin AS fecha_fin_9, t0.minimo_pruebas AS minimo_pruebas_10, t0.pruebas_puntuables AS pruebas_puntuables_11, t0.mejores_pruebas AS mejores_pruebas_12, t0.puntos_extra_participacion AS puntos_extra_participacion_13, t0.desempate AS desempate_14, t0.desempate2 AS desempate2_15, t0.activo AS activo_16, t0.parejas AS parejas_17, t0.federadosRegionales AS federadosRegionales_18, t0.modalidad AS modalidad_19, t0.titulo_competicion AS titulo_competicion_20, t0.generated_at AS generated_at_21, t0.tipo_final AS tipo_final_22, t0.excluir_final AS excluir_final_23, t0.observations AS observations_24, t0.ranking_type AS ranking_type_25, t0.include_special_tee AS include_special_tee_26, t0.agrupation AS agrupation_27, t0.only_club_players AS only_club_players_28, t0.Nivel_id AS Nivel_id_29, t30.id AS id_31, t30.puntos AS puntos_32, t30.Ranking_id AS Ranking_id_33, t0.Cliente_id AS Cliente_id_34, t35.id AS id_36, t35.normativa AS normativa_37, t35.ranking_id AS ranking_id_38, t0.Competicion_id AS Competicion_id_39, t0.club_id AS club_id_40, t0.ranking_point_position_template_id AS ranking_point_position_template_id_41 FROM Ranking t0 LEFT JOIN ParScratch t30 ON t30.Ranking_id = t0.id LEFT JOIN RankingNormativa t35 ON t35.ranking_id = t0.id WHERE t0.id = 40;

SELECT
  t0.id AS id_1,
  t0.orden AS orden_2,
  t0.forzado AS forzado_3,
  t0.Ranking_id AS Ranking_id_4
FROM
  ClasificadoRanking t0
WHERE
  t0.Ranking_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.orden AS orden_2, t0.forzado AS forzado_3, t0.Ranking_id AS Ranking_id_4 FROM ClasificadoRanking t0 WHERE t0.Ranking_id = 40 ORDER BY t0.orden ASC;

SELECT
  pr.puntos,
  pr.es_mejor_prueba,
  jor.id AS jornada,
  cr.id AS jugador,
  i.id AS inscrito,
  COALESCE(comp.id, c2.id) AS competitionId,
  ec.id AS externalCompetitionId,
  COALESCE(
    (
      SELECT
        SUM(per.puntos)
      FROM
        PenalidadRanking per
        INNER JOIN CompeticionRanking cr2 ON cr2.id = per.ranking_competition_id
      WHERE
        per.ClasificadoRanking_id = cr.id
        AND (
          cr2.external_competition_id = ec.id
          OR cr2.Competicion_id = comp.id
        )
    ),
    0
  ) AS puntosPenalidad,
  COALESCE(
    (
      SELECT
        SUM(br.puntos)
      FROM
        bonus_ranking br
        INNER JOIN CompeticionRanking cr2 ON cr2.id = br.ranking_competition_id
      WHERE
        br.clasificado_ranking_id = cr.id
        AND (
          cr2.external_competition_id = ec.id
          OR cr2.Competicion_id = comp.id
        )
    ),
    0
  ) AS puntosBonus
FROM
  ClasificadoRanking cr
  INNER JOIN jugadores_ranking jr ON jr.ClasificadoRanking_id = cr.id
  INNER JOIN Jugador j ON j.id = jr.Jugador_id
  INNER JOIN PuntosRanking pr ON pr.ClasificadoRanking_id = cr.id
  LEFT JOIN Jornada jor ON pr.Jornada_id = jor.id
  LEFT JOIN Competicion c2 ON jor.Competicion_id = c2.id
  LEFT JOIN Competicion comp ON pr.competition_id = comp.id
  LEFT JOIN external_competition ec ON pr.external_competition_id = ec.id
  LEFT JOIN Inscrito i ON i.Jugador_id = j.id
  AND (
    i.Competicion_id = comp.id
    OR i.Competicion_id = c2.id
  )
WHERE
  cr.Ranking_id = ?
  AND cr.forzado != -1
  AND (
    i.estado = 'pagado'
    OR i.id IS NULL
  )
ORDER BY
  j.apellidos,
  j.nombre

SELECT pr.puntos, pr.es_mejor_prueba, jor.id AS jornada, cr.id AS jugador, i.id AS inscrito,
            COALESCE(comp.id, c2.id) AS competitionId, ec.id AS externalCompetitionId,
            COALESCE((SELECT SUM(per.puntos) FROM PenalidadRanking per
            INNER JOIN CompeticionRanking cr2 ON cr2.id = per.ranking_competition_id
            WHERE per.ClasificadoRanking_id = cr.id AND (cr2.external_competition_id = ec.id OR cr2.Competicion_id = comp.id)
            ), 0) AS puntosPenalidad,
            COALESCE((SELECT SUM(br.puntos) FROM bonus_ranking br
            INNER JOIN CompeticionRanking cr2 ON cr2.id = br.ranking_competition_id
            WHERE br.clasificado_ranking_id = cr.id AND (cr2.external_competition_id = ec.id OR cr2.Competicion_id = comp.id)
            ), 0) AS puntosBonus
            FROM ClasificadoRanking cr
            INNER JOIN jugadores_ranking jr ON jr.ClasificadoRanking_id = cr.id
            INNER JOIN Jugador j ON j.id = jr.Jugador_id
            INNER JOIN PuntosRanking pr ON pr.ClasificadoRanking_id = cr.id
            LEFT JOIN Jornada jor ON pr.Jornada_id = jor.id
            LEFT JOIN Competicion c2 ON jor.Competicion_id = c2.id
            LEFT JOIN Competicion comp ON pr.competition_id = comp.id
            LEFT JOIN external_competition ec ON pr.external_competition_id = ec.id
            LEFT JOIN Inscrito i ON i.Jugador_id = j.id AND (i.Competicion_id = comp.id OR i.Competicion_id = c2.id)
            WHERE cr.Ranking_id = 40 AND cr.forzado != -1 AND (i.estado = 'pagado' OR i.id IS NULL)
            ORDER BY j.apellidos, j.nombre
        ;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nombre_corto AS nombre_corto_3,
  t0.url_privacidad AS url_privacidad_4,
  t0.cif AS cif_5,
  t0.prioridad AS prioridad_6,
  t0.iban AS iban_7,
  t0.comision AS comision_8,
  t0.minimo_competicion AS minimo_competicion_9,
  t0.minimo_inscripcion AS minimo_inscripcion_10,
  t0.comision_devolucion AS comision_devolucion_11,
  t0.comision_cancelacion AS comision_cancelacion_12,
  t0.comision_sustitucion AS comision_sustitucion_13,
  t0.letra_facturacion AS letra_facturacion_14,
  t0.habilitado_contabilidad AS habilitado_contabilidad_15,
  t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16,
  t0.limite_devoluciones AS limite_devoluciones_17,
  t0.cod_cliente AS cod_cliente_18,
  t0.razon_social AS razon_social_19,
  t0.direccion_facturacion AS direccion_facturacion_20,
  t0.politica_entrega AS politica_entrega_21,
  t0.politica_inicio AS politica_inicio_22,
  t0.tipo AS tipo_23,
  t24.id AS id_25,
  t24.nombre AS nombre_26,
  t24.Cliente_id AS Cliente_id_27,
  t24.Region_id AS Region_id_28
FROM
  Cliente t0
  LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.jornadas_independientes AS jornadas_independientes_2,
  t0.Competicion_id AS Competicion_id_3,
  t0.Ranking_id AS Ranking_id_4,
  t0.external_competition_id AS external_competition_id_5
FROM
  CompeticionRanking t0
WHERE
  t0.Ranking_id = ?

SELECT t0.id AS id_1, t0.jornadas_independientes AS jornadas_independientes_2, t0.Competicion_id AS Competicion_id_3, t0.Ranking_id AS Ranking_id_4, t0.external_competition_id AS external_competition_id_5 FROM CompeticionRanking t0 WHERE t0.Ranking_id = 40;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.codigo_contable AS codigo_contable_3,
  t0.nombre AS nombre_4,
  t0.fecha AS fecha_5,
  t0.inicio AS inicio_6,
  t0.fin AS fin_7,
  t0.plazas AS plazas_8,
  t0.jugadores AS jugadores_9,
  t0.observaciones AS observaciones_10,
  t0.observaciones_planificacion AS observaciones_planificacion_11,
  t0.aviso AS aviso_12,
  t0.informacion AS informacion_13,
  t0.rfeg_id AS rfeg_id_14,
  t0.cartel AS cartel_15,
  t0.horario AS horario_16,
  t0.fichero_inscritos AS fichero_inscritos_17,
  t0.fichero_clasificaciones AS fichero_clasificaciones_18,
  t0.fichero_localeRulePdf AS fichero_localeRulePdf_19,
  t0.fichero_banner_schedule AS fichero_banner_schedule_20,
  t0.fichero_reglas AS fichero_reglas_21,
  t0.fichero_varios_nombre AS fichero_varios_nombre_22,
  t0.fichero_varios AS fichero_varios_23,
  t0.circular AS circular_24,
  t0.nombre_observaciones AS nombre_observaciones_25,
  t0.hash AS hash_26,
  t0.estado AS estado_27,
  t0.estado_corte AS estado_corte_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.tarifa_reglamento AS tarifa_reglamento_31,
  t0.redireccion AS redireccion_32,
  t0.wagr AS wagr_33,
  t0.subvencion_junta AS subvencion_junta_34,
  t0.galeria AS galeria_35,
  t0.informacion_popup AS informacion_popup_36,
  t0.reglas AS reglas_37,
  t0.num_competiciones AS num_competiciones_38,
  t0.tag_color AS tag_color_39,
  t0.show_live_scoring AS show_live_scoring_40,
  t0.rfc AS rfc_41,
  t0.estricto AS estricto_42,
  t0.hcp_estricto AS hcp_estricto_43,
  t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44,
  t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45,
  t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46,
  t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47,
  t0.hcp_juego_masculino AS hcp_juego_masculino_48,
  t0.hcp_juego_femenino AS hcp_juego_femenino_49,
  t0.hcp_juego_pareja AS hcp_juego_pareja_50,
  t0.hcp_juego_equipo AS hcp_juego_equipo_51,
  t0.premios AS premios_52,
  t0.arbitrable AS arbitrable_53,
  t0.direccion_torneos AS direccion_torneos_54,
  t0.asistencia_presidente AS asistencia_presidente_55,
  t0.institucional AS institucional_56,
  t0.voluntarios AS voluntarios_57,
  t0.flyer AS flyer_58,
  t0.permitir AS permitir_59,
  t0.social AS social_60,
  t0.visible AS visible_61,
  t0.seguimiento AS seguimiento_62,
  t0.popup_inscripcion AS popup_inscripcion_63,
  t0.popup_inscripcion_texto AS popup_inscripcion_texto_64,
  t0.mostrar_sorteo AS mostrar_sorteo_65,
  t0.malaga2020 AS malaga2020_66,
  t0.lista_espera AS lista_espera_67,
  t0.restringir_licencia AS restringir_licencia_68,
  t0.seleccion_tarifas AS seleccion_tarifas_69,
  t0.permitir_extranjeros AS permitir_extranjeros_70,
  t0.plazas_manana AS plazas_manana_71,
  t0.plazas_tarde AS plazas_tarde_72,
  t0.tarjeta_electronica AS tarjeta_electronica_73,
  t0.auto_assign_marker AS auto_assign_marker_74,
  t0.livescoring_comunidad AS livescoring_comunidad_75,
  t0.plazas_lista_espera AS plazas_lista_espera_76,
  t0.deleted_at AS deleted_at_77,
  t0.contacto AS contacto_78,
  t0.benefico AS benefico_79,
  t0.flickr_gallery AS flickr_gallery_80,
  t0.barra_salida AS barra_salida_81,
  t0.observaciones_frontend AS observaciones_frontend_82,
  t0.mostrar_plazas AS mostrar_plazas_83,
  t0.politica_inicio AS politica_inicio_84,
  t0.politica_entrega AS politica_entrega_85,
  t0.short_url AS short_url_86,
  t0.privada AS privada_87,
  t0.camera_url AS camera_url_88,
  t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89,
  t0.liquidation_date AS liquidation_date_90,
  t0.collection_date AS collection_date_91,
  t0.livescoring_policy AS livescoring_policy_92,
  t0.livescoring_formula AS livescoring_formula_93,
  t0.show_events AS show_events_94,
  t0.destacada AS destacada_95,
  t0.Formula_id AS Formula_id_96,
  t0.Modo_id AS Modo_id_97,
  t0.Calculo_id AS Calculo_id_98,
  t0.Club_id AS Club_id_99,
  t0.Organizador_id AS Organizador_id_100,
  t0.Criterio_id AS Criterio_id_101,
  t0.Criterio2_id AS Criterio2_id_102,
  t103.id AS id_104,
  t103.created_at AS created_at_105,
  t103.updated_at AS updated_at_106,
  t103.jugador_id AS jugador_id_107,
  t103.competicion_id AS competicion_id_108
FROM
  Competicion t0
  LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.codigo_contable AS codigo_contable_3, t0.nombre AS nombre_4, t0.fecha AS fecha_5, t0.inicio AS inicio_6, t0.fin AS fin_7, t0.plazas AS plazas_8, t0.jugadores AS jugadores_9, t0.observaciones AS observaciones_10, t0.observaciones_planificacion AS observaciones_planificacion_11, t0.aviso AS aviso_12, t0.informacion AS informacion_13, t0.rfeg_id AS rfeg_id_14, t0.cartel AS cartel_15, t0.horario AS horario_16, t0.fichero_inscritos AS fichero_inscritos_17, t0.fichero_clasificaciones AS fichero_clasificaciones_18, t0.fichero_localeRulePdf AS fichero_localeRulePdf_19, t0.fichero_banner_schedule AS fichero_banner_schedule_20, t0.fichero_reglas AS fichero_reglas_21, t0.fichero_varios_nombre AS fichero_varios_nombre_22, t0.fichero_varios AS fichero_varios_23, t0.circular AS circular_24, t0.nombre_observaciones AS nombre_observaciones_25, t0.hash AS hash_26, t0.estado AS estado_27, t0.estado_corte AS estado_corte_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.tarifa_reglamento AS tarifa_reglamento_31, t0.redireccion AS redireccion_32, t0.wagr AS wagr_33, t0.subvencion_junta AS subvencion_junta_34, t0.galeria AS galeria_35, t0.informacion_popup AS informacion_popup_36, t0.reglas AS reglas_37, t0.num_competiciones AS num_competiciones_38, t0.tag_color AS tag_color_39, t0.show_live_scoring AS show_live_scoring_40, t0.rfc AS rfc_41, t0.estricto AS estricto_42, t0.hcp_estricto AS hcp_estricto_43, t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44, t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45, t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46, t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47, t0.hcp_juego_masculino AS hcp_juego_masculino_48, t0.hcp_juego_femenino AS hcp_juego_femenino_49, t0.hcp_juego_pareja AS hcp_juego_pareja_50, t0.hcp_juego_equipo AS hcp_juego_equipo_51, t0.premios AS premios_52, t0.arbitrable AS arbitrable_53, t0.direccion_torneos AS direccion_torneos_54, t0.asistencia_presidente AS asistencia_presidente_55, t0.institucional AS institucional_56, t0.voluntarios AS voluntarios_57, t0.flyer AS flyer_58, t0.permitir AS permitir_59, t0.social AS social_60, t0.visible AS visible_61, t0.seguimiento AS seguimiento_62, t0.popup_inscripcion AS popup_inscripcion_63, t0.popup_inscripcion_texto AS popup_inscripcion_texto_64, t0.mostrar_sorteo AS mostrar_sorteo_65, t0.malaga2020 AS malaga2020_66, t0.lista_espera AS lista_espera_67, t0.restringir_licencia AS restringir_licencia_68, t0.seleccion_tarifas AS seleccion_tarifas_69, t0.permitir_extranjeros AS permitir_extranjeros_70, t0.plazas_manana AS plazas_manana_71, t0.plazas_tarde AS plazas_tarde_72, t0.tarjeta_electronica AS tarjeta_electronica_73, t0.auto_assign_marker AS auto_assign_marker_74, t0.livescoring_comunidad AS livescoring_comunidad_75, t0.plazas_lista_espera AS plazas_lista_espera_76, t0.deleted_at AS deleted_at_77, t0.contacto AS contacto_78, t0.benefico AS benefico_79, t0.flickr_gallery AS flickr_gallery_80, t0.barra_salida AS barra_salida_81, t0.observaciones_frontend AS observaciones_frontend_82, t0.mostrar_plazas AS mostrar_plazas_83, t0.politica_inicio AS politica_inicio_84, t0.politica_entrega AS politica_entrega_85, t0.short_url AS short_url_86, t0.privada AS privada_87, t0.camera_url AS camera_url_88, t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89, t0.liquidation_date AS liquidation_date_90, t0.collection_date AS collection_date_91, t0.livescoring_policy AS livescoring_policy_92, t0.livescoring_formula AS livescoring_formula_93, t0.show_events AS show_events_94, t0.destacada AS destacada_95, t0.Formula_id AS Formula_id_96, t0.Modo_id AS Modo_id_97, t0.Calculo_id AS Calculo_id_98, t0.Club_id AS Club_id_99, t0.Organizador_id AS Organizador_id_100, t0.Criterio_id AS Criterio_id_101, t0.Criterio2_id AS Criterio2_id_102, t103.id AS id_104, t103.created_at AS created_at_105, t103.updated_at AS updated_at_106, t103.jugador_id AS jugador_id_107, t103.competicion_id AS competicion_id_108 FROM Competicion t0 LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id WHERE t0.id = 47799 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.orden AS orden_3,
  t0.created_at AS created_at_4,
  t0.procesada AS procesada_5,
  t0.sms_hcp AS sms_hcp_6,
  t0.asc_valor AS asc_valor_7,
  t0.clima AS clima_8,
  t0.zona_bandera AS zona_bandera_9,
  t0.sensibilidad AS sensibilidad_10,
  t0.bloqueo AS bloqueo_11,
  t0.team_livescoring AS team_livescoring_12,
  t0.scramble_estricto AS scramble_estricto_13,
  t0.Competicion_id AS Competicion_id_14,
  t0.Modalidad_id AS Modalidad_id_15,
  t0.Trazado_id AS Trazado_id_16,
  t17.id AS id_18,
  t17.value AS value_19,
  t17.created_at AS created_at_20,
  t17.updated_at AS updated_at_21,
  t17.jornada_id AS jornada_id_22,
  t17.ranking_id AS ranking_id_23
FROM
  Jornada t0
  LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id
WHERE
  t0.Competicion_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = 47799 ORDER BY t0.orden ASC;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.codigo_contable AS codigo_contable_3,
  t0.nombre AS nombre_4,
  t0.fecha AS fecha_5,
  t0.inicio AS inicio_6,
  t0.fin AS fin_7,
  t0.plazas AS plazas_8,
  t0.jugadores AS jugadores_9,
  t0.observaciones AS observaciones_10,
  t0.observaciones_planificacion AS observaciones_planificacion_11,
  t0.aviso AS aviso_12,
  t0.informacion AS informacion_13,
  t0.rfeg_id AS rfeg_id_14,
  t0.cartel AS cartel_15,
  t0.horario AS horario_16,
  t0.fichero_inscritos AS fichero_inscritos_17,
  t0.fichero_clasificaciones AS fichero_clasificaciones_18,
  t0.fichero_localeRulePdf AS fichero_localeRulePdf_19,
  t0.fichero_banner_schedule AS fichero_banner_schedule_20,
  t0.fichero_reglas AS fichero_reglas_21,
  t0.fichero_varios_nombre AS fichero_varios_nombre_22,
  t0.fichero_varios AS fichero_varios_23,
  t0.circular AS circular_24,
  t0.nombre_observaciones AS nombre_observaciones_25,
  t0.hash AS hash_26,
  t0.estado AS estado_27,
  t0.estado_corte AS estado_corte_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.tarifa_reglamento AS tarifa_reglamento_31,
  t0.redireccion AS redireccion_32,
  t0.wagr AS wagr_33,
  t0.subvencion_junta AS subvencion_junta_34,
  t0.galeria AS galeria_35,
  t0.informacion_popup AS informacion_popup_36,
  t0.reglas AS reglas_37,
  t0.num_competiciones AS num_competiciones_38,
  t0.tag_color AS tag_color_39,
  t0.show_live_scoring AS show_live_scoring_40,
  t0.rfc AS rfc_41,
  t0.estricto AS estricto_42,
  t0.hcp_estricto AS hcp_estricto_43,
  t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44,
  t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45,
  t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46,
  t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47,
  t0.hcp_juego_masculino AS hcp_juego_masculino_48,
  t0.hcp_juego_femenino AS hcp_juego_femenino_49,
  t0.hcp_juego_pareja AS hcp_juego_pareja_50,
  t0.hcp_juego_equipo AS hcp_juego_equipo_51,
  t0.premios AS premios_52,
  t0.arbitrable AS arbitrable_53,
  t0.direccion_torneos AS direccion_torneos_54,
  t0.asistencia_presidente AS asistencia_presidente_55,
  t0.institucional AS institucional_56,
  t0.voluntarios AS voluntarios_57,
  t0.flyer AS flyer_58,
  t0.permitir AS permitir_59,
  t0.social AS social_60,
  t0.visible AS visible_61,
  t0.seguimiento AS seguimiento_62,
  t0.popup_inscripcion AS popup_inscripcion_63,
  t0.popup_inscripcion_texto AS popup_inscripcion_texto_64,
  t0.mostrar_sorteo AS mostrar_sorteo_65,
  t0.malaga2020 AS malaga2020_66,
  t0.lista_espera AS lista_espera_67,
  t0.restringir_licencia AS restringir_licencia_68,
  t0.seleccion_tarifas AS seleccion_tarifas_69,
  t0.permitir_extranjeros AS permitir_extranjeros_70,
  t0.plazas_manana AS plazas_manana_71,
  t0.plazas_tarde AS plazas_tarde_72,
  t0.tarjeta_electronica AS tarjeta_electronica_73,
  t0.auto_assign_marker AS auto_assign_marker_74,
  t0.livescoring_comunidad AS livescoring_comunidad_75,
  t0.plazas_lista_espera AS plazas_lista_espera_76,
  t0.deleted_at AS deleted_at_77,
  t0.contacto AS contacto_78,
  t0.benefico AS benefico_79,
  t0.flickr_gallery AS flickr_gallery_80,
  t0.barra_salida AS barra_salida_81,
  t0.observaciones_frontend AS observaciones_frontend_82,
  t0.mostrar_plazas AS mostrar_plazas_83,
  t0.politica_inicio AS politica_inicio_84,
  t0.politica_entrega AS politica_entrega_85,
  t0.short_url AS short_url_86,
  t0.privada AS privada_87,
  t0.camera_url AS camera_url_88,
  t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89,
  t0.liquidation_date AS liquidation_date_90,
  t0.collection_date AS collection_date_91,
  t0.livescoring_policy AS livescoring_policy_92,
  t0.livescoring_formula AS livescoring_formula_93,
  t0.show_events AS show_events_94,
  t0.destacada AS destacada_95,
  t0.Formula_id AS Formula_id_96,
  t0.Modo_id AS Modo_id_97,
  t0.Calculo_id AS Calculo_id_98,
  t0.Club_id AS Club_id_99,
  t0.Organizador_id AS Organizador_id_100,
  t0.Criterio_id AS Criterio_id_101,
  t0.Criterio2_id AS Criterio2_id_102,
  t103.id AS id_104,
  t103.created_at AS created_at_105,
  t103.updated_at AS updated_at_106,
  t103.jugador_id AS jugador_id_107,
  t103.competicion_id AS competicion_id_108
FROM
  Competicion t0
  LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.codigo_contable AS codigo_contable_3, t0.nombre AS nombre_4, t0.fecha AS fecha_5, t0.inicio AS inicio_6, t0.fin AS fin_7, t0.plazas AS plazas_8, t0.jugadores AS jugadores_9, t0.observaciones AS observaciones_10, t0.observaciones_planificacion AS observaciones_planificacion_11, t0.aviso AS aviso_12, t0.informacion AS informacion_13, t0.rfeg_id AS rfeg_id_14, t0.cartel AS cartel_15, t0.horario AS horario_16, t0.fichero_inscritos AS fichero_inscritos_17, t0.fichero_clasificaciones AS fichero_clasificaciones_18, t0.fichero_localeRulePdf AS fichero_localeRulePdf_19, t0.fichero_banner_schedule AS fichero_banner_schedule_20, t0.fichero_reglas AS fichero_reglas_21, t0.fichero_varios_nombre AS fichero_varios_nombre_22, t0.fichero_varios AS fichero_varios_23, t0.circular AS circular_24, t0.nombre_observaciones AS nombre_observaciones_25, t0.hash AS hash_26, t0.estado AS estado_27, t0.estado_corte AS estado_corte_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.tarifa_reglamento AS tarifa_reglamento_31, t0.redireccion AS redireccion_32, t0.wagr AS wagr_33, t0.subvencion_junta AS subvencion_junta_34, t0.galeria AS galeria_35, t0.informacion_popup AS informacion_popup_36, t0.reglas AS reglas_37, t0.num_competiciones AS num_competiciones_38, t0.tag_color AS tag_color_39, t0.show_live_scoring AS show_live_scoring_40, t0.rfc AS rfc_41, t0.estricto AS estricto_42, t0.hcp_estricto AS hcp_estricto_43, t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44, t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45, t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46, t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47, t0.hcp_juego_masculino AS hcp_juego_masculino_48, t0.hcp_juego_femenino AS hcp_juego_femenino_49, t0.hcp_juego_pareja AS hcp_juego_pareja_50, t0.hcp_juego_equipo AS hcp_juego_equipo_51, t0.premios AS premios_52, t0.arbitrable AS arbitrable_53, t0.direccion_torneos AS direccion_torneos_54, t0.asistencia_presidente AS asistencia_presidente_55, t0.institucional AS institucional_56, t0.voluntarios AS voluntarios_57, t0.flyer AS flyer_58, t0.permitir AS permitir_59, t0.social AS social_60, t0.visible AS visible_61, t0.seguimiento AS seguimiento_62, t0.popup_inscripcion AS popup_inscripcion_63, t0.popup_inscripcion_texto AS popup_inscripcion_texto_64, t0.mostrar_sorteo AS mostrar_sorteo_65, t0.malaga2020 AS malaga2020_66, t0.lista_espera AS lista_espera_67, t0.restringir_licencia AS restringir_licencia_68, t0.seleccion_tarifas AS seleccion_tarifas_69, t0.permitir_extranjeros AS permitir_extranjeros_70, t0.plazas_manana AS plazas_manana_71, t0.plazas_tarde AS plazas_tarde_72, t0.tarjeta_electronica AS tarjeta_electronica_73, t0.auto_assign_marker AS auto_assign_marker_74, t0.livescoring_comunidad AS livescoring_comunidad_75, t0.plazas_lista_espera AS plazas_lista_espera_76, t0.deleted_at AS deleted_at_77, t0.contacto AS contacto_78, t0.benefico AS benefico_79, t0.flickr_gallery AS flickr_gallery_80, t0.barra_salida AS barra_salida_81, t0.observaciones_frontend AS observaciones_frontend_82, t0.mostrar_plazas AS mostrar_plazas_83, t0.politica_inicio AS politica_inicio_84, t0.politica_entrega AS politica_entrega_85, t0.short_url AS short_url_86, t0.privada AS privada_87, t0.camera_url AS camera_url_88, t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89, t0.liquidation_date AS liquidation_date_90, t0.collection_date AS collection_date_91, t0.livescoring_policy AS livescoring_policy_92, t0.livescoring_formula AS livescoring_formula_93, t0.show_events AS show_events_94, t0.destacada AS destacada_95, t0.Formula_id AS Formula_id_96, t0.Modo_id AS Modo_id_97, t0.Calculo_id AS Calculo_id_98, t0.Club_id AS Club_id_99, t0.Organizador_id AS Organizador_id_100, t0.Criterio_id AS Criterio_id_101, t0.Criterio2_id AS Criterio2_id_102, t103.id AS id_104, t103.created_at AS created_at_105, t103.updated_at AS updated_at_106, t103.jugador_id AS jugador_id_107, t103.competicion_id AS competicion_id_108 FROM Competicion t0 LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id WHERE t0.id = 48069 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.orden AS orden_3,
  t0.created_at AS created_at_4,
  t0.procesada AS procesada_5,
  t0.sms_hcp AS sms_hcp_6,
  t0.asc_valor AS asc_valor_7,
  t0.clima AS clima_8,
  t0.zona_bandera AS zona_bandera_9,
  t0.sensibilidad AS sensibilidad_10,
  t0.bloqueo AS bloqueo_11,
  t0.team_livescoring AS team_livescoring_12,
  t0.scramble_estricto AS scramble_estricto_13,
  t0.Competicion_id AS Competicion_id_14,
  t0.Modalidad_id AS Modalidad_id_15,
  t0.Trazado_id AS Trazado_id_16,
  t17.id AS id_18,
  t17.value AS value_19,
  t17.created_at AS created_at_20,
  t17.updated_at AS updated_at_21,
  t17.jornada_id AS jornada_id_22,
  t17.ranking_id AS ranking_id_23
FROM
  Jornada t0
  LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id
WHERE
  t0.Competicion_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = 48069 ORDER BY t0.orden ASC;