gistfile1.txt

    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
	LEFT 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',
	( SELECT row_status FROM favourite_influencers WHERE influencer_user_id = users.id AND entity_id = '377' LIMIT 1 ) AS favourite,
	profile_attachments.id AS profile_pic_id 
        FROM
	users AS users
	LEFT JOIN entities_users eu ON users.id = eu.user_id
	LEFT 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 influencer_objectives AS influencer_objectives ON influencer_objectives.entity_id = influencers.id
	LEFT JOIN setup_influencer_types AS setup_influencer_types ON setup_influencer_types.id = influencer_objectives.objectives_id
	LEFT JOIN file_attachments AS profile_attachments ON profile_attachments.id = influencers.profile_pic_id
	LEFT JOIN file_attachments_thumbnails AS profile_attachments_thumbnails ON profile_attachments_thumbnails.file_attachments_id = profile_attachments.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;