questionaire.log 217 KB
SELECT distinct question FROM questionaire_details WHERE cust_id=65194108 and question IN(1021,1319,1053,1056,1057,1058,1322,2462,2515,2505,2498,1328,1329,1330,1051);
SELECT distinct question FROM questionaire_details WHERE cust_id=42658536 and question IN(1021,1319,1056,1058,1327,1322,1325,2485,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=26678147 and question IN(1056,1057,1327,1024,1320,1318,1004,2462,2515,2505,2498,1328,1329,1330,1059);
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:41', updated_at='2018-04-04 07:31:41', user_id='94542',cust_id='43935995',call_id='1495199',name='MASTHAN CHEVUU',number='9043650699',question_time='2018-04-04 07-26-33',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=37603139 and question IN(1015,1016,1319,1053,1056,1327,1024,1320,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1059);
insert into questionaire_details set created_at='2018-04-04 07:31:53', updated_at='2018-04-04 07:31:53', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1015',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:53', updated_at='2018-04-04 07:31:53', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1016',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:53', updated_at='2018-04-04 07:31:53', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:54', updated_at='2018-04-04 07:31:54', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:54', updated_at='2018-04-04 07:31:54', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:54', updated_at='2018-04-04 07:31:54', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='If pre approved eligibility for 10 sec PL is there',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:31:54', updated_at='2018-04-04 07:31:54', user_id='82413',cust_id='34910138',call_id='1495217',name='PRASANNA D',number='9790716061',question_time='2018-04-04 07-29-47',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, you have done transcation at petrol pump using your DC/CC',followup1_response='  Yes',followup1_text='',followup2_question='Instant Loan credit facility ',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=39993154 and question IN(1056,1057,1327,1026,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1050);
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='Dear Sir / Madame, request you to help in letting us know your annual income',followup1_response='  My annual Income is XX lacs',followup1_text='',followup2_question='OK
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='Sir I can See your have not registered for Insta Alerts .',followup1_response='  Yes',followup1_text='',followup2_question='How can I register for Insta Alerts',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, as I can see, you are using a normal CC and there are regular debit in the account',followup1_response='  Yes',followup1_text='',followup2_question='We have an offer of on your credit card',followup2_response='  Yes',followup2_text='',followup3_question='Pls verify you DOB & Mailing address',followup3_response='  Yes',followup3_text='',followup4_question='After positive verification, share eligibilty and explain the benefits, Ask if he would like to go for upgrade',followup4_response='  I don?t want to UG',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='is there any funds Requirement , So that I can help for getting the Loans for you .',followup2_response='  Yes',followup2_text='',followup3_question='No issue , Sir but I request you to bring the Balance to the A/C ',followup3_response='  Yes',followup3_text='',followup4_question='Sir I Would also like to tell you , We can extend Classic Prog Benefits to your Family Members also',followup4_response='  No',followup4_text='',followup5_question='Sir it will make them feel proud like you to avail the classic benefits',followup5_response='  No Not right now',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay
insert into questionaire_details set created_at='2018-04-04 07:32:53', updated_at='2018-04-04 07:32:53', user_id='82238',cust_id='62693891',call_id='1495208',name='RACHANENI ABHILASH',number='9676274466',question_time='2018-04-04 07-27-27',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay
SELECT distinct question FROM questionaire_details WHERE cust_id=37314100 and question IN(1319,1056,1058,1327,1322,1318,1004,2462,2515,2505,2498,1328,1329,1330,1059,1061);
insert into questionaire_details set created_at='2018-04-04 07:33:54', updated_at='2018-04-04 07:33:54', user_id='82343',cust_id='6327650',call_id='1495227',name='T S KANNAN',number='9884060194',question_time='2018-04-04 07-30-51',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:33:55', updated_at='2018-04-04 07:33:55', user_id='82343',cust_id='6327650',call_id='1495227',name='T S KANNAN',number='9884060194',question_time='2018-04-04 07-30-51',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:33:55', updated_at='2018-04-04 07:33:55', user_id='82343',cust_id='6327650',call_id='1495227',name='T S KANNAN',number='9884060194',question_time='2018-04-04 07-30-51',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:33:55', updated_at='2018-04-04 07:33:55', user_id='82343',cust_id='6327650',call_id='1495227',name='T S KANNAN',number='9884060194',question_time='2018-04-04 07-30-51',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='Sir I can See your have not registered for Insta Alerts .',followup1_response='  Yes',followup1_text='',followup2_question='How can I register for Insta Alerts',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1024',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, as I can see, you are using a normal CC',followup1_response='  OK',followup1_text='',followup2_question='We have an offer of on your credit card',followup2_response='  OK',followup2_text='',followup3_question='Pls verify you DOB & Mailing address',followup3_response='  OK',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1320',primary_question='Pitch for Investment- MF, HLIC, Demat Account.',primary_response='  OK',primary_text='',followup1_question='Sir , I can see you got a Good Balance in you?re a/c . Anything Which you are Planning from that money in the Near Future',followup1_response='  No',followup1_text='',followup2_question='',followup2_response='  No',followup2_text='',followup3_question='',followup3_response='  No',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='Sir , I can see your Salary is not getting Credit in the A/C',followup1_response='  No , I have not changed my Company',followup1_text='',followup2_question='Is the Still salary is getting Credit in the a/c',followup2_response='  No , I have not changed my Company',followup2_text='',followup3_question='Sir , Request you to confirm the complete name of your company Name for updating the company Code',followup3_response='  No , I have not changed my Company',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:04', updated_at='2018-04-04 07:34:04', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1326',primary_question='Understadn the reason ',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  No',primary_text='',followup1_question='In todays busy schedule, online bill payment is of great help to save time & penalty on late payment',followup1_response='  No I am not interested now. Will let you know if required',followup1_text='',followup2_question='',followup2_response='  No I am not interested now. Will let you know if required',followup2_text='',followup3_question='',followup3_response='  No I am not interested now. Will let you know if required',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  No',primary_text='',followup1_question='In todays busy schedule, online shopping is of great help to save time and also avail the exciting offers.',followup1_response='  No I am not interested now. Will let you know if required',followup1_text='',followup2_question='Sure Sir, let me know whenever you require any help on same',followup2_response='  No I am not interested now. Will let you know if required',followup2_text='',followup3_question='',followup3_response='  No I am not interested now. Will let you know if required',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  No',primary_text='',followup1_question='Sir this is simple process wherein without visiting branch you can book FD/RD online anytime.',followup1_response='  OK I will book the same',followup1_text='',followup2_question='Sure Sir it is convenient, I can help you to book it now now itself through a simple step by logging into to net banking.',followup2_response='  OK I will book the same',followup2_text='',followup3_question='',followup3_response='  OK I will book the same',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1050',primary_question='Check profiling for TWL / car ownership, Pitch for car loan.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:34:05', updated_at='2018-04-04 07:34:05', user_id='87322',cust_id='56185957',call_id='1495220',name='DANIEL PANNEER SELVAN',number='9841688776',question_time='2018-04-04 07-30-09',question='1061',primary_question='Pitch HL BT & Top Up',primary_response='  OK',primary_text='',followup1_question='Do you have a Personal Loan currently running with competition bank?',followup1_response='  No',followup1_text='',followup2_question='',followup2_response='  No',followup2_text='',followup3_question='',followup3_response='  No',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=37603139 and question IN(1015,1016,1319,1053,1056,1327,1024,1320,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=40106108 and question IN(1056,1058,1327,1026,1322,1318,1004,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=53690995 and question IN(1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1059);
insert into questionaire_details set created_at='2018-04-04 07:39:39', updated_at='2018-04-04 07:39:39', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:39', updated_at='2018-04-04 07:39:39', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=45122212 and question IN(1021,1319,1053,1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330);
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=53690995 and question IN(1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=33345584 and question IN(1056,1057,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330);
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:40', updated_at='2018-04-04 07:39:40', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:39:41', updated_at='2018-04-04 07:39:41', user_id='82332',cust_id='33373527',call_id='1495212',name='MUTHU KUMAR C',number='9884723030',question_time='2018-04-04 07-28-16',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=53690995 and question IN(1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1059);
insert into questionaire_details set created_at='2018-04-04 07:39:59', updated_at='2018-04-04 07:39:59', user_id='95046',cust_id='64060662',call_id='1495259',name='CHINNAMMAL A',number='9894722393',question_time='2018-04-04 07-35-28',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:00', updated_at='2018-04-04 07:40:00', user_id='95046',cust_id='64060662',call_id='1495259',name='CHINNAMMAL A',number='9894722393',question_time='2018-04-04 07-35-28',question='1326',primary_question='Understadn the reason ',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:00', updated_at='2018-04-04 07:40:00', user_id='95046',cust_id='64060662',call_id='1495259',name='CHINNAMMAL A',number='9894722393',question_time='2018-04-04 07-35-28',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=35862858 and question IN(1015,1016,1319,1056,1058,1327,1026,1322,2462,2515,2505,2498,1328,1329,1330,1050,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=45122212 and question IN(1021,1319,1053,1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=61524110 and question IN(1056,1327,1026,1322,2462,2515,2505,2498,1059);
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1016',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Add on card for family members',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:30', updated_at='2018-04-04 07:40:30', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:31', updated_at='2018-04-04 07:40:31', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:31', updated_at='2018-04-04 07:40:31', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:31', updated_at='2018-04-04 07:40:31', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:40:31', updated_at='2018-04-04 07:40:31', user_id='82350',cust_id='37575231',call_id='1495210',name='PETCHIMUTHU M',number='9994253338',question_time='2018-04-04 07-27-59',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:41:01', updated_at='2018-04-04 07:41:01', user_id='90209',cust_id='56327400',call_id='1495233',name='NETHAJI DUVARAKANATHAN',number='9841230332',question_time='2018-04-04 07-32-01',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:41:01', updated_at='2018-04-04 07:41:01', user_id='90209',cust_id='56327400',call_id='1495233',name='NETHAJI DUVARAKANATHAN',number='9841230332',question_time='2018-04-04 07-32-01',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:41:01', updated_at='2018-04-04 07:41:01', user_id='90209',cust_id='56327400',call_id='1495233',name='NETHAJI DUVARAKANATHAN',number='9841230332',question_time='2018-04-04 07-32-01',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:41:01', updated_at='2018-04-04 07:41:01', user_id='90209',cust_id='56327400',call_id='1495233',name='NETHAJI DUVARAKANATHAN',number='9841230332',question_time='2018-04-04 07-32-01',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=59205425 and question IN(1021,1319,1056,1058,1322,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=53690995 and question IN(1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1059);
insert into questionaire_details set created_at='2018-04-04 07:43:37', updated_at='2018-04-04 07:43:37', user_id='82341',cust_id='21026369',call_id='1495118',name='M ELANGOVAN',number='09845680343',question_time='2018-04-04 07-14-18',question='1016',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:43:37', updated_at='2018-04-04 07:43:37', user_id='82341',cust_id='21026369',call_id='1495118',name='M ELANGOVAN',number='09845680343',question_time='2018-04-04 07-14-18',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:43:37', updated_at='2018-04-04 07:43:37', user_id='82341',cust_id='21026369',call_id='1495118',name='M ELANGOVAN',number='09845680343',question_time='2018-04-04 07-14-18',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:43:38', updated_at='2018-04-04 07:43:38', user_id='82341',cust_id='21026369',call_id='1495118',name='M ELANGOVAN',number='09845680343',question_time='2018-04-04 07-14-18',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:43:38', updated_at='2018-04-04 07:43:38', user_id='82341',cust_id='21026369',call_id='1495118',name='M ELANGOVAN',number='09845680343',question_time='2018-04-04 07-14-18',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=57230236 and question IN(1056,1058,1322,2462,2515,2505,2498,1328,1329,1330,1051);
SELECT distinct question FROM questionaire_details WHERE cust_id=42486846 and question IN(1056,1058,1026,1322,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=43539513 and question IN(1056,1057,1058,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330);
insert into questionaire_details set created_at='2018-04-04 07:44:38', updated_at='2018-04-04 07:44:38', user_id='94542',cust_id='37165677',call_id='1495247',name='GUNASEELAN S',number='8608701268',question_time='2018-04-04 07-33-52',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:38', updated_at='2018-04-04 07:44:38', user_id='94542',cust_id='37165677',call_id='1495247',name='GUNASEELAN S',number='8608701268',question_time='2018-04-04 07-33-52',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:38', updated_at='2018-04-04 07:44:38', user_id='94542',cust_id='37165677',call_id='1495247',name='GUNASEELAN S',number='8608701268',question_time='2018-04-04 07-33-52',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:38', updated_at='2018-04-04 07:44:38', user_id='94542',cust_id='37165677',call_id='1495247',name='GUNASEELAN S',number='8608701268',question_time='2018-04-04 07-33-52',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:56', updated_at='2018-04-04 07:44:56', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='Dear Sir / Madame, request you to help in letting us know your annual income',followup1_response='  I am busy now. Call me back later',followup1_text='',followup2_question='Sure Sir, What is the convenience time to call you back',followup2_response='  I am busy now. Call me back later',followup2_text='',followup3_question='',followup3_response='  I am busy now. Call me back later',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:57', updated_at='2018-04-04 07:44:57', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:57', updated_at='2018-04-04 07:44:57', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:57', updated_at='2018-04-04 07:44:57', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  No',primary_text='',followup1_question='Sir this is simple process wherein without visiting branch you can book FD/RD online anytime.',followup1_response='  OK I will book the same',followup1_text='',followup2_question='Sure Sir it is convenient, I can help you to book it now now itself through a simple step by logging into to net banking.',followup2_response='  OK I will book the same',followup2_text='',followup3_question='',followup3_response='  OK I will book the same',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:57', updated_at='2018-04-04 07:44:57', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:44:57', updated_at='2018-04-04 07:44:57', user_id='87322',cust_id='26141632',call_id='1495266',name='BASKARAN R',number='8903426954',question_time='2018-04-04 07-36-11',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:46:27', updated_at='2018-04-04 07:46:27', user_id='93738',cust_id='61037990',call_id='1495327',name='SIVA KUMAR E',number='9940332755',question_time='2018-04-04 07-43-42',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:46:27', updated_at='2018-04-04 07:46:27', user_id='93738',cust_id='61037990',call_id='1495327',name='SIVA KUMAR E',number='9940332755',question_time='2018-04-04 07-43-42',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, you have done transcation at petrol pump using your DC/CC',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:46:27', user_id='93738',cust_id='61037990',call_id='1495327',name='SIVA KUMAR E',number='9940332755',question_time='2018-04-04 07-43-42',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495327' and question='1057' and cust_id='61037990';
update questionaire_details set updated_at='2018-04-04 07:46:28', user_id='93738',cust_id='61037990',call_id='1495327',name='SIVA KUMAR E',number='9940332755',question_time='2018-04-04 07-43-42',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, you have done transcation at petrol pump using your DC/CC',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495327' and question='1051' and cust_id='61037990';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see you are not holding the HDFC Bank Credit Card',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='Sir , You are Eligible for LTF Card , I just Need Pan Card & Signature In the Application , When Can Send the Excutive to your Place',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='Sir I can See your have not registered for Insta Alerts .',followup1_response='  Yes',followup1_text='',followup2_question='How can I register for Insta Alerts',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='is there any funds Requirement , So that I can help for getting the Loans for you .',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='We have special offers attached for using our Bill pay option. Extra reward points are available if you can register for Smart pay online',followup1_response='  Does it support all operating systems & is it safe',followup1_text='',followup2_question='Sure Sir, I can help you to register now itself through a simple step by logging into to net banking',followup2_response='  Does it support all operating systems & is it safe',followup2_text='',followup3_question='Sure Sir, I will call & confirm with you on same.',followup3_response='  Does it support all operating systems & is it safe',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  No',primary_text='',followup1_question='Sir this is simple process wherein without visiting branch you can book FD/RD online anytime.',followup1_response='  OK I will book the same',followup1_text='',followup2_question='',followup2_response='  OK I will book the same',followup2_text='',followup3_question='',followup3_response='  OK I will book the same',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sure Sir it is convenient, I can help you to book it now now itself through a simple step by logging into to net banking.',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:17', updated_at='2018-04-04 07:47:17', user_id='82414',cust_id='46808112',call_id='1495270',name='SUKANYA V',number='9176383660',question_time='2018-04-04 07-36-39',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:36', updated_at='2018-04-04 07:47:36', user_id='82347',cust_id='27771122',call_id='1495325',name='DIVYA SAMPATH',number='9941561563',question_time='2018-04-04 07-43-37',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:37', updated_at='2018-04-04 07:47:37', user_id='82347',cust_id='27771122',call_id='1495325',name='DIVYA SAMPATH',number='9941561563',question_time='2018-04-04 07-43-37',question='1024',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, as I can see, you are using a normal CC',followup1_response='  OK',followup1_text='',followup2_question='',followup2_response='  OK',followup2_text='',followup3_question='',followup3_response='  OK',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:37', updated_at='2018-04-04 07:47:37', user_id='82347',cust_id='27771122',call_id='1495325',name='DIVYA SAMPATH',number='9941561563',question_time='2018-04-04 07-43-37',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:48', updated_at='2018-04-04 07:47:48', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:48', updated_at='2018-04-04 07:47:48', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:47:48', updated_at='2018-04-04 07:47:48', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:48', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1021' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:48', updated_at='2018-04-04 07:47:48', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1056' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:49', updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1322' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:49', updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1325' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:49', updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:49', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='2485' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='2462' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='2515' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='2505' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='2498' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1328' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:47:50', updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1061',primary_question='Pitch HL BT & Top Up',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1329' and cust_id='39890233';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1059' and cust_id='39890233';
update questionaire_details set updated_at='2018-04-04 07:47:50', user_id='93740',cust_id='39890233',call_id='1495157',name='ADITHYA A',number='9901158321',question_time='2018-04-04 07-19-43',question='1061',primary_question='Pitch HL BT & Top Up',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495157' and question='1061' and cust_id='39890233';
insert into questionaire_details set created_at='2018-04-04 07:48:35', updated_at='2018-04-04 07:48:35', user_id='82346',cust_id='63030147',call_id='1495284',name='ASWANTH P',number='9894838289',question_time='2018-04-04 07-39-08',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:35', updated_at='2018-04-04 07:48:35', user_id='82346',cust_id='63030147',call_id='1495284',name='ASWANTH P',number='9894838289',question_time='2018-04-04 07-39-08',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:35', updated_at='2018-04-04 07:48:35', user_id='82346',cust_id='63030147',call_id='1495284',name='ASWANTH P',number='9894838289',question_time='2018-04-04 07-39-08',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:37', updated_at='2018-04-04 07:48:37', user_id='95046',cust_id='41939399',call_id='1495336',name='D VENUGOPAL',number='8939166297',question_time='2018-04-04 07-44-37',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:37', updated_at='2018-04-04 07:48:37', user_id='95046',cust_id='41939399',call_id='1495336',name='D VENUGOPAL',number='8939166297',question_time='2018-04-04 07-44-37',question='1024',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:37', updated_at='2018-04-04 07:48:37', user_id='95046',cust_id='41939399',call_id='1495336',name='D VENUGOPAL',number='8939166297',question_time='2018-04-04 07-44-37',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=38116640 and question IN(1319,1056,1322,2462,2515,2505,2498,1328,1329,1330,1061);
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see you are not holding the HDFC Bank Credit Card',followup1_response='  Yes , But Currently I cant Speak to you  now Call me later',followup1_text='',followup2_question='',followup2_response='  Yes , But Currently I cant Speak to you  now Call me later',followup2_text='',followup3_question='',followup3_response='  Yes , But Currently I cant Speak to you  now Call me later',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='Dear Sir / Madame, request you to help in letting us know your annual income',followup1_response='  I am busy now. Call me back later',followup1_text='',followup2_question='',followup2_response='  I am busy now. Call me back later',followup2_text='',followup3_question='',followup3_response='  I am busy now. Call me back later',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:48:57', updated_at='2018-04-04 07:48:57', user_id='82387',cust_id='57054302',call_id='1495341',name='NANCY S',number='8056610744',question_time='2018-04-04 07-45-31',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:49:20', updated_at='2018-04-04 07:49:20', user_id='90938',cust_id='41474873',call_id='1495310',name='MOHAMMADA ASHRAPHA',number='9743410885',question_time='2018-04-04 07-42-14',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:49:20', updated_at='2018-04-04 07:49:20', user_id='90938',cust_id='41474873',call_id='1495310',name='MOHAMMADA ASHRAPHA',number='9743410885',question_time='2018-04-04 07-42-14',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:49:20', updated_at='2018-04-04 07:49:20', user_id='90938',cust_id='41474873',call_id='1495310',name='MOHAMMADA ASHRAPHA',number='9743410885',question_time='2018-04-04 07-42-14',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:49:21', updated_at='2018-04-04 07:49:21', user_id='90938',cust_id='41474873',call_id='1495310',name='MOHAMMADA ASHRAPHA',number='9743410885',question_time='2018-04-04 07-42-14',question='1050',primary_question='Check profiling for TWL / car ownership, Pitch for car loan.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
select `call_id`, `question` from `questionaire_details` where `cust_id` = '36244417' and `call_id` = '1495317' and `question` = '2462' limit 1;
insert into questionaire_details set created_at='2018-04-04 07:50:12', updated_at='2018-04-04 07:50:12', user_id='82240',cust_id='36244417',call_id='1495317',name='SRIDHAR SADASIVAM',number='9686809111',question_time='2018-04-04 07-42-48',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:50:12', updated_at='2018-04-04 07:50:12', user_id='82240',cust_id='36244417',call_id='1495317',name='SRIDHAR SADASIVAM',number='9686809111',question_time='2018-04-04 07-42-48',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='Sir additionally you can avail of special offers & discounts available for online shopping including cash backs, & higher reward points',followup1_response='  Let me know of the offers available',followup1_text='',followup2_question='',followup2_response='  Let me know of the offers available',followup2_text='',followup3_question='',followup3_response='  Let me know of the offers available',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:50:12', updated_at='2018-04-04 07:50:12', user_id='82240',cust_id='36244417',call_id='1495317',name='SRIDHAR SADASIVAM',number='9686809111',question_time='2018-04-04 07-42-48',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='Thank You Sir, You can also earn higher interest by investing online in FD/RD.',followup1_response='  Ok I will book the same',followup1_text='',followup2_question='Sure Sir it is convenient and safe. You can make payment online for shopping , buying grocery, book tickets, pay utility bills etc.',followup2_response='  Ok I will book the same',followup2_text='',followup3_question='',followup3_response='  Ok I will book the same',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=37697914 and question IN(1056,1058,1327,1026,1322,2462,2515,2505,2498,1051);
SELECT distinct question FROM questionaire_details WHERE cust_id=44008506 and question IN(1056,1058,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1051);
SELECT distinct question FROM questionaire_details WHERE cust_id=62038274 and question IN(1319,1053,1056,1058,1322,1325,1326,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=36778367 and question IN(1056,1026,1322,1325,1326,2462,2515,2505,2498,1328,1329,1330,1050);
insert into questionaire_details set created_at='2018-04-04 07:51:40', updated_at='2018-04-04 07:51:40', user_id='82238',cust_id='41471561',call_id='1495364',name='RAVI BANOTH',number='9663650335',question_time='2018-04-04 07-50-01',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='is there any funds Requirement , So that I can help for getting the Loans for you .',followup2_response='  Yes',followup2_text='',followup3_question='No issue , Sir but I request you to bring the Balance to the A/C ',followup3_response='  Yes',followup3_text='',followup4_question='Sir I Would also like to tell you , We can extend Classic Prog Benefits to your Family Members also',followup4_response='  No',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:51:40', updated_at='2018-04-04 07:51:40', user_id='82238',cust_id='41471561',call_id='1495364',name='RAVI BANOTH',number='9663650335',question_time='2018-04-04 07-50-01',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay
insert into questionaire_details set created_at='2018-04-04 07:51:40', updated_at='2018-04-04 07:51:40', user_id='82238',cust_id='41471561',call_id='1495364',name='RAVI BANOTH',number='9663650335',question_time='2018-04-04 07-50-01',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1024',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1320',primary_question='Pitch for Investment- MF, HLIC, Demat Account.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:12', updated_at='2018-04-04 07:52:12', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:13', updated_at='2018-04-04 07:52:13', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:13', updated_at='2018-04-04 07:52:13', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:13', updated_at='2018-04-04 07:52:13', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:13', updated_at='2018-04-04 07:52:13', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:13', updated_at='2018-04-04 07:52:13', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:14', updated_at='2018-04-04 07:52:14', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1050',primary_question='Check profiling for TWL / car ownership, Pitch for car loan.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:14', updated_at='2018-04-04 07:52:14', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:52:14', updated_at='2018-04-04 07:52:14', user_id='82332',cust_id='51316216',call_id='1495289',name='SMATHEEJ C',number='9884930926',question_time='2018-04-04 07-40-09',question='1061',primary_question='Pitch HL BT & Top Up',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=35862858 and question IN(1015,1016,1319,1056,1058,1327,1026,1322,2462,2515,2505,2498,1328,1329,1330,1050,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=39666038 and question IN(1015,1016,1319,1056,1058,1327,1024,1320,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=55630505 and question IN(1056,1057,1058,1327,1320,1318,1004,2462,2515,2505,2498,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=3282768 and question IN(1056,1057,1058,1327,1322,1325,1326,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=51411615 and question IN(1015,1016,1319,1056,1057,1058,1327,1024,1320,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=59406180 and question IN(1056,1057,1058,1327,1026,1322,2462,2515,2505,2498,1328,1329,1330,1051,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=9887653 and question IN(1056,1057,1327,1026,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330);
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='Dear Sir / Madame, request you to help in letting us know your annual income',followup1_response='  I am busy now. Call me back later',followup1_text='',followup2_question='Sure Sir, What is the convenience time to call you back',followup2_response='  I am busy now. Call me back later',followup2_text='',followup3_question='',followup3_response='  I am busy now. Call me back later',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='Sir I can See your have not registered for Insta Alerts .',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, as I can see, you are using a normal CC and there are regular debit in the account',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='is there any funds Requirement , So that I can help for getting the Loans for you .',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  No',primary_text='',followup1_question='In todays busy schedule, online bill payment is of great help to save time & penalty on late payment',followup1_response='  No I am not interested now. Will let you know if required',followup1_text='',followup2_question='',followup2_response='  No I am not interested now. Will let you know if required',followup2_text='',followup3_question='',followup3_response='  No I am not interested now. Will let you know if required',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:20', updated_at='2018-04-04 07:57:20', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:21', updated_at='2018-04-04 07:57:21', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  No',primary_text='',followup1_question='Sir this is simple process wherein without visiting branch you can book FD/RD online anytime.',followup1_response='  OK I will book the same',followup1_text='',followup2_question='Sure Sir it is convenient, I can help you to book it now now itself through a simple step by logging into to net banking.',followup2_response='  OK I will book the same',followup2_text='',followup3_question='',followup3_response='  OK I will book the same',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:21', updated_at='2018-04-04 07:57:21', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  No',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:21', updated_at='2018-04-04 07:57:21', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:57:21', updated_at='2018-04-04 07:57:21', user_id='87322',cust_id='50215821',call_id='1495403',name='RAJKUMAR S',number='7845035737',question_time='2018-04-04 07-54-07',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:12', updated_at='2018-04-04 07:58:12', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1050',primary_question='Check profiling for TWL / car ownership, Pitch for car loan.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:12', updated_at='2018-04-04 07:58:12', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:12', updated_at='2018-04-04 07:58:12', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:12', updated_at='2018-04-04 07:58:12', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:12', updated_at='2018-04-04 07:58:12', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1004',primary_question='Book TD through NB/MB',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1318',primary_question='Get activated on netbanking',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1326',primary_question='Understadn the reason ',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1320',primary_question='Pitch for Investment- MF, HLIC, Demat Account.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:13', updated_at='2018-04-04 07:58:13', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1024',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:14', updated_at='2018-04-04 07:58:14', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:14', updated_at='2018-04-04 07:58:14', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:14', updated_at='2018-04-04 07:58:14', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1016',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:14', updated_at='2018-04-04 07:58:14', user_id='82243',cust_id='52236694',call_id='1495332',name='SANIDHYA RASIWASIA',number='9176722478',question_time='2018-04-04 07-44-10',question='1015',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:17', updated_at='2018-04-04 07:58:17', user_id='95046',cust_id='40950405',call_id='1495406',name='D LATCHATHIPATHI',number='7299102707',question_time='2018-04-04 07-54-44',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:32', updated_at='2018-04-04 07:58:32', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:32', updated_at='2018-04-04 07:58:32', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:32', updated_at='2018-04-04 07:58:32', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:32', updated_at='2018-04-04 07:58:32', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:33', updated_at='2018-04-04 07:58:33', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:58:33', updated_at='2018-04-04 07:58:33', user_id='82341',cust_id='56369342',call_id='1495419',name='ABIRAMI G',number='9790976119',question_time='2018-04-04 07-56-55',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=38534236 and question IN(1319,1056,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=35472577 and question IN(1015,1016,1319,1056,1327,1026,1322,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=3282768 and question IN(1056,1057,1058,1327,1322,1325,1326,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=25386230 and question IN(1015,1016,1319,1056,1057,1058,1026,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=20061703 and question IN(1056,1057,1058,1327,1320,1318,1004,2462,2515,2505,2498,1328,1329,1330,1051,1059);
insert into questionaire_details set created_at='2018-04-04 07:59:47', updated_at='2018-04-04 07:59:47', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1015',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:47', updated_at='2018-04-04 07:59:47', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1016',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1053',primary_question='Update Aadhaar No through NB/MB, SMS Banking, Phone Banking, ATM, Branch visit.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:48', updated_at='2018-04-04 07:59:48', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:49', updated_at='2018-04-04 07:59:49', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:49', updated_at='2018-04-04 07:59:49', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:49', updated_at='2018-04-04 07:59:49', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:49', updated_at='2018-04-04 07:59:49', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 07:59:49', updated_at='2018-04-04 07:59:49', user_id='82332',cust_id='41849512',call_id='1495413',name='SATHIYAMURTHY R',number='8939992782',question_time='2018-04-04 07-55-11',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=41882723 and question IN(1021,1319,1056,1057,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1051,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=55358660 and question IN(1021,1319,1056,1058,1327,1320,1325,2485,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=61524110 and question IN(1056,1327,1026,1322,2462,2515,2505,2498,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=20161706 and question IN(1056,1057,1327,1320,2462,2515,2505,2498,1328,1329,1330,1051,1059,1060);
SELECT distinct question FROM questionaire_details WHERE cust_id=25386230 and question IN(1015,1016,1319,1056,1057,1058,1026,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=58451301 and question IN(1056,1057,1058,1327,1024,1320,2462,2515,2505,2498,1328,1329,1330,1051,1059);
insert into questionaire_details set created_at='2018-04-04 08:04:30', updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495423' and question='1056' and cust_id='20866034';
insert into questionaire_details set created_at='2018-04-04 08:04:30', updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495423' and question='1059' and cust_id='20866034';
insert into questionaire_details set created_at='2018-04-04 08:04:30', updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1051',primary_question='Check profiling for TWL / car ownership, Pitch for car loan- resh or CNC, update profiler with car details.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495423' and question='1051' and cust_id='20866034';
insert into questionaire_details set created_at='2018-04-04 08:04:30', updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
update questionaire_details set updated_at='2018-04-04 08:04:30', user_id='82346',cust_id='20866034',call_id='1495423',name='SANTHANA KRISHNAN VENKATRAMAN',number='9739745150',question_time='2018-04-04 07-57-23',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='' where call_id='1495423' and question='1329' and cust_id='20866034';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='Sir , I can see your Salary is not getting Credit in the A/C',followup1_response='  No , I have not changed my Company',followup1_text='',followup2_question='',followup2_response='  No , I have not changed my Company',followup2_text='',followup3_question='',followup3_response='  No , I have not changed my Company',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1326',primary_question='Understadn the reason ',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='2485',primary_question='Sir, we can see that salary is not getting credited in your salary account. Have you changed the employer or changed salary account with other bank',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:04:59', updated_at='2018-04-04 08:04:59', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:00', updated_at='2018-04-04 08:05:00', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='Sir additionally you can avail of special offers & discounts available for online shopping including cash backs, & higher reward points',followup1_response='  Let me know of the offers available',followup1_text='',followup2_question='',followup2_response='  Let me know of the offers available',followup2_text='',followup3_question='',followup3_response='  Let me know of the offers available',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:00', updated_at='2018-04-04 08:05:00', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:00', updated_at='2018-04-04 08:05:00', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:00', updated_at='2018-04-04 08:05:00', user_id='87155',cust_id='43539513',call_id='1495439',name='SYED HAFIZUDDIN',number='9094908019',question_time='2018-04-04 07-59-53',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=24577497 and question IN(1021,1319,1052,1056,1327,1322,1325,2485,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=41882723 and question IN(1021,1319,1056,1057,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1051,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=1277484 and question IN(1056,1058,1327,1322,2462,2515,2505,2498,1328,1329,1330,1051,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=61524110 and question IN(1056,1327,1026,1322,2462,2515,2505,2498,1059);
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1059',primary_question='Pitch 10 Sec loan through NB and other loan through DAP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='2498',primary_question='Sir, You are not using Net Banking/Mobile App as most convenient mode of doing  Banking transaction. I Can help You to register and use the same now.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='2505',primary_question='Sir, Thank You for using Net Banking/Mobile App for financial transaction. I Can help You to invest by booking FD/RD Online at ease.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='2515',primary_question='Sir, Thank You for using Net Banking/Mobile App for banking, I Can help You to to use the same for online shopping.',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='2462',primary_question='Sir, Thank You for using net banking/mobile app for financial transaction. Can I help You to register for your utility bill payments. ',primary_response='  Yes',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:49', updated_at='2018-04-04 08:05:49', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1325',primary_question='Check for reason, if new organisation, update the same in COCO link,  pitch CC Payment through NetBanking, PA products, Term Products, BP/SP, increase CTG,',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1057',primary_question='Take details / reconfirm updated profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1056',primary_question='Take details of pending profiler',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1053',primary_question='Update Aadhaar No through NB/MB, SMS Banking, Phone Banking, ATM, Branch visit.',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:05:50', updated_at='2018-04-04 08:05:50', user_id='82243',cust_id='51995086',call_id='1495471',name='SHANMUGASUNDARAM M',number='9840262414',question_time='2018-04-04 08-03-45',question='1021',primary_question='Understand the current CC customer is using and the benefits he is enjoying in the same, Pitch SPC.',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see you are not holding the HDFC Bank Credit Card',followup1_response='  Yes',followup1_text='',followup2_question='',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
SELECT distinct question FROM questionaire_details WHERE cust_id=7726409 and question IN(1015,1016,1319,1053,1056,1057,1327,1325,1326,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=53621490 and question IN(1021,1319,1056,1058,1327,1320,2462,2515,2505,2498,1328,1329,1330);
SELECT distinct question FROM questionaire_details WHERE cust_id=40796297 and question IN(1015,1016,1319,1056,1057,1058,1026,1322,2462,2515,2505,2498,1328,1329,1330,1059);
SELECT distinct question FROM questionaire_details WHERE cust_id=44008506 and question IN(1056,1058,1322,1325,1326,2485,2462,2515,2505,2498,1328,1329,1330,1051);
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82238',cust_id='50128910',call_id='1495492',name='S SELVARAJ',number='9600013063',question_time='2018-04-04 08-06-18',question='1058',primary_question='Register for Insta Alert through NB, Branch.',primary_response='  OK',primary_text='',followup1_question='Sir I can See your have not registered for Insta Alerts .',followup1_response='  Yes',followup1_text='',followup2_question='How can I register for Insta Alerts',followup2_response='  Yes',followup2_text='',followup3_question='',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82238',cust_id='50128910',call_id='1495492',name='S SELVARAJ',number='9600013063',question_time='2018-04-04 08-06-18',question='1026',primary_question='Pitch SPC, Reiterate Card Benefits',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, as I can see, you are using a normal CC and there are regular debit in the account',followup1_response='  Yes',followup1_text='',followup2_question='We have an offer of on your credit card',followup2_response='  Yes',followup2_text='',followup3_question='Pls verify you DOB & Mailing address',followup3_response='  Yes',followup3_text='',followup4_question='After positive verification, share eligibilty and explain the benefits, Ask if he would like to go for upgrade',followup4_response='  I don?t want to UG',followup4_text='',followup5_question='Thank You',followup5_response='  OK',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82238',cust_id='50128910',call_id='1495492',name='S SELVARAJ',number='9600013063',question_time='2018-04-04 08-06-18',question='1322',primary_question='Understand reason for Depletion, Ask for money, add CTG',primary_response='  OK',primary_text='',followup1_question='Sir , I Can see there is not much balance in you?re A/c , Compare to earlier ',followup1_response='  Yes',followup1_text='',followup2_question='is there any funds Requirement , So that I can help for getting the Loans for you .',followup2_response='  Yes',followup2_text='',followup3_question='No issue , Sir but I request you to bring the Balance to the A/C ',followup3_response='  Yes',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82387',cust_id='40526801',call_id='1495512',name='MANIMARAN V',number='9962245275',question_time='2018-04-04 08-08-16',question='1326',primary_question='Understadn the reason ',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82238',cust_id='50128910',call_id='1495492',name='S SELVARAJ',number='9600013063',question_time='2018-04-04 08-06-18',question='1328',primary_question='Identify SP/BP opportunity through flexcube statement, CBCI transaction and Register SP/BP',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82387',cust_id='40526801',call_id='1495512',name='MANIMARAN V',number='9962245275',question_time='2018-04-04 08-08-16',question='1318',primary_question='Get activated on netbanking',primary_response='  OK',primary_text='',followup1_question='',followup1_response='',followup1_text='',followup2_question='',followup2_response='',followup2_text='',followup3_question='',followup3_response='',followup3_text='',followup4_question='',followup4_response='',followup4_text='',followup5_question='',followup5_response='',followup5_text='',followup6_question='',followup6_response='',followup6_text='',followup7_question='',followup7_response='',followup7_text='';
insert into questionaire_details set created_at='2018-04-04 08:09:48', updated_at='2018-04-04 08:09:48', user_id='82238',cust_id='50128910',call_id='1495492',name='S SELVARAJ',number='9600013063',question_time='2018-04-04 08-06-18',question='1329',primary_question='Register BP through NB/MB, ATM.',primary_response='  OK',primary_text='',followup1_question='Mr / Ms XXX, I have observed that you pay you utility bill using NEFT/CC, manually every month',followup1_response='  Yes',followup1_text='',followup2_question='Sir, why don?t you register for smart pay