

User.query = SELECT `Login`, `Password`, `user`.Cinema_id, `Type` , `User_name`, `Name` FROM `user`, `cinema` WHERE `cinema`.Cinema_id = `user`.Cinema_id AND 
Condition.login = \ Login =
Condition.pwd = \ And Password =

Films.query.date = SELECT DISTINCT `Title` , `film`.Film_id FROM `film`, `cshow`, `cinema` WHERE `film`.Film_id = `cshow`.film_id AND `cinema`.Cinema_id = `cshow`.Cinema_id
Condition.Date = \ AND Cshow_date =
Condition.cinema = \ AND cshow.Cinema_id =
Films.query.date2 = \ ORDER BY `Title`

Shows.query.time = SELECT `Cshow_time` , `Cshow_id` FROM `film`, `cshow`, `cinema` WHERE `film`.Film_id = `cshow`.film_id AND `cinema`.Cinema_id = `cshow`.Cinema_id
Condition.film = \ AND `film`.Film_id =
Shows.query.time2 = \ ORDER BY `Cshow_time`

Reservation.query.show = SELECT `Reservation_id` , `Owner` , `Reservation_date`, `Reservation_time`  , `last3digits` , `NumberOfTickets` , `TicketsDelivery_datetime` FROM  `creditcard` , `reservation`  WHERE `reservation`.CreditCard_id = `creditcard`.CreditCard_id
Condition.show = \ AND `Reservation`.Cshow_id =
Reservation.query.show2 = \ ORDER BY `Owner`

Query.updateDelivreTime = UPDATE `Reservation` SET 
Update.delivreTime.part1 = \ TicketsDelivery_datetime =
Update.delivreTime.part2 = \ Where
Condition.reservationId = \ Reservation_id =