Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [voter_db]> select speakers.*, users.firstName from speakers left join users on speakers.userid=users.id where agendaitemid=155 order by agendaitemid, `index`;
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | createdAt | updatedAt | id | title | agendaItemId | userId | meetingId | entryTypeId | duration | status | index | parentId | autoCreated | spentTime | speakerName | firstName |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | 2019-05-24 17:25:12.130871 | 2019-05-24 17:50:32.000000 | 31 | Delegate | 155 | 1266 | 40 | 1 | 4 | completed | 1 | 31 | 0 | 180 | | Eirik Sørdahl |
- | 2019-05-24 17:07:51.647198 | 2019-05-24 17:54:36.000000 | 22 | Delegate | 155 | 1286 | 40 | 1 | 5 | completed | 2 | 22 | 0 | 196 | | Marit Wiig |
- | 2019-05-24 17:30:19.774402 | 2019-05-24 17:56:27.000000 | 34 | Delegate | 155 | 1160 | 40 | 1 | 4 | completed | 3 | 34 | 0 | 156 | | Sverre Flatebø |
- | 2019-05-24 17:13:58.822126 | 2019-05-24 17:56:27.000000 | 28 | NULL | 155 | 1233 | 40 | 1 | 5 | completed | 4 | 28 | 0 | 274 | | Jan Hendrik Parmann |
- | 2019-05-24 17:08:26.032941 | 2019-05-24 17:56:27.000000 | 23 | Delegate | 155 | 1201 | 40 | 1 | 5 | completed | 5 | 23 | 0 | 166 | | Astrid Waaler Kaas |
- | 2019-05-24 17:10:28.271148 | 2019-05-24 17:56:27.000000 | 25 | Delegate | 155 | 1165 | 40 | 1 | 5 | completed | 6 | 25 | 0 | 248 | | Grethe Fossli |
- | 2019-05-24 17:19:42.274545 | 2019-05-24 17:56:27.000000 | 30 | NULL | 155 | 1245 | 40 | 1 | 5 | completed | 7 | 30 | 0 | 206 | | Erik Røste |
- | 2019-05-24 17:32:34.184329 | 2019-05-24 17:56:27.000000 | 37 | Delegate | 155 | 1260 | 40 | 1 | 4 | completed | 8 | 37 | 0 | 114 | | Terje Svendsen |
- | 2019-05-24 17:10:51.102026 | 2019-05-24 17:56:27.000000 | 26 | Delegate | 155 | 1183 | 40 | 1 | 5 | completed | 9 | 26 | 0 | 136 | | Sebastian Henriksen |
- | 2019-05-24 17:25:56.671083 | 2019-05-24 17:56:27.000000 | 32 | Delegate | 155 | 1188 | 40 | 1 | 4 | completed | 10 | 32 | 0 | 92 | | John Arve Hveding |
- | 2019-05-24 17:08:36.046915 | 2019-05-24 17:56:27.000000 | 24 | Delegate | 155 | 1197 | 40 | 1 | 5 | completed | 11 | 24 | 0 | 300 | | Sigbjørn Johnsen |
- | 2019-05-24 17:26:03.998068 | 2019-05-24 17:56:27.000000 | 33 | Delegate | 155 | 1210 | 40 | 1 | 4 | completed | 12 | 33 | 0 | 154 | | Tor Inge Martinsen |
- | 2019-05-24 17:12:43.160049 | 2019-05-24 17:56:27.000000 | 27 | Delegate | 155 | 1154 | 40 | 1 | 5 | completed | 13 | 27 | 0 | 173 | | May Bente Eriksen |
- | 2019-05-24 17:33:49.638501 | 2019-05-24 17:56:27.000000 | 38 | Delegate | 155 | 1124 | 40 | 1 | 4 | new | 14 | 38 | 0 | 0 | | Mads Andreassen |
- | 2019-05-24 17:45:01.727554 | 2019-05-24 17:56:27.000000 | 39 | Delegate | 155 | 1123 | 40 | 1 | 5 | speaking | 15 | 39 | 0 | 0 | | Arild Mjøs Andersen |
- | 2019-05-24 17:31:51.402541 | 2019-05-24 17:56:27.000000 | 36 | Delegate | 155 | 1277 | 40 | 1 | 4 | completed | 16 | 36 | 0 | 197 | | Erik Unaas |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- 16 rows in set (0.00 sec)
- MariaDB [voter_db]> select speakers.*, users.firstName from speakers left join users on speakers.userid=users.id where agendaitemid=155 order by agendaitemid, `index`;
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | createdAt | updatedAt | id | title | agendaItemId | userId | meetingId | entryTypeId | duration | status | index | parentId | autoCreated | spentTime | speakerName | firstName |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | 2019-05-24 17:25:12.130871 | 2019-05-24 17:50:32.000000 | 31 | Delegate | 155 | 1266 | 40 | 1 | 4 | completed | 1 | 31 | 0 | 180 | | Eirik Sørdahl |
- | 2019-05-24 17:07:51.647198 | 2019-05-24 17:54:36.000000 | 22 | Delegate | 155 | 1286 | 40 | 1 | 5 | completed | 2 | 22 | 0 | 196 | | Marit Wiig |
- | 2019-05-24 17:13:58.822126 | 2019-05-24 17:57:14.000000 | 28 | NULL | 155 | 1233 | 40 | 1 | 5 | completed | 3 | 28 | 0 | 274 | | Jan Hendrik Parmann |
- | 2019-05-24 17:08:26.032941 | 2019-05-24 17:57:14.000000 | 23 | Delegate | 155 | 1201 | 40 | 1 | 5 | completed | 4 | 23 | 0 | 166 | | Astrid Waaler Kaas |
- | 2019-05-24 17:10:28.271148 | 2019-05-24 17:57:14.000000 | 25 | Delegate | 155 | 1165 | 40 | 1 | 5 | completed | 5 | 25 | 0 | 248 | | Grethe Fossli |
- | 2019-05-24 17:19:42.274545 | 2019-05-24 17:57:14.000000 | 30 | NULL | 155 | 1245 | 40 | 1 | 5 | completed | 6 | 30 | 0 | 206 | | Erik Røste |
- | 2019-05-24 17:32:34.184329 | 2019-05-24 17:57:14.000000 | 37 | Delegate | 155 | 1260 | 40 | 1 | 4 | completed | 7 | 37 | 0 | 114 | | Terje Svendsen |
- | 2019-05-24 17:10:51.102026 | 2019-05-24 17:57:14.000000 | 26 | Delegate | 155 | 1183 | 40 | 1 | 5 | completed | 8 | 26 | 0 | 136 | | Sebastian Henriksen |
- | 2019-05-24 17:08:36.046915 | 2019-05-24 17:57:14.000000 | 24 | Delegate | 155 | 1197 | 40 | 1 | 5 | completed | 9 | 24 | 0 | 300 | | Sigbjørn Johnsen |
- | 2019-05-24 17:12:43.160049 | 2019-05-24 17:57:14.000000 | 27 | Delegate | 155 | 1154 | 40 | 1 | 5 | completed | 10 | 27 | 0 | 173 | | May Bente Eriksen |
- | 2019-05-24 17:25:56.671083 | 2019-05-24 17:57:14.000000 | 32 | Delegate | 155 | 1188 | 40 | 1 | 4 | completed | 11 | 32 | 0 | 92 | | John Arve Hveding |
- | 2019-05-24 17:33:49.638501 | 2019-05-24 17:57:14.000000 | 38 | Delegate | 155 | 1124 | 40 | 1 | 4 | new | 12 | 38 | 0 | 0 | | Mads Andreassen |
- | 2019-05-24 17:26:03.998068 | 2019-05-24 17:57:14.000000 | 33 | Delegate | 155 | 1210 | 40 | 1 | 4 | completed | 13 | 33 | 0 | 154 | | Tor Inge Martinsen |
- | 2019-05-24 17:31:51.402541 | 2019-05-24 17:57:14.000000 | 36 | Delegate | 155 | 1277 | 40 | 1 | 4 | completed | 14 | 36 | 0 | 197 | | Erik Unaas |
- | 2019-05-24 17:45:01.727554 | 2019-05-24 17:57:14.000000 | 39 | Delegate | 155 | 1123 | 40 | 1 | 5 | speaking | 15 | 39 | 0 | 0 | | Arild Mjøs Andersen |
- | 2019-05-24 17:30:19.774402 | 2019-05-24 17:57:14.000000 | 34 | Delegate | 155 | 1160 | 40 | 1 | 4 | completed | 16 | 34 | 0 | 156 | | Sverre Flatebø |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- 16 rows in set (0.00 sec)
- MariaDB [voter_db]> select speakers.*, users.firstName from speakers left join users on speakers.userid=users.id where agendaitemid=155 order by agendaitemid, `index`;
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | createdAt | updatedAt | id | title | agendaItemId | userId | meetingId | entryTypeId | duration | status | index | parentId | autoCreated | spentTime | speakerName | firstName |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- | 2019-05-24 17:25:12.130871 | 2019-05-24 17:50:32.000000 | 31 | Delegate | 155 | 1266 | 40 | 1 | 4 | completed | 1 | 31 | 0 | 180 | | Eirik Sørdahl |
- | 2019-05-24 17:07:51.647198 | 2019-05-24 17:54:36.000000 | 22 | Delegate | 155 | 1286 | 40 | 1 | 5 | completed | 2 | 22 | 0 | 196 | | Marit Wiig |
- | 2019-05-24 17:13:58.822126 | 2019-05-24 17:57:14.000000 | 28 | NULL | 155 | 1233 | 40 | 1 | 5 | completed | 3 | 28 | 0 | 274 | | Jan Hendrik Parmann |
- | 2019-05-24 17:08:26.032941 | 2019-05-24 17:57:14.000000 | 23 | Delegate | 155 | 1201 | 40 | 1 | 5 | completed | 4 | 23 | 0 | 166 | | Astrid Waaler Kaas |
- | 2019-05-24 17:10:28.271148 | 2019-05-24 17:57:14.000000 | 25 | Delegate | 155 | 1165 | 40 | 1 | 5 | completed | 5 | 25 | 0 | 248 | | Grethe Fossli |
- | 2019-05-24 17:19:42.274545 | 2019-05-24 17:57:14.000000 | 30 | NULL | 155 | 1245 | 40 | 1 | 5 | completed | 6 | 30 | 0 | 206 | | Erik Røste |
- | 2019-05-24 17:32:34.184329 | 2019-05-24 17:57:14.000000 | 37 | Delegate | 155 | 1260 | 40 | 1 | 4 | completed | 7 | 37 | 0 | 114 | | Terje Svendsen |
- | 2019-05-24 17:10:51.102026 | 2019-05-24 17:57:14.000000 | 26 | Delegate | 155 | 1183 | 40 | 1 | 5 | completed | 8 | 26 | 0 | 136 | | Sebastian Henriksen |
- | 2019-05-24 17:08:36.046915 | 2019-05-24 17:57:14.000000 | 24 | Delegate | 155 | 1197 | 40 | 1 | 5 | completed | 9 | 24 | 0 | 300 | | Sigbjørn Johnsen |
- | 2019-05-24 17:12:43.160049 | 2019-05-24 17:57:14.000000 | 27 | Delegate | 155 | 1154 | 40 | 1 | 5 | completed | 10 | 27 | 0 | 173 | | May Bente Eriksen |
- | 2019-05-24 17:25:56.671083 | 2019-05-24 17:57:14.000000 | 32 | Delegate | 155 | 1188 | 40 | 1 | 4 | completed | 11 | 32 | 0 | 92 | | John Arve Hveding |
- | 2019-05-24 17:26:03.998068 | 2019-05-24 17:58:53.000000 | 33 | Delegate | 155 | 1210 | 40 | 1 | 4 | completed | 12 | 33 | 0 | 154 | | Tor Inge Martinsen |
- | 2019-05-24 17:33:49.638501 | 2019-05-24 17:58:56.000000 | 38 | Delegate | 155 | 1124 | 40 | 1 | 4 | speaking | 12 | 38 | 0 | 0 | | Mads Andreassen |
- | 2019-05-24 17:30:19.774402 | 2019-05-24 17:58:53.000000 | 34 | Delegate | 155 | 1160 | 40 | 1 | 4 | completed | 13 | 34 | 0 | 156 | | Sverre Flatebø |
- | 2019-05-24 17:31:51.402541 | 2019-05-24 17:58:56.000000 | 36 | Delegate | 155 | 1277 | 40 | 1 | 4 | completed | 15 | 36 | 0 | 197 | | Erik Unaas |
- | 2019-05-24 17:45:01.727554 | 2019-05-24 17:59:09.000000 | 39 | Delegate | 155 | 1123 | 40 | 1 | 5 | completed | 16 | 39 | 0 | 186 | | Arild Mjøs Andersen |
- +----------------------------+----------------------------+----+----------+--------------+--------+-----------+-------------+----------+-----------+-------+----------+-------------+-----------+-------------+----------------------+
- 16 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement