Video
CREATE TEMPORARY TABLE ci_search_results ( SELECT DISTINCT ci.ci_id, ci.ci_type_id, ci.ci_subtype_id, ROUND( cit.search_multiplier * (0.25 + CAST(ci_image_ci_id <> '' AS INTEGER)) * (1 + ((ci_pageviews_28d / 70659) * 0.3)) * ( MATCH(ci_title) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 400 + MATCH(ci_title) AGAINST ('tiwanaku spiritual and political centre of the unesco nhk tiwanaku' IN BOOLEAN MODE) * 400 + CAST(ci_title REGEXP '[[:<:]]tiwanaku spiritual and political centre of the \\.\\.\\. unesco/nhk tiwanaku[[:>:]]' AS SIGNED INTEGER) * 400 + MATCH(ci_text_linked) AGAINST ('tiwanaku spiritual and political centre of the unesco nhk tiwanaku' IN BOOLEAN MODE) * 100 + MATCH(ci_search_tags) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 500 + MATCH(ci_search_periods) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 2000 + MATCH(ci_search_regions) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 200 + MATCH(ci_search_subjects) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 200 + MATCH(ci_search_categories) AGAINST ('tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' IN NATURAL LANGUAGE MODE) * 500 + CAST(LOWER(ci_title) = 'tiwanaku spiritual and political centre of the ... unesco/nhk tiwanaku' AS SIGNED INTEGER) * 100000 + CAST(ci_title REGEXP '^tiwanaku spiritual and political centre of the \\.\\.\\. unesco/nhk tiwanaku[[:>:]]' AS SIGNED INTEGER) * 1000 + CAST(LOWER(ci_url) = '/tiwanaku_spiritual_and_political_centre_of_the__..._unesco/nhk_tiwanaku/' 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 );
Cite This Work
APA Style
Kyokai, U. T. N. N. H. (2018, July 27). Tiwanaku: Spiritual and Political Centre of the ... (UNESCO/NHK). World History Encyclopedia. Retrieved from https://www.worldhistory.org/video/1476/tiwanaku-spiritual-and-political-centre-of-the---u/
Chicago Style
Kyokai, UNESCO TV NHK Nippon Hoso. "Tiwanaku: Spiritual and Political Centre of the ... (UNESCO/NHK)." World History Encyclopedia. Last modified July 27, 2018. https://www.worldhistory.org/video/1476/tiwanaku-spiritual-and-political-centre-of-the---u/.
MLA Style
Kyokai, UNESCO TV NHK Nippon Hoso. "Tiwanaku: Spiritual and Political Centre of the ... (UNESCO/NHK)." World History Encyclopedia. World History Encyclopedia, 27 Jul 2018. Web. 26 May 2022.