big.rb

SELECT `enquiries`.`id` AS t0_r0, `enquiries`.`first_name` AS t0_r1, `enquiries`.`surname` AS t0_r2, `enquiries`.`mobile1` AS t0_r3, `enquiries`.`mobile2` AS t0_r4, `enquiries`.`email1` AS t0_r5, `enquiries`.`email2` AS t0_r6, `enquiries`.`gender` AS t0_r7, `enquiries`.`date_of_birth` AS t0_r8, `enquiries`.`score` AS t0_r9, `enquiries`.`source_id` AS t0_r10, `enquiries`.`assigned_to` AS t0_r11, `enquiries`.`assigned_by` AS t0_r12, `enquiries`.`created_by` AS t0_r13, `enquiries`.`updated_by` AS t0_r14, `enquiries`.`created_at` AS t0_r15, `enquiries`.`updated_at` AS t0_r16, `enquiries`.`country_id` AS t0_r17, `enquiries`.`status_id` AS t0_r18, `enquiries`.`address` AS t0_r19, `enquiries`.`active` AS t0_r20, `enquiries`.`contact_type_id` AS t0_r21, `enquiries`.`registered` AS t0_r22, `enquiries`.`image` AS t0_r23, `enquiries`.`branch_id` AS t0_r24, `enquiries`.`registered_at` AS t0_r25, `enquiries`.`registered_by` AS t0_r26, `enquiries`.`impressions_count` AS t0_r27, `enquiries`.`response_time` AS t0_r28, `enquiries`.`assigned_at` AS t0_r29, `enquiry_statuses`.`id` AS t1_r0, `enquiry_statuses`.`name` AS t1_r1, `enquiry_statuses`.`desc` AS t1_r2, `enquiry_statuses`.`created_at` AS t1_r3, `enquiry_statuses`.`updated_at` AS t1_r4, `enquiry_statuses`.`created_by` AS t1_r5, `enquiry_statuses`.`updated_by` AS t1_r6, `enquiry_statuses`.`cl` AS t1_r7, `follow_ups`.`id` AS t2_r0, `follow_ups`.`title` AS t2_r1, `follow_ups`.`desc` AS t2_r2, `follow_ups`.`starts_at` AS t2_r3, `follow_ups`.`ends_at` AS t2_r4, `follow_ups`.`api` AS t2_r5, `follow_ups`.`event_type_id` AS t2_r6, `follow_ups`.`venue` AS t2_r7, `follow_ups`.`remind_before` AS t2_r8, `follow_ups`.`created_by` AS t2_r9, `follow_ups`.`updated_by` AS t2_r10, `follow_ups`.`created_at` AS t2_r11, `follow_ups`.`updated_at` AS t2_r12, `follow_ups`.`enquiry_id` AS t2_r13, `follow_ups`.`assigned_to` AS t2_r14, `follow_ups`.`assigned_by` AS t2_r15, `follow_ups`.`registration_id` AS t2_r16, `follow_ups`.`institution_id` AS t2_r17, `follow_ups`.`person_id` AS t2_r18, `follow_ups`.`followed` AS t2_r19, `follow_ups`.`auto` AS t2_r20, `countries`.`id` AS t3_r0, `countries`.`name` AS t3_r1, `countries`.`desc` AS t3_r2, `countries`.`code` AS t3_r3, `countries`.`continent` AS t3_r4, `countries`.`region` AS t3_r5, `countries`.`government_form` AS t3_r6, `countries`.`local_name` AS t3_r7, `countries`.`capital_city_id` AS t3_r8, `countries`.`created_at` AS t3_r9, `countries`.`updated_at` AS t3_r10, `countries`.`created_by` AS t3_r11, `countries`.`updated_by` AS t3_r12, `countries`.`region_id` AS t3_r13, `users`.`id` AS t4_r0, `users`.`branch_id` AS t4_r1, `users`.`role_id` AS t4_r2, `users`.`image` AS t4_r3, `users`.`email_signature` AS t4_r4, `users`.`created_by` AS t4_r5, `users`.`updated_by` AS t4_r6, `users`.`created_at` AS t4_r7, `users`.`updated_at` AS t4_r8, `users`.`confirmation_token` AS t4_r9, `users`.`confirmed_at` AS t4_r10, `users`.`confirmation_sent_at` AS t4_r11, `users`.`unconfirmed_email` AS t4_r12, `users`.`email` AS t4_r13, `users`.`encrypted_password` AS t4_r14, `users`.`reset_password_token` AS t4_r15, `users`.`reset_password_sent_at` AS t4_r16, `users`.`remember_created_at` AS t4_r17, `users`.`sign_in_count` AS t4_r18, `users`.`current_sign_in_at` AS t4_r19, `users`.`last_sign_in_at` AS t4_r20, `users`.`current_sign_in_ip` AS t4_r21, `users`.`last_sign_in_ip` AS t4_r22, `users`.`first_name` AS t4_r23, `users`.`surname` AS t4_r24, `users`.`invitation_token` AS t4_r25, `users`.`invitation_created_at` AS t4_r26, `users`.`invitation_sent_at` AS t4_r27, `users`.`invitation_accepted_at` AS t4_r28, `users`.`invitation_limit` AS t4_r29, `users`.`invited_by_id` AS t4_r30, `users`.`invited_by_type` AS t4_r31, `users`.`mobile` AS t4_r32, `users`.`gender` AS t4_r33, `users`.`date_of_birth` AS t4_r34, `users`.`address` AS t4_r35, `users`.`skype` AS t4_r36, `users`.`facebook` AS t4_r37, `users`.`linkedin` AS t4_r38, `users`.`twitter` AS t4_r39, `users`.`website` AS t4_r40, `users`.`gplus` AS t4_r41, `users`.`blogger` AS t4_r42, `users`.`is_active` AS t4_r43, `_upd_bies_enquiries`.`id` AS t5_r0, `_upd_bies_enquiries`.`branch_id` AS t5_r1, `_upd_bies_enquiries`.`role_id` AS t5_r2, `_upd_bies_enquiries`.`image` AS t5_r3, `_upd_bies_enquiries`.`email_signature` AS t5_r4, `_upd_bies_enquiries`.`created_by` AS t5_r5, `_upd_bies_enquiries`.`updated_by` AS t5_r6, `_upd_bies_enquiries`.`created_at` AS t5_r7, `_upd_bies_enquiries`.`updated_at` AS t5_r8, `_upd_bies_enquiries`.`confirmation_token` AS t5_r9, `_upd_bies_enquiries`.`confirmed_at` AS t5_r10, `_upd_bies_enquiries`.`confirmation_sent_at` AS t5_r11, `_upd_bies_enquiries`.`unconfirmed_email` AS t5_r12, `_upd_bies_enquiries`.`email` AS t5_r13, `_upd_bies_enquiries`.`encrypted_password` AS t5_r14, `_upd_bies_enquiries`.`reset_password_token` AS t5_r15, `_upd_bies_enquiries`.`reset_password_sent_at` AS t5_r16, `_upd_bies_enquiries`.`remember_created_at` AS t5_r17, `_upd_bies_enquiries`.`sign_in_count` AS t5_r18, `_upd_bies_enquiries`.`current_sign_in_at` AS t5_r19, `_upd_bies_enquiries`.`last_sign_in_at` AS t5_r20, `_upd_bies_enquiries`.`current_sign_in_ip` AS t5_r21, `_upd_bies_enquiries`.`last_sign_in_ip` AS t5_r22, `_upd_bies_enquiries`.`first_name` AS t5_r23, `_upd_bies_enquiries`.`surname` AS t5_r24, `_upd_bies_enquiries`.`invitation_token` AS t5_r25, `_upd_bies_enquiries`.`invitation_created_at` AS t5_r26, `_upd_bies_enquiries`.`invitation_sent_at` AS t5_r27, `_upd_bies_enquiries`.`invitation_accepted_at` AS t5_r28, `_upd_bies_enquiries`.`invitation_limit` AS t5_r29, `_upd_bies_enquiries`.`invited_by_id` AS t5_r30, `_upd_bies_enquiries`.`invited_by_type` AS t5_r31, `_upd_bies_enquiries`.`mobile` AS t5_r32, `_upd_bies_enquiries`.`gender` AS t5_r33, `_upd_bies_enquiries`.`date_of_birth` AS t5_r34, `_upd_bies_enquiries`.`address` AS t5_r35, `_upd_bies_enquiries`.`skype` AS t5_r36, `_upd_bies_enquiries`.`facebook` AS t5_r37, `_upd_bies_enquiries`.`linkedin` AS t5_r38, `_upd_bies_enquiries`.`twitter` AS t5_r39, `_upd_bies_enquiries`.`website` AS t5_r40, `_upd_bies_enquiries`.`gplus` AS t5_r41, `_upd_bies_enquiries`.`blogger` AS t5_r42, `_upd_bies_enquiries`.`is_active` AS t5_r43 FROM `enquiries` LEFT OUTER JOIN `enquiry_statuses` ON `enquiry_statuses`.`id` = `enquiries`.`status_id` LEFT OUTER JOIN `follow_ups` ON `follow_ups`.`enquiry_id` = `enquiries`.`id` LEFT OUTER JOIN `countries` ON `countries`.`id` = `enquiries`.`country_id` LEFT OUTER JOIN `users` ON `users`.`id` = `enquiries`.`assigned_to` LEFT OUTER JOIN `users` `_upd_bies_enquiries` ON `_upd_bies_enquiries`.`id` = `enquiries`.`updated_by` WHERE `enquiries`.`id` IN (5, 15, 18, 28, 36, 37, 38, 39, 40, 42) AND (enquiry_statuses.name != 'deactivated') ORDER BY enquiries.id asc