# noinspection SpellCheckingInspectionForFile

SELECT
    n.title AS 'Név',
    tp_term.name AS 'Település',
    hs_term.name AS 'Helyszín',
    tip_term.name AS 'Típus',
    m1.field_1_honapra_amount AS 'Ár (1 hó)',
    m3.field_3_honapra_amount AS 'Ár (3 hó)',
    m6.field_6_honapra_amount AS 'Ár (6 hó)',
    m12.field_12_honapra_amount AS 'Ár (12 hó)',
    mr.field_meret_value AS 'Méret (m2)',
    hsz.field_hosszusag_value AS 'Hossz. (cm)',
    szl.field_szelesseg_value AS 'Szel. (cm)',
    mg.field_magassag_value AS 'Mag. (cm)',
    atlm.field_atlmagassag_value AS 'Átl. belm. (cm)',
    at_term.name AS 'Ajtó típusa',
    nysz.field_nyszelesseg_value AS 'Ny. szel. (cm)',
    nym.field_nymagassag_value AS 'Ny. mag. (cm)',
    ak_term.name AS 'Autó közv. megk.',
    ap_term.name AS 'Park. táv.',
    CASE ba.field_beallas_value
        WHEN 1 THEN 'Igen'
        WHEN 2 THEN 'Nem'
        ELSE 'Nincs megadva'
    END AS 'Autóval beállás',
    bl_term.name AS 'Belógó tárgy',
    CASE bi.field_biztositas_value
        WHEN 1 THEN 'Igen'
        WHEN 2 THEN 'Nem'
        ELSE 'Nincs megadva'
    END AS 'Bizt. köt.',
    cm_term.name AS 'Címke',
    el_term.name AS 'Elhelyezkedés',
    ep_term.name AS 'Épülethez elj.',
    fs_term.name AS 'Füstjelző',
    CASE ft.field_futes_value
        WHEN 1 THEN 'Temperált'
        WHEN 2 THEN 'Nincs'
        ELSE 'Nincs megadva'
    END AS 'Fűtés',
    km_term.name AS 'Kamera',
    kny_term.name AS 'Kapunyitás',
    kl_term.name AS 'Klíma',
    kn_term.name AS 'Konnektor',
    kh_term.name AS 'Konn.haszn.',
    lp_term.name AS 'Lépcső',
    ms_term.name AS 'Mosdó',
    nh_term.name AS '0-24',
    rs_term.name AS 'Riasztó',
    tny_term.name AS 'Tár. nyitás',
    CASE th.field_teherlift_value
        WHEN 1 THEN 'Igen'
        WHEN 2 THEN 'Nem'
        ELSE 'Nincs megadva'
    END AS 'Teherlift',
    vl_term.name AS 'Világítás',
    (
        SELECT vv_term.name
        FROM field_data_field_vizvetel vv
        LEFT JOIN taxonomy_term_data vv_term ON vv.field_vizvetel_tid = vv_term.tid
        WHERE vv.entity_id = n.nid
    ) AS 'Vízvétel',
    (
        SELECT zt_term.name
        FROM field_data_field_zartipusa zt
        LEFT JOIN taxonomy_term_data zt_term ON zt.field_zartipusa_tid = zt_term.tid
        WHERE zt.entity_id = n.nid
    ) AS 'Zár típus'

FROM `node` n

LEFT JOIN field_data_field_1_honapra m1 ON m1.entity_id = n.nid
LEFT JOIN field_data_field_3_honapra m3 ON m3.entity_id = n.nid
LEFT JOIN field_data_field_6_honapra m6 ON m6.entity_id = n.nid
LEFT JOIN field_data_field_12_honapra m12 ON m12.entity_id = n.nid
LEFT JOIN field_data_field_atlmagassag atlm ON atlm.entity_id = n.nid

LEFT JOIN field_data_field_ajtotipusa at ON at.entity_id = n.nid
LEFT JOIN taxonomy_term_data at_term ON at.field_ajtotipusa_tid = at_term.tid

LEFT JOIN field_data_field_autokozvetlen ak ON ak.entity_id = n.nid
LEFT JOIN taxonomy_term_data ak_term ON ak.field_autokozvetlen_tid = ak_term.tid

LEFT JOIN field_data_field_autoleparkol ap ON ap.entity_id = n.nid
LEFT JOIN taxonomy_term_data ap_term ON ap.field_autoleparkol_tid = ap_term.tid

LEFT JOIN field_data_field_beallas ba ON ba.entity_id = n.nid

LEFT JOIN field_data_field_belogo bl ON bl.entity_id = n.nid
LEFT JOIN taxonomy_term_data bl_term ON bl.field_belogo_tid = bl_term.tid

LEFT JOIN field_data_field_biztositas bi ON bi.entity_id = n.nid

LEFT JOIN field_data_field_cimke cm ON cm.entity_id = n.nid
LEFT JOIN taxonomy_term_data cm_term ON cm.field_cimke_tid = cm_term.tid

LEFT JOIN field_data_field_elhelyezkedes el ON el.entity_id = n.nid
LEFT JOIN taxonomy_term_data el_term ON el.field_elhelyezkedes_tid = el_term.tid

LEFT JOIN field_data_field_epulethez ep ON ep.entity_id = n.nid
LEFT JOIN taxonomy_term_data ep_term ON ep.field_epulethez_tid = ep_term.tid

LEFT JOIN field_data_field_fust fs ON fs.entity_id = n.nid
LEFT JOIN taxonomy_term_data fs_term ON fs.field_fust_tid = fs_term.tid

LEFT JOIN field_data_field_futes ft ON ft.entity_id = n.nid

LEFT JOIN field_data_field_helyszin hs ON hs.entity_id = n.nid
LEFT JOIN taxonomy_term_data hs_term ON hs.field_helyszin_tid = hs_term.tid

LEFT JOIN field_data_field_hosszusag hsz ON hsz.entity_id = n.nid
LEFT JOIN field_data_field_szelesseg szl ON szl.entity_id = n.nid
LEFT JOIN field_data_field_magassag mg ON mg.entity_id = n.nid

LEFT JOIN field_data_field_nyszelesseg nysz ON nysz.entity_id = n.nid
LEFT JOIN field_data_field_nymagassag nym ON nym.entity_id = n.nid

LEFT JOIN field_data_field_kamera km ON km.entity_id = n.nid
LEFT JOIN taxonomy_term_data km_term ON km.field_kamera_tid = km_term.tid

LEFT JOIN field_data_field_kapunyitas kny ON kny.entity_id = n.nid
LEFT JOIN taxonomy_term_data kny_term ON kny.field_kapunyitas_tid = kny_term.tid

LEFT JOIN field_data_field_klimatizalas kl ON kl.entity_id = n.nid
LEFT JOIN taxonomy_term_data kl_term ON kl.field_klimatizalas_tid = kl_term.tid

LEFT JOIN field_data_field_konektor kn ON kn.entity_id = n.nid
LEFT JOIN taxonomy_term_data kn_term ON kn.field_konektor_tid = kn_term.tid

LEFT JOIN field_data_field_konterhasz kh ON kh.entity_id = n.nid
LEFT JOIN taxonomy_term_data kh_term ON kh.field_konterhasz_tid = kh_term.tid

LEFT JOIN field_data_field_lepcso lp ON lp.entity_id = n.nid
LEFT JOIN taxonomy_term_data lp_term ON lp.field_lepcso_tid = lp_term.tid

LEFT JOIN field_data_field_meret mr ON mr.entity_id = n.nid

LEFT JOIN field_data_field_mosdo ms ON ms.entity_id = n.nid
LEFT JOIN taxonomy_term_data ms_term ON ms.field_mosdo_tid = ms_term.tid

LEFT JOIN field_data_field_nulla24 nh ON nh.entity_id = n.nid
LEFT JOIN taxonomy_term_data nh_term ON nh.field_nulla24_tid = nh_term.tid

LEFT JOIN field_data_field_riaszto rs ON rs.entity_id = n.nid
LEFT JOIN taxonomy_term_data rs_term ON rs.field_riaszto_tid = rs_term.tid

LEFT JOIN field_data_field_tarolonyitas tny ON tny.entity_id = n.nid
LEFT JOIN taxonomy_term_data tny_term ON tny.field_tarolonyitas_tid = tny_term.tid

LEFT JOIN field_data_field_teherlift th ON th.entity_id = n.nid

LEFT JOIN field_data_field_telepules tp ON tp.entity_id = n.nid
LEFT JOIN taxonomy_term_data tp_term ON tp.field_telepules_tid = tp_term.tid

LEFT JOIN field_data_field_tipus tip ON tip.entity_id = n.nid
LEFT JOIN taxonomy_term_data tip_term ON tip.field_tipus_tid = tip_term.tid

LEFT JOIN field_data_field_vilagitas vl ON vl.entity_id = n.nid
LEFT JOIN taxonomy_term_data vl_term ON vl.field_vilagitas_tid = vl_term.tid

WHERE `type` = 'tarolo'
ORDER BY n.title, n.nid;