PROdigital TV e.V.

(default) 4 queries took 18 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Date`.`id`, `Date`.`name`, `Date`.`subline`, `Date`.`cap`, `Date`.`date`, `Date`.`time`, `Date`.`text`, `Date`.`location`, `Date`.`city`, `Date`.`code`, `Date`.`street`, `Date`.`number`, `Date`.`eventcode`, `Date`.`sponsors_id`, `Date`.`livestream`, `Date`.`hls_url`, `Date`.`banner`, `Date`.`visible`, `Sponsor`.`id`, `Sponsor`.`name`, `Sponsor`.`date`, `Sponsor`.`city`, `Sponsor`.`image`, `Sponsor`.`thumbnail`, `Sponsor`.`link`, `Teaser`.`id`, `Teaser`.`image`, `Teaser`.`thumbnail`, `Teaser`.`credit`, `Teaser`.`description`, `Teaser`.`sort_order`, `Teaser`.`story_id`, `Teaser`.`model`, `Teaser`.`is_teaser` FROM `cake_prodigital2`.`dates` AS `Date` LEFT JOIN `cake_prodigital2`.`sponsors` AS `Sponsor` ON (`Date`.`sponsors_id` = `Sponsor`.`id`) LEFT JOIN `cake_prodigital2`.`z_media_images` AS `Teaser` ON (`Teaser`.`story_id` = `Date`.`id` AND model = 'Date' AND is_teaser = 1) WHERE `Date`.`date` < CURDATE() AND `Date`.`visible` = '1' ORDER BY `Date`.`city` desc LIMIT 42, 6	6	6	13
2	SELECT `MediaImage`.`id`, `MediaImage`.`image`, `MediaImage`.`thumbnail`, `MediaImage`.`credit`, `MediaImage`.`description`, `MediaImage`.`sort_order`, `MediaImage`.`story_id`, `MediaImage`.`model`, `MediaImage`.`is_teaser` FROM `cake_prodigital2`.`z_media_images` AS `MediaImage` WHERE `MediaImage`.`model` = 'Date' AND `MediaImage`.`story_id` IN (25, 34, 35, 75, 81, 72) ORDER BY `MediaImage`.`sort_order` ASC	39	39	1
3	SELECT COUNT(*) AS `count` FROM `cake_prodigital2`.`dates` AS `Date` LEFT JOIN `cake_prodigital2`.`sponsors` AS `Sponsor` ON (`Date`.`sponsors_id` = `Sponsor`.`id`) LEFT JOIN `cake_prodigital2`.`z_media_images` AS `Teaser` ON (`Teaser`.`story_id` = `Date`.`id` AND model = 'Date' AND is_teaser = 1) WHERE `Date`.`date` < CURDATE() AND `Date`.`visible` = '1'	1	1	4
4	SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_prodigital2`.`cake_sessions` AS `Session` WHERE `id` = '1aa38138240293570f74f84d939b9d99' LIMIT 1	0	0	0

(default) 4 queries took 18 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Date`.`id`, `Date`.`name`, `Date`.`subline`, `Date`.`cap`, `Date`.`date`, `Date`.`time`, `Date`.`text`, `Date`.`location`, `Date`.`city`, `Date`.`code`, `Date`.`street`, `Date`.`number`, `Date`.`eventcode`, `Date`.`sponsors_id`, `Date`.`livestream`, `Date`.`hls_url`, `Date`.`banner`, `Date`.`visible`, `Sponsor`.`id`, `Sponsor`.`name`, `Sponsor`.`date`, `Sponsor`.`city`, `Sponsor`.`image`, `Sponsor`.`thumbnail`, `Sponsor`.`link`, `Teaser`.`id`, `Teaser`.`image`, `Teaser`.`thumbnail`, `Teaser`.`credit`, `Teaser`.`description`, `Teaser`.`sort_order`, `Teaser`.`story_id`, `Teaser`.`model`, `Teaser`.`is_teaser` FROM `cake_prodigital2`.`dates` AS `Date` LEFT JOIN `cake_prodigital2`.`sponsors` AS `Sponsor` ON (`Date`.`sponsors_id` = `Sponsor`.`id`) LEFT JOIN `cake_prodigital2`.`z_media_images` AS `Teaser` ON (`Teaser`.`story_id` = `Date`.`id` AND model = 'Date' AND is_teaser = 1) WHERE `Date`.`date` < CURDATE() AND `Date`.`visible` = '1' ORDER BY `Date`.`city` desc LIMIT 42, 6

SELECT `MediaImage`.`id`, `MediaImage`.`image`, `MediaImage`.`thumbnail`, `MediaImage`.`credit`, `MediaImage`.`description`, `MediaImage`.`sort_order`, `MediaImage`.`story_id`, `MediaImage`.`model`, `MediaImage`.`is_teaser` FROM `cake_prodigital2`.`z_media_images` AS `MediaImage` WHERE `MediaImage`.`model` = 'Date' AND `MediaImage`.`story_id` IN (25, 34, 35, 75, 81, 72) ORDER BY `MediaImage`.`sort_order` ASC

SELECT COUNT(*) AS `count` FROM `cake_prodigital2`.`dates` AS `Date` LEFT JOIN `cake_prodigital2`.`sponsors` AS `Sponsor` ON (`Date`.`sponsors_id` = `Sponsor`.`id`) LEFT JOIN `cake_prodigital2`.`z_media_images` AS `Teaser` ON (`Teaser`.`story_id` = `Date`.`id` AND model = 'Date' AND is_teaser = 1) WHERE `Date`.`date` < CURDATE() AND `Date`.`visible` = '1'

SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_prodigital2`.`cake_sessions` AS `Session` WHERE `id` = '1aa38138240293570f74f84d939b9d99' LIMIT 1

Medienfrühstück Archiv

40. Medienfrühstück

PROdigitalTV Mitgliederversammlung

Mitgliederversammlung von PROdigitalTV: Vorstand im Amt bestätigt

PROdigitalTV Medienfrühstück am 18. Februar 2025 in Berlin, KANZLEI HEUSSEN: Die Agenda

EINLADUNG! PROdigitalTV lädt zum Medienfrühstück zur Berlinale am Di., den 17. Februar, in die Kanzlei HEUSSEN ein

MEMBERS ONLY! 20 % Rabatt für MediaTech Hub Conference 25./26.09.2024