| 1 |
1.58 ms |
SELECT f0_.id AS id_0, f0_.status AS status_1, f0_.created_at AS created_at_2, f0_.question1 AS question1_3, f0_.question2a AS question2a_4, f0_.question2b AS question2b_5, f0_.question2c AS question2c_6, f0_.question3 AS question3_7, f0_.question4 AS question4_8, f0_.question5 AS question5_9, f0_.question1new AS question1new_10, f0_.question2new AS question2new_11, f0_.question3new AS question3new_12, f0_.question4new AS question4new_13, f0_.question5new AS question5new_14, f0_.question6new AS question6new_15, u1_.id AS id_16, u1_.email AS email_17, u1_.roles AS roles_18, u1_.password AS password_19, u1_.first_name AS first_name_20, u1_.last_name AS last_name_21, u1_.phone_number AS phone_number_22, u1_.membership_level AS membership_level_23, u1_.is_ambassador AS is_ambassador_24, u1_.reset_hash AS reset_hash_25, u1_.reset_hash_expire AS reset_hash_expire_26, u1_.title AS title_27, u1_.phone_ext AS phone_ext_28, u1_.mobile AS mobile_29, u1_.contact_type AS contact_type_30, u1_.department AS department_31, u1_.fax AS fax_32, u1_.user_type AS user_type_33, u1_.last_login AS last_login_34, u1_.is_new AS is_new_35, u1_.internal AS internal_36, u1_.username AS username_37, u1_.accepted_terms AS accepted_terms_38, u1_.accepted_terms_time AS accepted_terms_time_39, u1_.ambassador_assigned_date AS ambassador_assigned_date_40, u1_.request_status AS request_status_41, u1_.user_accepted_terms2 AS user_accepted_terms2_42, u1_.user_accepted_terms_time2 AS user_accepted_terms_time2_43, u1_.download_nda_time AS download_nda_time_44, m2_.id AS id_45, m2_.name AS name_46, m2_.first_name AS first_name_47, m2_.last_name AS last_name_48, m2_.email AS email_49, m2_.phone AS phone_50, m2_.fei AS fei_51, m2_.street AS street_52, m2_.city AS city_53, m2_.state AS state_54, m2_.zip AS zip_55, m2_.industry AS industry_56, m2_.ethnicity AS ethnicity_57, m2_.external_id AS external_id_58, m2_.revenue AS revenue_59, m2_.type AS type_60, m2_.gender AS gender_61, m2_.business_type AS business_type_62, m2_.business_structure AS business_structure_63, m2_.geographic_market AS geographic_market_64, m2_.description AS description_65, m2_.naics AS naics_66, m2_.nigp AS nigp_67, m2_.keywords AS keywords_68, m2_.certifications AS certifications_69, m2_.certification_entity AS certification_entity_70, m2_.certification_type AS certification_type_71, m2_.certification_date AS certification_date_72, m2_.year_established AS year_established_73, m2_.qualify_status AS qualify_status_74, m2_.website AS website_75, m2_.employees AS employees_76, m2_.status AS status_77, m2_.revenue_class AS revenue_class_78, m2_.rating AS rating_79, m2_.your_industry AS your_industry_80, m2_.professional_licenses AS professional_licenses_81, m2_.dba AS dba_82, m2_.created_at AS created_at_83, m2_.modified_at AS modified_at_84, m2_.senate AS senate_85, m2_.house_of_representatives AS house_of_representatives_86, m2_.congressional AS congressional_87, m2_.commissioner AS commissioner_88, m2_.school_board AS school_board_89, m2_.city_council AS city_council_90, m2_.deleted AS deleted_91, u3_.id AS id_92, u3_.email AS email_93, u3_.roles AS roles_94, u3_.password AS password_95, u3_.first_name AS first_name_96, u3_.last_name AS last_name_97, u3_.phone_number AS phone_number_98, u3_.membership_level AS membership_level_99, u3_.is_ambassador AS is_ambassador_100, u3_.reset_hash AS reset_hash_101, u3_.reset_hash_expire AS reset_hash_expire_102, u3_.title AS title_103, u3_.phone_ext AS phone_ext_104, u3_.mobile AS mobile_105, u3_.contact_type AS contact_type_106, u3_.department AS department_107, u3_.fax AS fax_108, u3_.user_type AS user_type_109, u3_.last_login AS last_login_110, u3_.is_new AS is_new_111, u3_.internal AS internal_112, u3_.username AS username_113, u3_.accepted_terms AS accepted_terms_114, u3_.accepted_terms_time AS accepted_terms_time_115, u3_.ambassador_assigned_date AS ambassador_assigned_date_116, u3_.request_status AS request_status_117, u3_.user_accepted_terms2 AS user_accepted_terms2_118, u3_.user_accepted_terms_time2 AS user_accepted_terms_time2_119, u3_.download_nda_time AS download_nda_time_120, f0_.assigned_user_id AS assigned_user_id_121, u1_.member_id AS member_id_122, u1_.ambassador_id AS ambassador_id_123, u3_.member_id AS member_id_124, u3_.ambassador_id AS ambassador_id_125 FROM first30_day_mbebusiness_reviews f0_ LEFT JOIN `user` u1_ ON f0_.assigned_user_id = u1_.id LEFT JOIN member m2_ ON u1_.member_id = m2_.id LEFT JOIN `user` u3_ ON u1_.ambassador_id = u3_.id ORDER BY f0_.id ASC LIMIT 20 OFFSET 20
SELECT
f0_.id AS id_0,
f0_.status AS status_1,
f0_.created_at AS created_at_2,
f0_.question1 AS question1_3,
f0_.question2a AS question2a_4,
f0_.question2b AS question2b_5,
f0_.question2c AS question2c_6,
f0_.question3 AS question3_7,
f0_.question4 AS question4_8,
f0_.question5 AS question5_9,
f0_.question1new AS question1new_10,
f0_.question2new AS question2new_11,
f0_.question3new AS question3new_12,
f0_.question4new AS question4new_13,
f0_.question5new AS question5new_14,
f0_.question6new AS question6new_15,
u1_.id AS id_16,
u1_.email AS email_17,
u1_.roles AS roles_18,
u1_.password AS password_19,
u1_.first_name AS first_name_20,
u1_.last_name AS last_name_21,
u1_.phone_number AS phone_number_22,
u1_.membership_level AS membership_level_23,
u1_.is_ambassador AS is_ambassador_24,
u1_.reset_hash AS reset_hash_25,
u1_.reset_hash_expire AS reset_hash_expire_26,
u1_.title AS title_27,
u1_.phone_ext AS phone_ext_28,
u1_.mobile AS mobile_29,
u1_.contact_type AS contact_type_30,
u1_.department AS department_31,
u1_.fax AS fax_32,
u1_.user_type AS user_type_33,
u1_.last_login AS last_login_34,
u1_.is_new AS is_new_35,
u1_.internal AS internal_36,
u1_.username AS username_37,
u1_.accepted_terms AS accepted_terms_38,
u1_.accepted_terms_time AS accepted_terms_time_39,
u1_.ambassador_assigned_date AS ambassador_assigned_date_40,
u1_.request_status AS request_status_41,
u1_.user_accepted_terms2 AS user_accepted_terms2_42,
u1_.user_accepted_terms_time2 AS user_accepted_terms_time2_43,
u1_.download_nda_time AS download_nda_time_44,
m2_.id AS id_45,
m2_.name AS name_46,
m2_.first_name AS first_name_47,
m2_.last_name AS last_name_48,
m2_.email AS email_49,
m2_.phone AS phone_50,
m2_.fei AS fei_51,
m2_.street AS street_52,
m2_.city AS city_53,
m2_.state AS state_54,
m2_.zip AS zip_55,
m2_.industry AS industry_56,
m2_.ethnicity AS ethnicity_57,
m2_.external_id AS external_id_58,
m2_.revenue AS revenue_59,
m2_.type AS type_60,
m2_.gender AS gender_61,
m2_.business_type AS business_type_62,
m2_.business_structure AS business_structure_63,
m2_.geographic_market AS geographic_market_64,
m2_.description AS description_65,
m2_.naics AS naics_66,
m2_.nigp AS nigp_67,
m2_.keywords AS keywords_68,
m2_.certifications AS certifications_69,
m2_.certification_entity AS certification_entity_70,
m2_.certification_type AS certification_type_71,
m2_.certification_date AS certification_date_72,
m2_.year_established AS year_established_73,
m2_.qualify_status AS qualify_status_74,
m2_.website AS website_75,
m2_.employees AS employees_76,
m2_.status AS status_77,
m2_.revenue_class AS revenue_class_78,
m2_.rating AS rating_79,
m2_.your_industry AS your_industry_80,
m2_.professional_licenses AS professional_licenses_81,
m2_.dba AS dba_82,
m2_.created_at AS created_at_83,
m2_.modified_at AS modified_at_84,
m2_.senate AS senate_85,
m2_.house_of_representatives AS house_of_representatives_86,
m2_.congressional AS congressional_87,
m2_.commissioner AS commissioner_88,
m2_.school_board AS school_board_89,
m2_.city_council AS city_council_90,
m2_.deleted AS deleted_91,
u3_.id AS id_92,
u3_.email AS email_93,
u3_.roles AS roles_94,
u3_.password AS password_95,
u3_.first_name AS first_name_96,
u3_.last_name AS last_name_97,
u3_.phone_number AS phone_number_98,
u3_.membership_level AS membership_level_99,
u3_.is_ambassador AS is_ambassador_100,
u3_.reset_hash AS reset_hash_101,
u3_.reset_hash_expire AS reset_hash_expire_102,
u3_.title AS title_103,
u3_.phone_ext AS phone_ext_104,
u3_.mobile AS mobile_105,
u3_.contact_type AS contact_type_106,
u3_.department AS department_107,
u3_.fax AS fax_108,
u3_.user_type AS user_type_109,
u3_.last_login AS last_login_110,
u3_.is_new AS is_new_111,
u3_.internal AS internal_112,
u3_.username AS username_113,
u3_.accepted_terms AS accepted_terms_114,
u3_.accepted_terms_time AS accepted_terms_time_115,
u3_.ambassador_assigned_date AS ambassador_assigned_date_116,
u3_.request_status AS request_status_117,
u3_.user_accepted_terms2 AS user_accepted_terms2_118,
u3_.user_accepted_terms_time2 AS user_accepted_terms_time2_119,
u3_.download_nda_time AS download_nda_time_120,
f0_.assigned_user_id AS assigned_user_id_121,
u1_.member_id AS member_id_122,
u1_.ambassador_id AS ambassador_id_123,
u3_.member_id AS member_id_124,
u3_.ambassador_id AS ambassador_id_125
FROM
first30_day_mbebusiness_reviews f0_
LEFT JOIN `user` u1_ ON f0_.assigned_user_id = u1_.id
LEFT JOIN member m2_ ON u1_.member_id = m2_.id
LEFT JOIN `user` u3_ ON u1_.ambassador_id = u3_.id
ORDER BY
f0_.id ASC
LIMIT
20 OFFSET 20
SELECT f0_.id AS id_0, f0_.status AS status_1, f0_.created_at AS created_at_2, f0_.question1 AS question1_3, f0_.question2a AS question2a_4, f0_.question2b AS question2b_5, f0_.question2c AS question2c_6, f0_.question3 AS question3_7, f0_.question4 AS question4_8, f0_.question5 AS question5_9, f0_.question1new AS question1new_10, f0_.question2new AS question2new_11, f0_.question3new AS question3new_12, f0_.question4new AS question4new_13, f0_.question5new AS question5new_14, f0_.question6new AS question6new_15, u1_.id AS id_16, u1_.email AS email_17, u1_.roles AS roles_18, u1_.password AS password_19, u1_.first_name AS first_name_20, u1_.last_name AS last_name_21, u1_.phone_number AS phone_number_22, u1_.membership_level AS membership_level_23, u1_.is_ambassador AS is_ambassador_24, u1_.reset_hash AS reset_hash_25, u1_.reset_hash_expire AS reset_hash_expire_26, u1_.title AS title_27, u1_.phone_ext AS phone_ext_28, u1_.mobile AS mobile_29, u1_.contact_type AS contact_type_30, u1_.department AS department_31, u1_.fax AS fax_32, u1_.user_type AS user_type_33, u1_.last_login AS last_login_34, u1_.is_new AS is_new_35, u1_.internal AS internal_36, u1_.username AS username_37, u1_.accepted_terms AS accepted_terms_38, u1_.accepted_terms_time AS accepted_terms_time_39, u1_.ambassador_assigned_date AS ambassador_assigned_date_40, u1_.request_status AS request_status_41, u1_.user_accepted_terms2 AS user_accepted_terms2_42, u1_.user_accepted_terms_time2 AS user_accepted_terms_time2_43, u1_.download_nda_time AS download_nda_time_44, m2_.id AS id_45, m2_.name AS name_46, m2_.first_name AS first_name_47, m2_.last_name AS last_name_48, m2_.email AS email_49, m2_.phone AS phone_50, m2_.fei AS fei_51, m2_.street AS street_52, m2_.city AS city_53, m2_.state AS state_54, m2_.zip AS zip_55, m2_.industry AS industry_56, m2_.ethnicity AS ethnicity_57, m2_.external_id AS external_id_58, m2_.revenue AS revenue_59, m2_.type AS type_60, m2_.gender AS gender_61, m2_.business_type AS business_type_62, m2_.business_structure AS business_structure_63, m2_.geographic_market AS geographic_market_64, m2_.description AS description_65, m2_.naics AS naics_66, m2_.nigp AS nigp_67, m2_.keywords AS keywords_68, m2_.certifications AS certifications_69, m2_.certification_entity AS certification_entity_70, m2_.certification_type AS certification_type_71, m2_.certification_date AS certification_date_72, m2_.year_established AS year_established_73, m2_.qualify_status AS qualify_status_74, m2_.website AS website_75, m2_.employees AS employees_76, m2_.status AS status_77, m2_.revenue_class AS revenue_class_78, m2_.rating AS rating_79, m2_.your_industry AS your_industry_80, m2_.professional_licenses AS professional_licenses_81, m2_.dba AS dba_82, m2_.created_at AS created_at_83, m2_.modified_at AS modified_at_84, m2_.senate AS senate_85, m2_.house_of_representatives AS house_of_representatives_86, m2_.congressional AS congressional_87, m2_.commissioner AS commissioner_88, m2_.school_board AS school_board_89, m2_.city_council AS city_council_90, m2_.deleted AS deleted_91, u3_.id AS id_92, u3_.email AS email_93, u3_.roles AS roles_94, u3_.password AS password_95, u3_.first_name AS first_name_96, u3_.last_name AS last_name_97, u3_.phone_number AS phone_number_98, u3_.membership_level AS membership_level_99, u3_.is_ambassador AS is_ambassador_100, u3_.reset_hash AS reset_hash_101, u3_.reset_hash_expire AS reset_hash_expire_102, u3_.title AS title_103, u3_.phone_ext AS phone_ext_104, u3_.mobile AS mobile_105, u3_.contact_type AS contact_type_106, u3_.department AS department_107, u3_.fax AS fax_108, u3_.user_type AS user_type_109, u3_.last_login AS last_login_110, u3_.is_new AS is_new_111, u3_.internal AS internal_112, u3_.username AS username_113, u3_.accepted_terms AS accepted_terms_114, u3_.accepted_terms_time AS accepted_terms_time_115, u3_.ambassador_assigned_date AS ambassador_assigned_date_116, u3_.request_status AS request_status_117, u3_.user_accepted_terms2 AS user_accepted_terms2_118, u3_.user_accepted_terms_time2 AS user_accepted_terms_time2_119, u3_.download_nda_time AS download_nda_time_120, f0_.assigned_user_id AS assigned_user_id_121, u1_.member_id AS member_id_122, u1_.ambassador_id AS ambassador_id_123, u3_.member_id AS member_id_124, u3_.ambassador_id AS ambassador_id_125 FROM first30_day_mbebusiness_reviews f0_ LEFT JOIN `user` u1_ ON f0_.assigned_user_id = u1_.id LEFT JOIN member m2_ ON u1_.member_id = m2_.id LEFT JOIN `user` u3_ ON u1_.ambassador_id = u3_.id ORDER BY f0_.id ASC LIMIT 20 OFFSET 20;
|