| 2 |
0.60 ms |
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.comment AS comment_2, b0_.participant AS participant_3, b0_.status AS status_4, b0_.created_at AS created_at_5, b0_.created_by AS created_by_6, b0_.updated_at AS updated_at_7, b0_.updated_by AS updated_by_8, b0_.place AS place_9, b0_.is_deleted AS is_deleted_10, b0_.duration AS duration_11, b0_.is_credit_calculated AS is_credit_calculated_12, b0_.is_holiday_or_sunday AS is_holiday_or_sunday_13, b0_.total_credit AS total_credit_14, b0_.is_location_calculated AS is_location_calculated_15, b0_.distance AS distance_16, b0_.comment_credit_traitement AS comment_credit_traitement_17, b0_.is_unique AS is_unique_18, b0_.nbr_day AS nbr_day_19, b0_.nbr_half_day AS nbr_half_day_20, b0_.nbr_forfait AS nbr_forfait_21, c1_.id AS id_22, c1_.comment AS comment_23, c1_.title AS title_24, c1_.lastname AS lastname_25, c1_.firstname AS firstname_26, c1_.email AS email_27, c1_.landline AS landline_28, c1_.cell_phone AS cell_phone_29, c1_.hourly_rate AS hourly_rate_30, c1_.is_active AS is_active_31, c1_.is_employee AS is_employee_32, c1_.latitude AS latitude_33, c1_.longitude AS longitude_34, c1_.address AS address_35, c1_.street_location AS street_location_36, c1_.secteur AS secteur_37, c1_.address_line AS address_line_38, c1_.address_zip AS address_zip_39, c1_.address_city AS address_city_40, c1_.update_at AS update_at_41, c1_.refresh_geo AS refresh_geo_42, b2_.id AS id_43, b2_.ogust_id AS ogust_id_44, b2_.username AS username_45, b2_.password AS password_46, b2_.name AS name_47, b2_.address1 AS address1_48, b2_.address2 AS address2_49, b2_.postal_code AS postal_code_50, b2_.city AS city_51, b2_.latitude AS latitude_52, b2_.longitude AS longitude_53, b3_.id AS id_54, b3_.name AS name_55, b3_.is_idf AS is_idf_56, b4_.id AS id_57, b4_.nature AS nature_58, b4_.name AS name_59, b4_.duration AS duration_60, b5_.id AS id_61, b5_.created_at AS created_at_62, b5_.created_by AS created_by_63, b5_.comment AS comment_64, b6_.id AS id_65, b6_.hourly_rate AS hourly_rate_66, b6_.is_variable_hourly_rate AS is_variable_hourly_rate_67, b6_.status AS status_68, b6_.created_at AS created_at_69, b6_.is_deleted AS is_deleted_70, b6_.created_by AS created_by_71, c7_.id AS id_72, c7_.comment AS comment_73, c7_.title AS title_74, c7_.lastname AS lastname_75, c7_.firstname AS firstname_76, c7_.email AS email_77, c7_.landline AS landline_78, c7_.cell_phone AS cell_phone_79, c7_.hourly_rate AS hourly_rate_80, c7_.is_active AS is_active_81, c7_.is_employee AS is_employee_82, c7_.latitude AS latitude_83, c7_.longitude AS longitude_84, c7_.address AS address_85, c7_.street_location AS street_location_86, c7_.secteur AS secteur_87, c7_.address_line AS address_line_88, c7_.address_zip AS address_zip_89, c7_.address_city AS address_city_90, c7_.update_at AS update_at_91, c7_.refresh_geo AS refresh_geo_92, b8_.id AS id_93, b8_.date AS date_94, b8_.comment AS comment_95, b8_.participant AS participant_96, b8_.status AS status_97, b8_.created_at AS created_at_98, b8_.created_by AS created_by_99, b8_.updated_at AS updated_at_100, b8_.updated_by AS updated_by_101, b8_.place AS place_102, b8_.is_deleted AS is_deleted_103, b8_.duration AS duration_104, b8_.is_credit_calculated AS is_credit_calculated_105, b8_.is_holiday_or_sunday AS is_holiday_or_sunday_106, b8_.total_credit AS total_credit_107, b8_.is_location_calculated AS is_location_calculated_108, b8_.distance AS distance_109, b8_.comment_credit_traitement AS comment_credit_traitement_110, b8_.is_unique AS is_unique_111, b8_.nbr_day AS nbr_day_112, b8_.nbr_half_day AS nbr_half_day_113, b8_.nbr_forfait AS nbr_forfait_114, b9_.id AS id_115, b9_.date AS date_116, b9_.comment AS comment_117, b9_.participant AS participant_118, b9_.status AS status_119, b9_.created_at AS created_at_120, b9_.created_by AS created_by_121, b9_.updated_at AS updated_at_122, b9_.updated_by AS updated_by_123, b9_.place AS place_124, b9_.is_deleted AS is_deleted_125, b9_.duration AS duration_126, b9_.is_credit_calculated AS is_credit_calculated_127, b9_.is_holiday_or_sunday AS is_holiday_or_sunday_128, b9_.total_credit AS total_credit_129, b9_.is_location_calculated AS is_location_calculated_130, b9_.distance AS distance_131, b9_.comment_credit_traitement AS comment_credit_traitement_132, b9_.is_unique AS is_unique_133, b9_.nbr_day AS nbr_day_134, b9_.nbr_half_day AS nbr_half_day_135, b9_.nbr_forfait AS nbr_forfait_136, b10_.id AS id_137, b10_.status AS status_138, b10_.participants_number AS participants_number_139, b10_.intervention_date AS intervention_date_140, b10_.room_quality AS room_quality_141, b10_.meeting_staff AS meeting_staff_142, b10_.customer_support AS customer_support_143, b10_.customer_protective_equipment AS customer_protective_equipment_144, b10_.coach_protective_equipment AS coach_protective_equipment_145, b10_.cleaning AS cleaning_146, b10_.shopping_list AS shopping_list_147, b10_.reception_quality AS reception_quality_148, b10_.pouch AS pouch_149, b10_.post AS post_150, b10_.partnership AS partnership_151, b10_.note AS note_152, b10_.mcb_comment AS mcb_comment_153, b10_.b2c_proposal AS b2c_proposal_154, b10_.link AS link_155, b0_.coach AS coach_156, b0_.shop AS shop_157, b0_.code49 AS code49_158, b0_.parent_workshop_id AS parent_workshop_id_159, b0_.contract_id AS contract_id_160, b0_.accounting_id AS accounting_id_161, b2_.brand AS brand_162, b2_.class_price AS class_price_163, b2_.user_id AS user_id_164, b2_.area_id AS area_id_165, b3_.user_id AS user_id_166, b5_.workshop AS workshop_167, b6_.workshop AS workshop_168, b6_.coach AS coach_169, b8_.coach AS coach_170, b8_.shop AS shop_171, b8_.code49 AS code49_172, b8_.parent_workshop_id AS parent_workshop_id_173, b8_.contract_id AS contract_id_174, b8_.accounting_id AS accounting_id_175, b9_.coach AS coach_176, b9_.shop AS shop_177, b9_.code49 AS code49_178, b9_.parent_workshop_id AS parent_workshop_id_179, b9_.contract_id AS contract_id_180, b9_.accounting_id AS accounting_id_181, b10_.workshop_id AS workshop_id_182 FROM b2b_workshop b0_ INNER JOIN coach c1_ ON b0_.coach = c1_.id INNER JOIN b2b_shop b2_ ON b0_.shop = b2_.id LEFT JOIN b2b_area b3_ ON b2_.area_id = b3_.id INNER JOIN b2b_code49 b4_ ON b0_.code49 = b4_.id LEFT JOIN b2b_comment b5_ ON b0_.id = b5_.workshop LEFT JOIN b2b_proposal b6_ ON b0_.id = b6_.workshop LEFT JOIN coach c7_ ON b6_.coach = c7_.id LEFT JOIN b2b_workshop b8_ ON b0_.parent_workshop_id = b8_.id LEFT JOIN b2b_workshop b9_ ON b0_.id = b9_.parent_workshop_id LEFT JOIN b2b_audit b10_ ON b0_.id = b10_.workshop_id WHERE b0_.id IN (SELECT b11_.id FROM b2b_workshop b11_ INNER JOIN coach c12_ ON b11_.coach = c12_.id WHERE b11_.is_deleted = ? AND b11_.date <= ? AND b11_.date >= ? AND c12_.id = ?) ORDER BY b0_.date ASC
Parameters: [
0
"2026-01-23 00:00:00"
"2025-12-23 00:00:00"
237588112
]
SELECT
b0_.id AS id_0,
b0_.date AS date_1,
b0_.comment AS comment_2,
b0_.participant AS participant_3,
b0_.status AS status_4,
b0_.created_at AS created_at_5,
b0_.created_by AS created_by_6,
b0_.updated_at AS updated_at_7,
b0_.updated_by AS updated_by_8,
b0_.place AS place_9,
b0_.is_deleted AS is_deleted_10,
b0_.duration AS duration_11,
b0_.is_credit_calculated AS is_credit_calculated_12,
b0_.is_holiday_or_sunday AS is_holiday_or_sunday_13,
b0_.total_credit AS total_credit_14,
b0_.is_location_calculated AS is_location_calculated_15,
b0_.distance AS distance_16,
b0_.comment_credit_traitement AS comment_credit_traitement_17,
b0_.is_unique AS is_unique_18,
b0_.nbr_day AS nbr_day_19,
b0_.nbr_half_day AS nbr_half_day_20,
b0_.nbr_forfait AS nbr_forfait_21,
c1_.id AS id_22,
c1_.comment AS comment_23,
c1_.title AS title_24,
c1_.lastname AS lastname_25,
c1_.firstname AS firstname_26,
c1_.email AS email_27,
c1_.landline AS landline_28,
c1_.cell_phone AS cell_phone_29,
c1_.hourly_rate AS hourly_rate_30,
c1_.is_active AS is_active_31,
c1_.is_employee AS is_employee_32,
c1_.latitude AS latitude_33,
c1_.longitude AS longitude_34,
c1_.address AS address_35,
c1_.street_location AS street_location_36,
c1_.secteur AS secteur_37,
c1_.address_line AS address_line_38,
c1_.address_zip AS address_zip_39,
c1_.address_city AS address_city_40,
c1_.update_at AS update_at_41,
c1_.refresh_geo AS refresh_geo_42,
b2_.id AS id_43,
b2_.ogust_id AS ogust_id_44,
b2_.username AS username_45,
b2_.password AS password_46,
b2_.name AS name_47,
b2_.address1 AS address1_48,
b2_.address2 AS address2_49,
b2_.postal_code AS postal_code_50,
b2_.city AS city_51,
b2_.latitude AS latitude_52,
b2_.longitude AS longitude_53,
b3_.id AS id_54,
b3_.name AS name_55,
b3_.is_idf AS is_idf_56,
b4_.id AS id_57,
b4_.nature AS nature_58,
b4_.name AS name_59,
b4_.duration AS duration_60,
b5_.id AS id_61,
b5_.created_at AS created_at_62,
b5_.created_by AS created_by_63,
b5_.comment AS comment_64,
b6_.id AS id_65,
b6_.hourly_rate AS hourly_rate_66,
b6_.is_variable_hourly_rate AS is_variable_hourly_rate_67,
b6_.status AS status_68,
b6_.created_at AS created_at_69,
b6_.is_deleted AS is_deleted_70,
b6_.created_by AS created_by_71,
c7_.id AS id_72,
c7_.comment AS comment_73,
c7_.title AS title_74,
c7_.lastname AS lastname_75,
c7_.firstname AS firstname_76,
c7_.email AS email_77,
c7_.landline AS landline_78,
c7_.cell_phone AS cell_phone_79,
c7_.hourly_rate AS hourly_rate_80,
c7_.is_active AS is_active_81,
c7_.is_employee AS is_employee_82,
c7_.latitude AS latitude_83,
c7_.longitude AS longitude_84,
c7_.address AS address_85,
c7_.street_location AS street_location_86,
c7_.secteur AS secteur_87,
c7_.address_line AS address_line_88,
c7_.address_zip AS address_zip_89,
c7_.address_city AS address_city_90,
c7_.update_at AS update_at_91,
c7_.refresh_geo AS refresh_geo_92,
b8_.id AS id_93,
b8_.date AS date_94,
b8_.comment AS comment_95,
b8_.participant AS participant_96,
b8_.status AS status_97,
b8_.created_at AS created_at_98,
b8_.created_by AS created_by_99,
b8_.updated_at AS updated_at_100,
b8_.updated_by AS updated_by_101,
b8_.place AS place_102,
b8_.is_deleted AS is_deleted_103,
b8_.duration AS duration_104,
b8_.is_credit_calculated AS is_credit_calculated_105,
b8_.is_holiday_or_sunday AS is_holiday_or_sunday_106,
b8_.total_credit AS total_credit_107,
b8_.is_location_calculated AS is_location_calculated_108,
b8_.distance AS distance_109,
b8_.comment_credit_traitement AS comment_credit_traitement_110,
b8_.is_unique AS is_unique_111,
b8_.nbr_day AS nbr_day_112,
b8_.nbr_half_day AS nbr_half_day_113,
b8_.nbr_forfait AS nbr_forfait_114,
b9_.id AS id_115,
b9_.date AS date_116,
b9_.comment AS comment_117,
b9_.participant AS participant_118,
b9_.status AS status_119,
b9_.created_at AS created_at_120,
b9_.created_by AS created_by_121,
b9_.updated_at AS updated_at_122,
b9_.updated_by AS updated_by_123,
b9_.place AS place_124,
b9_.is_deleted AS is_deleted_125,
b9_.duration AS duration_126,
b9_.is_credit_calculated AS is_credit_calculated_127,
b9_.is_holiday_or_sunday AS is_holiday_or_sunday_128,
b9_.total_credit AS total_credit_129,
b9_.is_location_calculated AS is_location_calculated_130,
b9_.distance AS distance_131,
b9_.comment_credit_traitement AS comment_credit_traitement_132,
b9_.is_unique AS is_unique_133,
b9_.nbr_day AS nbr_day_134,
b9_.nbr_half_day AS nbr_half_day_135,
b9_.nbr_forfait AS nbr_forfait_136,
b10_.id AS id_137,
b10_.status AS status_138,
b10_.participants_number AS participants_number_139,
b10_.intervention_date AS intervention_date_140,
b10_.room_quality AS room_quality_141,
b10_.meeting_staff AS meeting_staff_142,
b10_.customer_support AS customer_support_143,
b10_.customer_protective_equipment AS customer_protective_equipment_144,
b10_.coach_protective_equipment AS coach_protective_equipment_145,
b10_.cleaning AS cleaning_146,
b10_.shopping_list AS shopping_list_147,
b10_.reception_quality AS reception_quality_148,
b10_.pouch AS pouch_149,
b10_.post AS post_150,
b10_.partnership AS partnership_151,
b10_.note AS note_152,
b10_.mcb_comment AS mcb_comment_153,
b10_.b2c_proposal AS b2c_proposal_154,
b10_.link AS link_155,
b0_.coach AS coach_156,
b0_.shop AS shop_157,
b0_.code49 AS code49_158,
b0_.parent_workshop_id AS parent_workshop_id_159,
b0_.contract_id AS contract_id_160,
b0_.accounting_id AS accounting_id_161,
b2_.brand AS brand_162,
b2_.class_price AS class_price_163,
b2_.user_id AS user_id_164,
b2_.area_id AS area_id_165,
b3_.user_id AS user_id_166,
b5_.workshop AS workshop_167,
b6_.workshop AS workshop_168,
b6_.coach AS coach_169,
b8_.coach AS coach_170,
b8_.shop AS shop_171,
b8_.code49 AS code49_172,
b8_.parent_workshop_id AS parent_workshop_id_173,
b8_.contract_id AS contract_id_174,
b8_.accounting_id AS accounting_id_175,
b9_.coach AS coach_176,
b9_.shop AS shop_177,
b9_.code49 AS code49_178,
b9_.parent_workshop_id AS parent_workshop_id_179,
b9_.contract_id AS contract_id_180,
b9_.accounting_id AS accounting_id_181,
b10_.workshop_id AS workshop_id_182
FROM
b2b_workshop b0_
INNER JOIN coach c1_ ON b0_.coach = c1_.id
INNER JOIN b2b_shop b2_ ON b0_.shop = b2_.id
LEFT JOIN b2b_area b3_ ON b2_.area_id = b3_.id
INNER JOIN b2b_code49 b4_ ON b0_.code49 = b4_.id
LEFT JOIN b2b_comment b5_ ON b0_.id = b5_.workshop
LEFT JOIN b2b_proposal b6_ ON b0_.id = b6_.workshop
LEFT JOIN coach c7_ ON b6_.coach = c7_.id
LEFT JOIN b2b_workshop b8_ ON b0_.parent_workshop_id = b8_.id
LEFT JOIN b2b_workshop b9_ ON b0_.id = b9_.parent_workshop_id
LEFT JOIN b2b_audit b10_ ON b0_.id = b10_.workshop_id
WHERE
b0_.id IN (
SELECT
b11_.id
FROM
b2b_workshop b11_
INNER JOIN coach c12_ ON b11_.coach = c12_.id
WHERE
b11_.is_deleted = ?
AND b11_.date <= ?
AND b11_.date >= ?
AND c12_.id = ?
)
ORDER BY
b0_.date ASC
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.comment AS comment_2, b0_.participant AS participant_3, b0_.status AS status_4, b0_.created_at AS created_at_5, b0_.created_by AS created_by_6, b0_.updated_at AS updated_at_7, b0_.updated_by AS updated_by_8, b0_.place AS place_9, b0_.is_deleted AS is_deleted_10, b0_.duration AS duration_11, b0_.is_credit_calculated AS is_credit_calculated_12, b0_.is_holiday_or_sunday AS is_holiday_or_sunday_13, b0_.total_credit AS total_credit_14, b0_.is_location_calculated AS is_location_calculated_15, b0_.distance AS distance_16, b0_.comment_credit_traitement AS comment_credit_traitement_17, b0_.is_unique AS is_unique_18, b0_.nbr_day AS nbr_day_19, b0_.nbr_half_day AS nbr_half_day_20, b0_.nbr_forfait AS nbr_forfait_21, c1_.id AS id_22, c1_.comment AS comment_23, c1_.title AS title_24, c1_.lastname AS lastname_25, c1_.firstname AS firstname_26, c1_.email AS email_27, c1_.landline AS landline_28, c1_.cell_phone AS cell_phone_29, c1_.hourly_rate AS hourly_rate_30, c1_.is_active AS is_active_31, c1_.is_employee AS is_employee_32, c1_.latitude AS latitude_33, c1_.longitude AS longitude_34, c1_.address AS address_35, c1_.street_location AS street_location_36, c1_.secteur AS secteur_37, c1_.address_line AS address_line_38, c1_.address_zip AS address_zip_39, c1_.address_city AS address_city_40, c1_.update_at AS update_at_41, c1_.refresh_geo AS refresh_geo_42, b2_.id AS id_43, b2_.ogust_id AS ogust_id_44, b2_.username AS username_45, b2_.password AS password_46, b2_.name AS name_47, b2_.address1 AS address1_48, b2_.address2 AS address2_49, b2_.postal_code AS postal_code_50, b2_.city AS city_51, b2_.latitude AS latitude_52, b2_.longitude AS longitude_53, b3_.id AS id_54, b3_.name AS name_55, b3_.is_idf AS is_idf_56, b4_.id AS id_57, b4_.nature AS nature_58, b4_.name AS name_59, b4_.duration AS duration_60, b5_.id AS id_61, b5_.created_at AS created_at_62, b5_.created_by AS created_by_63, b5_.comment AS comment_64, b6_.id AS id_65, b6_.hourly_rate AS hourly_rate_66, b6_.is_variable_hourly_rate AS is_variable_hourly_rate_67, b6_.status AS status_68, b6_.created_at AS created_at_69, b6_.is_deleted AS is_deleted_70, b6_.created_by AS created_by_71, c7_.id AS id_72, c7_.comment AS comment_73, c7_.title AS title_74, c7_.lastname AS lastname_75, c7_.firstname AS firstname_76, c7_.email AS email_77, c7_.landline AS landline_78, c7_.cell_phone AS cell_phone_79, c7_.hourly_rate AS hourly_rate_80, c7_.is_active AS is_active_81, c7_.is_employee AS is_employee_82, c7_.latitude AS latitude_83, c7_.longitude AS longitude_84, c7_.address AS address_85, c7_.street_location AS street_location_86, c7_.secteur AS secteur_87, c7_.address_line AS address_line_88, c7_.address_zip AS address_zip_89, c7_.address_city AS address_city_90, c7_.update_at AS update_at_91, c7_.refresh_geo AS refresh_geo_92, b8_.id AS id_93, b8_.date AS date_94, b8_.comment AS comment_95, b8_.participant AS participant_96, b8_.status AS status_97, b8_.created_at AS created_at_98, b8_.created_by AS created_by_99, b8_.updated_at AS updated_at_100, b8_.updated_by AS updated_by_101, b8_.place AS place_102, b8_.is_deleted AS is_deleted_103, b8_.duration AS duration_104, b8_.is_credit_calculated AS is_credit_calculated_105, b8_.is_holiday_or_sunday AS is_holiday_or_sunday_106, b8_.total_credit AS total_credit_107, b8_.is_location_calculated AS is_location_calculated_108, b8_.distance AS distance_109, b8_.comment_credit_traitement AS comment_credit_traitement_110, b8_.is_unique AS is_unique_111, b8_.nbr_day AS nbr_day_112, b8_.nbr_half_day AS nbr_half_day_113, b8_.nbr_forfait AS nbr_forfait_114, b9_.id AS id_115, b9_.date AS date_116, b9_.comment AS comment_117, b9_.participant AS participant_118, b9_.status AS status_119, b9_.created_at AS created_at_120, b9_.created_by AS created_by_121, b9_.updated_at AS updated_at_122, b9_.updated_by AS updated_by_123, b9_.place AS place_124, b9_.is_deleted AS is_deleted_125, b9_.duration AS duration_126, b9_.is_credit_calculated AS is_credit_calculated_127, b9_.is_holiday_or_sunday AS is_holiday_or_sunday_128, b9_.total_credit AS total_credit_129, b9_.is_location_calculated AS is_location_calculated_130, b9_.distance AS distance_131, b9_.comment_credit_traitement AS comment_credit_traitement_132, b9_.is_unique AS is_unique_133, b9_.nbr_day AS nbr_day_134, b9_.nbr_half_day AS nbr_half_day_135, b9_.nbr_forfait AS nbr_forfait_136, b10_.id AS id_137, b10_.status AS status_138, b10_.participants_number AS participants_number_139, b10_.intervention_date AS intervention_date_140, b10_.room_quality AS room_quality_141, b10_.meeting_staff AS meeting_staff_142, b10_.customer_support AS customer_support_143, b10_.customer_protective_equipment AS customer_protective_equipment_144, b10_.coach_protective_equipment AS coach_protective_equipment_145, b10_.cleaning AS cleaning_146, b10_.shopping_list AS shopping_list_147, b10_.reception_quality AS reception_quality_148, b10_.pouch AS pouch_149, b10_.post AS post_150, b10_.partnership AS partnership_151, b10_.note AS note_152, b10_.mcb_comment AS mcb_comment_153, b10_.b2c_proposal AS b2c_proposal_154, b10_.link AS link_155, b0_.coach AS coach_156, b0_.shop AS shop_157, b0_.code49 AS code49_158, b0_.parent_workshop_id AS parent_workshop_id_159, b0_.contract_id AS contract_id_160, b0_.accounting_id AS accounting_id_161, b2_.brand AS brand_162, b2_.class_price AS class_price_163, b2_.user_id AS user_id_164, b2_.area_id AS area_id_165, b3_.user_id AS user_id_166, b5_.workshop AS workshop_167, b6_.workshop AS workshop_168, b6_.coach AS coach_169, b8_.coach AS coach_170, b8_.shop AS shop_171, b8_.code49 AS code49_172, b8_.parent_workshop_id AS parent_workshop_id_173, b8_.contract_id AS contract_id_174, b8_.accounting_id AS accounting_id_175, b9_.coach AS coach_176, b9_.shop AS shop_177, b9_.code49 AS code49_178, b9_.parent_workshop_id AS parent_workshop_id_179, b9_.contract_id AS contract_id_180, b9_.accounting_id AS accounting_id_181, b10_.workshop_id AS workshop_id_182 FROM b2b_workshop b0_ INNER JOIN coach c1_ ON b0_.coach = c1_.id INNER JOIN b2b_shop b2_ ON b0_.shop = b2_.id LEFT JOIN b2b_area b3_ ON b2_.area_id = b3_.id INNER JOIN b2b_code49 b4_ ON b0_.code49 = b4_.id LEFT JOIN b2b_comment b5_ ON b0_.id = b5_.workshop LEFT JOIN b2b_proposal b6_ ON b0_.id = b6_.workshop LEFT JOIN coach c7_ ON b6_.coach = c7_.id LEFT JOIN b2b_workshop b8_ ON b0_.parent_workshop_id = b8_.id LEFT JOIN b2b_workshop b9_ ON b0_.id = b9_.parent_workshop_id LEFT JOIN b2b_audit b10_ ON b0_.id = b10_.workshop_id WHERE b0_.id IN (SELECT b11_.id FROM b2b_workshop b11_ INNER JOIN coach c12_ ON b11_.coach = c12_.id WHERE b11_.is_deleted = 0 AND b11_.date <= '2026-01-23 00:00:00' AND b11_.date >= '2025-12-23 00:00:00' AND c12_.id = 237588112) ORDER BY b0_.date ASC;
|