Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Keys.illustration' in 'where clause'

SQL Query: SELECT `Opensearches`.`ID` AS `Opensearches__ID`, `Opensearches`.`team_ID` AS `Opensearches__team_ID`, `Opensearches`.`user_ID` AS `Opensearches__user_ID`, `Opensearches`.`user` AS `Opensearches__user`, `Opensearches`.`initialen` AS `Opensearches__initialen`, `Opensearches`.`auteur` AS `Opensearches__auteur`, `Opensearches`.`title` AS `Opensearches__title`, `Opensearches`.`description` AS `Opensearches__description`, `Opensearches`.`headline` AS `Opensearches__headline`, `Opensearches`.`keywords` AS `Opensearches__keywords`, `Opensearches`.`people` AS `Opensearches__people`, `Opensearches`.`event` AS `Opensearches__event`, `Opensearches`.`location` AS `Opensearches__location`, `Opensearches`.`state` AS `Opensearches__state`, `Opensearches`.`country` AS `Opensearches__country`, `Opensearches`.`country_code` AS `Opensearches__country_code`, `Opensearches`.`category` AS `Opensearches__category`, `Opensearches`.`supp_category` AS `Opensearches__supp_category`, `Opensearches`.`special_instructions` AS `Opensearches__special_instructions`, `Opensearches`.`contact` AS `Opensearches__contact`, `Opensearches`.`intellectualGenre` AS `Opensearches__intellectualGenre`, `Opensearches`.`urgency` AS `Opensearches__urgency`, `Opensearches`.`indoors` AS `Opensearches__indoors`, `Opensearches`.`URL` AS `Opensearches__URL`, `Opensearches`.`directory` AS `Opensearches__directory`, `Opensearches`.`filename` AS `Opensearches__filename`, `Opensearches`.`input_filename` AS `Opensearches__input_filename`, `Opensearches`.`thumbnail` AS `Opensearches__thumbnail`, `Opensearches`.`datetaken` AS `Opensearches__datetaken`, `Opensearches`.`dateentered` AS `Opensearches__dateentered`, `Opensearches`.`rel_date` AS `Opensearches__rel_date`, `Opensearches`.`orientation` AS `Opensearches__orientation`, `Opensearches`.`camera_make` AS `Opensearches__camera_make`, `Opensearches`.`camera_model` AS `Opensearches__camera_model`, `Opensearches`.`flash` AS `Opensearches__flash`, `Opensearches`.`fnumber` AS `Opensearches__fnumber`, `Opensearches`.`focal_length` AS `Opensearches__focal_length`, `Opensearches`.`height` AS `Opensearches__height`, `Opensearches`.`ISO` AS `Opensearches__ISO`, `Opensearches`.`width` AS `Opensearches__width`, `Opensearches`.`shutter` AS `Opensearches__shutter`, `Opensearches`.`software` AS `Opensearches__software`, `Opensearches`.`code` AS `Opensearches__code`, `Opensearches`.`rating` AS `Opensearches__rating`, `Opensearches`.`type` AS `Opensearches__type`, `Opensearches`.`solo` AS `Opensearches__solo`, `Opensearches`.`showa` AS `Opensearches__showa`, `Opensearches`.`backup` AS `Opensearches__backup`, `Opensearches`.`kleur` AS `Opensearches__kleur`, `Teams`.`id` AS `Teams__id`, `Teams`.`naam` AS `Teams__naam`, `Teams`.`username` AS `Teams__username`, `Teams`.`pass` AS `Teams__pass`, `Teams`.`password` AS `Teams__password`, `Teams`.`initialen` AS `Teams__initialen`, `Teams`.`vol_naam` AS `Teams__vol_naam`, `Teams`.`taal` AS `Teams__taal`, `Teams`.`adres` AS `Teams__adres`, `Teams`.`Street` AS `Teams__Street`, `Teams`.`City` AS `Teams__City`, `Teams`.`Country` AS `Teams__Country`, `Teams`.`zone` AS `Teams__zone`, `Teams`.`Lat` AS `Teams__Lat`, `Teams`.`Lng` AS `Teams__Lng`, `Teams`.`tel` AS `Teams__tel`, `Teams`.`email` AS `Teams__email`, `Teams`.`btw` AS `Teams__btw`, `Teams`.`vennootschap` AS `Teams__vennootschap`, `Teams`.`IBAN` AS `Teams__IBAN`, `Teams`.`RV` AS `Teams__RV`, `Teams`.`nummerplaat` AS `Teams__nummerplaat`, `Teams`.`perskaart` AS `Teams__perskaart`, `Teams`.`partner_naam` AS `Teams__partner_naam`, `Teams`.`partner_phone` AS `Teams__partner_phone`, `Teams`.`details` AS `Teams__details`, `Teams`.`werkgebied` AS `Teams__werkgebied`, `Teams`.`base` AS `Teams__base`, `Teams`.`adres_prive` AS `Teams__adres_prive`, `Teams`.`specialiteiten` AS `Teams__specialiteiten`, `Teams`.`skills` AS `Teams__skills`, `Teams`.`portret` AS `Teams__portret`, `Teams`.`sign` AS `Teams__sign`, `Teams`.`hardware` AS `Teams__hardware`, `Teams`.`web_copyright` AS `Teams__web_copyright`, `Teams`.`web_color` AS `Teams__web_color`, `Teams`.`web_name` AS `Teams__web_name`, `Teams`.`facebook_id` AS `Teams__facebook_id`, `Teams`.`twitter_id` AS `Teams__twitter_id`, `Teams`.`google_id` AS `Teams__google_id`, `Teams`.`instagram_id` AS `Teams__instagram_id`, `Teams`.`linkedin_id` AS `Teams__linkedin_id`, `Teams`.`tumblr_id` AS `Teams__tumblr_id`, `Teams`.`medium_id` AS `Teams__medium_id`, `Teams`.`persweb` AS `Teams__persweb`, `Teams`.`rechten` AS `Teams__rechten`, `Teams`.`type` AS `Teams__type`, `Teams`.`cat` AS `Teams__cat`, `Teams`.`smallteam` AS `Teams__smallteam`, `Teams`.`code` AS `Teams__code`, `Teams`.`stock_tarief` AS `Teams__stock_tarief`, `Teams`.`open_web` AS `Teams__open_web`, `Teams`.`open_print` AS `Teams__open_print`, `Teams`.`printprice` AS `Teams__printprice`, `Teams`.`returnlink` AS `Teams__returnlink`, `Teams`.`aansl_datum` AS `Teams__aansl_datum`, `Teams`.`membership_fee` AS `Teams__membership_fee`, `Teams`.`master_use` AS `Teams__master_use`, `Teams`.`author_rights` AS `Teams__author_rights`, `Teams`.`activate` AS `Teams__activate`, `Teams`.`tijd` AS `Teams__tijd` FROM `archief` `Opensearches` INNER JOIN `archief_team` `Teams` ON (`Teams`.`activate` = :c0 AND `Teams`.`initialen` = (`Opensearches`.`initialen`)) LEFT JOIN `archief_client_ass_image` `Assimg` ON (`client_ID` in (:c1,:c2,:c3,:c4,:c5) AND `Opensearches`.`ID` = (`Assimg`.`photo_ID`)) WHERE (MATCH(Opensearches.keywords, Opensearches.description) AGAINST(:search IN BOOLEAN MODE) AND `Opensearches`.`rel_date` <= :c6 AND `Opensearches`.`orientation` = :c7 AND `Keys`.`illustration` = :c8 AND `Opensearches`.`showa` = :c9 AND `Opensearches`.`type` = :c10 AND `Opensearches`.`datetaken` >= :c11 AND `Opensearches`.`datetaken` <= :c12 AND (`Assimg`.`ID`) IS NULL) ORDER BY `Opensearches`.`ID` DESC LIMIT 100 OFFSET 0

If you want to customize this error message, create src/Template/Error/error500.ctp

	`$connection = $this->_driver->getConnection();`

	`try {`
	`$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults);`
	`$result = $this->_statement->execute($params);`
	`} finally {`
	`$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);`
	`}`

	`public function execute($params = null)`
	`{`
	`$this->_hasExecuted = true;`

	`return $this->_statement->execute($params);`
	`}`

	`/**`
	`* Returns the next row for the result set after executing this statement.`

	`$t = microtime(true);`
	`$query = new LoggedQuery();`

	`try {`
	`$result = parent::execute($params);`
	`} catch (Exception $e) {`
	`$e->queryString = $this->queryString;`
	`$query->error = $e;`
	`$this->_log($query, $params, $t);`

	`{`
	`return $this->getDisconnectRetry()->run(function () use ($query) {`
	`$statement = $this->prepare($query);`
	`$query->getValueBinder()->attachTo($statement);`
	`$statement->execute();`

	`return $statement;`
	`});`
	`}`

	`$lastException = null;`

	`do {`
	`try {`
	`return $action();`
	`} catch (Exception $e) {`
	`$lastException = $e;`
	`if (!$this->strategy->shouldRetry($e, $retryCount)) {`
	`throw $e;`

	`* @return \Cake\Database\StatementInterface executed statement`
	`*/`
	`public function run(Query $query)`
	`{`
	`return $this->getDisconnectRetry()->run(function () use ($query) {`
	`$statement = $this->prepare($query);`
	`$query->getValueBinder()->attachTo($statement);`
	`$statement->execute();`

	`* @return \Cake\Database\StatementInterface`
	`*/`
	`public function execute()`
	`{`
	`$statement = $this->_connection->run($this);`
	`$this->_iterator = $this->_decorateStatement($statement);`
	`$this->_dirty = false;`

	`return $this->_iterator;`


	`return new $decorator($this->_results);`
	`}`

	`$statement = $this->getEagerLoader()->loadExternal($this, $this->execute());`

	`return new ResultSet($this, $statement);`
	`}`

	`if ($this->_cache) {`
	`$results = $this->_cache->fetch($this);`
	`}`
	`if (!isset($results)) {`
	`$results = $this->_decorateResults($this->_execute());`
	`if ($this->_cache) {`
	`$this->_cache->store($this, $results);`
	`}`
	`}`

	`'You cannot call all() on a non-select query. Use execute() instead.'`
	`);`
	`}`

	`return $this->_all();`
	`}`

	`/**`
	`* Trigger the beforeFind event on the query's repository object.`

	`$data = $this->extractData($object, $params, $settings);`
	`$query = $this->getQuery($object, $query, $data);`

	`$cleanQuery = clone $query;`
	`$results = $query->all();`
	`$data['numResults'] = count($results);`
	`$data['count'] = $this->getCount($cleanQuery, $data);`

	`$pagingParams = $this->buildParams($data);`

	`{`
	`$request = $this->_registry->getController()->getRequest();`

	`try {`
	`$results = $this->_paginator->paginate(`
	`$object,`
	`$request->getQueryParams(),`
	`$settings`
	`);`

	`throw new RuntimeException('Unable to locate an object compatible with paginate.');`
	`}`
	`$settings += $this->paginate;`

	`return $this->Paginator->paginate($table, $settings);`
	`}`

	`/**`
	`* Method to check that an action is accessible from a URL.`

	`$this->set('q_fr', $sqen);`
	`$this->set('q_en', $sqfr);`
	`$this->set('t', $this->request->getQuery('t'));`
	`$this->set('q', $sq);`
	`$this->set('results', $this->paginate($query));`
	`$this->set('tel', $query->count());`


	`}`

	`}`
	`/** @var callable $callable */`
	`$callable = [$this, $request->getParam('action')];`

	`$result = $callable(...array_values($request->getParam('pass')));`
	`if ($result instanceof Response) {`
	`$this->response = $result;`
	`}`

	`if ($result instanceof Response) {`
	`return $result;`
	`}`

	`$response = $controller->invokeAction();`
	`if ($response !== null && !($response instanceof Response)) {`
	`throw new LogicException('Controller actions can only return Cake\Http\Response or null.');`
	`}`

	`} else {`
	`$controller = $this->factory->create($request, $response);`
	`}`

	`$response = $this->_invoke($controller);`
	`if ($request->getParam('return')) {`
	`return $response;`
	`}`

	`* @return \Psr\Http\Message\ResponseInterface`
	`*/`
	`public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next)`
	`{`
	`return $this->getDispatcher()->dispatch($request, $response);`
	`}`

	`/**`
	`* Get the ActionDispatcher.`

	`$next = $this->middleware->get($this->index);`
	`if ($next) {`
	`$this->index++;`

	`return $next($request, $response, $this);`
	`}`

	`// End of the queue`
	`return $response;`

	`public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next)`
	`{`
	`$locale = Locale::acceptFromHttp($request->getHeaderLine('Accept-Language'));`
	`if (!$locale) {`
	`return $next($request, $response);`
	`}`
	`if ($this->locales !== ['*']) {`
	`$locale = Locale::lookup($this->locales, $locale, true);`
	`}`

	`);`
	`}`
	`$matching = Router::getRouteCollection()->getMiddleware($middleware);`
	`if (!$matching) {`
	`return $next($request, $response);`
	`}`
	`$matching[] = $next;`
	`$middleware = new MiddlewareQueue($matching);`
	`$runner = new Runner();`

	`public function __invoke($request, $response, $next)`
	`{`
	`$url = $request->getUri()->getPath();`
	`if (strpos($url, '..') !== false \|\| strpos($url, '.') === false) {`
	`return $next($request, $response);`
	`}`

	`if (strpos($url, '/.') !== false) {`
	`return $next($request, $response);`

	`public function __invoke($request, $response, $next)`
	`{`
	`$this->service->loadPanels();`
	`$this->service->initializePanels();`
	`$response = $next($request, $response);`
	`$row = $this->service->saveData($request, $response);`
	`if (!$row) {`
	`return $response;`
	`}`

	`{`
	`$this->middleware = $middleware;`
	`$this->index = 0;`

	`return $this->__invoke($request, $response);`
	`}`

	`/**`
	`* @param \Psr\Http\Message\ServerRequestInterface $request The server request`

	`}`
	`$this->dispatchEvent('Server.buildMiddleware', ['middleware' => $middleware]);`
	`$middleware->add($this->app);`

	`$response = $this->runner->run($middleware, $request, $response);`

	`if (!($response instanceof ResponseInterface)) {`
	`throw new RuntimeException(sprintf(`
	`'Application did not create a response. Got "%s" instead.',`

	`// Bind your application to the server.`
	`$server = new Server(new Application(dirname(__DIR__) . '/config'));`

	`// Run the request/response through the application and emit the response.`
	`$server->emit($server->run());`