frkRpM16

1SELECT anon_1.id, anon_1.first_name, anon_1.last_name, anon_1.url_bit, anon_1.short_url, anon_1.email, anon_1.alternate_email, anon_1.admin_id, anon_1.password, anon_1.`role`, anon_1.user_type, anon_1.user_access, anon_1.first_login, anon_1.last_login, anon_1.create_time, anon_1.update_time, anon_1.photo_update_time, anon_1.is_verified, anon_1.is_visible, anon_1.is_bounced, anon_1.marketing, anon_1.active, anon_1.job_status, anon_1.linkedin_id, anon_1.linkedin_member_id, anon_1.linkedin_token, anon_1.linkedin_token_expiry, anon_1.linkedin_url, anon_1.linkedin_pub_url, anon_1.linkedin_sync_time, anon_1.angel_id, anon_1.secretkey, anon_1.google_token, anon_1.google_refresh_token, anon_1.google_token_expiry, anon_1.status, anon_1.referral_company_id, anon_1.referral_jobpost_id, anon_1.employer_company_id, anon_1.undergrad_year, anon_1.profile_intro, anon_1.profile_photo_url, anon_1.home_zipcode, anon_1.mini_resume, anon_1.location, anon_1.primary_market, anon_1.industry, anon_1.cell_phone, anon_1.title, anon_1.twilio_id, anon_1.internal_note, anon_1.intent_score, anon_1.lead_queue_owner, anon_1.lead_queue_event, anon_1.src_queue_stage, anon_1.src_queue_event_time, anon_1.lead_queue_stage, anon_1.lead_queue_event_time, anon_1.extended_data, anon_1.user_id, anon_1.company_id, anon_1.type, anon_1.degree_level, anon_1.field_of_study, anon_1.description, anon_1.additional, anon_1.start_date, anon_1.end_date, anon_1.is_current, anon_1.is_deleted, opp_1.id, opp_1.source_name, opp_1.sales_source, opp_1.min_base, opp_1.min_ote, opp_1.target_base, opp_1.target_ote, opp_1.status, opp_1.latest_status, opp_1.application_status, opp_1.close_reason, opp_1.close_reason_detail, opp_1.opp_type, opp_1.ta_next_action, opp_1.notes, opp_1.desired_location, opp_1.current_and_prior_roles, opp_1.reason_for_leaving, opp_1.career_aspiration, opp_1.ideal_next_role, opp_1.external_interview_status, opp_1.urgency, opp_1.competition, opp_1.compensation, opp_1.personal_intel, opp_1.highlight, opp_1.creator, opp_1.owner, opp_1.ta, opp_1.sourcer, opp_1.internal_referrer, opp_1.current_base, opp_1.current_ote, opp_1.create_time, opp_1.update_time, opp_1.first_reachout_time, opp_1.last_contact, opp_1.is_disqualified, opp_1.start_time, opp_1.end_time, opp_1.user_id, opp_1.extended_data 
2FROM (SELECT DISTINCT user.id AS id, user.first_name AS first_name, user.last_name AS last_name, user.url_bit AS url_bit, user.short_url AS short_url, user.email AS email, user.alternate_email AS alternate_email, user.admin_id AS admin_id, user.password AS password, user.`role` AS `role`, user.user_type AS user_type, user.user_access AS user_access, user.first_login AS first_login, user.last_login AS last_login, user.create_time AS create_time, user.update_time AS update_time, user.photo_update_time AS photo_update_time, user.is_verified AS is_verified, user.is_visible AS is_visible, user.is_bounced AS is_bounced, user.marketing AS marketing, user.active AS active, user.job_status AS job_status, user.linkedin_id AS linkedin_id, user.linkedin_member_id AS linkedin_member_id, user.linkedin_token AS linkedin_token, user.linkedin_token_expiry AS linkedin_token_expiry, user.linkedin_url AS linkedin_url, user.linkedin_pub_url AS linkedin_pub_url, user.linkedin_sync_time AS linkedin_sync_time, user.angel_id AS angel_id, user.secretkey AS secretkey, user.google_token AS google_token, user.google_refresh_token AS google_refresh_token, user.google_token_expiry AS google_token_expiry, user.status AS status, user.referral_company_id AS referral_company_id, user.referral_jobpost_id AS referral_jobpost_id, user.employer_company_id AS employer_company_id, user.undergrad_year AS undergrad_year, user.profile_intro AS profile_intro, user.profile_photo_url AS profile_photo_url, user.home_zipcode AS home_zipcode, user.mini_resume AS mini_resume, user.location AS location, user.primary_market AS primary_market, user.industry AS industry, user.cell_phone AS cell_phone, user.title AS title, user.twilio_id AS twilio_id, user.internal_note AS internal_note, user.intent_score AS intent_score, user.lead_queue_owner AS lead_queue_owner, user.lead_queue_event AS lead_queue_event, user.src_queue_stage AS src_queue_stage, user.src_queue_event_time AS src_queue_event_time, user.lead_queue_stage AS lead_queue_stage, user.lead_queue_event_time AS lead_queue_event_time, user.extended_data AS extended_data, position.id AS id, position.user_id AS user_id, position.company_id AS company_id, position.type AS type, position.location AS location, position.title AS title, position.degree_level AS degree_level, position.field_of_study AS field_of_study, position.description AS description, position.additional AS additional, position.start_date AS start_date, position.end_date AS end_date, position.is_current AS is_current, position.is_deleted AS is_deleted, position.create_time AS create_time 
3FROM user INNER JOIN position ON position.user_id = user.id 
4WHERE position.company_id=54 AND position.is_deleted = false AND user.active = true AND user.user_type NOT IN ('MERGED', 'FAKE') ORDER BY position.is_current DESC) AS anon_1 LEFT OUTER JOIN opp AS opp_1 ON anon_1.id = opp_1.user_id ORDER BY anon_1.is_current DESC;