| 1 |
0.73 ms |
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.sport_id AS sport_id_2, t0_.week_description AS week_description_3, t0_.website AS website_4, t0_.address AS address_5, t0_.monday AS monday_6, t0_.tuesday AS tuesday_7, t0_.wednesday AS wednesday_8, t0_.thursday AS thursday_9, t0_.friday AS friday_10, t0_.saturday AS saturday_11, t0_.sunday AS sunday_12, t0_.reservation_phone AS reservation_phone_13, t0_.reservation_email AS reservation_email_14, t0_.reservation_web AS reservation_web_15, t0_.display AS display_16, t0_.hash AS hash_17, t0_.full AS full_18, t0_.created_by AS created_by_19, t0_.created_at AS created_at_20, t0_.updated_at AS updated_at_21, t0_.year AS year_22, t0_.slug AS slug_23, t0_.featured AS featured_24, f1_.id AS id_25, f1_.name AS name_26, f1_.address AS address_27, f1_.phone AS phone_28, f1_.description AS description_29, f1_.website AS website_30, f1_.type AS type_31, f1_.sports AS sports_32, f1_.coordinates AS coordinates_33, f1_.email AS email_34, f1_.administrative_district AS administrative_district_35, f1_.update_status AS update_status_36, f1_.image AS image_37, t0_.facility_id AS facility_id_38, t0_.club_id AS club_id_39, t0_.sport_id AS sport_id_40 FROM tyden_sportu t0_ LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id WHERE t0_.year = ? AND t0_.facility_id IS NOT NULL AND t0_.display = ? AND t0_.featured = ?
Parameters: [
2026
"ano"
1
]
SELECT
t0_.id AS id_0,
t0_.email AS email_1,
t0_.sport_id AS sport_id_2,
t0_.week_description AS week_description_3,
t0_.website AS website_4,
t0_.address AS address_5,
t0_.monday AS monday_6,
t0_.tuesday AS tuesday_7,
t0_.wednesday AS wednesday_8,
t0_.thursday AS thursday_9,
t0_.friday AS friday_10,
t0_.saturday AS saturday_11,
t0_.sunday AS sunday_12,
t0_.reservation_phone AS reservation_phone_13,
t0_.reservation_email AS reservation_email_14,
t0_.reservation_web AS reservation_web_15,
t0_.display AS display_16,
t0_.hash AS hash_17,
t0_.full AS full_18,
t0_.created_by AS created_by_19,
t0_.created_at AS created_at_20,
t0_.updated_at AS updated_at_21,
t0_.year AS year_22,
t0_.slug AS slug_23,
t0_.featured AS featured_24,
f1_.id AS id_25,
f1_.name AS name_26,
f1_.address AS address_27,
f1_.phone AS phone_28,
f1_.description AS description_29,
f1_.website AS website_30,
f1_.type AS type_31,
f1_.sports AS sports_32,
f1_.coordinates AS coordinates_33,
f1_.email AS email_34,
f1_.administrative_district AS administrative_district_35,
f1_.update_status AS update_status_36,
f1_.image AS image_37,
t0_.facility_id AS facility_id_38,
t0_.club_id AS club_id_39,
t0_.sport_id AS sport_id_40
FROM
tyden_sportu t0_
LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id
WHERE
t0_.year = ?
AND t0_.facility_id IS NOT NULL
AND t0_.display = ?
AND t0_.featured = ?
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.sport_id AS sport_id_2, t0_.week_description AS week_description_3, t0_.website AS website_4, t0_.address AS address_5, t0_.monday AS monday_6, t0_.tuesday AS tuesday_7, t0_.wednesday AS wednesday_8, t0_.thursday AS thursday_9, t0_.friday AS friday_10, t0_.saturday AS saturday_11, t0_.sunday AS sunday_12, t0_.reservation_phone AS reservation_phone_13, t0_.reservation_email AS reservation_email_14, t0_.reservation_web AS reservation_web_15, t0_.display AS display_16, t0_.hash AS hash_17, t0_.full AS full_18, t0_.created_by AS created_by_19, t0_.created_at AS created_at_20, t0_.updated_at AS updated_at_21, t0_.year AS year_22, t0_.slug AS slug_23, t0_.featured AS featured_24, f1_.id AS id_25, f1_.name AS name_26, f1_.address AS address_27, f1_.phone AS phone_28, f1_.description AS description_29, f1_.website AS website_30, f1_.type AS type_31, f1_.sports AS sports_32, f1_.coordinates AS coordinates_33, f1_.email AS email_34, f1_.administrative_district AS administrative_district_35, f1_.update_status AS update_status_36, f1_.image AS image_37, t0_.facility_id AS facility_id_38, t0_.club_id AS club_id_39, t0_.sport_id AS sport_id_40 FROM tyden_sportu t0_ LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id WHERE t0_.year = 2026 AND t0_.facility_id IS NOT NULL AND t0_.display = 'ano' AND t0_.featured = 1;
|