SELECT Reservation id Reservation ressource_id Reservation client_id R

1
SELECT `Reservation`.`id`, `Reservation`.`ressource_id`, `Reservation`.`client_id`, `Reservation`.`fe_user_id`, `Reservation`.`price`, `Reservation`.`username`, `Reservation`.`begin`, `Reservation`.`end`, `Reservation`.`perscount`, `Reservation`.`comments`, `Reservation`.`recurrenceType`, `Reservation`.`relatedreservation`, `Reservation`.`lastupdated`, `Reservation`.`lastupdtuser`, `Reservation`.`sessionid`, `Reservation`.`confirmcode`, `Reservation`.`status`, `Reservation`.`lastupdtip`, `Reservation`.`addfield_groups_id`, `Reservation`.`price_ressource`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`client_id`, `User`.`language`, `User`.`anrede`, `User`.`lastname`, `User`.`firstname`, `User`.`birthdate`, `User`.`passport`, `User`.`email`, `User`.`organization`, `User`.`phone`, `User`.`phone2`, `User`.`status`, `User`.`register_session`, `User`.`mailformat`, `User`.`strasse`, `User`.`hnr`, `User`.`ort`, `User`.`plz`, `User`.`state`, `User`.`country`, `User`.`add_field_groups_id`, `Ressource`.`id`, `Ressource`.`ressourcetype_id`, `Ressource`.`price_group_id`, `Ressource`.`add_field_groups_id`, `Ressource`.`input_type`, `Ressource`.`description`, `Ressource`.`shortdescr`, `Ressource`.`amount`, `Ressource`.`active`, `Ressource`.`countReservation`, `Ressource`.`postal`, `Ressource`.`location`, `Ressource`.`order`, `Ressource`.`mileage`, `Ressource`.`anotation`, `Ressource`.`parent_ressource_id`, `Ressource`.`parent_ressourcetype_id`, `Ressource`.`multiple`, `Ressource`.`maxcount`, `Ressource`.`created`, `Ressource`.`modified`, `Ressource`.`fe_visible`, `Client`.`id`, `Client`.`username`, `Client`.`password`, `Client`.`clientnbr`, `Client`.`paymode_id`, `Client`.`anrede`, `Client`.`lastname`, `Client`.`firstname`, `Client`.`email`, `Client`.`organization`, `Client`.`phone`, `Client`.`template_id`, `Client`.`status`, `Client`.`register_session`, `Client`.`mailformat`, `Client`.`agbs`, `Client`.`strasse`, `Client`.`hnr`, `Client`.`ort`, `Client`.`plz`, `Client`.`languages`, `Client`.`allow_fe_payment`, `Client`.`allow_pdf`, `Client`.`allow_ical`, `Ressourcetype`.`id`, `Ressourcetype`.`client_id`, `Ressourcetype`.`price_group_id`, `Ressourcetype`.`description`, `Ressourcetype`.`shortdescr`, `Ressourcetype`.`ressourcecount`, `Ressourcetype`.`ressourcecategory`, `Ressourcetype`.`amount`, `Ressourcetype`.`order`, `Ressourcetype`.`active`, `Ressourcetype`.`default`, `Ressourcetype`.`lastupdateUserid`, `Ressourcetype`.`lastupddttm` FROM `bk_reservations` AS `Reservation` LEFT JOIN `bk_fe_users` AS `User` ON (`Reservation`.`fe_user_id` = `User`.`id`) LEFT JOIN `bk_ressources` AS `Ressource` ON (`Reservation`.`ressource_id` = `Ressource`.`id`) LEFT JOIN `bk_be_users` AS `Client` ON (`Reservation`.`client_id` = `Client`.`id`) LEFT JOIN `bk_ressourcetypes` AS `Ressourcetype` ON (`Ressourcetype`.`id` = `Ressource`.`ressourcetype_id`) WHERE `Reservation`.`id` = 45 LIMIT 1