Home PIB

SELECT n.id AS id, n.seria AS seria, n.number AS number, n.type AS type, n."isEst" AS isEst, n.airports AS airports, n.fir AS fir, n.replace_number AS replace_number, n.begin_at AS begin_at, n.end_at AS end_at, n.active AS active, MAX(CASE WHEN nf.key = 'E' AND nf.lang = 'ru' THEN nf.value END) AS e_ru, MAX(CASE WHEN nf.key = 'E' AND nf.lang = 'en' THEN nf.value END) AS e_en, MAX(CASE WHEN nf.key = 'D' AND nf.lang = 'ru' THEN nf.value END) AS d_ru, MAX(CASE WHEN nf.key = 'D' AND nf.lang = 'en' THEN nf.value END) AS d_en, MAX(CASE WHEN nf.key = 'F' AND nf.lang = 'ru' THEN nf.value END) AS f_ru, MAX(CASE WHEN nf.key = 'F' AND nf.lang = 'en' THEN nf.value END) AS f_en, MAX(CASE WHEN nf.key = 'G' AND nf.lang = 'ru' THEN nf.value END) AS g_ru, MAX(CASE WHEN nf.key = 'G' AND nf.lang = 'en' THEN nf.value END) AS g_en, MAX(CASE WHEN nf.key = 'Q' AND nf.lang = 'ru' THEN nf.value END) AS q_ru, MAX(CASE WHEN nf.key = 'Q' AND nf.lang = 'en' THEN nf.value END) AS q_en FROM notams n LEFT JOIN notam_fields nf ON nf.notam_id = n.id AND nf.airline_id IS NULL GROUP BY n.id LIMIT 1

[{id: 1, seria: "A", number: "0216/24", type: "R", isest: true, airports: "{HTTB}", fir: "HTDC", replace_number: "0140/24", begin_at: 2024-09-05 12:45:00 +0000, end_at: 2024-12-05 15:30:00 +0000, active: false, e_ru: nil, e_en: "DVOR TV 114.7MHZ U/S.", d_ru: nil, d_en: nil, f_ru: nil, f_en: nil, g_ru: nil, g_en: nil, q_ru: nil, q_en: "HTDC/QNVAS/IV/BO/AE/000/999/0504S03249E005"}]