Avatar - Der Herr der Elemente (S1/F2) im TV Programm: 12:20 - 31.05.

Sendungsinfo

« Zurück

Vor »

Beschreibung

Zum Serienprofil

Der Avatar kehrt zurück - Sokka und Katara wollen nicht tatenlos zusehen, wie sich ihr Freund für sie opfert. Aang hatte sich freiwillig den Kriegern der Feuernation gestellt, um die Wassernation zu schützen. Obgleich seine Situation aussichtslos zu sein scheint, zeigt sich bald, dass er den Feuerkriegern durchaus gewachsen ist...

Stars

Zach Tyler
Mae Whitman

Crew

Regie

Michael Dante Dimartino
Bryan Konietzko
Drehbuch

Michael Dante Dimartino
Bryan Konietzko
Musik

Jeremy Zuckerman
Benjamin Wynn
Produzent

Michael Dante Dimartino
Aaron Ehasz
Bryan Konietzko
Ton

Justin Brinsfield
Schnitt

Jeff Adams

-- Debugger --

PHP-Verarbeitungszeit: 0,8884 Sekunden

SELECT cg.id, cg.name FROM t_channel_groups AS cg WHERE cg.checksum = 3836484992Ausführungszeit: 0,0017 Sekunden

SELECT c.id, c.name, c.is_paytv, cd.zattoo FROM t_channel AS c LEFT JOIN t_channel_data_seo AS cd ON cd.channel_id=c.id WHERE checksum = 3836484992Ausführungszeit: 0,0014 Sekunden

SELECT b.id, b.starttime, b.endtime, b.utc_offset, b.tvshow_id, b.channel_id, bc.url_name AS broadcast_url, bt.leadtext, ts.category_id, tsd.title, tsd.subtitle, tsd.year, tsd.charakter, tsd.country, tsd.rating, tsd.rating_humor, tsd.rating_action, tsd.rating_excite, tsd.rating_erotic, tsd.rating_romantic, tsd.quote as quotetext, bd.dolby, bd.tip, bd.hd, bd.blinde, bd.wide, bd.zweikanal, bd.stereo, bd.untertitel, bd.pic3d, bd.neu, bd.live, she.staffel, she.folge, she.series_id, s.name AS series_name, s.topserial, c.name, c.is_paytv, bi.url_prefix, bi.filename, tsd.description, tv.filetype, tv.url, tv.width, tv.height, ty.url AS youtube FROM t_broadcast AS b LEFT JOIN t_broadcast_checksum AS bc ON bc.broadcast_id=b.id LEFT JOIN t_broadcast_data AS bd ON bd.broadcast_id=b.id LEFT JOIN t_broadcast_tips AS bt ON bt.broadcast_id=b.id LEFT JOIN t_broadcast_images_wide AS bi ON bi.broadcast_id = b.id LEFT JOIN t_tvshow AS ts ON b.tvshow_id=ts.id LEFT JOIN t_channel AS c ON b.channel_id=c.id LEFT JOIN t_tvshow_data AS tsd ON ts.id=tsd.tvshow_id LEFT JOIN t_series_has_episodes AS she ON she.tvshow_id=b.tvshow_id LEFT JOIN t_series AS s ON she.series_id=s.id LEFT JOIN t_tvshow_videos AS tv ON tv.tvshow_id = ts.id LEFT JOIN x_ternal_youtube_trailer AS ty ON ty.tvshow_id = ts.id WHERE bc.checksum = 3077705058 ORDER BY ABS(b.starttime-1495943991) LIMIT 1Ausführungszeit: 0,0032 Sekunden

SELECT c.id, c.name, c.is_paytv, cd.zattoo FROM t_channel_has_group AS chg LEFT JOIN t_channel_groups AS cg ON cg.id = chg.group_id LEFT JOIN t_channel AS c ON c.id=chg.channel_id LEFT JOIN t_channel_data_seo AS cd ON cd.channel_id=c.id ORDER BY cg.sort, chg.sort LIMIT 0,30Ausführungszeit: 0,0008 Sekunden

SELECT chg.*, c.url_name FROM t_channel_has_group AS chg LEFT JOIN t_channel AS c ON c.id = chg.channel_id ORDER BY chg.group_id, chg.sortAusführungszeit: 0,0012 Sekunden

SELECT * FROM t_seo_fields WHERE url='http://www.hoerzu.de/tv-programm/avatar-der-herr-der-elemente/der-avatar-kehrt-zurueck/'Ausführungszeit: 0,0028 Sekunden

SELECT * FROM t_tvshow_has_actor AS tsha LEFT JOIN t_person AS p ON tsha.person_id=p.id WHERE tsha.tvshow_id = 48832041 ORDER BY `tsha`.`sort` ASCAusführungszeit: 0,0027 Sekunden

SELECT *, tshc.job as movie_job FROM t_tvshow_has_crew AS tshc LEFT JOIN t_person AS p ON tshc.person_id=p.id WHERE tshc.tvshow_id = 48832041 ORDER BY tshc.person_group_idAusführungszeit: 0,0023 Sekunden

SELECT concat(bi.url_prefix, bi.filename) AS image FROM t_broadcast_images_wide as bi WHERE bi.broadcast_id = 117658762 ORDER BY bi.sortAusführungszeit: 0,0022 Sekunden

SELECT t.url_name, t.tag FROM t_tvshow_tags AS t LEFT JOIN t_broadcast AS b ON b.tvshow_id = t.tvshow_id WHERE b.id = 117658762Ausführungszeit: 0,0028 Sekunden

SELECT b.id, b.starttime, b.endtime, b.utc_offset, b.tvshow_id, b.channel_id, bc.url_name AS broadcast_url, ts.category_id, tsd.title, tsd.subtitle, tsd.year, tsd.charakter, tsd.country, tsd.description, c.name, c.is_paytv, she.staffel, she.folge, she.series_id FROM t_broadcast AS b LEFT JOIN t_broadcast_checksum AS bc ON bc.broadcast_id=b.id LEFT JOIN t_tvshow AS ts ON b.tvshow_id = ts.id LEFT JOIN t_tvshow_data AS tsd ON ts.id = tsd.tvshow_id LEFT JOIN t_channel AS c ON c.id=b.channel_id LEFT JOIN t_series_has_episodes AS she ON she.tvshow_id=b.tvshow_id WHERE b.tvshow_id = 48832041 AND b.id != 117658762 ORDER BY b.starttime LIMIT 7Ausführungszeit: 0,0017 Sekunden

Aktuelle Zeit: 20:15
Aktuelles Datum: 28.05.2017
DayPath: heute/
Active Content: broadcast_detail
Active Channel:
Active Category:
Active Channel Group:
Aktueller Timestamp: 1495995300
DynCon:
DynParams:
Subpage: beschreibung
Aktueller Zeitabschnitt: abend
Sender: Nicktoons (551)
Ausstrahlungs Id: 117658762
Sendung Id: 48832041

Avatar - Der Herr der Elemente

Der Avatar kehrt zurück

Beschreibung

Stars

Crew

Ähnliche Sendungen

-- Debugger --