local_current_membership
1,392 rows
This data as json, CSV (advanced)
Suggested facets: membership
| Link | rowid ▼ | room_id | user_id | event_id | membership | event_stream_ordering |
|---|---|---|---|---|---|---|
| 1 | 1 | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | @james:matrix.jamesst.one | $3hoqCxRfRzsBF15dGCBKp3q-y4G-E5ZO-GUHsgcbAk0 | join | 3 3 |
| 2 | 2 | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $9mxBManLkFBObtGi9FdwYG7eO_v01tlF-A8la21pipM | join | 9 9 |
| 3 | 3 | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | @james:matrix.jamesst.one | $iJUDpOXmkV8s7TFhaHOLD7wFZ94SiixHBiRHwNrAwas | join | 36 36 |
| 4 | 4 | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | @signalbot:matrix.jamesst.one | $LL8p9X-ybSaQqHHZNyO8aqbB4Enpo4wZ_DibVXQOGuU | join | 42 42 |
| 5 | 5 | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $wg81eaFDF57ZoWw_QRRXOe0XnJN-xuJ7nlaQDv2N-24 | join | 63 63 |
| 6 | 6 | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $OpH23j_RrgQ94R4QcYLgmekjaaFylVF_j41lnLEVNBo | join | 64 64 |
| 7 | 7 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $3pMIcpTLR2hJuSn4KSPbOKNS7hOTO9uuRqIuv2L7rJg | join | 65 65 |
| 8 | 8 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $F617RSSjs22vCwI99ryYsoUAP7l_xyoa8x_Y8dpUPlk | join | 66 66 |
| 9 | 9 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $uuSk8AGXd4i4FqjxQyomVXlkaxK4Wlsc-tu8sRZlbNQ | join | 67 67 |
| 10 | 10 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $j2JcCWz_r-dn3OjEBF8Rl6jFmQ5c5m-Td9MNSu5h20Q | join | 68 68 |
| 11 | 11 | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $5EUD5-MHpCTpf3hNa6WhE3eZ2nhLCpeZ173yMlgBrM8 | join | 117 117 |
| 12 | 12 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $T60UYkUtMbz6u8Gnw_nPMv8LsaxsW99SHaROOChvIjQ | join | 118 118 |
| 13 | 13 | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $cTn-NmkmQzMxMd3_and2MyZ9-hLsQQUDz-BwWQLJK0w | join | 119 119 |
| 14 | 14 | !UUvAhTKNjAWCZdiukW:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $OpoUwfvOZNBAO8P7rR83O5R5be9sfPqbbmANl5J3SYM | join | 120 120 |
| 15 | 15 | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $blTLJywpRQK2qn7h-GAfexjE_1gmzRUP91RmXFgnlQc | join | 121 121 |
| 21 | 21 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $wmMQtPbPU7bRRLewe3vx3laZ3-yjezFqSkTExYVH_2M | join | 127 127 |
| 39 | 39 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | @telegram_1130788997:matrix.jamesst.one | $w3Jd10ioqg6Wkl8jZIWeWClDCJuPqmKvRajSlwR5lgE | join | 188 188 |
| 49 | 49 | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $Nwcac6itXnigUTXP0d_Me4FQrxnDcNG-kleFUXRa5iw | join | 198 198 |
| 51 | 51 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $1YMuaxguJO4KLUelCInKqy20qnxiwQ78dXjH-5iuJTo | join | 200 200 |
| 54 | 54 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $qsoR6tEJkDauxh127lePZvlrUeMYrnrXaVxvhtCARV4 | join | 203 203 |
| 59 | 59 | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | @telegram_6193339016:matrix.jamesst.one | $jPK3DLclw-9zKuxJqK8hiSDQkPfFwOfwvSU9npZhTc0 | join | 208 208 |
| 60 | 60 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | @telegram_1130788997:matrix.jamesst.one | $XEyWQTSsZskenzEOlmwqDe5ojSjIlODF18vUQ5CjdxI | join | 209 209 |
| 62 | 62 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | @telegram_1122421532:matrix.jamesst.one | $rNT1-3G5Rvlw1UfaFa9D10jZqQm32yr7V0d-2vmCt6Q | join | 211 211 |
| 63 | 63 | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | @telegram_8606696926:matrix.jamesst.one | $p8mPEjVaJgK_5vO7hPwwgll9JyeVrjqqaiSP_msnkzA | join | 212 212 |
| 64 | 64 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | @telegram_1122421532:matrix.jamesst.one | $TRqjSNKhH_qY6T1lKBkIVlAowalNpJeIA6ifK4v0zjc | join | 213 213 |
| 66 | 66 | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | @telegram_1122421532:matrix.jamesst.one | $LYwr0K8u9S24rJFbkuiL14peSQHgaPnLKbnLKXuAGLU | join | 215 215 |
| 67 | 67 | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | @telegram_1122421532:matrix.jamesst.one | $gHLMzrtaypvS_tKVplY1QlQZAjGluZn62fwauQyviaA | join | 216 216 |
| 69 | 69 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $K8YRCTcVRT6v08afwpP6ENQySbk3niHcbA0GCSXhRbw | join | 218 218 |
| 71 | 71 | !UUvAhTKNjAWCZdiukW:matrix.jamesst.one | @telegram_1387366216:matrix.jamesst.one | $elmluqrDx-bpcj9j0MTksf65hgMRfsezlIzPXzo0dog | join | 221 221 |
| 72 | 72 | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | @telegram_1130788997:matrix.jamesst.one | $yB5y0XKzo7-nUER3oKklveRLVoCHflA1wPI7fXWsbTo | join | 222 222 |
| 76 | 76 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $lkNV5P2XxNvk_EdYvGhbL4sBAeNeBMkDpx91s1wQSmY | join | 226 226 |
| 80 | 80 | !TuuVfHAWQDmtlxZyTc:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $TStsILiosSTQI0t9ETPepjaeCo4Ss_7XxxdnMn7q8U4 | join | 231 231 |
| 81 | 81 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @telegram_1122421532:matrix.jamesst.one | $kOnbpl2RuNksPsh7_Qr2M4NSiconDQYclovhrXzrN54 | join | 232 232 |
| 85 | 85 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $ogSb70Ze1vK_Fv4Iw7q1_muaf0Ok6u0B4fi44iFHGCs | join | 238 238 |
| 86 | 86 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $V86ZzcX9LLs41paHCKOpfu79cTvvgmC7flFxmwUAJgo | join | 239 239 |
| 87 | 87 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $GC8jkVSqyDP_5x3aoh3Pp-7LbZwPuYOuTBdLOr8y6aI | join | 240 240 |
| 88 | 88 | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | @telegram_6193339016:matrix.jamesst.one | $5VC3rlNvPhlewrK2OhS-47h4oKYM97kTLkBqBrZOCn8 | join | 241 241 |
| 89 | 89 | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $w6TWM3Dyu6uj0Tu1rqpnfT4sVSQ6XK1CMJUi3J8y1Tk | join | 242 242 |
| 92 | 92 | !HenNzFPhosZJtuised:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $kqHkhaBB3bjZtPgX32twFqiOLwuMfDhj7IjVcFtG7dM | join | 245 245 |
| 93 | 93 | !UJqzdqWCbSZOHNGKko:matrix.jamesst.one | @telegrambot:matrix.jamesst.one | $_DYZ4Vf7snFQAMT2za0rlSkh0x6I96nBGlOHs-kd0xc | join | 246 246 |
| 94 | 94 | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $cbNBeMR2FNDfKeJbrIC2AQya9DBmVKXPc1W5z3A9SC8 | join | 258 258 |
| 95 | 95 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $5WWealbhE4gZHaBiM9gr7d7smJeg551i2l6lzmpLuS4 | join | 260 260 |
| 99 | 99 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | @telegram_1130788997:matrix.jamesst.one | $yqzTQsp5hpG0iCgJVeqlZf9Y8v6V2O4OL-uw9fq9nAc | join | 266 266 |
| 101 | 101 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @telegram_1130788997:matrix.jamesst.one | $SQGKZq2_bqH4lDfNJWKrFGQ9___yfvobidud8Qlu0AU | join | 287 287 |
| 103 | 103 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $Vc6A5OvSF-qo9XgR3Qz4ujpMxFiYAU3LBOugux3mVL0 | join | 290 290 |
| 111 | 111 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @telegram_836113426:matrix.jamesst.one | $2b1HWaGd1wrI13Ymk01FWAE-8dtxzj6nN0QtxBajFgk | join | 316 316 |
| 112 | 112 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | @james:matrix.jamesst.one | $3OXJ7oYH_ZW2xZWKOIX0TDO_ghbyLKnDGW5N3WdwEdY | join | 331 331 |
| 113 | 113 | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | @james:matrix.jamesst.one | $O_R5o7lx0rw97G_kxOXD87AEURFw4JpdYqgdx-1W8s8 | join | 342 342 |
| 114 | 114 | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | @james:matrix.jamesst.one | $ON4XHJemQdC8-FTgnB7hj1aOjAIUzwh2DvU45QHrSeg | join | 343 343 |
| 115 | 115 | !UJqzdqWCbSZOHNGKko:matrix.jamesst.one | @james:matrix.jamesst.one | $CJO9OwH6GafmhmJ22mvtM_zS7FvOTNNe6SzB5fGMKM4 | join | 344 344 |
| 116 | 116 | !HenNzFPhosZJtuised:matrix.jamesst.one | @james:matrix.jamesst.one | $9WXd5MbZIxpus3JrcFr9-bwt0njVWT8wkA1wBEYfkXU | join | 345 345 |
| 117 | 117 | !TuuVfHAWQDmtlxZyTc:matrix.jamesst.one | @james:matrix.jamesst.one | $x1AuqyOegrvrRHBEY9OCKQSop16Pqwd3Xqh7JkvngR0 | join | 346 346 |
| 118 | 118 | !UUvAhTKNjAWCZdiukW:matrix.jamesst.one | @james:matrix.jamesst.one | $PQIODNPSug04czrTRB-RaZcxgo17bw0H5mUR74A7Azo | join | 347 347 |
| 119 | 119 | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | @james:matrix.jamesst.one | $UwRqnSnCmX-j2p14GJ_BfqYoFrNONuKb7SKMS1mjl0o | join | 348 348 |
| 120 | 120 | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | @james:matrix.jamesst.one | $eLJHFlgOoDTL1aFD9YAEd0PVKbyKDGJJJNu2p8F0bLw | join | 349 349 |
| 121 | 121 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | @james:matrix.jamesst.one | $xVbpN3fVvzTQczRHxYiBn8J5-qjlkhkt41vDUjQ4wD0 | join | 350 350 |
| 122 | 122 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | @james:matrix.jamesst.one | $aQjeb2I6h2DBNCVnwRi1eXo0YjhVQnrz0m5ISS3Z9dQ | join | 351 351 |
| 123 | 123 | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | @james:matrix.jamesst.one | $qbARUuYz4QUn5N3qSFTu1jCyOlk229hzg3f992Ga5uE | join | 352 352 |
| 124 | 124 | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | @james:matrix.jamesst.one | $G4cx6fQnlM4e61hVY4YTDa70o1jvOg_QMjq53_sBO1g | join | 353 353 |
| 125 | 125 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | @james:matrix.jamesst.one | $ukmyw-o9t2Yo_oCpwh7VAlfbCl5_YA9A4b-r9VKYAmk | join | 354 354 |
| 126 | 126 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | @james:matrix.jamesst.one | $jy-Ycro6o3J_MYEhShAEb8Uj2qtfENcyodL3wn0cFKs | join | 355 355 |
| 127 | 127 | !FMIBicfcNbhIoPeYcL:matrix.jamesst.one | @james:matrix.jamesst.one | $-zlUbtFKR0hN1BC5fl_hZ-kOvl0znchCQw4pARNuLwg | join | 374 374 |
| 128 | 128 | !FMIBicfcNbhIoPeYcL:matrix.jamesst.one | @telegram_1126947413:matrix.jamesst.one | $XfeoIwPSMHrPekMjSAvQswlumP49_6B16ZnIo60wvnY | join | 380 380 |
| 129 | 129 | !BlgOiSpdKGmaXVClci:matrix.jamesst.one | @james:matrix.jamesst.one | $PEWoU8qn5gZVhjN38TfbJ0vhh4ttNlo-5ZKCzAR9iR0 | join | 386 386 |
| 130 | 130 | !BlgOiSpdKGmaXVClci:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $H9ngobgnroEMdjmTuBEHHnz3G0Nf-nc1RituzDIxvb8 | join | 392 392 |
| 131 | 131 | !YuTkIZfXxcPwXTVVSR:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $H3f2ATOb9GguOYy4Z7hf97JzaIVqNNbZjEqxPaJKdBQ | join | 404 404 |
| 134 | 134 | !YuTkIZfXxcPwXTVVSR:matrix.jamesst.one | @slack_t0qh48pl4-u072zlzmnmc:matrix.jamesst.one | $SlacArwvfJyh4yvDMMJILw6CdBK7PCFUm8Kkl0UBM-4 | join | 420 420 |
| 135 | 135 | !paEYvyghpqtUQhrPNa:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $rv6v457RjDemrjgMXlGQTDB8zHuZOJqMG6zjfqhy5Tk | join | 487 487 |
| 136 | 136 | !BKJJFinmkAqADXNazP:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $5AlV_bn5ZjftqyZZGCvVbTUZ50GZa1FtCSjCxeAQte8 | join | 488 488 |
| 137 | 137 | !KZxzXOwrTpPPiMOFhu:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $163M55cDXiuqlKpM6L8A1SB4PwAcK3kvoqerNghrqNU | join | 489 489 |
| 138 | 138 | !ElgDfrMJYslEdyrFht:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $BavhzIqmslrdq7HaHweBj9g6dW-jvvOIw81zEf5sWU0 | join | 490 490 |
| 139 | 139 | !oCiWUELXBrnJJEOfHN:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $IJQckaUN_cMDyXzfVFOa9pSRhGUIFxEB-H7OPC8dCM8 | join | 491 491 |
| 140 | 140 | !IDVzmHGTigaDkLInhb:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $WZqZgkDl5mIG3PL4ATmHmayBraGk8366_pGcY9_rz48 | join | 492 492 |
| 141 | 141 | !SYcYAciaPLevjjQelT:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $2VH7DR7Yj4JLPGDOvKWWtQve8IVatsCf4QmEe_Mk6Y0 | join | 493 493 |
| 142 | 142 | !AjmuzElxFNgRRZQNoQ:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $LMQVoAOKB0o62eD_aKQIu4aUDHhKUp3uelYGxzN5Pr8 | join | 494 494 |
| 143 | 143 | !nmtFIaWniwOuEEsZPI:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $R5x4ppwnPOyyLAWtPNSh3AcNfjMJg4cRh3EAiqmVVDc | join | 495 495 |
| 144 | 144 | !KmpLRLsyyaPdUYdMHb:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $u9eax_E7Z9T5ItfyZ8jFsydtSD6co-nCtgdyFATnQf4 | join | 496 496 |
| 145 | 145 | !kKtScliyhdpXGYJoyR:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $KM3S9KM6P3C8NZzQt6XEOEcOG-hQofrddS0xYdmmEQs | join | 497 497 |
| 146 | 146 | !LxWwgtpXTQVjcFMgkb:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $UhqJlNGPMoIovu0EZqIjWkt0aOkyAG8btMJWB0bpjkQ | join | 498 498 |
| 147 | 147 | !AqEkmqWBtPNnPrufwA:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $bC8NFRwOINnauF-t7bvMybP9WCrcJ-8EznTX0Rb6F-k | join | 499 499 |
| 148 | 148 | !EHdkQWRkfptmqktyaP:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $LICDSFjaeUk7JgqRvMKY6vtvPb9rOFTRspYMlW1eepA | join | 500 500 |
| 149 | 149 | !nJVpZYntXuvRnsxkfR:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $CfXuQEHnQgm4il1JOU__B1jbQF7yKJkxC9zmP03hyQ0 | join | 501 501 |
| 150 | 150 | !hqiiyckjNGemPGuALY:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $bGlexSJFvaGXrdSw3d03lVLKCQxN1EQjaW25k_AvA9M | join | 502 502 |
| 151 | 151 | !qgdrlnxfxQUvpxZdQB:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $eT9LFG_KWirVby0Bp5eoFiLP_XJXJ6Fo5GP9E-crLYI | join | 503 503 |
| 152 | 152 | !wtqlekpwOtgIKIzUye:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $bMYo38hp4ur5hoRQFHgp27pZj4M3D1I0pC-IOoBvfjg | join | 504 504 |
| 153 | 153 | !SHlOLhRmKSJrdjtNGQ:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $JBsJB7Kzjb7OxVBjaps9cEmkpRiRjyQa8WeifB8hbf4 | join | 505 505 |
| 154 | 154 | !hsifellATWsMazXlZA:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $NecAmzPrtAygbpGfQyD4Sq1N7vivyQ1VFQcUbomLiF8 | join | 506 506 |
| 155 | 155 | !zmsygXhOAWGjoosiDX:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $xCIAYUGjz3yE7nOC3AtgHZ13OnHWHzyivFcPobPM5Yc | join | 608 608 |
| 156 | 156 | !cBhJppwGOsWgjyoOQQ:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $gFtDCA05a6aQyHl3WeynDdPfjvC0wbKZxBe4srr72pE | join | 609 609 |
| 157 | 157 | !PhFBDVEcLtoQxmvPSL:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $OmTZzrt2TH7mFAtYgOo9zKj3wgtXmkKTTJ85qNMbyAI | join | 610 610 |
| 158 | 158 | !RhMgvAPjLANRigRiwG:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $Nj9wkCm0Qr6Src7Sd6btnbroX_NH2LPRwkKXqX3Qfso | join | 611 611 |
| 159 | 159 | !HPNcDxTDpUhwcvGFdW:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $mgz9NQlWZmSXSFPD0_ikFJJpqND2iEmSpegLJCqsqIA | join | 612 612 |
| 160 | 160 | !BcXnWMtRzAnQcBRJTw:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $rWhjTFLNIb6j4RLW3Pa0J---G-hxo0Ikfkx_pBxi5WQ | join | 613 613 |
| 161 | 161 | !OmcewBHpqinKaAilnV:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $RXpIGh-dQ0cZ7mNGQuBxlKKtyDkkU_mx15UreAZXZyw | join | 614 614 |
| 162 | 162 | !RppQZemJMBraLoZloF:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $p_ZcW_14F9ITkdXpJ5OxqQcJQGz5fIi1zIYta3ktYK4 | join | 615 615 |
| 163 | 163 | !foAyKLHyzufIEbwwSe:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $0we5miI6gNRqQh4_NvJSjUUWJ5I6KDce9DD0EXlB2u0 | join | 616 616 |
| 164 | 164 | !aamIUwRMpqoTVlOgYQ:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $wvheLY3C9WVOiT5oaqMyJt20Epx-KGLcYwbPUHAqVqM | join | 617 617 |
| 165 | 165 | !CCUfAhwGFDisuRJodI:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $Le1lilR4a5VI1QvA3CDSXNX9jeLJh7GlO3kRlSvysGQ | join | 719 719 |
| 166 | 166 | !LFSjGRgyyAkgpjNvAb:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $GXcNWpQJidJFQdvHh5BKqO3bCrl9uuFTi8wCvJOum0k | join | 720 720 |
| 167 | 167 | !qvoVrGJcqwQNByFOEN:matrix.jamesst.one | @slackbot:matrix.jamesst.one | $v0wvp_sAHqy2rUd1NRYKFzwqzrHzsEcyTgUoK13ze7A | join | 721 721 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE local_current_membership (
room_id TEXT NOT NULL,
user_id TEXT NOT NULL,
event_id TEXT NOT NULL,
membership TEXT NOT NULL
, event_stream_ordering BIGINT REFERENCES events(stream_ordering));
CREATE UNIQUE INDEX local_current_membership_idx ON local_current_membership(user_id, room_id);
CREATE INDEX local_current_membership_room_idx ON local_current_membership(room_id);
CREATE INDEX local_current_membership_stream_ordering_idx ON local_current_membership (event_stream_ordering) ;