Почему возникает ошибка SQLite3 в коде php?

Question

[Svoboo]

Вознакает ошибка:

Warning: SQLite3::query(): Unable to prepare statement: 1, near "WITH": syntax error in DBClass.php on line 825

Fatal error: Call to a member function fetchArray() on boolean in DBClass.php on line 827

Вот сам код:

$query = 'WITH 
                a as (
                        SELECT `id` FROM `'.DB::prefix('video').'` 
                        INDEXED BY "INDEX_TUBE_CAT_ID"
                        WHERE (`categoryId` = '.$array['categoryId'].') AND (`date` < '.time().') AND (`id` > '.$array['tubeId'].')
                        ORDER BY `id` LIMIT ' . $array['limit'] . '
                     ),
                b as (
                        SELECT `id` FROM `'.DB::prefix('video').'`
                        INDEXED BY "INDEX_TUBE_CAT_ID"
                        WHERE (`categoryId` = '.$array['categoryId'].') AND (`date` < '.time().')
                        ORDER BY `id` LIMIT (SELECT ' . $array['limit'] . ' - COUNT(*) FROM a)
                    )
                SELECT a.* FROM a union SELECT b.* FROM b';
        $similarId =  $this->sqlite->query($query); //825 строка

        while ($row = $similarId->fetchArray(SQLITE3_ASSOC)) { //827 строка
            $similarArray[] = $row['id'];
        }
        return $similarArray;

Почему она возникает?

Comments

[Arris]

var_dump($query); перед 825 строкой что показывает?

[Svoboo]

Arris:

string(668) "WITH a as ( SELECT `id` FROM `sd_video` INDEXED BY "INDEX_TUBE_CAT_ID" WHERE (`categoryId` = 1) AND (`date` < 1502557282) AND (`id` > 39) ORDER BY `id` LIMIT 4 ), b as ( SELECT `id` FROM `sd_video` INDEXED BY "INDEX_TUBE_CAT_ID" WHERE (`categoryId` = 1) AND (`date` < 1502557282) ORDER BY `id` LIMIT (SELECT 4 - COUNT(*) FROM a) ) SELECT a.* FROM a union SELECT b.* FROM b"