SELECT `Subscriber`.`id`, `Subscriber`.`name`, `Subscriber`.`surname`, `Subscriber`.`email`, `Subscriber`.`password`, `Subscriber`.`password_token`, `Subscriber`.`password_hash`, `Subscriber`.`subscription_type_id`, `Subscriber`.`registration_date`, `Subscriber`.`expiry_date`, `Subscriber`.`renewal_date`, `Subscriber`.`status`, `Subscriber`.`payment_type`, `Subscriber`.`last_process`, `Subscriber`.`created`, `Subscriber`.`updated`, `Subscriber`.`contact_company_name`, `Subscriber`.`contact_title`, `Subscriber`.`contact_title_other`, `Subscriber`.`contact_name`, `Subscriber`.`contact_surname`, `Subscriber`.`contact_job_title`, `Subscriber`.`contact_address`, `Subscriber`.`contact_address2`, `Subscriber`.`contact_address3`, `Subscriber`.`contact_city`, `Subscriber`.`contact_country_id`, `Subscriber`.`contact_county`, `Subscriber`.`contact_postal_code`, `Subscriber`.`contact_email`, `Subscriber`.`contact_phone`, `Subscriber`.`billing_company_name`, `Subscriber`.`billing_title`, `Subscriber`.`billing_title_other`, `Subscriber`.`billing_name`, `Subscriber`.`billing_surname`, `Subscriber`.`billing_job_title`, `Subscriber`.`billing_address`, `Subscriber`.`billing_address2`, `Subscriber`.`billing_address3`, `Subscriber`.`billing_city`, `Subscriber`.`billing_country_id`, `Subscriber`.`billing_county`, `Subscriber`.`billing_postal_code`, `Subscriber`.`billing_email`, `Subscriber`.`billing_phone`, `Subscriber`.`receive_expiry_emails`, `Subscriber`.`receive_notifications`, `Subscriber`.`opt_out_code`, `Subscriber`.`job_function`, `Subscriber`.`job_function_other`, `Subscriber`.`job_level`, `Subscriber`.`job_level_other`, `Subscriber`.`area_interest`, `Subscriber`.`company_type`, `Subscriber`.`company_type_other`, `Subscriber`.`industry_sector`, `Subscriber`.`industry_sector_other`, `Subscriber`.`free_digital_subscription`, `Subscriber`.`personal_identifier_answer`, `Subscriber`.`free_digital_expiry_date`, `Subscriber`.`free_digital_renewal_date`, `Subscriber`.`mobile`, `Subscriber`.`txn_id`, `Subscriber`.`free_print_subscription`, `Subscriber`.`free_print_expiry_date`, `Subscriber`.`free_digital_registration_date`, `Subscriber`.`free_print_registration_date`, `Subscriber`.`free_print_personal_identifier_answer`, `Subscriber`.`free_print_renewal_date`, `Subscriber`.`is_admin_alert`, `Subscriber`.`is_confirm_mail_sent`, `Subscriber`.`is_renew_redirected`, `Subscriber`.`is_free_sub_expired`, `Subscriber`.`email_preference`, `Subscriber`.`decision_making_level_id`, `Subscriber`.`decision_making_level_other`, `Subscriber`.`newsletter_registration`, `Subscriber`.`zform_registration` FROM `drugrpl_dtr2021`.`subscribers` AS `Subscriber` WHERE `Subscriber`.`subscription_type_id` IN (1, 2) | 0 | 0 | 0 | |