SELECT
        optimizedSub1.*,
        (SELECT
            favourite_influencers.row_status
        FROM
            favourite_influencers
        WHERE
            influencer_user_id = optimizedSub1.id
            AND favourite_influencers.entity_id = '377' LIMIT 1) AS favourite
    FROM
        (SELECT
            influencers.id AS influencer_id,
            influencers.entity_type AS entity_type,
            influencers.entity_name AS social_name,
            rating.display_value AS rating,
            countries.id AS country_id,
            countries.country_name AS country_name,
            LOWER(countries.iso_code_2) AS country_iso_code_2,
            LOWER(countries.iso_code_3) AS country_iso_code_3,
            users.id AS influencer_user_id,
            users.first_name AS first_name,
            users.last_name AS last_name,
            users.login_email AS login_email,
            users.last_login AS last_login,
            influencers.entity_description AS entity_description,
            roles.id AS role_id,
            roles.code_name AS role_code_name,
            roles.role_name AS role_display_name,
            states.id AS state_id,
            states.state_name AS state_name,
            cities.id AS city_id,
            cities.city_name AS city_name,
            GROUP_CONCAT(DISTINCT audience_countries.id) AS audience_country_ids,
            GROUP_CONCAT(DISTINCT audience_countries.country_name) AS audience_country_name,
            GROUP_CONCAT(DISTINCT LOWER(audience_countries.iso_code_2)) AS audience_country_iso_code_2,
            GROUP_CONCAT(DISTINCT audience_countries.id) AS audience_country_iso_code_3,
            GROUP_CONCAT(DISTINCT audience_cities.id) AS audience_city_ids,
            GROUP_CONCAT(DISTINCT audience_cities.city_name) AS audience_city_name,
            GROUP_CONCAT(DISTINCT audience_states.id) AS audience_state_ids,
            GROUP_CONCAT(DISTINCT audience_states.state_name) AS audience_state_name,
            (COALESCE((SELECT
                count(influencer_users.id)
            FROM
                users AS influencer_users
            INNER JOIN
                entities_users seu
                    ON seu.id = influencer_users.id
            INNER JOIN
                entities AS campaigns_influencers
                    ON campaigns_influencers.id = seu.id
            INNER JOIN
                campaigns_offered_influencers coi
                    ON coi.user_id = influencer_users.id
            WHERE
                coi.campaign_offered_status = 'completed'
                AND campaigns_influencers.id = influencers.id),
            0)) AS campaigns_completed,
            GROUP_CONCAT(DISTINCT (CASE
                WHEN interest_groups.parent_id IS NULL THEN interest_groups.id
                ELSE NULL
            END)) AS primary_interest_groups_ids,
            GROUP_CONCAT(DISTINCT (CASE
                WHEN interest_groups.parent_id IS NULL THEN interest_groups.interest_name
                ELSE NULL
            END)) AS primary_interest_groups,
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    SUM(total_fan_count) AS total_fans_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id))
                ELSE 0
            END AS 'total_fan_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'facebook'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'facebook_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'twitter'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'twitter_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'youtube'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'youtube_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'instagram'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'instagram_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'snapchat'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'snapchat_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'linkedin'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'linkedin_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'pinterest'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'pinterest_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    total_fan_count
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'tumblr'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'tumblr_total_count',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'facebook'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'facebook_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'facebook'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'facebook_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'facebook'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'facebook_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'twitter'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'twitter_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'twitter'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'twitter_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'twitter'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'twitter_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'youtube'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'youtube_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'youtube'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'youtube_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'youtube'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'youtube_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'snapchat'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'snapchat_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'snapchat'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'snapchat_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'snapchat'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'snapchat_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'instagram'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'instagram_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'instagram'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'instagram_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'instagram'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'instagram_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'linkedin'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'linkedin_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'linkedin'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'linkedin_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'linkedin'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'linkedin_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'pinterest'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'pinterest_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'pinterest'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'pinterest_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'pinterest'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'pinterest_engagement_sort_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.id
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'tumblr'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'tumblr_engagement_id',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.display_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'tumblr'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'tumblr_engagement_display_value',
            CASE
                WHEN setup_socialmedia_channels.code_name IS NOT NULL THEN ((SELECT
                    social_engagement_levels.sort_value
                FROM
                    users AS social_users
                INNER JOIN
                    entities_users AS seu
                        ON seu.user_id = social_users.id
                INNER JOIN
                    entities AS social_influencers
                        ON social_influencers.id = seu.entity_id
                LEFT JOIN
                    influencers_socialstats AS sss
                        ON sss.influencer_user_id = social_users.id
                LEFT JOIN
                    setup_socialmedia_channels AS ssc
                        ON ssc.id = sss.setup_socialmedia_channel_id
                LEFT JOIN
                    setup_social_engagement_levels AS social_engagement_levels
                        ON social_engagement_levels.id = sss.setup_social_engagement_rate_id
                WHERE
                    social_influencers.id = influencers.id
                    AND ssc.code_name = 'tumblr'
                GROUP BY
                    influencers.id))
                ELSE '-'
            END AS 'tumblr_engagement_sort_value',
            profile_attachments.id AS profile_pic_id
        FROM
            users AS users
        LEFT JOIN
            entities_users eu
                ON users.id = eu.user_id
        INNER JOIN
            entities AS influencers
                ON influencers.id = eu.entity_id
        LEFT JOIN
            entities_users_roles AS users_role
                ON users_role.user_id = users.id
        LEFT JOIN
            setup_roles AS roles
                ON roles.id = users_role.role_id
        LEFT JOIN
            setup_rating_list AS rating
                ON rating.id = influencers.rating_id
        LEFT JOIN
            setup_countries AS countries
                ON countries.id = influencers.country_id
        LEFT JOIN
            setup_states AS states
                ON states.id = influencers.states_id
        LEFT JOIN
            setup_cities AS cities
                ON cities.id = influencers.city_id
        LEFT JOIN
            influencers_audience_location AS influencers_audience_location
                ON influencers_audience_location.user_id = users.id
        LEFT JOIN
            setup_countries AS audience_countries
                ON audience_countries.id = influencers_audience_location.country_id
        LEFT JOIN
            setup_states AS audience_states
                ON audience_states.id = influencers_audience_location.state_id
        LEFT JOIN
            setup_cities AS audience_cities
                ON audience_cities.id = influencers_audience_location.city_id
        LEFT JOIN
            influencer_interests AS influencer_interests
                ON influencer_interests.entity_id = influencers.id
        LEFT JOIN
            setup_interest_groups AS interest_groups
                ON interest_groups.id = influencer_interests.interest_groups_id
        LEFT JOIN
            influencers_socialstats AS social_stats
                ON social_stats.influencer_user_id = users.id
        LEFT JOIN
            setup_socialmedia_channels AS setup_socialmedia_channels
                ON setup_socialmedia_channels.id = social_stats.setup_socialmedia_channel_id
        LEFT JOIN
            setup_social_engagement_levels AS social_engagement_levels
                ON social_engagement_levels.id = social_stats.setup_social_engagement_rate_id
        LEFT JOIN
            file_attachments AS profile_attachments
                ON profile_attachments.id = influencers.profile_pic_id
        WHERE
            (
                (
                    influencers.entity_type = 'influencer'
                    AND influencers.row_status = 'active'
                    AND users.row_status = 'active'
                    AND users.account_verified = 1
                )
            )
        GROUP BY
            influencers.id
        ORDER BY
            Field(countries.id,
            231) DESC LIMIT 25 OFFSET 0) AS optimizedSub1