select `recommend_email_send_by_cron`.`business_id` as `businessId`, `recommend_email_send_by_cron`.`email` as `email`, `user_form_submission`.`id` as `userId`, `recommend_email_send_by_cron`.`name` as `name`, `recommend_email_send_by_cron`.`status` as `status`, `recommend_email_send_by_cron`.`sign_in_data` as `sign_in_time`, `recommend_email_send_by_cron`.`sent_time` as `mail_sent_time`, `user_form_submission`.`created_at` as `created_at`, `user_form_submission`.`form_id` as `formId`, (CASE WHEN (select user_id from track_button_events where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN 'Yes' ELSE 'No' END) as noButtonClicked, (CASE WHEN (select user_id from recommend_feedback_details where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN recommend_feedback_details.feedback ELSE '' END) as message, (CASE WHEN (select user_id from recommend_yes_button_track where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN 'Yes' ELSE 'No' END) as yesButtonClicked, (CASE WHEN (recommend_email_send_by_cron.status= 'sent') THEN 'Yes' ELSE '' END) as mail_sent from `user_form_submission` inner join `recommend_email_send_by_cron` on `recommend_email_send_by_cron`.`user_id` = `user_form_submission`.`id` where `user_form_submission`.`business_id` = ?