questionaire.log
217 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
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