Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

select version();


version


PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit


-- die Daten (ein paar Beispiele)
-- siehe https://www.delphipraxis.net/209555-json-einlesen-hilfe-fuer-anfaenger.html
create table edg (jd json);
insert into edg values('{"channels":{"sixx_deutschland":[{"cc":[],"e_no":3,"et":"Vergissmeinnicht","i_t":"3260539e5ffe840b6b02","id":238874757,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640094000,"tms_id":"EP019559640045","s_no":6,"c":["Series"],"e":1640094000,"g":["Drama","Fantasy","Mystery "],"i":"cms/3260539e5ffe840b6b02/format_480x360.jpg","yp_req":false,"s":1640090700,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":4,"et":"Die Ohnmacht der Drei","i_t":"ad0d1a805f179b4979cd","id":239947163,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640097300,"tms_id":"EP019559640051","s_no":6,"c":["Series"],"e":1640097300,"g":["Drama","Fantasy","Mystery "],"i":"cms/ad0d1a805f179b4979cd/format_480x360.jpg","yp_req":false,"s":1640094000,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":5,"et":"T\u00f6dliche Liebe","i_t":"f17d5f1f2c3bbbbb81b3","id":238874759,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640100600,"tms_id":"EP019559640046","s_no":6,"c":["Series"],"e":1640100600,"g":["Drama","Fantasy","Mystery "],"i":"cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","yp_req":false,"s":1640097300,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":6,"et":"Opfer der Sehnsucht","i_t":"17be62d86fe922aca6ff","id":238874760,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640103900,"tms_id":"EP019559640050","s_no":6,"c":["Series"],"e":1640103900,"g":["Drama","Fantasy","Mystery "],"i":"cms/17be62d86fe922aca6ff/format_480x360.jpg","yp_req":false,"s":1640100600,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}],"einsfestival":[{"cc":[],"e_no":13,"et":"Tr\u00fcgerischer Friede","i_t":"26a0c981a9aabb48f2c8","id":238889226,"ser_i_t":"e30ca90f0d4f39cd0226","ts_id":104039,"r_e":true,"i_url":"http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640091300,"tms_id":"EP014726400205","s_no":14,"c":["Series"],"e":1640091300,"g":["Drama","Hospital"],"i":"cms/26a0c981a9aabb48f2c8/format_480x360.jpg","yp_req":false,"s":1640088600,"t":"In aller Freundschaft","c_ids":[1]},{"yp_req":false,"i_url":"http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg","e":1640096700,"i":"cms/5cdd924d7c04ddc8184a/format_480x360.jpg","g":["Comedy"],"ser_e":false,"cc":[],"r_e":true,"ser_i_t":null,"c":["Movies"],"imdb_id":null,"rg_u":1640096700,"e_no":null,"s":1640091300,"t":"Stenzels Bescherung","c_ids":[5],"et":"","i_t":"5cdd924d7c04ddc8184a","id":238889227,"tms_id":"MV013526530000","s_no":null},{"cc":[],"e_no":6,"et":"Gef\u00e4hrliche Spiele","i_t":"3c84b5bdbfd35eb04bd1","id":238889228,"ser_i_t":"83b9c9d57247dfbf2abb","ts_id":134442,"r_e":true,"i_url":"http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640099700,"tms_id":"EP018542110041","s_no":2,"c":["Series"],"e":1640099700,"g":["Drama"],"i":"cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","yp_req":false,"s":1640096700,"t":"Der Dicke","c_ids":[1]},{"cc":[],"e_no":7,"et":"Spieglein, Spieglein","i_t":"daaad429b66e1efa8819","id":238889229,"ser_i_t":"2becf7a89c7b7e9c8314","ts_id":106779,"r_e":true,"i_url":"http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640102700,"tms_id":"EP018486430110","s_no":7,"c":["Series"],"e":1640102700,"g":["Comedy","Crime"],"i":"cms/daaad429b66e1efa8819/format_480x360.jpg","yp_req":false,"s":1640099700,"t":"Hubert und Staller","c_ids":[1]}]}}');
1 rows affected

-- ein paar Basisabfragen (für die Idee)
select jd::json->'channels' as channels from edg;
select  json_each( jd::json->'channels' ) from edg;
select  json_object_keys(jd::json->'channels' ),json_each_text(jd::json->'channels' ) from edg;  
select  e.* from edg, lateral json_each_text(jd::json->'channels' ) e;


channels


{"sixx_deutschland":[{"cc":[],"e_no":3,"et":"Vergissmeinnicht","i_t":"3260539e5ffe840b6b02","id":238874757,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640094000,"tms_id":"EP019559640045","s_no":6,"c":["Series"],"e":1640094000,"g":["Drama","Fantasy","Mystery "],"i":"cms/3260539e5ffe840b6b02/format_480x360.jpg","yp_req":false,"s":1640090700,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":4,"et":"Die Ohnmacht der Drei","i_t":"ad0d1a805f179b4979cd","id":239947163,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640097300,"tms_id":"EP019559640051","s_no":6,"c":["Series"],"e":1640097300,"g":["Drama","Fantasy","Mystery "],"i":"cms/ad0d1a805f179b4979cd/format_480x360.jpg","yp_req":false,"s":1640094000,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":5,"et":"T\u00f6dliche Liebe","i_t":"f17d5f1f2c3bbbbb81b3","id":238874759,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640100600,"tms_id":"EP019559640046","s_no":6,"c":["Series"],"e":1640100600,"g":["Drama","Fantasy","Mystery "],"i":"cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","yp_req":false,"s":1640097300,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":6,"et":"Opfer der Sehnsucht","i_t":"17be62d86fe922aca6ff","id":238874760,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640103900,"tms_id":"EP019559640050","s_no":6,"c":["Series"],"e":1640103900,"g":["Drama","Fantasy","Mystery "],"i":"cms/17be62d86fe922aca6ff/format_480x360.jpg","yp_req":false,"s":1640100600,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}],"einsfestival":[{"cc":[],"e_no":13,"et":"Tr\u00fcgerischer Friede","i_t":"26a0c981a9aabb48f2c8","id":238889226,"ser_i_t":"e30ca90f0d4f39cd0226","ts_id":104039,"r_e":true,"i_url":"http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640091300,"tms_id":"EP014726400205","s_no":14,"c":["Series"],"e":1640091300,"g":["Drama","Hospital"],"i":"cms/26a0c981a9aabb48f2c8/format_480x360.jpg","yp_req":false,"s":1640088600,"t":"In aller Freundschaft","c_ids":[1]},{"yp_req":false,"i_url":"http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg","e":1640096700,"i":"cms/5cdd924d7c04ddc8184a/format_480x360.jpg","g":["Comedy"],"ser_e":false,"cc":[],"r_e":true,"ser_i_t":null,"c":["Movies"],"imdb_id":null,"rg_u":1640096700,"e_no":null,"s":1640091300,"t":"Stenzels Bescherung","c_ids":[5],"et":"","i_t":"5cdd924d7c04ddc8184a","id":238889227,"tms_id":"MV013526530000","s_no":null},{"cc":[],"e_no":6,"et":"Gef\u00e4hrliche Spiele","i_t":"3c84b5bdbfd35eb04bd1","id":238889228,"ser_i_t":"83b9c9d57247dfbf2abb","ts_id":134442,"r_e":true,"i_url":"http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640099700,"tms_id":"EP018542110041","s_no":2,"c":["Series"],"e":1640099700,"g":["Drama"],"i":"cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","yp_req":false,"s":1640096700,"t":"Der Dicke","c_ids":[1]},{"cc":[],"e_no":7,"et":"Spieglein, Spieglein","i_t":"daaad429b66e1efa8819","id":238889229,"ser_i_t":"2becf7a89c7b7e9c8314","ts_id":106779,"r_e":true,"i_url":"http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640102700,"tms_id":"EP018486430110","s_no":7,"c":["Series"],"e":1640102700,"g":["Comedy","Crime"],"i":"cms/daaad429b66e1efa8819/format_480x360.jpg","yp_req":false,"s":1640099700,"t":"Hubert und Staller","c_ids":[1]}]}




json_each


(sixx_deutschland,"[{""cc"":[],""e_no"":3,""et"":""Vergissmeinnicht"",""i_t"":""3260539e5ffe840b6b02"",""id"":238874757,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640094000,""tms_id"":""EP019559640045"",""s_no"":6,""c"":[""Series""],""e"":1640094000,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/3260539e5ffe840b6b02/format_480x360.jpg"",""yp_req"":false,""s"":1640090700,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":4,""et"":""Die Ohnmacht der Drei"",""i_t"":""ad0d1a805f179b4979cd"",""id"":239947163,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640097300,""tms_id"":""EP019559640051"",""s_no"":6,""c"":[""Series""],""e"":1640097300,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/ad0d1a805f179b4979cd/format_480x360.jpg"",""yp_req"":false,""s"":1640094000,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":5,""et"":""T\u00f6dliche Liebe"",""i_t"":""f17d5f1f2c3bbbbb81b3"",""id"":238874759,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640100600,""tms_id"":""EP019559640046"",""s_no"":6,""c"":[""Series""],""e"":1640100600,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg"",""yp_req"":false,""s"":1640097300,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":6,""et"":""Opfer der Sehnsucht"",""i_t"":""17be62d86fe922aca6ff"",""id"":238874760,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640103900,""tms_id"":""EP019559640050"",""s_no"":6,""c"":[""Series""],""e"":1640103900,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/17be62d86fe922aca6ff/format_480x360.jpg"",""yp_req"":false,""s"":1640100600,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]}]")

(einsfestival,"[{""cc"":[],""e_no"":13,""et"":""Tr\u00fcgerischer Friede"",""i_t"":""26a0c981a9aabb48f2c8"",""id"":238889226,""ser_i_t"":""e30ca90f0d4f39cd0226"",""ts_id"":104039,""r_e"":true,""i_url"":""http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640091300,""tms_id"":""EP014726400205"",""s_no"":14,""c"":[""Series""],""e"":1640091300,""g"":[""Drama"",""Hospital""],""i"":""cms/26a0c981a9aabb48f2c8/format_480x360.jpg"",""yp_req"":false,""s"":1640088600,""t"":""In aller Freundschaft"",""c_ids"":[1]},{""yp_req"":false,""i_url"":""http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg"",""e"":1640096700,""i"":""cms/5cdd924d7c04ddc8184a/format_480x360.jpg"",""g"":[""Comedy""],""ser_e"":false,""cc"":[],""r_e"":true,""ser_i_t"":null,""c"":[""Movies""],""imdb_id"":null,""rg_u"":1640096700,""e_no"":null,""s"":1640091300,""t"":""Stenzels Bescherung"",""c_ids"":[5],""et"":"""",""i_t"":""5cdd924d7c04ddc8184a"",""id"":238889227,""tms_id"":""MV013526530000"",""s_no"":null},{""cc"":[],""e_no"":6,""et"":""Gef\u00e4hrliche Spiele"",""i_t"":""3c84b5bdbfd35eb04bd1"",""id"":238889228,""ser_i_t"":""83b9c9d57247dfbf2abb"",""ts_id"":134442,""r_e"":true,""i_url"":""http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640099700,""tms_id"":""EP018542110041"",""s_no"":2,""c"":[""Series""],""e"":1640099700,""g"":[""Drama""],""i"":""cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg"",""yp_req"":false,""s"":1640096700,""t"":""Der Dicke"",""c_ids"":[1]},{""cc"":[],""e_no"":7,""et"":""Spieglein, Spieglein"",""i_t"":""daaad429b66e1efa8819"",""id"":238889229,""ser_i_t"":""2becf7a89c7b7e9c8314"",""ts_id"":106779,""r_e"":true,""i_url"":""http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640102700,""tms_id"":""EP018486430110"",""s_no"":7,""c"":[""Series""],""e"":1640102700,""g"":[""Comedy"",""Crime""],""i"":""cms/daaad429b66e1efa8819/format_480x360.jpg"",""yp_req"":false,""s"":1640099700,""t"":""Hubert und Staller"",""c_ids"":[1]}]")




json_object_keys
json_each_text


sixx_deutschland
(sixx_deutschland,"[{""cc"":[],""e_no"":3,""et"":""Vergissmeinnicht"",""i_t"":""3260539e5ffe840b6b02"",""id"":238874757,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640094000,""tms_id"":""EP019559640045"",""s_no"":6,""c"":[""Series""],""e"":1640094000,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/3260539e5ffe840b6b02/format_480x360.jpg"",""yp_req"":false,""s"":1640090700,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":4,""et"":""Die Ohnmacht der Drei"",""i_t"":""ad0d1a805f179b4979cd"",""id"":239947163,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640097300,""tms_id"":""EP019559640051"",""s_no"":6,""c"":[""Series""],""e"":1640097300,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/ad0d1a805f179b4979cd/format_480x360.jpg"",""yp_req"":false,""s"":1640094000,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":5,""et"":""T\u00f6dliche Liebe"",""i_t"":""f17d5f1f2c3bbbbb81b3"",""id"":238874759,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640100600,""tms_id"":""EP019559640046"",""s_no"":6,""c"":[""Series""],""e"":1640100600,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg"",""yp_req"":false,""s"":1640097300,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]},{""cc"":[],""e_no"":6,""et"":""Opfer der Sehnsucht"",""i_t"":""17be62d86fe922aca6ff"",""id"":238874760,""ser_i_t"":""946d13ee02ba631cb6ee"",""ts_id"":104745,""r_e"":true,""i_url"":""http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640103900,""tms_id"":""EP019559640050"",""s_no"":6,""c"":[""Series""],""e"":1640103900,""g"":[""Drama"",""Fantasy"",""Mystery ""],""i"":""cms/17be62d86fe922aca6ff/format_480x360.jpg"",""yp_req"":false,""s"":1640100600,""t"":""Charmed - Zauberhafte Hexen"",""c_ids"":[1]}]")

einsfestival
(einsfestival,"[{""cc"":[],""e_no"":13,""et"":""Tr\u00fcgerischer Friede"",""i_t"":""26a0c981a9aabb48f2c8"",""id"":238889226,""ser_i_t"":""e30ca90f0d4f39cd0226"",""ts_id"":104039,""r_e"":true,""i_url"":""http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640091300,""tms_id"":""EP014726400205"",""s_no"":14,""c"":[""Series""],""e"":1640091300,""g"":[""Drama"",""Hospital""],""i"":""cms/26a0c981a9aabb48f2c8/format_480x360.jpg"",""yp_req"":false,""s"":1640088600,""t"":""In aller Freundschaft"",""c_ids"":[1]},{""yp_req"":false,""i_url"":""http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg"",""e"":1640096700,""i"":""cms/5cdd924d7c04ddc8184a/format_480x360.jpg"",""g"":[""Comedy""],""ser_e"":false,""cc"":[],""r_e"":true,""ser_i_t"":null,""c"":[""Movies""],""imdb_id"":null,""rg_u"":1640096700,""e_no"":null,""s"":1640091300,""t"":""Stenzels Bescherung"",""c_ids"":[5],""et"":"""",""i_t"":""5cdd924d7c04ddc8184a"",""id"":238889227,""tms_id"":""MV013526530000"",""s_no"":null},{""cc"":[],""e_no"":6,""et"":""Gef\u00e4hrliche Spiele"",""i_t"":""3c84b5bdbfd35eb04bd1"",""id"":238889228,""ser_i_t"":""83b9c9d57247dfbf2abb"",""ts_id"":134442,""r_e"":true,""i_url"":""http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640099700,""tms_id"":""EP018542110041"",""s_no"":2,""c"":[""Series""],""e"":1640099700,""g"":[""Drama""],""i"":""cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg"",""yp_req"":false,""s"":1640096700,""t"":""Der Dicke"",""c_ids"":[1]},{""cc"":[],""e_no"":7,""et"":""Spieglein, Spieglein"",""i_t"":""daaad429b66e1efa8819"",""id"":238889229,""ser_i_t"":""2becf7a89c7b7e9c8314"",""ts_id"":106779,""r_e"":true,""i_url"":""http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg"",""ser_e"":true,""imdb_id"":null,""rg_u"":1640102700,""tms_id"":""EP018486430110"",""s_no"":7,""c"":[""Series""],""e"":1640102700,""g"":[""Comedy"",""Crime""],""i"":""cms/daaad429b66e1efa8819/format_480x360.jpg"",""yp_req"":false,""s"":1640099700,""t"":""Hubert und Staller"",""c_ids"":[1]}]")




key
value


sixx_deutschland
[{"cc":[],"e_no":3,"et":"Vergissmeinnicht","i_t":"3260539e5ffe840b6b02","id":238874757,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640094000,"tms_id":"EP019559640045","s_no":6,"c":["Series"],"e":1640094000,"g":["Drama","Fantasy","Mystery "],"i":"cms/3260539e5ffe840b6b02/format_480x360.jpg","yp_req":false,"s":1640090700,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":4,"et":"Die Ohnmacht der Drei","i_t":"ad0d1a805f179b4979cd","id":239947163,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640097300,"tms_id":"EP019559640051","s_no":6,"c":["Series"],"e":1640097300,"g":["Drama","Fantasy","Mystery "],"i":"cms/ad0d1a805f179b4979cd/format_480x360.jpg","yp_req":false,"s":1640094000,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":5,"et":"T\u00f6dliche Liebe","i_t":"f17d5f1f2c3bbbbb81b3","id":238874759,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640100600,"tms_id":"EP019559640046","s_no":6,"c":["Series"],"e":1640100600,"g":["Drama","Fantasy","Mystery "],"i":"cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","yp_req":false,"s":1640097300,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]},{"cc":[],"e_no":6,"et":"Opfer der Sehnsucht","i_t":"17be62d86fe922aca6ff","id":238874760,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640103900,"tms_id":"EP019559640050","s_no":6,"c":["Series"],"e":1640103900,"g":["Drama","Fantasy","Mystery "],"i":"cms/17be62d86fe922aca6ff/format_480x360.jpg","yp_req":false,"s":1640100600,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}]

einsfestival
[{"cc":[],"e_no":13,"et":"Tr\u00fcgerischer Friede","i_t":"26a0c981a9aabb48f2c8","id":238889226,"ser_i_t":"e30ca90f0d4f39cd0226","ts_id":104039,"r_e":true,"i_url":"http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640091300,"tms_id":"EP014726400205","s_no":14,"c":["Series"],"e":1640091300,"g":["Drama","Hospital"],"i":"cms/26a0c981a9aabb48f2c8/format_480x360.jpg","yp_req":false,"s":1640088600,"t":"In aller Freundschaft","c_ids":[1]},{"yp_req":false,"i_url":"http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg","e":1640096700,"i":"cms/5cdd924d7c04ddc8184a/format_480x360.jpg","g":["Comedy"],"ser_e":false,"cc":[],"r_e":true,"ser_i_t":null,"c":["Movies"],"imdb_id":null,"rg_u":1640096700,"e_no":null,"s":1640091300,"t":"Stenzels Bescherung","c_ids":[5],"et":"","i_t":"5cdd924d7c04ddc8184a","id":238889227,"tms_id":"MV013526530000","s_no":null},{"cc":[],"e_no":6,"et":"Gef\u00e4hrliche Spiele","i_t":"3c84b5bdbfd35eb04bd1","id":238889228,"ser_i_t":"83b9c9d57247dfbf2abb","ts_id":134442,"r_e":true,"i_url":"http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640099700,"tms_id":"EP018542110041","s_no":2,"c":["Series"],"e":1640099700,"g":["Drama"],"i":"cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","yp_req":false,"s":1640096700,"t":"Der Dicke","c_ids":[1]},{"cc":[],"e_no":7,"et":"Spieglein, Spieglein","i_t":"daaad429b66e1efa8819","id":238889229,"ser_i_t":"2becf7a89c7b7e9c8314","ts_id":106779,"r_e":true,"i_url":"http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640102700,"tms_id":"EP018486430110","s_no":7,"c":["Series"],"e":1640102700,"g":["Comedy","Crime"],"i":"cms/daaad429b66e1efa8819/format_480x360.jpg","yp_req":false,"s":1640099700,"t":"Hubert und Staller","c_ids":[1]}]


-- Kernabfrage
select d.key as channel, json_array_elements(d.value) as record from 
(select  e.* from edg, lateral json_each(jd::json->'channels' ) e)d;


channel
record


sixx_deutschland
{"cc":[],"e_no":3,"et":"Vergissmeinnicht","i_t":"3260539e5ffe840b6b02","id":238874757,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640094000,"tms_id":"EP019559640045","s_no":6,"c":["Series"],"e":1640094000,"g":["Drama","Fantasy","Mystery "],"i":"cms/3260539e5ffe840b6b02/format_480x360.jpg","yp_req":false,"s":1640090700,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}

sixx_deutschland
{"cc":[],"e_no":4,"et":"Die Ohnmacht der Drei","i_t":"ad0d1a805f179b4979cd","id":239947163,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640097300,"tms_id":"EP019559640051","s_no":6,"c":["Series"],"e":1640097300,"g":["Drama","Fantasy","Mystery "],"i":"cms/ad0d1a805f179b4979cd/format_480x360.jpg","yp_req":false,"s":1640094000,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}

sixx_deutschland
{"cc":[],"e_no":5,"et":"T\u00f6dliche Liebe","i_t":"f17d5f1f2c3bbbbb81b3","id":238874759,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640100600,"tms_id":"EP019559640046","s_no":6,"c":["Series"],"e":1640100600,"g":["Drama","Fantasy","Mystery "],"i":"cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","yp_req":false,"s":1640097300,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}

sixx_deutschland
{"cc":[],"e_no":6,"et":"Opfer der Sehnsucht","i_t":"17be62d86fe922aca6ff","id":238874760,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640103900,"tms_id":"EP019559640050","s_no":6,"c":["Series"],"e":1640103900,"g":["Drama","Fantasy","Mystery "],"i":"cms/17be62d86fe922aca6ff/format_480x360.jpg","yp_req":false,"s":1640100600,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}

einsfestival
{"cc":[],"e_no":13,"et":"Tr\u00fcgerischer Friede","i_t":"26a0c981a9aabb48f2c8","id":238889226,"ser_i_t":"e30ca90f0d4f39cd0226","ts_id":104039,"r_e":true,"i_url":"http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640091300,"tms_id":"EP014726400205","s_no":14,"c":["Series"],"e":1640091300,"g":["Drama","Hospital"],"i":"cms/26a0c981a9aabb48f2c8/format_480x360.jpg","yp_req":false,"s":1640088600,"t":"In aller Freundschaft","c_ids":[1]}

einsfestival
{"yp_req":false,"i_url":"http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg","e":1640096700,"i":"cms/5cdd924d7c04ddc8184a/format_480x360.jpg","g":["Comedy"],"ser_e":false,"cc":[],"r_e":true,"ser_i_t":null,"c":["Movies"],"imdb_id":null,"rg_u":1640096700,"e_no":null,"s":1640091300,"t":"Stenzels Bescherung","c_ids":[5],"et":"","i_t":"5cdd924d7c04ddc8184a","id":238889227,"tms_id":"MV013526530000","s_no":null}

einsfestival
{"cc":[],"e_no":6,"et":"Gef\u00e4hrliche Spiele","i_t":"3c84b5bdbfd35eb04bd1","id":238889228,"ser_i_t":"83b9c9d57247dfbf2abb","ts_id":134442,"r_e":true,"i_url":"http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640099700,"tms_id":"EP018542110041","s_no":2,"c":["Series"],"e":1640099700,"g":["Drama"],"i":"cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","yp_req":false,"s":1640096700,"t":"Der Dicke","c_ids":[1]}

einsfestival
{"cc":[],"e_no":7,"et":"Spieglein, Spieglein","i_t":"daaad429b66e1efa8819","id":238889229,"ser_i_t":"2becf7a89c7b7e9c8314","ts_id":106779,"r_e":true,"i_url":"http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640102700,"tms_id":"EP018486430110","s_no":7,"c":["Series"],"e":1640102700,"g":["Comedy","Crime"],"i":"cms/daaad429b66e1efa8819/format_480x360.jpg","yp_req":false,"s":1640099700,"t":"Hubert und Staller","c_ids":[1]}


-- Kernabfrage mit allen Spalten benannt
select channel, 
       record->>'cc' as _Array,
       record->>'e_no' as nummer,
       record->>'et' as subTitel,       
       record->>'i_t' as eineID,
       record->>'id' as eineID2,
       record->>'ser_i_t' as eineID3,
       record->>'ts_id' as eineID4,
       record->>'r_e' as einBool,
       record->>'i_url' as bildURLLink,
       record->>'ser_e' as einBool,
       record->>'imdb_id' as imdbLink,
       record->>'rg_u' as eineID4,
       record->>'tms_id' as eineID4,
       record->>'s_no' as einZahl,
       record->>'c' as typ,
       record->>'e' as eineZahl,
       record->>'g' as tags_Array,
       record->>'i' as bildCMSLink,
       record->>'yp_req' as einBool,
       record->>'s' as eineZahl,
       record->>'t' as Titel,
       record->>'c_ids' as einZahl_Array
  from (select d.key as channel, json_array_elements(d.value) as record from 
         (select  e.* from edg, lateral json_each(jd::json->'channels' ) e)d)r;


channel
_array
nummer
subtitel
eineid
eineid2
eineid3
eineid4
einbool
bildurllink
einbool
imdblink
eineid4
eineid4
einzahl
typ
einezahl
tags_array
bildcmslink
einbool
einezahl
titel
einzahl_array


sixx_deutschland
[]
3
Vergissmeinnicht
3260539e5ffe840b6b02
238874757
946d13ee02ba631cb6ee
104745
true
http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg
true
null
1640094000
EP019559640045
6
["Series"]
1640094000
["Drama","Fantasy","Mystery "]
cms/3260539e5ffe840b6b02/format_480x360.jpg
false
1640090700
Charmed - Zauberhafte Hexen
[1]

sixx_deutschland
[]
4
Die Ohnmacht der Drei
ad0d1a805f179b4979cd
239947163
946d13ee02ba631cb6ee
104745
true
http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg
true
null
1640097300
EP019559640051
6
["Series"]
1640097300
["Drama","Fantasy","Mystery "]
cms/ad0d1a805f179b4979cd/format_480x360.jpg
false
1640094000
Charmed - Zauberhafte Hexen
[1]

sixx_deutschland
[]
5
Tödliche Liebe
f17d5f1f2c3bbbbb81b3
238874759
946d13ee02ba631cb6ee
104745
true
http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg
true
null
1640100600
EP019559640046
6
["Series"]
1640100600
["Drama","Fantasy","Mystery "]
cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg
false
1640097300
Charmed - Zauberhafte Hexen
[1]

sixx_deutschland
[]
6
Opfer der Sehnsucht
17be62d86fe922aca6ff
238874760
946d13ee02ba631cb6ee
104745
true
http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg
true
null
1640103900
EP019559640050
6
["Series"]
1640103900
["Drama","Fantasy","Mystery "]
cms/17be62d86fe922aca6ff/format_480x360.jpg
false
1640100600
Charmed - Zauberhafte Hexen
[1]

einsfestival
[]
13
Trügerischer Friede
26a0c981a9aabb48f2c8
238889226
e30ca90f0d4f39cd0226
104039
true
http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg
true
null
1640091300
EP014726400205
14
["Series"]
1640091300
["Drama","Hospital"]
cms/26a0c981a9aabb48f2c8/format_480x360.jpg
false
1640088600
In aller Freundschaft
[1]

einsfestival
[]
null

5cdd924d7c04ddc8184a
238889227
null
null
true
http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg
false
null
1640096700
MV013526530000
null
["Movies"]
1640096700
["Comedy"]
cms/5cdd924d7c04ddc8184a/format_480x360.jpg
false
1640091300
Stenzels Bescherung
[5]

einsfestival
[]
6
Gefährliche Spiele
3c84b5bdbfd35eb04bd1
238889228
83b9c9d57247dfbf2abb
134442
true
http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg
true
null
1640099700
EP018542110041
2
["Series"]
1640099700
["Drama"]
cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg
false
1640096700
Der Dicke
[1]

einsfestival
[]
7
Spieglein, Spieglein
daaad429b66e1efa8819
238889229
2becf7a89c7b7e9c8314
106779
true
http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg
true
null
1640102700
EP018486430110
7
["Series"]
1640102700
["Comedy","Crime"]
cms/daaad429b66e1efa8819/format_480x360.jpg
false
1640099700
Hubert und Staller
[1]


-- Transformation, nur interessante Spalten
select channel, 
       record->>'t' as titel,
       record->>'et' as subTitel,       
       record->>'i_t' as eineID,
       record->>'i_url' as bildURLLink,
       record->>'tms_id' as eineID,
       record->>'c' as typ,
       record->>'g' as tags_Array,
       record->>'i' as bildCMSLink
  from (select d.key as channel, json_array_elements(d.value) as record from 
         (select  e.* from edg, lateral json_each(jd::json->'channels' ) e)d)r;


channel
titel
subtitel
eineid
bildurllink
eineid
typ
tags_array
bildcmslink


sixx_deutschland
Charmed - Zauberhafte Hexen
Vergissmeinnicht
3260539e5ffe840b6b02
http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg
EP019559640045
["Series"]
["Drama","Fantasy","Mystery "]
cms/3260539e5ffe840b6b02/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Die Ohnmacht der Drei
ad0d1a805f179b4979cd
http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg
EP019559640051
["Series"]
["Drama","Fantasy","Mystery "]
cms/ad0d1a805f179b4979cd/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Tödliche Liebe
f17d5f1f2c3bbbbb81b3
http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg
EP019559640046
["Series"]
["Drama","Fantasy","Mystery "]
cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Opfer der Sehnsucht
17be62d86fe922aca6ff
http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg
EP019559640050
["Series"]
["Drama","Fantasy","Mystery "]
cms/17be62d86fe922aca6ff/format_480x360.jpg

einsfestival
In aller Freundschaft
Trügerischer Friede
26a0c981a9aabb48f2c8
http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg
EP014726400205
["Series"]
["Drama","Hospital"]
cms/26a0c981a9aabb48f2c8/format_480x360.jpg

einsfestival
Stenzels Bescherung

5cdd924d7c04ddc8184a
http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg
MV013526530000
["Movies"]
["Comedy"]
cms/5cdd924d7c04ddc8184a/format_480x360.jpg

einsfestival
Der Dicke
Gefährliche Spiele
3c84b5bdbfd35eb04bd1
http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg
EP018542110041
["Series"]
["Drama"]
cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg

einsfestival
Hubert und Staller
Spieglein, Spieglein
daaad429b66e1efa8819
http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg
EP018486430110
["Series"]
["Comedy","Crime"]
cms/daaad429b66e1efa8819/format_480x360.jpg


-- transformiert und Beispielfilter
select channel, 
       record->>'t' as titel,
       record->>'et' as subTitel,       
       record->>'i_t' as eineID,
       record->>'i_url' as bildURLLink,
       record->>'tms_id' as eineID,
       record->>'c' as typ,
       record->>'g' as tags_Array,
       record->>'i' as bildCMSLink
  from (select d.key as channel, json_array_elements(d.value) as record from 
         (select  e.* from edg, lateral json_each(jd::json->'channels' ) e)d)r
 where record->>'t' like 'Charmed%';


channel
titel
subtitel
eineid
bildurllink
eineid
typ
tags_array
bildcmslink


sixx_deutschland
Charmed - Zauberhafte Hexen
Vergissmeinnicht
3260539e5ffe840b6b02
http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg
EP019559640045
["Series"]
["Drama","Fantasy","Mystery "]
cms/3260539e5ffe840b6b02/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Die Ohnmacht der Drei
ad0d1a805f179b4979cd
http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg
EP019559640051
["Series"]
["Drama","Fantasy","Mystery "]
cms/ad0d1a805f179b4979cd/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Tödliche Liebe
f17d5f1f2c3bbbbb81b3
http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg
EP019559640046
["Series"]
["Drama","Fantasy","Mystery "]
cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg

sixx_deutschland
Charmed - Zauberhafte Hexen
Opfer der Sehnsucht
17be62d86fe922aca6ff
http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg
EP019559640050
["Series"]
["Drama","Fantasy","Mystery "]
cms/17be62d86fe922aca6ff/format_480x360.jpg

channel	record
sixx_deutschland	{"cc":[],"e_no":3,"et":"Vergissmeinnicht","i_t":"3260539e5ffe840b6b02","id":238874757,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640094000,"tms_id":"EP019559640045","s_no":6,"c":["Series"],"e":1640094000,"g":["Drama","Fantasy","Mystery "],"i":"cms/3260539e5ffe840b6b02/format_480x360.jpg","yp_req":false,"s":1640090700,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}
sixx_deutschland	{"cc":[],"e_no":4,"et":"Die Ohnmacht der Drei","i_t":"ad0d1a805f179b4979cd","id":239947163,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640097300,"tms_id":"EP019559640051","s_no":6,"c":["Series"],"e":1640097300,"g":["Drama","Fantasy","Mystery "],"i":"cms/ad0d1a805f179b4979cd/format_480x360.jpg","yp_req":false,"s":1640094000,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}
sixx_deutschland	{"cc":[],"e_no":5,"et":"T\u00f6dliche Liebe","i_t":"f17d5f1f2c3bbbbb81b3","id":238874759,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640100600,"tms_id":"EP019559640046","s_no":6,"c":["Series"],"e":1640100600,"g":["Drama","Fantasy","Mystery "],"i":"cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg","yp_req":false,"s":1640097300,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}
sixx_deutschland	{"cc":[],"e_no":6,"et":"Opfer der Sehnsucht","i_t":"17be62d86fe922aca6ff","id":238874760,"ser_i_t":"946d13ee02ba631cb6ee","ts_id":104745,"r_e":true,"i_url":"http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640103900,"tms_id":"EP019559640050","s_no":6,"c":["Series"],"e":1640103900,"g":["Drama","Fantasy","Mystery "],"i":"cms/17be62d86fe922aca6ff/format_480x360.jpg","yp_req":false,"s":1640100600,"t":"Charmed - Zauberhafte Hexen","c_ids":[1]}
einsfestival	{"cc":[],"e_no":13,"et":"Tr\u00fcgerischer Friede","i_t":"26a0c981a9aabb48f2c8","id":238889226,"ser_i_t":"e30ca90f0d4f39cd0226","ts_id":104039,"r_e":true,"i_url":"http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640091300,"tms_id":"EP014726400205","s_no":14,"c":["Series"],"e":1640091300,"g":["Drama","Hospital"],"i":"cms/26a0c981a9aabb48f2c8/format_480x360.jpg","yp_req":false,"s":1640088600,"t":"In aller Freundschaft","c_ids":[1]}
einsfestival	{"yp_req":false,"i_url":"http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg","e":1640096700,"i":"cms/5cdd924d7c04ddc8184a/format_480x360.jpg","g":["Comedy"],"ser_e":false,"cc":[],"r_e":true,"ser_i_t":null,"c":["Movies"],"imdb_id":null,"rg_u":1640096700,"e_no":null,"s":1640091300,"t":"Stenzels Bescherung","c_ids":[5],"et":"","i_t":"5cdd924d7c04ddc8184a","id":238889227,"tms_id":"MV013526530000","s_no":null}
einsfestival	{"cc":[],"e_no":6,"et":"Gef\u00e4hrliche Spiele","i_t":"3c84b5bdbfd35eb04bd1","id":238889228,"ser_i_t":"83b9c9d57247dfbf2abb","ts_id":134442,"r_e":true,"i_url":"http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640099700,"tms_id":"EP018542110041","s_no":2,"c":["Series"],"e":1640099700,"g":["Drama"],"i":"cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg","yp_req":false,"s":1640096700,"t":"Der Dicke","c_ids":[1]}
einsfestival	{"cc":[],"e_no":7,"et":"Spieglein, Spieglein","i_t":"daaad429b66e1efa8819","id":238889229,"ser_i_t":"2becf7a89c7b7e9c8314","ts_id":106779,"r_e":true,"i_url":"http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg","ser_e":true,"imdb_id":null,"rg_u":1640102700,"tms_id":"EP018486430110","s_no":7,"c":["Series"],"e":1640102700,"g":["Comedy","Crime"],"i":"cms/daaad429b66e1efa8819/format_480x360.jpg","yp_req":false,"s":1640099700,"t":"Hubert und Staller","c_ids":[1]}

channel	_array	nummer	subtitel	eineid	eineid2	eineid3	eineid4	einbool	bildurllink	einbool	imdblink	eineid4	eineid4	einzahl	typ	einezahl	tags_array	bildcmslink	einbool	einezahl	titel	einzahl_array
sixx_deutschland	[]	3	Vergissmeinnicht	3260539e5ffe840b6b02	238874757	946d13ee02ba631cb6ee	104745	true	http://images.zattic.com/cms/3260539e5ffe840b6b02/format_480x360.jpg	true	null	1640094000	EP019559640045	6	["Series"]	1640094000	["Drama","Fantasy","Mystery "]	cms/3260539e5ffe840b6b02/format_480x360.jpg	false	1640090700	Charmed - Zauberhafte Hexen	[1]
sixx_deutschland	[]	4	Die Ohnmacht der Drei	ad0d1a805f179b4979cd	239947163	946d13ee02ba631cb6ee	104745	true	http://images.zattic.com/cms/ad0d1a805f179b4979cd/format_480x360.jpg	true	null	1640097300	EP019559640051	6	["Series"]	1640097300	["Drama","Fantasy","Mystery "]	cms/ad0d1a805f179b4979cd/format_480x360.jpg	false	1640094000	Charmed - Zauberhafte Hexen	[1]
sixx_deutschland	[]	5	Tödliche Liebe	f17d5f1f2c3bbbbb81b3	238874759	946d13ee02ba631cb6ee	104745	true	http://images.zattic.com/cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg	true	null	1640100600	EP019559640046	6	["Series"]	1640100600	["Drama","Fantasy","Mystery "]	cms/f17d5f1f2c3bbbbb81b3/format_480x360.jpg	false	1640097300	Charmed - Zauberhafte Hexen	[1]
sixx_deutschland	[]	6	Opfer der Sehnsucht	17be62d86fe922aca6ff	238874760	946d13ee02ba631cb6ee	104745	true	http://images.zattic.com/cms/17be62d86fe922aca6ff/format_480x360.jpg	true	null	1640103900	EP019559640050	6	["Series"]	1640103900	["Drama","Fantasy","Mystery "]	cms/17be62d86fe922aca6ff/format_480x360.jpg	false	1640100600	Charmed - Zauberhafte Hexen	[1]
einsfestival	[]	13	Trügerischer Friede	26a0c981a9aabb48f2c8	238889226	e30ca90f0d4f39cd0226	104039	true	http://images.zattic.com/cms/26a0c981a9aabb48f2c8/format_480x360.jpg	true	null	1640091300	EP014726400205	14	["Series"]	1640091300	["Drama","Hospital"]	cms/26a0c981a9aabb48f2c8/format_480x360.jpg	false	1640088600	In aller Freundschaft	[1]
einsfestival	[]	null		5cdd924d7c04ddc8184a	238889227	null	null	true	http://images.zattic.com/cms/5cdd924d7c04ddc8184a/format_480x360.jpg	false	null	1640096700	MV013526530000	null	["Movies"]	1640096700	["Comedy"]	cms/5cdd924d7c04ddc8184a/format_480x360.jpg	false	1640091300	Stenzels Bescherung	[5]
einsfestival	[]	6	Gefährliche Spiele	3c84b5bdbfd35eb04bd1	238889228	83b9c9d57247dfbf2abb	134442	true	http://images.zattic.com/cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg	true	null	1640099700	EP018542110041	2	["Series"]	1640099700	["Drama"]	cms/3c84b5bdbfd35eb04bd1/format_480x360.jpg	false	1640096700	Der Dicke	[1]
einsfestival	[]	7	Spieglein, Spieglein	daaad429b66e1efa8819	238889229	2becf7a89c7b7e9c8314	106779	true	http://images.zattic.com/cms/daaad429b66e1efa8819/format_480x360.jpg	true	null	1640102700	EP018486430110	7	["Series"]	1640102700	["Comedy","Crime"]	cms/daaad429b66e1efa8819/format_480x360.jpg	false	1640099700	Hubert und Staller	[1]