The Fair Melusine

Illustration

Joshua J. Mark
by Julius Hübner
published on 13 October 2021

The Fair Melusine, oil on canvas painting by German artist Julius Hübner, 1844.

National Museum, Poznan.

The painting depicts the moment in the legend when Raymondin spies on his wife, Melusine, and discovers she is half-serpent on Saturdays.

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)) *
        
                (CAST('the fair melusine melusine' REGEXP  AS SIGNED INTEGER) * 3) *              
                (
                    MATCH(ci_title) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 400 +                    
                    MATCH(ci_text_linked) AGAINST ('the fair melusine melusine' IN BOOLEAN MODE) * 100 +
                    MATCH(ci_search_tags) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 500 +
                    MATCH(ci_search_periods) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 2000 +
                    MATCH(ci_search_regions) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 200 + 
                    MATCH(ci_search_subjects) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 200 +
                    MATCH(ci_search_categories) AGAINST ('the fair melusine melusine' IN NATURAL LANGUAGE MODE) * 500 +
                    CAST(LOWER(ci_title) = 'the fair melusine melusine' AS SIGNED INTEGER) * 100000                    
                     +
            CAST(LOWER(ci_url) = '/the_fair_melusine_melusine/' 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 'AS SIGNED INTEGER) * 3) * ( ...' at line 6 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(2734): Zend_Db_Adapter_Pdo_Abstract->query('\n CREATE...') #5 /home/ancient/dev_www/include/content_item.php(3154): ci_search2('the fair melusi in /home/ancient/dev_www/libraries/Zend/Db/Statement/Pdo.php on line 234