James I: The First Stuart King of England | Game of Kings | Timeline

Video

Dylan Campbell
by Timeline - World History Documentaries
published on 13 January 2021

Prof Kate Williams studies the legacy of the Stuarts through the eyes of an aristocratic Welsh clan. After Elizabeth I's death in 1603, James VI of Scotland claimed the throne.

Remove Ads

Advertisement

        CREATE TEMPORARY TABLE ci_search_results AS (
            SELECT DISTINCT ci.ci_id, ci.ci_type_id, ROUND(
                cit.search_multiplier * 
            (0.25 + CAST(ci_image_ci_id <> '' AS INTEGER)) * (1 + ((ci_pageviews_28d / 24261) * 0.3)) *
                                    
                (
                    MATCH(ci_title) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 400 +                    
                    MATCH(ci_title) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN BOOLEAN MODE) * 400 +
                    CAST(ci_title REGEXP '[[:<:]]james i the first stuart king of england | game of kings | timeline james i of england[[:>:]]' AS SIGNED INTEGER) * 400 +                                        
                    CAST(LOWER(ci_title) = 'james i the first stuart king of england | game of kings | timeline james i of england' AS SIGNED INTEGER) * 100000 +
                    CAST(ci_title REGEXP '^james i the first stuart king of england | game of kings | timeline james i of england[[:>:]]' AS SIGNED INTEGER) * 5000                    
                    MATCH(ci_text_linked) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN BOOLEAN MODE) * 100 +
                    MATCH(ci_search_tags) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 500 +
                    MATCH(ci_search_periods) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 2000 +
                    MATCH(ci_search_regions) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 200 + 
                    MATCH(ci_search_subjects) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 200 +
                    MATCH(ci_search_categories) AGAINST ('james i the first stuart king of england | game of kings | timeline james i of england' IN NATURAL LANGUAGE MODE) * 500 +
                     +
            CAST(LOWER(ci_url) = '/james_i_the_first_stuart_king_of_england_|_game_of_kings_|_timeline_james_i_of_england/' AS INTEGER) * 10000                      
                                            
                )
            ) AS score 
            FROM content_items_published AS ci
            INNER JOIN content_item_types AS cit ON cit.ci_type_id = ci.ci_type_id 
            WHERE ci_lang = 'en'
            HAVING score > 5000
            ORDER BY score DESC
            LIMIT 300
        );
    

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MATCH(ci_text_linked) AGAINST ('james i the first stuart king of england | ga...' at line 12 in /home/ancient/dev_www/libraries/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/ancient/dev_www/libraries/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/ancient/dev_www/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/ancient/dev_www/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/ancient/dev_www/libraries/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('\n CREATE...', Array) #4 /home/ancient/dev_www/include/content_item.php(2740): Zend_Db_Adapter_Pdo_Abstract->query('\n CREATE...') #5 /home/ancient/dev_www/include/content_item.php(3160): ci_search2('james i the fi in /home/ancient/dev_www/libraries/Zend/Db/Statement/Pdo.php on line 234