protected function build() { parent::build(); if ($this->isMapItAreaOnly) { $this->joins[] = " JOIN area_mapit_information ON area_mapit_information.area_id = area_information.id "; } if ($this->human) { $this->joins[] = " JOIN human_in_area ON human_in_area.area_id = area_information.id AND human_in_area.human_id = :human_id AND human_in_area.removed_at IS NULL"; $this->params['human_id'] = $this->human->getId(); } if ($this->includeAreasWithNoEventsOnly) { $this->joins[] = " LEFT JOIN meetyournextmp_event_in_area ON meetyournextmp_event_in_area.area_id = area_information.id "; $this->joins[] = " LEFT JOIN event_information ON event_information.id = meetyournextmp_event_in_area.event_id " . "AND event_information.is_deleted = '0' AND event_information.is_cancelled ='0'"; $this->where[] = " event_information.id IS NULL "; } }