SELECT `News`.`id`, `News`.`title`, `News`.`text`, `News`.`slug`, `News`.`user_id`, `News`.`link`, `News`.`media_id`, `News`.`created`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`name`, `User`.`role`, `User`.`created`, `User`.`modified`, `User`.`hash_change_password`, `Media`.`id`, `Media`.`dirname`, `Media`.`basename`, `Media`.`checksum`, `Media`.`alternative`, `Media`.`description`, `Media`.`name`, `Media`.`materialtype_id`, `Media`.`tutorial_id`, `Media`.`variant`, `Media`.`nr`, `Media`.`counter` FROM `kaubdb`.`news` AS `News` LEFT JOIN `kaubdb`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `kaubdb`.`media` AS `Media` ON (`News`.`media_id` = `Media`.`id`) WHERE 1 = 1 ORDER BY `News`.`created` desc | 3 | 3 | 0 | |
SELECT `Event`.`id`, `Event`.`title`, `Event`.`date`, `Event`.`starttime`, `Event`.`endtime`, `Event`.`text`, `Event`.`user_id`, `Event`.`link`, `Event`.`media_id`, `Event`.`document_id`, `Event`.`created`, `Event`.`place_id`, `Event`.`slug`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`name`, `User`.`role`, `User`.`created`, `User`.`modified`, `User`.`hash_change_password`, `Media`.`id`, `Media`.`dirname`, `Media`.`basename`, `Media`.`checksum`, `Media`.`alternative`, `Media`.`description`, `Media`.`name`, `Media`.`materialtype_id`, `Media`.`tutorial_id`, `Media`.`variant`, `Media`.`nr`, `Media`.`counter`, `Document`.`id`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`description`, `Document`.`name`, `Document`.`materialtype_id`, `Document`.`tutorial_id`, `Document`.`variant`, `Document`.`nr`, `Document`.`counter`, `Place`.`id`, `Place`.`name`, `Place`.`street`, `Place`.`postal`, `Place`.`city`, `Place`.`link` FROM `kaubdb`.`events` AS `Event` LEFT JOIN `kaubdb`.`users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `kaubdb`.`media` AS `Media` ON (`Event`.`media_id` = `Media`.`id`) LEFT JOIN `kaubdb`.`media` AS `Document` ON (`Event`.`document_id` = `Document`.`id`) LEFT JOIN `kaubdb`.`places` AS `Place` ON (`Event`.`place_id` = `Place`.`id`) WHERE `Event`.`date` >= '2024.11.21' ORDER BY `Event`.`date` asc LIMIT 5 | 0 | 0 | 0 | |