SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 71 AND b.c_folder_id = 71) AND (a.c_name = '8oker1qutdg8sj3op8r4pv1bts@google.com.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) INTO OUTFILE '/tmp/querydump.csv' \8oker1qutdg8sj3op8r4pv1bts@google.com.ics","2","1588060750","1588061305","vevent","BEGIN:VCALENDAR \RODID:-//Ximian//NONSGML Evolution Calendar//EN \ERSION:2.0 \ALSCALE:GREGORIAN \EGIN:VEVENT \TSTART:20200429T080000Z \TEND:20200429T100000Z \TSTAMP:20200428T075854Z \RGANIZER;CN=external.ulrich@gmail.com:mailto:external.ulrich@gma \il.com \ID:8oker1qutdg8sj3op8r4pv1bts@google.com \TTENDEE;ROLE=REQ-PARTICIPANT;X-NUM-GUESTS=0;PARTSTAT=ACCEPTED;CN=xxxxxxxxx U \rbanik;CUTYPE=INDIVIDUAL:mailto:xxxxxxxxx@benocs.com \TTENDEE;RSVP=TRUE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;X-NUM-GUESTS= \0;CN=\"xxxxxxxxx, xxxxxxxxx\";CUTYPE=INDIVIDUAL:mailto:xxxxxxxxx.xxxxxxxxx@mag \enta.at \TTENDEE;CN=Lori xxxxxxxxx;PARTSTAT=ACCEPTED;ROLE=REQ-PARTICIPANT;X-NUM-GUEST \S=0;CUTYPE=INDIVIDUAL:mailto:lxxxxxxxxx@benocs.com \TTENDEE;RSVP=TRUE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;X-NUM-GUESTS= \0;CUTYPE=INDIVIDUAL:mailto:xxxxxxxxx@benocs.com \-MICROSOFT-CDO-OWNERAPPTID:1033407331 \REATED:20200422T093359Z \ESCRIPTION:Benocs is inviting you to a scheduled Zoom meeting.\\n\\nTopic: W \orkshop Magenta Austria/Benocs\\nTime: Apr 29\\, 2020 10:00 AM Paris\\n\\nJoin \ Zoom Meeting\\nhttps://us02web.zoom.us/j/xxxxxxxxx\\n\\nMeeting ID: 868 14 \38 2313\\nOne tap mobile\\n+496950502596\\,\\,xxxxxxxxx# Germany\\n+496971049 \922\\,\\,xxxxxxxxx# Germany\\n\\nDial by your location\\n +49 695 050 \2596 Germany\\n +49 69 7104 9922 Germany\\n +49 30 5679 5800 G \ermany\\n +1 669 900 6833 US (San Jose)\\n +1 253 215 8782 US \(Tacoma)\\n +1 301 715 8592 US (Germantown)\\n +1 312 626 6799 \ US (Chicago)\\n +1 346 248 7799 US (Houston)\\n +1 408 638 09 \68 US (San Jose)\\n +1 646 876 9923 US (New York)\\n +36 1 701 \ 0488 Hungary\\n +36 1 408 8456 Hungary\\n +33 1 7095 0103 Fra \nce\\n +33 1 7095 0350 France\\n +33 7 5678 4048 France\\n \ +33 1 7037 2246 France\\n +33 1 7037 9729 France\\n +31 20 \794 6519 Netherlands\\n +31 20 794 6520 Netherlands\\n +31 20 \794 7345 Netherlands\\n +31 20 241 0288 Netherlands\\n +31 20 \794 0854 Netherlands\\n +44 203 481 5240 United Kingdom\\n +44 \ 131 460 1196 United Kingdom\\n +44 203 051 2874 United Kingdom\\n \ +44 203 481 5237 United Kingdom\\n +90 216 900 2606 Turkey\\n \ +90 216 900 1866 Turkey\\nMeeting ID: xxxxxxxxx\\nFind your local n \umber: https://us02web.zoom.us/u/xxxxxxxxx\\n\\n\\n-::~:~::~:~:~:~:~:~:~:~:~ \:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\\nDiesen Abs \chnitt der Beschreibung nicht bearbeiten.\\n\\nZeigen Sie Ihren Termin unter \ https://www.google.com/calendar/event?action=VIEW&eid=OG9rZXIxcXV0ZGc4c2o \zb3A4cjRwdjFidHMgcHVyYmFuaWtAYmVub2NzLmNvbQ&tok=MzAjaGFtbWVyc2NobWlkdC51bH \xxxxxxxxx&c \tz=Europe%2FVienna&hl=de&es=1 an.\\n-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~ \:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::- \AST-MODIFIED:20200428T080825Z \OCATION:https://us02web.zoom.us/j/xxxxxxxxx \EQUENCE:1 \TATUS:CONFIRMED \UMMARY:Workshop Magenta Austria/Benocs \RANSP:OPAQUE \-MICROSOFT-CDO-REPLYTIME:20200428T075909Z \LASS:PUBLIC \ND:VEVENT END:VCALENDAR" select * from sogo_quick_appointment where c_name = '8oker1qutdg8sj3op8r4pv1bts@google.com.ics' INTO OUTFILE '/tmp/querydump2.csv'; 71 8oker1qutdg8sj3op8r4pv1bts@google.com.ics 8oker1qutdg8sj3op8r4pv1bts@google.com 1588147200 1588154400 \N Workshop Magenta Austria/Benocs xxxxxxxxx xxxxxxxxx\ xxxxxxxxx, xxxxxxxxx\ Lori xxxxxxxxx\ 0 0 \N 0 1 1 0 https://us02web.zoom.us/j/xxxxxxxxx external.ulrich@gmail.com xxxxxxxxx@benocs.com\ xxxxxxxxx.xxxxxxxxx@magenta.at\ lxxxxxxxxx@benocs.com\ xxxxxxxxx@benocs.com 1\ 0\ 1\ 0 \N 1 vevent 0 Benocs is inviting you to a scheduled Zoom meeting.\ \ Topic: Workshop Magenta Austria/Benocs\ Time: Apr 29, 2020 10:00 AM Paris\ \ Join Zoom Meeting\ https://us02web.zoom.us/j/xxxxxxxxx\ \ Meeting ID: xxxxxxxxx\ One tap mobile\ +496950502596,,xxxxxxxxx# Germany\ +496971049922,,xxxxxxxxx# Germany\ \ Dial by your location\ +49 695 050 2596 Germany\ +49 69 7104 9922 Germany\ +49 30 5679 5800 Germany\ +1 669 900 6833 US (San Jose)\ +1 253 215 8782 US (Tacoma)\ +1 301 715 8592 US (Germantown)\ +1 312 626 6799 US (Chicago)\ +1 346 248 7799 US (Houston)\ +1 408 638 0968 US (San Jose)\ +1 646 876 9923 US (New York)\ +36 1 701 0488 Hungary\ +36 1 408 8456 Hungary\ +33 1 7095 0103 France\ +33 1 7095 0350 France\ +33 7 5678 4048 France\ +33 1 7037 2246 France\ +33 1 7037 9729 France\ +31 20 794 6519 Netherlands\ +31 20 794 6520 Netherlands\ +31 20 794 7345 Netherlands\ +31 20 241 0288 Netherlands\ +31 20 794 0854 Netherlands\ +44 203 481 5240 United Kingdom\ +44 131 460 1196 United Kingdom\ +44 203 051 2874 United Kingdom\ +44 203 481 5237 United Kingdom\ +90 216 900 2606 Turkey\ +90 216 900 1866 Turkey\ Meeting ID: xxxxxxxxx\ Find your local number: https://us02web.zoom.us/u/xxxxxxxxx\ \ \ -::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\ Diesen Abschnitt der Beschreibung nicht bearbeiten.\ \ Zeigen Sie Ihren Termin unter https://www.google.com/calendar/event?action=VIEW&eid=OG9rZXIxcXV0ZGc4c2ozb3A4cjRwdjFidHMgcHVyYmFuaWtAYmVub2NzLmNvbQ&tok=MzAjaGFtbWVyc2NobWlkdC51bHxxxxxxxxx&ctz=Europe%2FVienna&hl=de&es=1 an.\ -::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-