- STRAIGHT_JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
- STRAIGHT_JOIN `contact` AS `author` ON `author`.`id` = `item`.`author-id`
- STRAIGHT_JOIN `contact` AS `owner` ON `owner`.`id` = `item`.`owner-id`
+ LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
+ LEFT JOIN `contact` AS `author` ON `author`.`id` = `item`.`author-id`
+ LEFT JOIN `contact` AS `owner` ON `owner`.`id` = `item`.`owner-id`