(
            SELECT DISTINCT(o.id), sr.navigation_url,

            MATCH(sr.search_data_search_keywords) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA0,
            MATCH(sr.search_data_title) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA1,
            MATCH(sr.search_data_subtitle) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA2,
            MATCH(sr.search_data_intro_text) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA3,
            MATCH(sr.search_data_plain_text) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA4,
            MATCH(sr.search_data_text) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA5,
            MATCH(sr.search_data_blocks) AGAINST ('+peoplerichard +morgan*' IN BOOLEAN MODE) AS scoreA6,

            MATCH(sr.search_data_search_keywords) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB0,
            MATCH(sr.search_data_title) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB1,
            MATCH(sr.search_data_subtitle) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB2,
            MATCH(sr.search_data_intro_text) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB3,
            MATCH(sr.search_data_plain_text) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB4,
            MATCH(sr.search_data_text) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB5,
            MATCH(sr.search_data_blocks) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE) AS scoreB6,

            MATCH(sr.search_data_search_keywords) AGAINST ('our peoplerichard morgan*' IN BOOLEAN MODE) AS scoreC0

            FROM objects o
            JOIN search_raw sr ON sr.object_id = o.id

        
            WHERE 1
        
            AND o.publish_from > 0
            AND o.pending_deletion = 0
            AND o.publish_from <= UNIX_TIMESTAMP(NOW())
            AND (
                o.publish_to = 0
                OR
                o.publish_to >= UNIX_TIMESTAMP(NOW())
            )

            AND MATCH (sr.search_data_raw) AGAINST ('peoplerichard morgan*' IN BOOLEAN MODE)
        
            ORDER BY
         o.template_id = 19 DESC, 
            ((scoreA0 * 15) + (scoreA1 * 10) + scoreA2 + (scoreA3 * 5) + scoreA4 + (scoreA5 * 3) + scoreA6)*100 + ((scoreB0 * 15) + (scoreB1 * 10) + scoreB2 + (scoreB3 * 5) + scoreB4 + (scoreB5 * 3) + scoreB6) + (scoreC0 * 10) DESC
        )