Passages under the Hippodrome of Tyre

Illustration

Carole Raddato
by
published on 22 November 2021

The passages under the hippodrome of Tyre (Lebanon). The hipprodrome, built in the 2nd century CE, is considered the second-largest hippodrome in the ancient world.

Remove Ads

Advertisement

About the Author

Carole Raddato
Carole maintains the popular ancient history photo-blog Following Hadrian, where she travels the world in the footsteps of emperor Hadrian.

        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(ci_title REGEXP '^richard i[[:>:]]' AS SIGNED INTEGER) * 3) *              
                (
                    MATCH(ci_title) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 400 +                    
                    MATCH(ci_text_linked) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN BOOLEAN MODE) * 100 +
                    MATCH(ci_search_tags) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 500 +
                    MATCH(ci_search_periods) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 2000 +
                    MATCH(ci_search_regions) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 200 + 
                    MATCH(ci_search_subjects) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 200 +
                    MATCH(ci_search_categories) AGAINST ('passages under the hippodrome of tyre hippodrome tyre' IN NATURAL LANGUAGE MODE) * 500 +
                    CAST(LOWER(ci_title) = 'passages under the hippodrome of tyre hippodrome tyre' AS SIGNED INTEGER) * 100000                    
                     +
            CAST(LOWER(ci_url) = '/passages_under_the_hippodrome_of_tyre_hippodrome_tyre/' 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

Raddato, C. (2021, November 22). Passages under the Hippodrome of Tyre. World History Encyclopedia. Retrieved from https://www.worldhistory.org/image/14893/passages-under-the-hippodrome-of-tyre/

Chicago Style

Raddato, Carole. "Passages under the Hippodrome of Tyre." World History Encyclopedia. Last modified November 22, 2021. https://www.worldhistory.org/image/14893/passages-under-the-hippodrome-of-tyre/.

MLA Style

Raddato, Carole. "Passages under the Hippodrome of Tyre." World History Encyclopedia. World History Encyclopedia, 22 Nov 2021. Web. 26 Jan 2022.

Membership