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 `News`.`slug` = 'Hinweis_Fehlerhafte_Begleit_DVD_in_der_2_Auflage' LIMIT 1 | 1 | 1 | 0 | |
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 `News`.`id` != 10 ORDER BY `News`.`created` desc LIMIT 4 | 2 | 2 | 0 | |