TYPO3 / TYPO3.CMS

            while ($row = $result->fetch()) {

                $cacheEntryIdentifiers[] = $row['identifier'];

            }

            if (!empty($cacheEntryIdentifiers)) {

                // Delete tag rows connected to expired cache entries

                $quotedIdentifiers = $queryBuilder->createNamedParameter($cacheEntryIdentifiers, Connection::PARAM_STR_ARRAY);

                $queryBuilder->delete($this->tagsTable)

                    ->where($queryBuilder->expr()->in('identifier', $quotedIdentifiers))

                    ->execute();

            }

            $queryBuilder->delete($this->cacheTable)

                ->where($queryBuilder->expr()->lt(

                    'expires',

            while ($row = $result->fetch()) {

                $tagsEntryIdentifiers[] = $row['identifier'];

            }

            if (!empty($tagsEntryIdentifiers)) {

                $quotedIdentifiers = $queryBuilder->createNamedParameter($tagsEntryIdentifiers, Connection::PARAM_STR_ARRAY);

                $queryBuilder->delete($this->tagsTable)

                    ->where($queryBuilder->expr()->in('identifier', $quotedIdentifiers))

                    ->execute();

            }

        }

    }

            if (!empty($hashList)) {

                $result['deletedNodes'] = count($hashList);

                $result['deletedNodes_hashList'] = implode(',', $hashList);

                if (!$testOnly) {

                    $queryBuilder = $connection->createQueryBuilder();

                    $queryBuilder

                        ->delete('sys_refindex')

                        ->where(

                            $queryBuilder->expr()->in(

                                'hash',

                                $queryBuilder->createNamedParameter($hashList, Connection::PARAM_STR_ARRAY)

                            )

                        )

                        ->execute();

                }

            }

        }