executeQueryWithIds example

$sql = <<<'SQL' SELECT JSON_EXTRACT(slot_config, "$.*.sliderItems.value[*].mediaId") as mediaId FROM `$table` WHERE JSON_OVERLAPS( JSON_EXTRACT(slot_config, "$.*.sliderItems.value[*].mediaId"), JSON_ARRAY(%s) ); SQL;

        $sql = str_replace('$table', $table, $sql);

        return $this->executeQueryWithIds($sql, $event);
    }

    /** * @return array<string> */
    private function findMediaIdsInImagesInOverridesTable(string $table, UnusedMediaSearchEvent $event): array
    {
        $sql = <<<'SQL' SELECT JSON_EXTRACT(slot_config, "$.*.media.value") as mediaId FROM `$table` WHERE JSON_OVERLAPS( JSON_EXTRACT(slot_config, "$.*.media.value"), JSON_ARRAY(%s) );