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 ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 400 +                    
                    MATCH(ci_text_linked) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN BOOLEAN MODE) * 100 +
                    MATCH(ci_search_tags) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 500 +
                    MATCH(ci_search_periods) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 2000 +
                    MATCH(ci_search_regions) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 200 + 
                    MATCH(ci_search_subjects) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 200 +
                    MATCH(ci_search_categories) AGAINST ('ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' IN NATURAL LANGUAGE MODE) * 500 +
                    CAST(LOWER(ci_title) = 'ancient greek music by prof. stefan hagel ancient aulos greek music kithara music musical instrument' AS SIGNED INTEGER) * 100000                    
                     +
            CAST(LOWER(ci_url) = '/ancient_greek_music_by_prof._stefan_hagel_ancient_aulos_greek_music_kithara_music_musical_instrument/' 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 1000
        );
    
Related: Ancient Greek Music by Prof. Stefan Hagel (Video) - page 1 - World History Encyclopedia

Ancient Greek Music by Prof. Stefan Hagel

Membership