PROdigital TV e.V.

(default) 4 queries took 17 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 24, 6	6	6	12
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 (21, 28, 10, 52, 53, 71) ORDER BY `MediaImage`.`sort_order` ASC	9	9	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` = 'a8d07f312d4bca6c6d2ae66d74938ba5' LIMIT 1	0	0	0

(default) 4 queries took 17 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 24, 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 (21, 28, 10, 52, 53, 71) 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` = 'a8d07f312d4bca6c6d2ae66d74938ba5' LIMIT 1

Medienfrühstück Archiv

Medienfrühstück in Salzburg

42. Medienfrühstück von PROdigitalTV

Mitglieder Regionaltreffen Hamburg um 11 Uhr

Jahreshauptversammlung Online - Members only

PROdigitalTV kompakt: Barrierefreiheit in den Medien - Do. 21.10.2021, 10:00 Uhr

MEMBERS ONLY: SAVE THE DATE ZUR DIESJÄHRIGEN MITGLIEDERVERSAMMLUNG