Untitled

select uid,

       action,

       sessionNumber,

       addJson,

       ts,

       JSONExtractInt(addJson, 'timestamp') as timestamp,

       appVersion

from stat.funnelTrack

where dt >= now()::date - 30

AND uid in ('uid', 'jckyuc258b', '6yrvg7z51i', 'o979a8zvqw', 'bsb5v89ind', '1d154vwpxg', '5vh0mmvcri', 'vdeozjx0nl', 'etxeg89l50', '0tvwo150z8', '9x0yprnmhg', 'fr36n7w43j', 'knlwmcgf76', 'h11uphnfia', 'l0wc9wyguy', 'bnir6ukgei', 's57q11rwdi', 'c1d4favjm3', 'kin2yb50fr', 'hbqq9ipx7w', 'z5ivyfpfx9', 'lrqhuhrsik', 'mgeoej6pwy', 'utoahtwx98', 'yrwda99whz', 'cy8yepmwxu', 'ufekuo0d9m', 'o5kz2e7d0v', '07idbhu10b', 'npd3yssfex', 'or1dur0x4a', 'fpz7hlljko', 'a73rb9647h', '49p7vw8rtg', 'psptde4kds', 'ayt4m4q968', 'lgn5knh8f4', 'ow8b8xzkug', 'aq561puiam', 'qewovd4a6a', '2ebp3u5nsc', 'olcdr7wzei', 'ondisu9m5k', 'k4tjummusy', 'qlritkfelz', 'msrfi9o52b', 'znqwf3p853', '0vwksm3wk0', 'vfjxnkuhlw', 'xhi3w0z4gg', 'bzhjxrvrvu', 'p0qzidww6v', 'umn8eiai4a', 'd9v0tint2t', 'sixfuir24c', 'wdw1x2pqiy', '0gz33a246t', 'og8rur1zym', '3pmuf7kf3h', 'hdz0xlmasg', 'q583cramue', 'ai8gx6dmye', 'x031lt7pii', '6wj4m1zte3', 'dbn9akhd3x', 'nbxhxoui1g', '050nsjoz4l', 'ase0he464v', '42k3ucixkb', '7fg3n9zpxs', '9co2vj1s3z', 'syaylxcfwp', '500ulp0oq4', 'ptzk0etlls', 'n90gvyehwj', 'rjopv44sa5', 'zpe1hmso5p', 'yo5hubs1sx', 'dqife05xkp', 'jclw0vyk9f', 'ezbtnnyem2', 'dlyqvqbwj9', '62pr0t5z2m', '6amv167etw', '17guj9jaju', 'gbiobirxvp', '6xnehjrfw6', '6v03plxx3a', 'e9acpu1er9', 'q4hvqd0lrl', 'oll5739ikt', 'o72z7s6uwg', 'no57ws6mls', 'g97ozelk13', 'g2ky5ydmvr', '6rcntdm3qg', 'ujtlpzgf79', 'k464tnshzo', 'ay7lyjexpb', 'ljh32e8um8', 'ysh0xvstxj', '4vq5yksveq', 'bb1vthhc7k', '5wbtprl2th', '7gq18xrdc1', 'ckmx5dgdsu', 'n4pjvhy6j4', 'sm3oddzw7a', '3j0xzlh2tq', '6denppfmer', 'r7rs8km9ut', 'b83y6jiqma', 'ueob4d66sf', '3b3uip2xrm', '9p2k2ynhws', 'pqbsv95bqw', 'z8y4glepqy', 'p8u8fed7bv', '3blyk6sxqm', 'oakqn2cohf', 'kjzsnhdge3', 'qbcvoag07q', '6d90zqxi9m', '1z38m47cni', 'w1yl1d48br', '76jwxex2en', 'qkosj5bxow', 'cqb5pk2u9i', 'e0so5z1g5b', '3vezyo0kvd', '4713pyy15t', 'co804t6exl', 'stzcft9a9y', 'ehiom6tjk0', 'qph61ytx5m', '9xhez9ek3o', 'bona1o1ujw', 'i6kxrj321m', 'uzut9hg3mu', 'irpdi5bavt', 'h016w7gp5d', 'r1w4jvb9tx', 'cvoq2e116p', '4hiz2wfj7o', '4r0huj0ae8', 'miul6t1d4x', 'gc9zxlyru5', 'a3rbbilywq', 'zi21o3no5b', 'eiybif8o6o', 'k3me8doxng', 'mrdalddgy6', '1hsus7ot10', '4212xu5i51', '8s8d4oty3w', 'ricvwkzzu9', 'ny2nvotrm3', '68ln6uklnf', '3kjdgt0yfn', '4uz5twuqnj', 'vwz3brocyk', 'utcwv5xufn', 'sn2vz5osw8', '9arqnipctl', 'fvl25lpmcz', 'jny54zov2f', '0jv7ketgex', 'e6j7q97m70', 'f12vv37iv5', 'eitvbya2p2', 'zi34nuq9sk', 'd9ykq2szw4', 'z8x8hylocm', 'l98d0fgvaf', 'jmz4nggoik', 'oeqvoa87hp', '5tjwereux0', 'k4v8j38hqh', 'vd4nfzahvm', '0j95oyggem', '767nra0fau', 'r7fzntef0e', 'jllikwv9to', 'ydnumjtfq1', 'ij0ij2z9ub', 'x4zequxgo1', '1pgsbn4g2d', 'w95q2yxo7m', 'b7kyx1e2yv', '8kz5vjc212', 'uqu5jlf5fw', 'ze3a3l1scm', 'myli4j9ufs', 'nbym9zxpiu', 'alwb5ccfta', 'oq72wwwwbq', '6m978mg9v5', 'ps9vjcziw3', 'qt3l4vqdm2', '0i8msnxsuu', 'gkddf60ox7', 'sj5ygx46i3', '9jgjrbnqgl', 'izg61j3930', '39vvgagthj', 'vu4lv2u9xz', 'nkwnf3zqzk', 'n1e9wkdjf9', '9vhgz4co1x', 'm6xpg9henj', 'xa4l0uvz7n', 'nyn4ghznfs', 'hn6zgljykz', 'shl66j8z4g', 'jagdzlqi3n', 'a4gydijici', 'bz74nlxstr', 's8gqxjt1ix', 'kcbgh2sg3m', 'ekt1fyzqqe', '7xi861bmmq', 'lvb10289xu', 'e0t1e59c9w', 'rn0nkhelk7', 'ia43vhk4wa', 'lyql27dijw', 'pz4vn6ok5t', 'w5u0399n5o', 'q1oex8az8m', 't7flhcw82o', 'bpejj8fynn', 'uru0rd82iy', 'fediqh8d07', 'aeb3bgtxuz', 'mon1apiyes', 'bbgbq7xb5r', 'nxujvjuddi', 'e2qdmx6yb4', 'ncxr5kntli', 'osegzz25fs', '8fzmcs9qaz', 'vr17lkwl5c', 'llymt1poij', '4pggikpob8', 'kemfhv820t', 'r0md2h3hjq', '2vfaugzs43', 'ovl3k91urt', '4neh6lbvxm', 'ldoysnkju6', 'sun5jac6sx', '89drhp0iad', 'fw83xn22qy', '6eg13f6wod', 'p2889bpd7x', 'q2cod5n680', '1lt6ttnm6r', 'vl2602cynk', 'sg8v44h9x4', '7jc6fxuowv', 'jte0cpgkmj', 'hr7ugnyls1', 'agdd1vpt0c', 'u0brz56qmh', 'gptv7xmx29', '16h900v08b', 'v5l9ijib49', 'wikr2c3p3y', 'c6k0092elv', 'n586uy5qjc', 'd272012fm4', 'ztx17q13dc', 'hpkpbxro1k', '3xsue0ubto', '9heumis8q9', 'knzb5cyiiq', 'jugpulcjuc', 'ahybwidn45', 'wdc7lge8yh', 'sc77tfwmqz', 'ven57iu7i9', '2x7f5jx4cy', '249kmwqpt6', 'hyz2856rll', 'k4g1j7gqsi', '8oe4y7r33z', 'j2en4n39ol', '6ttkv59sar', '1rlhqzqke4', 'c9kvz00lg0', 'n8iq57fe7g', '57r4z96ejt', 'tkdrssmtjf', 'llv5rhvvjm', 'ududlre4vt', 's8r3q66r5d', 'wzxy5z06sc', 'cziu7slw45', 'jh0ozy4jre', 'iy05h09ohf', 'isvpvp37zw', 'jjoyig3orw', 'ra2dyt6isx', '53zw6p0vty', 'g01j1ymx52', 'a75ebojo0a', '24kg7zw5zf', 't0yawer693', 'f6eil8r3pb', 'ncc9d7ke1l', 'sqn0g76pwy', 'tzmzpj7w1l', 'ir42jzg24w', 'nc2q0jfg75', 'v7fyp1i3y2', 'dw5xkpciko', 'afnd1avt3c', '82fwrtohup', 'qw4hxm4blf', 'dwqhkwky11', '8ir7awcpb0', '90zw2kiwl9', 'z0p41k3s0r', 'qnlznma9n7', 'gf5s48141i', 'ojq0bmy6c7', 'r0h2r673hm', 'eoundc1p1l', 'bbb8wg5q0m', 'zjq7b3mc1y', '7w3vqwcyqz', 'm4bnfly3wp', 'i0cy8t8tyh', 'azrdv3ifwl', 'e7hg2haadd', 'qony9i3t4y', '6up20s4lj3', '3e9qqyylbh', 'sx0nvdv6t1', '7vhz424wp6', 'iz8at2jho6', 'p1mmho89o3', '3lymwyc2o7', 'of49zfgdfs', 'kzkxw8808j', 'e9audep41z', '4cu3fi6su0', 'fverfd5i2s', 'vtfxa2ivbq', 'ys4n17zmxa', '1feca00y9h', 'l60ejrd1y0', '5wnl22gqfx', '2bija0zziq', 'g6ko1o6him', '7pcnd5fioo', 'lpspu89xs5', 'z09bnrcmzj', '8xx00est40', 's0i7oq04gg', '5g5ih5vgpp', '6caffyd3sj', '4by8n7txtb', '22rwphx05v', 'wh4yl8a28z', 'ftrgwp3edd', '6sfm5cxp3p', '0f8rojgmq4', '2qise0ohte', 'c4p8u1ebog', '9juz1sui7q', 'q1arpxhotn', 'jvp01zrh7i', '3oot86nxt7', 'whydiirzcj', 'ykfuflgxv0', 'ivjb53iy05', 'y4mb636bl0', '2111hc42iz', 'pa1pu6tyrl', 'xm205wscbi', '46l6n4qke0', '8y8ym9nnx1', 'i5i1bcmpoj', 'fmopqyb9ol')

and action in ('full_register', 'profile_open', 'main_screen_open', 'open_first')

order by uid, ts, timestamp

limit 5000;