Index: src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoom.java
===================================================================
--- src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoom.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoom.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -24,9 +24,9 @@
     @Id
     @Column(name ="id_projection")
-    Integer id_projection;
+    Integer idprojection;
 
     @Id
     @Column(name ="id_room")
-    Integer id_room;
+    Integer idroom;
 
 
Index: src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoomId.java
===================================================================
--- src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoomId.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/model/manytomany/ProjectionIsPlayedInRoomId.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -7,5 +7,5 @@
 @Data
 public class ProjectionIsPlayedInRoomId implements Serializable {
-    Integer id_projection;
-    Integer id_room;
+    Integer idprojection;
+    Integer idroom;
 }
Index: src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java
===================================================================
--- src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/repository/ProjectionIsPlayedInRoomRepository.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -10,5 +10,5 @@
 
 public interface ProjectionIsPlayedInRoomRepository extends JpaRepository<ProjectionIsPlayedInRoom, ProjectionIsPlayedInRoomId> {
-    @Query("SELECT pir FROM ProjectionIsPlayedInRoom pir WHERE pir.id_projection = :id_projection")
+    @Query("SELECT pir FROM ProjectionIsPlayedInRoom pir WHERE pir.idprojection = :id_projection")
     List<ProjectionIsPlayedInRoom> findAllByProjectionId(@Param("id_projection") Integer id_projection);
 }
Index: src/main/java/com/example/moviezone/repository/ProjectionRepository.java
===================================================================
--- src/main/java/com/example/moviezone/repository/ProjectionRepository.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/repository/ProjectionRepository.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -3,10 +3,12 @@
 import com.example.moviezone.model.Projection;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
 
+import javax.transaction.Transactional;
 import java.time.LocalDate;
 import java.util.List;
-
+@Transactional
 public interface ProjectionRepository extends JpaRepository<Projection,Integer> {
-    //    NOTE: CHANGE THIS WITH MATERIALIZED VIEW
-    //List<Projection> findAllBydate_time_startBefore(LocalDate datum);
+    @Procedure("project.getProjectionsForFilms")
+    List<Projection> getProjectionsForFilms(int id);
 }
Index: src/main/java/com/example/moviezone/service/Impl/ProjectionServiceImpl.java
===================================================================
--- src/main/java/com/example/moviezone/service/Impl/ProjectionServiceImpl.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/service/Impl/ProjectionServiceImpl.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -26,4 +26,9 @@
 
     @Override
+    public List<Projection> getProjectionsForFilms(int id) {
+        return projectionRepository.getProjectionsForFilms(id);
+    }
+
+    @Override
     public Projection findById(Integer id_projection) {
         return projectionRepository.findById(id_projection).orElseThrow(RuntimeException::new);
Index: src/main/java/com/example/moviezone/service/ProjectionService.java
===================================================================
--- src/main/java/com/example/moviezone/service/ProjectionService.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/service/ProjectionService.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -9,4 +9,5 @@
 public interface ProjectionService {
     List<Projection> findAllProjections();
+    List<Projection> getProjectionsForFilms(int id);
     Projection findById(Integer id_projection);
 Projection save(LocalDate date_time_start,LocalDate date_time_end, String type_of_technology, Integer id_film );
Index: src/main/java/com/example/moviezone/web/HomeController.java
===================================================================
--- src/main/java/com/example/moviezone/web/HomeController.java	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/java/com/example/moviezone/web/HomeController.java	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -85,4 +85,14 @@
         model.addAttribute("event", event);
         model.addAttribute("bodyContent", "event");
+
+        return "master-template";
+    }
+    @GetMapping("/getProjections/{id}")
+    @Transactional
+    public String getProjectionsFromFilm(@PathVariable Long id, Model model) {
+        Film film=filmService.getFilmById(id).get();
+        model.addAttribute("film",film);
+        model.addAttribute("projections",projectionService.getProjectionsForFilms(id.intValue()));
+        model.addAttribute("bodyContent", "projectionsForFilm");
 
         return "master-template";
@@ -168,5 +178,5 @@
             model.addAttribute("films",filmService.getFilmsNow());
         }
-        model.addAttribute("bodyContent","films");
+        model.addAttribute("bodyContent","projections");
         return "master-template";
     }
Index: src/main/resources/templates/projections.html
===================================================================
--- src/main/resources/templates/projections.html	(revision 90317eab09c9bb08660ecb5f90412ce8048f29b7)
+++ src/main/resources/templates/projections.html	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -194,5 +194,26 @@
         border-radius: 20px;
     }
+    .form-group{
+        width: 200px;
+    }
 </style>
+<div>
+    <form th:action="@{'/home/projections'}"
+          th:method="GET">
+
+        <div class="form-group">
+            <label style="color: white;font-size: 20px;font-weight: bold">Кино</label>
+            <select name="id_cinema" class="form-control" id="id_cinema">
+                <option
+                        th:selected="${cinemas.get(1)}"
+                        th:each="cinema : ${cinemas}"
+                        th:value="${cinema.getId_cinema()}"
+                        th:text="${cinema.getName()}">
+                </option>
+            </select>
+
+        </div>
+        <button class="button" type="submit">Filter</button>
+    </form>
 <div xmlns:th="http://www.thymeleaf.org">
     <div class="main">
@@ -214,4 +235,9 @@
                         <span th:text="${film.getGenre()}"></span>
                     </div>
+                    <form
+                          th:action="@{'/home/getProjections/{id}' (id=${film.getId_film()})}"
+                          th:method="GET">
+                        <button class="button" type="submit">Projections</button>
+                    </form>
                 </div>
             </div>
Index: src/main/resources/templates/projectionsForFilm.html
===================================================================
--- src/main/resources/templates/projectionsForFilm.html	(revision 58675202baf48180a61747ec4b98b5c814a21466)
+++ src/main/resources/templates/projectionsForFilm.html	(revision 58675202baf48180a61747ec4b98b5c814a21466)
@@ -0,0 +1,40 @@
+<style>
+    .card-horizontal {
+        display: flex;
+        flex: 1 1 auto;
+    }
+    .card {
+        transition: all .2s ease-in-out;
+    }
+    .card:hover {
+        transform: scale(1.05);
+    }
+</style>
+<h1 style="color: white" th:text="${film.name}"></h1>
+<div style="border-radius:30px" >
+    <div class="row">
+        <div class="col-12 mt-3" style="padding-left:100px;height:75%;">
+            <div class="card" style=" border-radius: 30px;width:92%;align-self:center">
+                <div class="card-horizontal" th:each="projection : ${projections}">
+                    <div class="card-body">
+
+                        <h4 class="card-title" >
+                            <div>
+                            <span>Почеток на проекција: </span>
+                            <span th:text="${projection.date_time_start}"></span></div>
+                            <div>
+                                <span>Крај на проекција: </span>
+                                <span th:text="${projection.date_time_end}"></span></div>
+                        </h4>
+                        <p class="card-text" th:text="${projection.type_of_technology}"></p>
+                    </div>
+                </div>
+                <div class="card-footer" style="border-bottom-right-radius:30px;border-bottom-left-radius:30px">
+                    <small>
+
+                    </small>
+                </div>
+            </div>
+        </div>
+    </div>
+</div>