| 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 6, 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 (31, 69, 80, 48, 76, 20) ORDER BY `MediaImage`.`sort_order` ASC | | 16 | 16 | 1 |
