Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'show_events_limit' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'workshop_terms_es' LIMIT 1;

SELECT 
  c0_.id AS id_0, 
  COALESCE(t9_.content, c0_.slug) AS slug_1, 
  COALESCE(t1_.content, c0_.name) AS name_2, 
  COALESCE(
    t8_.content, c0_.shortDescription
  ) AS shortDescription_3, 
  c0_.imageDescriptionPath AS imageDescriptionPath_4, 
  c15_.imageUrl AS imageUrl_5, 
  c15_.id AS id_6, 
  COALESCE(t16_.content, c15_.name) AS name_7, 
  IFNULL(c24_.date, c24_.originalDate) AS sclr_8 
FROM 
  CourseType c0_ 
  LEFT JOIN CourseLevel c13_ ON c0_.id = c13_.courseType_id 
  LEFT JOIN Course c15_ ON c13_.id = c15_.courseLevel_id 
  LEFT JOIN Term t25_ ON c15_.term_id = t25_.id 
  LEFT JOIN CourseSession c24_ ON c15_.id = c24_.course_id 
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' 
  AND t1_.field = 'name' 
  AND t1_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t1_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' 
  AND t2_.field = 'title' 
  AND t2_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t2_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' 
  AND t3_.field = 'description' 
  AND t3_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t3_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'es' 
  AND t4_.field = 'introductionTitle' 
  AND t4_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t4_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' 
  AND t5_.field = 'introductionDescription' 
  AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t5_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' 
  AND t6_.field = 'ballTitle' 
  AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t6_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t7_ ON t7_.locale = 'es' 
  AND t7_.field = 'ballDescription' 
  AND t7_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t7_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t8_ ON t8_.locale = 'es' 
  AND t8_.field = 'shortDescription' 
  AND t8_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t8_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t9_ ON t9_.locale = 'es' 
  AND t9_.field = 'slug' 
  AND t9_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t9_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t10_ ON t10_.locale = 'es' 
  AND t10_.field = 'noCoursesMessage' 
  AND t10_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t10_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t11_ ON t11_.locale = 'es' 
  AND t11_.field = 'metaTitle' 
  AND t11_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t11_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t12_ ON t12_.locale = 'es' 
  AND t12_.field = 'metaDescription' 
  AND t12_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' 
  AND t12_.foreignKey = c0_.id 
  LEFT JOIN ext_translations t14_ ON t14_.locale = 'es' 
  AND t14_.field = 'name' 
  AND t14_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseLevel' 
  AND t14_.foreignKey = c13_.id 
  LEFT JOIN ext_translations t16_ ON t16_.locale = 'es' 
  AND t16_.field = 'name' 
  AND t16_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t16_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t17_ ON t17_.locale = 'es' 
  AND t17_.field = 'descuentoText1' 
  AND t17_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t17_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t18_ ON t18_.locale = 'es' 
  AND t18_.field = 'descuentoText2' 
  AND t18_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t18_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t19_ ON t19_.locale = 'es' 
  AND t19_.field = 'legal' 
  AND t19_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t19_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t20_ ON t20_.locale = 'es' 
  AND t20_.field = 'descuentoInformation' 
  AND t20_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t20_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t21_ ON t21_.locale = 'es' 
  AND t21_.field = 'publicComments' 
  AND t21_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t21_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t22_ ON t22_.locale = 'es' 
  AND t22_.field = 'asActivity' 
  AND t22_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t22_.foreignKey = c15_.id 
  LEFT JOIN ext_translations t23_ ON t23_.locale = 'es' 
  AND t23_.field = 'priceText' 
  AND t23_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' 
  AND t23_.foreignKey = c15_.id 
WHERE 
  c15_.type = ? 
  AND c24_.date = ? 
  AND c15_.published = 1 
  AND c24_.date <= '2026-08-31'

SELECT c0_.id AS id_0, COALESCE(t9_.content, c0_.slug) AS slug_1, COALESCE(t1_.content, c0_.name) AS name_2, COALESCE(t8_.content, c0_.shortDescription) AS shortDescription_3, c0_.imageDescriptionPath AS imageDescriptionPath_4, c15_.imageUrl AS imageUrl_5, c15_.id AS id_6, COALESCE(t16_.content, c15_.name) AS name_7, IFNULL(c24_.date, c24_.originalDate) AS sclr_8 FROM CourseType c0_ LEFT JOIN CourseLevel c13_ ON c0_.id = c13_.courseType_id LEFT JOIN Course c15_ ON c13_.id = c15_.courseLevel_id LEFT JOIN Term t25_ ON c15_.term_id = t25_.id LEFT JOIN CourseSession c24_ ON c15_.id = c24_.course_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' AND t1_.field = 'name' AND t1_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t1_.foreignKey = c0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' AND t2_.field = 'title' AND t2_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t2_.foreignKey = c0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' AND t3_.field = 'description' AND t3_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t3_.foreignKey = c0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'es' AND t4_.field = 'introductionTitle' AND t4_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t4_.foreignKey = c0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' AND t5_.field = 'introductionDescription' AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t5_.foreignKey = c0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' AND t6_.field = 'ballTitle' AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t6_.foreignKey = c0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'es' AND t7_.field = 'ballDescription' AND t7_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t7_.foreignKey = c0_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'es' AND t8_.field = 'shortDescription' AND t8_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t8_.foreignKey = c0_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'es' AND t9_.field = 'slug' AND t9_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t9_.foreignKey = c0_.id LEFT JOIN ext_translations t10_ ON t10_.locale = 'es' AND t10_.field = 'noCoursesMessage' AND t10_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t10_.foreignKey = c0_.id LEFT JOIN ext_translations t11_ ON t11_.locale = 'es' AND t11_.field = 'metaTitle' AND t11_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t11_.foreignKey = c0_.id LEFT JOIN ext_translations t12_ ON t12_.locale = 'es' AND t12_.field = 'metaDescription' AND t12_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseType' AND t12_.foreignKey = c0_.id LEFT JOIN ext_translations t14_ ON t14_.locale = 'es' AND t14_.field = 'name' AND t14_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\CourseLevel' AND t14_.foreignKey = c13_.id LEFT JOIN ext_translations t16_ ON t16_.locale = 'es' AND t16_.field = 'name' AND t16_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t16_.foreignKey = c15_.id LEFT JOIN ext_translations t17_ ON t17_.locale = 'es' AND t17_.field = 'descuentoText1' AND t17_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t17_.foreignKey = c15_.id LEFT JOIN ext_translations t18_ ON t18_.locale = 'es' AND t18_.field = 'descuentoText2' AND t18_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t18_.foreignKey = c15_.id LEFT JOIN ext_translations t19_ ON t19_.locale = 'es' AND t19_.field = 'legal' AND t19_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t19_.foreignKey = c15_.id LEFT JOIN ext_translations t20_ ON t20_.locale = 'es' AND t20_.field = 'descuentoInformation' AND t20_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t20_.foreignKey = c15_.id LEFT JOIN ext_translations t21_ ON t21_.locale = 'es' AND t21_.field = 'publicComments' AND t21_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t21_.foreignKey = c15_.id LEFT JOIN ext_translations t22_ ON t22_.locale = 'es' AND t22_.field = 'asActivity' AND t22_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t22_.foreignKey = c15_.id LEFT JOIN ext_translations t23_ ON t23_.locale = 'es' AND t23_.field = 'priceText' AND t23_.objectClass = 'Bailongu\\CourseBundle\\Entity\\Course' AND t23_.foreignKey = c15_.id WHERE c15_.type = 1 AND c24_.date = '2025-03-09' AND c15_.published = 1 AND c24_.date <= '2026-08-31';

SELECT 
  a0_.id AS id_0, 
  a0_.name AS name_1, 
  a0_.description AS description_2, 
  a0_.webDescription AS webDescription_3, 
  a0_.date AS date_4, 
  a0_.timeStart AS timeStart_5, 
  a0_.timeEnd AS timeEnd_6, 
  a0_.price AS price_7, 
  a0_.capacity AS capacity_8, 
  a0_.dateTimeCreation AS dateTimeCreation_9, 
  a0_.dateTimeModification AS dateTimeModification_10, 
  a0_.type AS type_11, 
  a0_.sortValue AS sortValue_12, 
  a0_.currentStudentsFree AS currentStudentsFree_13, 
  a0_.computePoints AS computePoints_14, 
  a0_.computeCourseHours AS computeCourseHours_15, 
  a0_.computeDanceHours AS computeDanceHours_16, 
  a0_.comments AS comments_17, 
  a0_.legacyReference AS legacyReference_18, 
  a0_.legacyReferenceCourse AS legacyReferenceCourse_19, 
  a0_.as_activity AS as_activity_20, 
  a0_.publishedInAgenda AS publishedInAgenda_21, 
  a0_.background_color AS background_color_22, 
  a0_.text_color AS text_color_23, 
  a0_.imagePoster AS imagePoster_24, 
  a0_.imagePath AS imagePath_25, 
  a0_.imagePathEs AS imagePathEs_26, 
  a0_.published AS published_27, 
  a0_.category_id AS category_id_28, 
  a0_.room_id AS room_id_29, 
  a0_.expandableRoom_id AS expandableRoom_id_30, 
  a0_.term_id AS term_id_31 
FROM 
  Activity a0_ 
WHERE 
  a0_.date = ? 
  AND a0_.type = ? 
  AND a0_.publishedInAgenda = 1 
  AND a0_.date <= '2026-08-31'

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.webDescription AS webDescription_3, a0_.date AS date_4, a0_.timeStart AS timeStart_5, a0_.timeEnd AS timeEnd_6, a0_.price AS price_7, a0_.capacity AS capacity_8, a0_.dateTimeCreation AS dateTimeCreation_9, a0_.dateTimeModification AS dateTimeModification_10, a0_.type AS type_11, a0_.sortValue AS sortValue_12, a0_.currentStudentsFree AS currentStudentsFree_13, a0_.computePoints AS computePoints_14, a0_.computeCourseHours AS computeCourseHours_15, a0_.computeDanceHours AS computeDanceHours_16, a0_.comments AS comments_17, a0_.legacyReference AS legacyReference_18, a0_.legacyReferenceCourse AS legacyReferenceCourse_19, a0_.as_activity AS as_activity_20, a0_.publishedInAgenda AS publishedInAgenda_21, a0_.background_color AS background_color_22, a0_.text_color AS text_color_23, a0_.imagePoster AS imagePoster_24, a0_.imagePath AS imagePath_25, a0_.imagePathEs AS imagePathEs_26, a0_.published AS published_27, a0_.category_id AS category_id_28, a0_.room_id AS room_id_29, a0_.expandableRoom_id AS expandableRoom_id_30, a0_.term_id AS term_id_31 FROM Activity a0_ WHERE a0_.date = '2025-03-09' AND a0_.type = 1 AND a0_.publishedInAgenda = 1 AND a0_.date <= '2026-08-31';

SELECT 
  c4_.id AS id_0, 
  COALESCE(t5_.content, c4_.name) AS name_1, 
  COALESCE(t1_.content, a0_.name) AS name_2, 
  COALESCE(t6_.content, c4_.webDescription) AS webDescription_3, 
  COALESCE(t2_.content, a0_.webDescription) AS webDescription_4, 
  c4_.imageUrl AS imageUrl_5, 
  a0_.id AS id_6, 
  a0_.date AS date_7 
FROM 
  Activity a0_ 
  LEFT JOIN Category c4_ ON a0_.category_id = c4_.id 
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' 
  AND t1_.field = 'name' 
  AND t1_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t1_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' 
  AND t2_.field = 'webDescription' 
  AND t2_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t2_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' 
  AND t3_.field = 'asActivity' 
  AND t3_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t3_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' 
  AND t5_.field = 'name' 
  AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' 
  AND t5_.foreignKey = c4_.id 
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' 
  AND t6_.field = 'webDescription' 
  AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' 
  AND t6_.foreignKey = c4_.id 
WHERE 
  a0_.date = ? 
  AND c4_.active = ? 
  AND a0_.published = 1 
  AND a0_.publishedInAgenda = 1 
  AND a0_.date <= '2026-08-31'

SELECT c4_.id AS id_0, COALESCE(t5_.content, c4_.name) AS name_1, COALESCE(t1_.content, a0_.name) AS name_2, COALESCE(t6_.content, c4_.webDescription) AS webDescription_3, COALESCE(t2_.content, a0_.webDescription) AS webDescription_4, c4_.imageUrl AS imageUrl_5, a0_.id AS id_6, a0_.date AS date_7 FROM Activity a0_ LEFT JOIN Category c4_ ON a0_.category_id = c4_.id LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' AND t1_.field = 'name' AND t1_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t1_.foreignKey = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' AND t2_.field = 'webDescription' AND t2_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t2_.foreignKey = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' AND t3_.field = 'asActivity' AND t3_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t3_.foreignKey = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' AND t5_.field = 'name' AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' AND t5_.foreignKey = c4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' AND t6_.field = 'webDescription' AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' AND t6_.foreignKey = c4_.id WHERE a0_.date = '2025-03-09' AND c4_.active = 1 AND a0_.published = 1 AND a0_.publishedInAgenda = 1 AND a0_.date <= '2026-08-31';

SELECT 
  a0_.id AS id_0, 
  a0_.category AS category_1, 
  a0_.title AS title_2, 
  a0_.description AS description_3, 
  a0_.link AS link_4, 
  a0_.as_activity AS as_activity_5, 
  a0_.recommended AS recommended_6, 
  a0_.publishedInAgenda AS publishedInAgenda_7, 
  a0_.background_color AS background_color_8, 
  a0_.text_color AS text_color_9, 
  a0_.imageUrl AS imageUrl_10, 
  a0_.imageUrlEs AS imageUrlEs_11, 
  a0_.date AS date_12, 
  a0_.dateEnd AS dateEnd_13, 
  a0_.dateCreation AS dateCreation_14, 
  a0_.dateModification AS dateModification_15, 
  a0_.sortValue AS sortValue_16, 
  a0_.dateToShow AS dateToShow_17, 
  a0_.showDate AS showDate_18 
FROM 
  Agenda a0_ 
WHERE 
  a0_.dateToShow LIKE '2025-03-09%' 
  AND a0_.dateToShow <= '2026-08-31' 
  AND a0_.publishedInAgenda = 1 
ORDER BY 
  a0_.dateToShow ASC, 
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.title AS title_2, a0_.description AS description_3, a0_.link AS link_4, a0_.as_activity AS as_activity_5, a0_.recommended AS recommended_6, a0_.publishedInAgenda AS publishedInAgenda_7, a0_.background_color AS background_color_8, a0_.text_color AS text_color_9, a0_.imageUrl AS imageUrl_10, a0_.imageUrlEs AS imageUrlEs_11, a0_.date AS date_12, a0_.dateEnd AS dateEnd_13, a0_.dateCreation AS dateCreation_14, a0_.dateModification AS dateModification_15, a0_.sortValue AS sortValue_16, a0_.dateToShow AS dateToShow_17, a0_.showDate AS showDate_18 FROM Agenda a0_ WHERE a0_.dateToShow LIKE '2025-03-09%' AND a0_.dateToShow <= '2026-08-31' AND a0_.publishedInAgenda = 1 ORDER BY a0_.dateToShow ASC, a0_.id DESC;

SELECT 
  e0_.content AS content_0, 
  e0_.field AS field_1 
FROM 
  ext_translations e0_ 
WHERE 
  e0_.foreignKey = ? 
  AND e0_.locale = ? 
  AND e0_.objectClass = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreignKey = '385' AND e0_.locale = 'es' AND e0_.objectClass = 'Bailongu\\WebBundle\\Entity\\Agenda';

SELECT 
  s0_.date AS date_0, 
  (
    SELECT 
      COUNT(s1_.id) + 1 AS sclr_2 
    FROM 
      Session s1_ 
    WHERE 
      s1_.date < s0_.date 
      AND s1_.calendar_id = c2_.id
  ) AS sclr_1 
FROM 
  Term t3_ 
  INNER JOIN Calendar c2_ ON t3_.id = c2_.term_id 
  INNER JOIN Course c4_ ON c2_.id = c4_.calendar_id 
  INNER JOIN Session s0_ ON c2_.id = s0_.calendar_id 
  INNER JOIN Category c5_ ON c4_.category_id = c5_.id 
WHERE 
  c5_.id IN (2, 11) 
  AND t3_.superTerm_id IS NOT NULL 
  AND (
    s0_.date BETWEEN ? 
    AND ?
  ) 
  AND c4_.type = ? 
  AND c4_.status <> ? 
GROUP BY 
  s0_.date

SELECT s0_.date AS date_0, (SELECT COUNT(s1_.id) + 1 AS sclr_2 FROM Session s1_ WHERE s1_.date < s0_.date AND s1_.calendar_id = c2_.id) AS sclr_1 FROM Term t3_ INNER JOIN Calendar c2_ ON t3_.id = c2_.term_id INNER JOIN Course c4_ ON c2_.id = c4_.calendar_id INNER JOIN Session s0_ ON c2_.id = s0_.calendar_id INNER JOIN Category c5_ ON c4_.category_id = c5_.id WHERE c5_.id IN (2, 11) AND t3_.superTerm_id IS NOT NULL AND (s0_.date BETWEEN '2025-03-01' AND '2025-03-31') AND c4_.type = 0 AND c4_.status <> 0 GROUP BY s0_.date;

SELECT 
  c0_.id AS id_0, 
  c0_.slug AS slug_1, 
  c0_.name AS name_2, 
  c0_.shortDescription AS shortDescription_3, 
  c0_.imageDescriptionPath AS imageDescriptionPath_4, 
  c1_.imageUrl AS imageUrl_5, 
  c1_.background_color AS background_color_6, 
  c1_.text_color AS text_color_7, 
  c1_.id AS id_8, 
  IFNULL(c2_.date, c2_.originalDate) AS sclr_9 
FROM 
  CourseType c0_ 
  LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id 
  LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id 
  LEFT JOIN Term t4_ ON c1_.term_id = t4_.id 
  LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id 
WHERE 
  c1_.type = ? 
  AND (
    c2_.date >= ? 
    AND c2_.date <= ?
  ) 
  AND c1_.published = 1

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.name AS name_2, c0_.shortDescription AS shortDescription_3, c0_.imageDescriptionPath AS imageDescriptionPath_4, c1_.imageUrl AS imageUrl_5, c1_.background_color AS background_color_6, c1_.text_color AS text_color_7, c1_.id AS id_8, IFNULL(c2_.date, c2_.originalDate) AS sclr_9 FROM CourseType c0_ LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id LEFT JOIN Term t4_ ON c1_.term_id = t4_.id LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id WHERE c1_.type = 1 AND (c2_.date >= '2025-03-01' AND c2_.date <= '2025-03-31') AND c1_.published = 1;

SELECT 
  c4_.id AS id_0, 
  COALESCE(t5_.content, c4_.name) AS name_1, 
  COALESCE(t1_.content, a0_.name) AS name_2, 
  COALESCE(t6_.content, c4_.webDescription) AS webDescription_3, 
  COALESCE(t2_.content, a0_.webDescription) AS webDescription_4, 
  c4_.imageUrl AS imageUrl_5, 
  c4_.background_color AS background_color_6, 
  c4_.text_color AS text_color_7, 
  a0_.id AS id_8, 
  a0_.date AS date_9 
FROM 
  Activity a0_ 
  LEFT JOIN Category c4_ ON a0_.category_id = c4_.id 
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' 
  AND t1_.field = 'name' 
  AND t1_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t1_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' 
  AND t2_.field = 'webDescription' 
  AND t2_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t2_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' 
  AND t3_.field = 'asActivity' 
  AND t3_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' 
  AND t3_.foreignKey = a0_.id 
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' 
  AND t5_.field = 'name' 
  AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' 
  AND t5_.foreignKey = c4_.id 
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' 
  AND t6_.field = 'webDescription' 
  AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' 
  AND t6_.foreignKey = c4_.id 
WHERE 
  (
    a0_.date >= ? 
    AND a0_.date <= ?
  ) 
  AND c4_.active = ? 
  AND a0_.published = 1 
  AND a0_.publishedInAgenda = 1

SELECT c4_.id AS id_0, COALESCE(t5_.content, c4_.name) AS name_1, COALESCE(t1_.content, a0_.name) AS name_2, COALESCE(t6_.content, c4_.webDescription) AS webDescription_3, COALESCE(t2_.content, a0_.webDescription) AS webDescription_4, c4_.imageUrl AS imageUrl_5, c4_.background_color AS background_color_6, c4_.text_color AS text_color_7, a0_.id AS id_8, a0_.date AS date_9 FROM Activity a0_ LEFT JOIN Category c4_ ON a0_.category_id = c4_.id LEFT JOIN ext_translations t1_ ON t1_.locale = 'es' AND t1_.field = 'name' AND t1_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t1_.foreignKey = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'es' AND t2_.field = 'webDescription' AND t2_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t2_.foreignKey = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'es' AND t3_.field = 'asActivity' AND t3_.objectClass = 'Bailongu\\ActivityBundle\\Entity\\Activity' AND t3_.foreignKey = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'es' AND t5_.field = 'name' AND t5_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' AND t5_.foreignKey = c4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'es' AND t6_.field = 'webDescription' AND t6_.objectClass = 'Bailongu\\CourseTypeBundle\\Entity\\Category' AND t6_.foreignKey = c4_.id WHERE (a0_.date >= '2025-03-01' AND a0_.date <= '2025-03-31') AND c4_.active = 1 AND a0_.published = 1 AND a0_.publishedInAgenda = 1;

SELECT 
  a0_.id AS id_0, 
  a0_.name AS name_1, 
  a0_.description AS description_2, 
  a0_.webDescription AS webDescription_3, 
  a0_.date AS date_4, 
  a0_.timeStart AS timeStart_5, 
  a0_.timeEnd AS timeEnd_6, 
  a0_.price AS price_7, 
  a0_.capacity AS capacity_8, 
  a0_.dateTimeCreation AS dateTimeCreation_9, 
  a0_.dateTimeModification AS dateTimeModification_10, 
  a0_.type AS type_11, 
  a0_.sortValue AS sortValue_12, 
  a0_.currentStudentsFree AS currentStudentsFree_13, 
  a0_.computePoints AS computePoints_14, 
  a0_.computeCourseHours AS computeCourseHours_15, 
  a0_.computeDanceHours AS computeDanceHours_16, 
  a0_.comments AS comments_17, 
  a0_.legacyReference AS legacyReference_18, 
  a0_.legacyReferenceCourse AS legacyReferenceCourse_19, 
  a0_.as_activity AS as_activity_20, 
  a0_.publishedInAgenda AS publishedInAgenda_21, 
  a0_.background_color AS background_color_22, 
  a0_.text_color AS text_color_23, 
  a0_.imagePoster AS imagePoster_24, 
  a0_.imagePath AS imagePath_25, 
  a0_.imagePathEs AS imagePathEs_26, 
  a0_.published AS published_27, 
  a0_.category_id AS category_id_28, 
  a0_.room_id AS room_id_29, 
  a0_.expandableRoom_id AS expandableRoom_id_30, 
  a0_.term_id AS term_id_31 
FROM 
  Activity a0_ 
WHERE 
  (
    a0_.date >= ? 
    AND a0_.date <= ?
  ) 
  AND a0_.type = ? 
ORDER BY 
  a0_.date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.webDescription AS webDescription_3, a0_.date AS date_4, a0_.timeStart AS timeStart_5, a0_.timeEnd AS timeEnd_6, a0_.price AS price_7, a0_.capacity AS capacity_8, a0_.dateTimeCreation AS dateTimeCreation_9, a0_.dateTimeModification AS dateTimeModification_10, a0_.type AS type_11, a0_.sortValue AS sortValue_12, a0_.currentStudentsFree AS currentStudentsFree_13, a0_.computePoints AS computePoints_14, a0_.computeCourseHours AS computeCourseHours_15, a0_.computeDanceHours AS computeDanceHours_16, a0_.comments AS comments_17, a0_.legacyReference AS legacyReference_18, a0_.legacyReferenceCourse AS legacyReferenceCourse_19, a0_.as_activity AS as_activity_20, a0_.publishedInAgenda AS publishedInAgenda_21, a0_.background_color AS background_color_22, a0_.text_color AS text_color_23, a0_.imagePoster AS imagePoster_24, a0_.imagePath AS imagePath_25, a0_.imagePathEs AS imagePathEs_26, a0_.published AS published_27, a0_.category_id AS category_id_28, a0_.room_id AS room_id_29, a0_.expandableRoom_id AS expandableRoom_id_30, a0_.term_id AS term_id_31 FROM Activity a0_ WHERE (a0_.date >= '2025-03-01' AND a0_.date <= '2025-03-31') AND a0_.type = 1 ORDER BY a0_.date ASC;

SELECT 
  a0_.id AS id_0, 
  a0_.category AS category_1, 
  a0_.title AS title_2, 
  a0_.description AS description_3, 
  a0_.link AS link_4, 
  a0_.as_activity AS as_activity_5, 
  a0_.recommended AS recommended_6, 
  a0_.publishedInAgenda AS publishedInAgenda_7, 
  a0_.background_color AS background_color_8, 
  a0_.text_color AS text_color_9, 
  a0_.imageUrl AS imageUrl_10, 
  a0_.imageUrlEs AS imageUrlEs_11, 
  a0_.date AS date_12, 
  a0_.dateEnd AS dateEnd_13, 
  a0_.dateCreation AS dateCreation_14, 
  a0_.dateModification AS dateModification_15, 
  a0_.sortValue AS sortValue_16, 
  a0_.dateToShow AS dateToShow_17, 
  a0_.showDate AS showDate_18 
FROM 
  Agenda a0_ 
WHERE 
  a0_.dateToShow LIKE '2025-03-%' 
  AND a0_.dateToShow <= '2026-08-31' 
  AND a0_.publishedInAgenda = 1 
ORDER BY 
  a0_.dateToShow ASC, 
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.title AS title_2, a0_.description AS description_3, a0_.link AS link_4, a0_.as_activity AS as_activity_5, a0_.recommended AS recommended_6, a0_.publishedInAgenda AS publishedInAgenda_7, a0_.background_color AS background_color_8, a0_.text_color AS text_color_9, a0_.imageUrl AS imageUrl_10, a0_.imageUrlEs AS imageUrlEs_11, a0_.date AS date_12, a0_.dateEnd AS dateEnd_13, a0_.dateCreation AS dateCreation_14, a0_.dateModification AS dateModification_15, a0_.sortValue AS sortValue_16, a0_.dateToShow AS dateToShow_17, a0_.showDate AS showDate_18 FROM Agenda a0_ WHERE a0_.dateToShow LIKE '2025-03-%' AND a0_.dateToShow <= '2026-08-31' AND a0_.publishedInAgenda = 1 ORDER BY a0_.dateToShow ASC, a0_.id DESC;

SELECT 
  e0_.content AS content_0, 
  e0_.field AS field_1 
FROM 
  ext_translations e0_ 
WHERE 
  e0_.foreignKey = ? 
  AND e0_.locale = ? 
  AND e0_.objectClass = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreignKey = '403' AND e0_.locale = 'es' AND e0_.objectClass = 'Bailongu\\WebBundle\\Entity\\Agenda';

SELECT 
  e0_.content AS content_0, 
  e0_.field AS field_1 
FROM 
  ext_translations e0_ 
WHERE 
  e0_.foreignKey = ? 
  AND e0_.locale = ? 
  AND e0_.objectClass = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreignKey = '402' AND e0_.locale = 'es' AND e0_.objectClass = 'Bailongu\\WebBundle\\Entity\\Agenda';