update experiment_analytics set variant='new_pharma' where device_id in ('da041972b6eb3af3','fec525834d61c2af','308a87296febc84f','ad25a4651e5c66b9','1898b44533ad43c6','46314236e0340ad7','9a2176c1e6c7d9bf','5b81642dc1ed4bfe','d8f6386320d02a0a','4c52ffd952a4e184','35ffa32aefd38531','d40e91368466a6','d7a832fb6daf1c5b','757574d480997e85','70b177f5826c096d','fbd6f8277247f9a6','1db33575b98995b4','6a2381f243f91326','c6da9e747108fa3','36aea866a10b09d2','3a6471ab26ddbf87','10175268eb9e7db9','5419f66ffe8e364c','ankit.nargotra@1mg.com','bb5f3bebce09c1','9796b66a81780638','2bc64ee010e23f6d','angadtal@gmail.com','3c94f782b8fb0e64','5E98B5FA-A8FD-4F4F-88D4-61DEFFC4B7E1','C4394464-3EC2-4B64-BC8F-5ABF20CF105F','073F63B3-9FD2-438D-A20D-4039C35EE8D3','664a11f83fab609e');

insert into experiment_analytics (device_id, user_id, experiment_name, variant, frequency, created, updated) values ('da041972b6eb3af3', 'vikas.kjs@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388129', '2016-04-20 11:37:06.388156'),('fec525834d61c2af', 'vikas.kjs@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388166', '2016-04-20 11:37:06.388170'),('308a87296febc84f', 'ankit.nargotra@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388175', '2016-04-20 11:37:06.388179'),('ad25a4651e5c66b9', 'prachi.jain@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388184', '2016-04-20 11:37:06.388187'),('1898b44533ad43c6', 'dkpal86@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388192', '2016-04-20 11:37:06.388196'),('1db33575b98995b4', 'gurpreet.kp08@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388202', '2016-04-20 11:37:06.388205'),('10175268eb9e7db9', 'vicky.kumar@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388210', '2016-04-20 11:37:06.388214'),('ankit.nargotra@1mg.com', 'ankit.nargotra@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388219', '2016-04-20 11:37:06.388222'),('9796b66a81780638', 'mridu.mehta@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388227', '2016-04-20 11:37:06.388231'),('2bc64ee010e23f6d', 'shatyajeet@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388236', '2016-04-20 11:37:06.388240'),('angadtal@gmail.com', 'angadtal@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388245', '2016-04-20 11:37:06.388248'),('5E98B5FA-A8FD-4F4F-88D4-61DEFFC4B7E1', 'angadtal@gmail.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388253', '2016-04-20 11:37:06.388257'),('C4394464-3EC2-4B64-BC8F-5ABF20CF105F', 'suruchi.chawla@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388262', '2016-04-20 11:37:06.388265'),('073F63B3-9FD2-438D-A20D-4039C35EE8D3', 'ankit.nargotra@1mg.com', 'search', 'new_pharma', 0, '2016-04-20 11:37:06.388275', '2016-04-20 11:37:06.388279');



insert into experiment_analytics (device_id, user_id, experiment_name, variant, frequency, created, updated) values ('da041972b6eb3af3', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.052899', '2016-04-20 11:16:20.052941'),('fec525834d61c2af', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.052957', '2016-04-20 11:16:20.052964'),('308a87296febc84f', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.052972', '2016-04-20 11:16:20.052978'),('ad25a4651e5c66b9', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.052987', '2016-04-20 11:16:20.052993'),('1898b44533ad43c6', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053001', '2016-04-20 11:16:20.053007'),('46314236e0340ad7', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053017', '2016-04-20 11:16:20.053023'),('5b81642dc1ed4bfe', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053045', '2016-04-20 11:16:20.053051'),('4c52ffd952a4e184', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053073', '2016-04-20 11:16:20.053079'),('35ffa32aefd38531', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053087', '2016-04-20 11:16:20.053093'),('d40e91368466a6', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053101', '2016-04-20 11:16:20.053107'),('d7a832fb6daf1c5b', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053115', '2016-04-20 11:16:20.053121'),('70b177f5826c096d', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053150', '2016-04-20 11:16:20.053156'),('1db33575b98995b4', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053178', '2016-04-20 11:16:20.053184'),('6a2381f243f91326', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053193', '2016-04-20 11:16:20.053199'),('c6da9e747108fa3', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053207', '2016-04-20 11:16:20.053213'),('36aea866a10b09d2', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053220', '2016-04-20 11:16:20.053226'),('10175268eb9e7db9', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053248', '2016-04-20 11:16:20.053254'),('5419f66ffe8e364c', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053262', '2016-04-20 11:16:20.053268'),('ankit.nargotra@1mg.com', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053276', '2016-04-20 11:16:20.053281'),('bb5f3bebce09c1', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053289', '2016-04-20 11:16:20.053295'),('9796b66a81780638', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053303', '2016-04-20 11:16:20.053309'),('angadtal@gmail.com', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053331', '2016-04-20 11:16:20.053337'),('3c94f782b8fb0e64', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053345', '2016-04-20 11:16:20.053351'),('5E98B5FA-A8FD-4F4F-88D4-61DEFFC4B7E1', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053359', '2016-04-20 11:16:20.053365'),('C4394464-3EC2-4B64-BC8F-5ABF20CF105F', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053373', '2016-04-20 11:16:20.053379'),('073F63B3-9FD2-438D-A20D-4039C35EE8D3', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053386', '2016-04-20 11:16:20.053392'),('664a11f83fab609e', '', 'search', 'new_pharma', 0, '2016-04-20 11:16:20.053400', '2016-04-20 11:16:20.053406');