Gowler/Masterarbeit
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
Masterarbeit/QuellCode/CentronERP/tests/Centron.Tests.EndToEnd/Tests/IndexSearch/Statements.expected.txt
T
Christoph Schwörer f045b99a25 Codebasis als Dateien ins Arbeitsrepo statt als Gitlink 
QuellCode/CentronERP war nur als Gitlink (Submodul-Referenz auf 79c1142)
getrackt, ohne .gitmodules und ohne erreichbares Remote. Der
Untersuchungsgegenstand der Versuchsreihe war damit nicht reproduzierbar
gesichert: Ein Klon haette ein leeres Verzeichnis erhalten, und die Belege
der 3.287 Anforderungen waeren nicht ueberpruefbar gewesen.

Umstellung:
- Historie nach c:\DEV\CentronERP_git_snapshot_79c1142 ausgelagert
  (vollstaendig lesbar, enthaelt 79c1142 und Vorgaenger 89ccfd6)
- Gitlink aus dem Index entfernt
- Dateiinhalt aufgenommen: 24.557 Dateien, rund 333 MB

Die verschachtelte .gitignore der Codebasis gilt weiter, Build-Artefakte
bleiben ausgeschlossen. Details in Versuche/Versuch_01/_Codebasis-Nachweis.md
2026-08-26 07:43:51 +02:00

58 lines
51 KiB
Plaintext
Raw Permalink Blame History

[
'select objectfull0_.ObjectI3D as col_0_0_ from dbo.ObjectFulltextIndexStats objectfull0_ where objectfull0_.ObjectKind=@p0 and objectfull0_.IsUpdateRequested=1',
'delete from dbo.ObjectFulltextIndex where ObjectKind=@p0 and ObjectI3D=@p1',
'SELECT helpdesk0_.I3D as i1_alias_0_, helpdesk0_.Beschreibung as beschreibung14_alias_0_, helpdesk0_.Problem as problem15_alias_0_, helpdesk0_.InternalNote as internalnote65_alias_0_, helpdesk0_.IsTicketRefused as isticketrefused66_alias_0_, helpdesk0_.VerantwortlicherI3D as verantwortlicheri5_alias_0_, helpdesk0_.AnsprechpartnerI3D as ansprechpartneri46_alias_0_, helpdesk0_.KundeEMail as kundeemail16_alias_0_, helpdesk0_.FaelligAm as faelligam17_alias_0_, helpdesk0_.AbgeschlossenAm as abgeschlossenam18_alias_0_, helpdesk0_.ErfasstAm as erfasstam19_alias_0_, helpdesk0_.inFAQ as infaq20_alias_0_, helpdesk0_.isTemplate as istemplate21_alias_0_, helpdesk0_.TemplateI3D as templatei22_alias_0_, helpdesk0_.TemplatePos as templatepos23_alias_0_, helpdesk0_.LatestHistoryI3D as latesthistoryi24_alias_0_, helpdesk0_.Nummer as nummer25_alias_0_, helpdesk0_.ErstellerI3D as erstelleri9_alias_0_, helpdesk0_.TodoI3D as todoi26_alias_0_, helpdesk0_.ScanDocI3D as scandoci27_alias_0_, helpdesk0_.RechPosI3D as rechposi28_alias_0_, helpdesk0_.AnschriftI3D as anschrifti6_alias_0_, helpdesk0_.SerienNr as seriennr29_alias_0_, helpdesk0_.Berechnet as berechnet30_alias_0_, helpdesk0_.VertragI3D as vertragi31_alias_0_, helpdesk0_.VertragArt as vertragart32_alias_0_, helpdesk0_.LizenzKopfI3D as lizenzkopfi33_alias_0_, helpdesk0_.OutlookModul as outlookmodul34_alias_0_, helpdesk0_.OutlookPrioritaet as outlookprioritaet35_alias_0_, helpdesk0_.ErstelltAus as erstelltaus36_alias_0_, helpdesk0_.Kennzeichen as kennzeichen37_alias_0_, helpdesk0_.Version as version38_alias_0_, helpdesk0_.Verknuepfungsnummer as verknuepfungsnummer39_alias_0_, helpdesk0_.LockUserI3D as lockuseri67_alias_0_, helpdesk0_.LockUser as lockuser40_alias_0_, helpdesk0_.Zusatztext2 as zusatztext41_alias_0_, helpdesk0_.Dokumentation as dokumentation68_alias_0_, helpdesk0_.ErstelltVersion as erstelltversion42_alias_0_, helpdesk0_.GeaendertVonI3D as geaendertvoni10_alias_0_, helpdesk0_.GeaendertDatum as geaendertdatum43_alias_0_, helpdesk0_.GeaendertVersion as geaendertversion44_alias_0_, helpdesk0_.IstRMAFall as istrmafall45_alias_0_, helpdesk0_.AnsprechAnrede as ansprechanrede47_alias_0_, helpdesk0_.AnsprechName as ansprechname48_alias_0_, helpdesk0_.AnsprechTelefon as ansprechtelefon49_alias_0_, helpdesk0_.AnsprechEMail as ansprechemail50_alias_0_, helpdesk0_.KundeName as kundename51_alias_0_, helpdesk0_.KundeStrasse as kundestrasse52_alias_0_, helpdesk0_.KundePLZ as kundeplz53_alias_0_, helpdesk0_.KundeOrt as kundeort54_alias_0_, helpdesk0_.KundeInnendienst as kundeinnendienst55_alias_0_, helpdesk0_.KundeAussendienst as kundeaussendienst56_alias_0_, helpdesk0_.KundeTechniker as kundetechniker57_alias_0_, helpdesk0_.KundeTechniker2 as kundetechniker58_alias_0_, helpdesk0_.AnsprechFax as ansprechfax59_alias_0_, helpdesk0_.hlpdsk_GruppenI3D as hlpdsk60_alias_0_, helpdesk0_.Freitext1 as freitext61_alias_0_, helpdesk0_.FehlerNr as fehlernr62_alias_0_, helpdesk0_.AnlageAufforderung as anlageaufforderung63_alias_0_, helpdesk0_.Bewertung as bewertung64_alias_0_, helpdesk0_.GeplanteDauerInStd as geplantedauerinstd69_alias_0_, helpdesk0_.BearbeitungszeitraumStart as bearbeitungszeitraumstart70_alias_0_, helpdesk0_.BearbeitungszeitraumEnde as bearbeitungszeitraumende71_alias_0_, helpdesk0_.IsOnlyInternalVisible as isonlyinternalvisible72_alias_0_, helpdesk0_.hlpdsk_loesungI3D as hlpdsk73_alias_0_, helpdesk0_.KundeI3D as kundei7_alias_0_, helpdesk0_.Status as status4_alias_0_, helpdesk0_.Prioritaet as prioritaet2_alias_0_, helpdesk0_.hlpdsk_typenI3D as hlpdsk3_alias_0_, helpdesk0_.HauptkategorieI3D as hauptkategoriei11_alias_0_, helpdesk0_.Unterkategorie1I3D as unterkategorie12_alias_0_, helpdesk0_.Unterkategorie2I3D as unterkategorie13_alias_0_, helpdesk0_.FilialI3D as filiali74_alias_0_, helpdesk0_.CreatedFromObjectI3D as createdfromobjecti75_alias_0_, helpdesk0_.CreatedFromObjectKind as createdfromobjectkind76_alias_0_, helpdesk0_.CreatedFromTicketPatternI3D as createdfromticketpatterni77_alias_0_, helpdesk0_.ProjectNumber as projectnumber78_alias_0_, helpdesk0_.CentronFingerprint as centronfingerprint79_alias_0_, helpdesk0_.ParentHelpdeskI3D as parenthelpdeski80_alias_0_, helpdesk0_.ProjectHelpdeskI3D as projecthelpdeski81_alias_0_, helpdesk0_.ArticleWorkItemI3D as articleworkitemi82_alias_0_, helpdesk0_.CFlowStateI3D as cflowstatei83_alias_0_, helpdesk0_.EscalationLevel as escalationlevel84_alias_0_, helpdesk0_.LastCommentDate as lastcommentdate85_alias_0_, helpdesk0_.LastEmailDate as lastemaildate86_alias_0_ FROM dbo.hlpdsk_requests helpdesk0_ WHERE helpdesk0_.I3D=@p0',
'SELECT employeeco0_.I3D as i1_alias_0_, employeeco0_.Status as status2_alias_0_, employeeco0_.Vorname as vorname3_alias_0_, employeeco0_.Name as name4_alias_0_, employeeco0_.KurzZeich as kurzzeich5_alias_0_, employeeco0_.Eintritt as eintritt6_alias_0_, employeeco0_.Austritt as austritt7_alias_0_, employeeco0_.Telefon1 as telefon8_alias_0_, employeeco0_.Email as email9_alias_0_, employeeco0_.VorgesetzterI3D as vorgesetzteri10_alias_0_, employeeco0_.FilialI3D as filiali11_alias_0_, employeeco0_.Dispatcher as dispatcher12_alias_0_, employeeco0_.IsActive as isactive13_alias_0_, employeeco0_.Availability as availability14_alias_0_, employeeco0_.LastAvailabilityChange as lastavailabilitychange15_alias_0_, employeeco0_.Resturlaub as resturlaub16_alias_0_, employeeco0_.Urlaubsanspruch as urlaubsanspruch17_alias_0_, employeeco0_.Personalnummer as personalnummer18_alias_0_, employeeco0_.GraphOdataDeltaLink as graphodatadeltalink19_alias_0_, employeeco0_.SupportLevelI3D as supportleveli20_alias_0_, employeeco0_.Sprachkenntnisse as sprachkenntnisse21_alias_0_ FROM dbo.Personal employeeco0_ WHERE employeeco0_.I3D=@p0',
'SELECT contactper0_.I3D as i1_alias_2_, contactper0_.AnschriftID as anschriftid2_alias_2_, contactper0_.Ansprech as ansprech3_alias_2_, contactper0_.AnsprechVorname as ansprechvorname4_alias_2_, contactper0_.Beruf as beruf5_alias_2_, contactper0_.Tel1 as tel6_alias_2_, contactper0_.Tel2 as tel7_alias_2_, contactper0_.Tel3 as tel8_alias_2_, contactper0_.Tel5 as tel9_alias_2_, contactper0_.Fax1 as fax10_alias_2_, contactper0_.Fax2 as fax11_alias_2_, contactper0_.Email1 as email12_alias_2_, contactper0_.Email2 as email13_alias_2_, contactper0_.Kommentar as kommentar14_alias_2_, contactper0_.Abteilung as abteilung15_alias_2_, contactper0_.AbteilungText as abteilungtext16_alias_2_, contactper0_.AnlaDatum as anladatum17_alias_2_, contactper0_.AnlaBenu as anlabenu18_alias_2_, contactper0_.Status as status19_alias_2_, contactper0_.Mailing1 as mailing20_alias_2_, contactper0_.Mailing2 as mailing21_alias_2_, contactper0_.Geburtsdatum as geburtsdatum22_alias_2_, contactper0_.Standard as standard23_alias_2_, contactper0_.ReferenzKundenI3D as referenzkundeni24_alias_2_, contactper0_.ErstelltVersion as erstelltversion25_alias_2_, contactper0_.GeaendertVonI3D as geaendertvoni26_alias_2_, contactper0_.GeaendertDatum as geaendertdatum27_alias_2_, contactper0_.GeaendertVersion as geaendertversion28_alias_2_, contactper0_.ErstelltDurch as erstelltdurch29_alias_2_, contactper0_.LeadAnsprechpartnerI3D as leadansprechpartneri30_alias_2_, contactper0_.Kommentar2 as kommentar31_alias_2_, contactper0_.Kommentar3 as kommentar32_alias_2_, contactper0_.ActiveDirectorySID as activedirectorysid33_alias_2_, contactper0_.DefaultSubstitute as defaultsubstitute34_alias_2_, contactper0_.RechCCEmpfaenger as rechccempfaenger35_alias_2_, contactper0_.AnredeI3D as anredei36_alias_2_, contactdep1_.I3D as i1_alias_0_, contactdep1_.Abteilung as abteilung2_alias_0_, contactdep1_.Kommentar as kommentar3_alias_0_, contactdep1_.Status as status4_alias_0_, contactdep1_.RepGroup as repgroup5_alias_0_, contactsal2_.I3D as i1_alias_1_, contactsal2_.Anrede as anrede2_alias_1_, contactsal2_.Briefanrede as briefanrede3_alias_1_ FROM dbo.Personen contactper0_ left outer join dbo.Abteilung contactdep1_ on contactper0_.Abteilung=contactdep1_.I3D left outer join dbo.Anrede contactsal2_ on contactper0_.AnredeI3D=contactsal2_.I3D WHERE contactper0_.I3D=@p0',
'SELECT address0_.I3D as i1_alias_0_, address0_.Kunde as kunde2_alias_0_, address0_.Kreditor as kreditor3_alias_0_, address0_.Strasse as strasse4_alias_0_, address0_.Plz as plz5_alias_0_, address0_.Ort as ort6_alias_0_, address0_.Kommentar as kommentar7_alias_0_, address0_.UmsaIdentNr as umsaidentnr8_alias_0_, address0_.Status as status9_alias_0_, address0_.AnschriftArt as anschriftart10_alias_0_, address0_.DruckArt as druckart11_alias_0_, address0_.DruckAnsprech as druckansprech12_alias_0_, address0_.KredRMA as kredrma13_alias_0_, address0_.KundeDefault as kundedefault14_alias_0_, address0_.KreditorDefault as kreditordefault15_alias_0_, address0_.PostfachAktiv as postfachaktiv16_alias_0_, address0_.Postfach as postfach17_alias_0_, address0_.Abteilung as abteilung18_alias_0_, address0_.Sprache as sprache19_alias_0_, address0_.Waehrung as waehrung20_alias_0_, address0_.ErstelltVersion as erstelltversion21_alias_0_, address0_.GeaendertDatum as geaendertdatum22_alias_0_, address0_.GeaendertVonI3D as geaendertvoni23_alias_0_, address0_.GeaendertVersion as geaendertversion24_alias_0_, address0_.ErstelltDurch as erstelltdurch25_alias_0_, address0_.VarAnschrift as varanschrift26_alias_0_, address0_.LeadAnschriftI3D as leadanschrifti27_alias_0_, address0_.DruckAbteilung as druckabteilung28_alias_0_, address0_.DruckAbteilungAnsprech as druckabteilungansprech29_alias_0_, address0_.Land as land30_alias_0_ FROM dbo.Anschrif address0_ WHERE address0_.I3D=@p0',
'SELECT country0_.I3D as i1_alias_0_, country0_.Status as status2_alias_0_, country0_.Standard as standard3_alias_0_, country0_.Land as land4_alias_0_, country0_.PlzKurz as plzkurz5_alias_0_, country0_.Vorwahl as vorwahl6_alias_0_, country0_.Kurzzeichen as kurzzeichen7_alias_0_, country0_.Nummer as nummer8_alias_0_, country0_.Waehrung as waehrung9_alias_0_, country0_.Zeichen as zeichen10_alias_0_, country0_.RWZeichen as rwzeichen11_alias_0_, country0_.KursZuEur as kurszueur12_alias_0_, country0_.Kurztext as kurztext13_alias_0_, country0_.ErloesKTO as erloeskto14_alias_0_, country0_.AufwandKTO as aufwandkto15_alias_0_, country0_.ErstelltVonI3D as erstelltvoni16_alias_0_, country0_.ErstelltDatum as erstelltdatum17_alias_0_, country0_.ErstelltVersion as erstelltversion18_alias_0_, country0_.GeaendertVonI3D as geaendertvoni19_alias_0_, country0_.GeaendertDatum as geaendertdatum20_alias_0_, country0_.GeaendertVersion as geaendertversion21_alias_0_, country0_.EUMitglied as eumitglied22_alias_0_, country0_.ISOCodeNummerisch as isocodenummerisch23_alias_0_, country0_.Flagge as flagge24_alias_0_, country0_.FlaggeExt as flaggeext25_alias_0_, country0_.MenueVerfueg as menueverfueg26_alias_0_ FROM dbo.Laenkenn country0_ WHERE country0_.I3D=@p0',
'SELECT employeeco0_.I3D as i1_alias_0_, employeeco0_.Status as status2_alias_0_, employeeco0_.Vorname as vorname3_alias_0_, employeeco0_.Name as name4_alias_0_, employeeco0_.KurzZeich as kurzzeich5_alias_0_, employeeco0_.Eintritt as eintritt6_alias_0_, employeeco0_.Austritt as austritt7_alias_0_, employeeco0_.Telefon1 as telefon8_alias_0_, employeeco0_.Email as email9_alias_0_, employeeco0_.VorgesetzterI3D as vorgesetzteri10_alias_0_, employeeco0_.FilialI3D as filiali11_alias_0_, employeeco0_.Dispatcher as dispatcher12_alias_0_, employeeco0_.IsActive as isactive13_alias_0_, employeeco0_.Availability as availability14_alias_0_, employeeco0_.LastAvailabilityChange as lastavailabilitychange15_alias_0_, employeeco0_.Resturlaub as resturlaub16_alias_0_, employeeco0_.Urlaubsanspruch as urlaubsanspruch17_alias_0_, employeeco0_.Personalnummer as personalnummer18_alias_0_, employeeco0_.GraphOdataDeltaLink as graphodatadeltalink19_alias_0_, employeeco0_.SupportLevelI3D as supportleveli20_alias_0_, employeeco0_.Sprachkenntnisse as sprachkenntnisse21_alias_0_ FROM dbo.Personal employeeco0_ WHERE employeeco0_.I3D=@p0',
'SELECT helpdeskst0_.I3D as i1_alias_0_, helpdeskst0_.Number as number2_alias_0_, helpdeskst0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskst0_.Beschreibung as beschreibung4_alias_0_, helpdeskst0_.Status as status5_alias_0_, helpdeskst0_.Icon as icon6_alias_0_, helpdeskst0_.Deactivated as deactivated7_alias_0_, helpdeskst0_.InternalCompanyBillingActive as internalcompanybillingactive8_alias_0_, helpdeskst0_.ServiceBoardWebColor as serviceboardwebcolor9_alias_0_, helpdeskst0_.ServiceBoardWebIcon as serviceboardwebicon10_alias_0_ FROM dbo.hlpdsk_status helpdeskst0_ WHERE helpdeskst0_.I3D=@p0',
'SELECT helpdeskpr0_.I3D as i1_alias_0_, helpdeskpr0_.Bezeichnung as bezeichnung2_alias_0_, helpdeskpr0_.Number as number19_alias_0_, helpdeskpr0_.Beschreibung as beschreibung3_alias_0_, helpdeskpr0_.Werktage as werktage4_alias_0_, helpdeskpr0_.Stunde2 as stunde5_alias_0_, helpdeskpr0_.Stunde3 as stunde6_alias_0_, helpdeskpr0_.Status as status7_alias_0_, helpdeskpr0_.ErstelltDatum as erstelltdatum8_alias_0_, helpdeskpr0_.ErstelltVonI3d as erstelltvoni17_alias_0_, helpdeskpr0_.ErstelltVersion as erstelltversion9_alias_0_, helpdeskpr0_.GeaendertDatum as geaendertdatum10_alias_0_, helpdeskpr0_.GeaendertVonI3D as geaendertvoni18_alias_0_, helpdeskpr0_.GeaendertVersion as geaendertversion11_alias_0_, helpdeskpr0_.EskalationSa as eskalationsa12_alias_0_, helpdeskpr0_.EskalationSo as eskalationso13_alias_0_, helpdeskpr0_.GeschaeftsZeitVon as geschaeftszeitvon14_alias_0_, helpdeskpr0_.GeschaeftsZeitBis as geschaeftszeitbis15_alias_0_, helpdeskpr0_.Farbe as farbe16_alias_0_, helpdeskpr0_.FaeligkeitVerzoegerung as faeligkeitverzoegerung20_alias_0_, helpdeskpr0_.IsSLA as issla21_alias_0_, helpdeskpr0_.Deactivated as deactivated22_alias_0_, helpdeskpr0_.ServiceBoardWebColor as serviceboardwebcolor23_alias_0_, helpdeskpr0_.ServiceBoardWebIcon as serviceboardwebicon24_alias_0_ FROM dbo.hlpdsk_prioritaeten helpdeskpr0_ WHERE helpdeskpr0_.I3D=@p0',
'SELECT helpdeskty0_.I3D as i1_alias_0_, helpdeskty0_.Nummer as nummer2_alias_0_, helpdeskty0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskty0_.Beschreibung as beschreibung4_alias_0_, helpdeskty0_.Farbe as farbe5_alias_0_, helpdeskty0_.Deactivated as deactivated6_alias_0_, helpdeskty0_.ServiceBoardWebColor as serviceboardwebcolor7_alias_0_, helpdeskty0_.ServiceBoardWebIcon as serviceboardwebicon8_alias_0_ FROM dbo.hlpdsk_typen helpdeskty0_ WHERE helpdeskty0_.I3D=@p0',
'SELECT helpdeskca0_.I3D as i1_alias_0_, helpdeskca0_.Nummer as nummer2_alias_0_, helpdeskca0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskca0_.Beschreibung as beschreibung4_alias_0_, helpdeskca0_.Status as status5_alias_0_, helpdeskca0_.ParentI3D as parenti6_alias_0_, helpdeskca0_.Deactivated as deactivated7_alias_0_, helpdeskca0_.ServiceBoardWebColor as serviceboardwebcolor8_alias_0_, helpdeskca0_.ServiceBoardWebIcon as serviceboardwebicon9_alias_0_ FROM dbo.hlpdsk_kategorien helpdeskca0_ WHERE helpdeskca0_.I3D=@p0',
'SELECT helpdeskca0_.I3D as i1_alias_0_, helpdeskca0_.Nummer as nummer2_alias_0_, helpdeskca0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskca0_.Beschreibung as beschreibung4_alias_0_, helpdeskca0_.Status as status5_alias_0_, helpdeskca0_.ParentI3D as parenti6_alias_0_, helpdeskca0_.Deactivated as deactivated7_alias_0_, helpdeskca0_.ServiceBoardWebColor as serviceboardwebcolor8_alias_0_, helpdeskca0_.ServiceBoardWebIcon as serviceboardwebicon9_alias_0_ FROM dbo.hlpdsk_kategorien helpdeskca0_ WHERE helpdeskca0_.I3D=@p0',
'SELECT helpdeskca0_.I3D as i1_alias_0_, helpdeskca0_.Nummer as nummer2_alias_0_, helpdeskca0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskca0_.Beschreibung as beschreibung4_alias_0_, helpdeskca0_.Status as status5_alias_0_, helpdeskca0_.ParentI3D as parenti6_alias_0_, helpdeskca0_.Deactivated as deactivated7_alias_0_, helpdeskca0_.ServiceBoardWebColor as serviceboardwebcolor8_alias_0_, helpdeskca0_.ServiceBoardWebIcon as serviceboardwebicon9_alias_0_ FROM dbo.hlpdsk_kategorien helpdeskca0_ WHERE helpdeskca0_.I3D=@p0',
'SELECT helpdeskti0_.RequestI3D as requesti3_alias_9_, helpdeskti0_.I3D as i1_alias_9_, helpdeskti0_.I3D as i1_alias_8_, helpdeskti0_.RequestI3D as requesti3_alias_8_, helpdeskti0_.PersonalI3D as personali7_alias_8_, helpdeskti0_.CreatedDate as createddate22_alias_8_, helpdeskti0_.CreatedVersion as createdversion23_alias_8_, helpdeskti0_.Bemerkung as bemerkung8_alias_8_, helpdeskti0_.InterneNotiz as internenotiz9_alias_8_, helpdeskti0_.Berechenbar as berechenbar10_alias_8_, helpdeskti0_.Start as start4_alias_8_, helpdeskti0_.Stop as stop5_alias_8_, helpdeskti0_.Status as status2_alias_8_, helpdeskti0_.Timer as timer6_alias_8_, helpdeskti0_.Bewertung as bewertung24_alias_8_, helpdeskti0_.DeviceI3D as devicei25_alias_8_, helpdeskti0_.hlpdsk_timer_typenI3D as hlpdsk11_alias_8_, helpdeskti0_.ReferenceOrderItemI3D as referenceorderitemi15_alias_8_, helpdeskti0_.LiefPosI3D as liefposi26_alias_8_, helpdeskti0_.RechPosI3D as rechposi27_alias_8_, helpdeskti0_.AufPosI3D as aufposi28_alias_8_, helpdeskti0_.ArtikelI3D as artikeli12_alias_8_, helpdeskti0_.Geplant as geplant13_alias_8_, helpdeskti0_.Gedruckt as gedruckt14_alias_8_, helpdeskti0_.IsSigned as issigned18_alias_8_, helpdeskti0_.LunchTime as lunchtime29_alias_8_, helpdeskti0_.ContractI3D as contracti16_alias_8_, helpdeskti0_.BillingStateI3D as billingstatei30_alias_8_, helpdeskti0_.SentAt as sentat17_alias_8_, helpdeskti0_.DocumentI3D as documenti19_alias_8_, helpdeskti0_.ParentI3D as parenti20_alias_8_, helpdeskti0_.PlannedDurationInMinutes as planneddurationinminutes31_alias_8_, helpdeskti0_.ProgressInPercent as progressinpercent32_alias_8_, helpdeskti0_.ArticleWorkItemI3D as articleworkitemi21_alias_8_, helpdeskti0_.AiTextRatingJson as aitextratingjson33_alias_8_, employeeco1_.I3D as i1_alias_0_, employeeco1_.Status as status2_alias_0_, employeeco1_.Vorname as vorname3_alias_0_, employeeco1_.Name as name4_alias_0_, employeeco1_.KurzZeich as kurzzeich5_alias_0_, employeeco1_.Eintritt as eintritt6_alias_0_, employeeco1_.Austritt as austritt7_alias_0_, employeeco1_.Telefon1 as telefon8_alias_0_, employeeco1_.Email as email9_alias_0_, employeeco1_.VorgesetzterI3D as vorgesetzteri10_alias_0_, employeeco1_.FilialI3D as filiali11_alias_0_, employeeco1_.Dispatcher as dispatcher12_alias_0_, employeeco1_.IsActive as isactive13_alias_0_, employeeco1_.Availability as availability14_alias_0_, employeeco1_.LastAvailabilityChange as lastavailabilitychange15_alias_0_, employeeco1_.Resturlaub as resturlaub16_alias_0_, employeeco1_.Urlaubsanspruch as urlaubsanspruch17_alias_0_, employeeco1_.Personalnummer as personalnummer18_alias_0_, employeeco1_.GraphOdataDeltaLink as graphodatadeltalink19_alias_0_, employeeco1_.SupportLevelI3D as supportleveli20_alias_0_, employeeco1_.Sprachkenntnisse as sprachkenntnisse21_alias_0_, article2_.I3D as i1_alias_1_, article2_.Status as status2_alias_1_, article2_.Artikelcode as artikelcode4_alias_1_, article2_.Hersteller as hersteller5_alias_1_, article2_.EANCode as eancode6_alias_1_, article2_.MailTo as mailto70_alias_1_, article2_.Lieferbar as lieferbar36_alias_1_, article2_.NichtRabattierbar as nichtrabattierbar39_alias_1_, article2_.Carepack as carepack37_alias_1_, article2_.TonerArtikel as tonerartikel71_alias_1_, article2_.TonerArtikelDeckung as tonerartikeldeckung72_alias_1_, article2_.TonerArtikelSeiten as tonerartikelseiten73_alias_1_, article2_.FrachtfuehrerI3D as frachtfuehreri74_alias_1_, article2_.FrachtfuehrerLimit as frachtfuehrerlimit75_alias_1_, article2_.SondervereinbarungsPflichtig as sondervereinbarungspflichtig76_alias_1_, article2_.Laenge as laenge77_alias_1_, article2_.Breite as breite78_alias_1_, article2_.Hoehe as hoehe79_alias_1_, article2_.Volumen as volumen80_alias_1_, article2_.ZaehlerArtikel as zaehlerartikel35_alias_1_, article2_.Farbe as farbe81_alias_1_, article2_.FertigungsInfo as fertigungsinfo82_alias_1_, article2_.FertigungsInfoAnzeigen as fertigungsinfoanzeigen83_alias_1_, article2_.Fertigungsware as fertigungsware60_alias_1_, article2_.Kurzbegriff as kurzbegriff7_alias_1_, article2_.Artikelbeschreibung as artikelbeschreibung8_alias_1_, article2_.Warengruppe as warengruppe9_alias_1_, article2_.WEBKategorie as webkategorie10_alias_1_, article2_.DocBeeTicketTemplateID as docbeetickettemplateid84_alias_1_, article2_.StkListe as stkliste49_alias_1_, article2_.StkListeFesteVKs as stklistefestevks46_alias_1_, article2_.KreditorI3D as kreditori29_alias_1_, article2_.Garantie1Wert as garantie85_alias_1_, article2_.Garantie1Art as garantie86_alias_1_, article2_.Garantie2Wert as garantie87_alias_1_, article2_.Garantie2Art as garantie88_alias_1_, article2_.VPE as vpe89_alias_1_, article2_.TextAenderbar as textaenderbar27_alias_1_, article2_.EKGleichVK as ekgleichvk11_alias_1_, article2_.Produktionsbestand as produktionsbestand90_alias_1_, article2_.UrsprungsLandI3d as ursprungslandi91_alias_1_, article2_.Warennummer as warennummer92_alias_1_, article2_.EinkInfo as einkinfo93_alias_1_, article2_.ProjectOffersText as projectofferstext94_alias_1_, article2_.QSInfo as qsinfo95_alias_1_, article2_.GespInfo as gespinfo96_alias_1_, article2_.ALieferantI3D as alieferanti97_alias_1_, article2_.BLieferantI3D as blieferanti98_alias_1_, article2_.CLieferantI3D as clieferanti99_alias_1_, article2_.Zulauf as zulauf21_alias_1_, article2_.LagerStkListe as lagerstkliste100_alias_1_, article2_.SNStueckliste as snstueckliste64_alias_1_, article2_.Mindestbestellmenge as mindestbestellmenge101_alias_1_, article2_.Preisupdate as preisupdate44_alias_1_, article2_.EOLauto as eolauto45_alias_1_, article2_.VarAttributes as varattributes102_alias_1_, article2_.isReverseCharge as isreversecharge50_alias_1_, article2_.KeinMischEK as keinmischek103_alias_1_, article2_.WEBArtik as webartik57_alias_1_, article2_.ArticleSync as articlesync58_alias_1_, article2_.FolgeArtikel as folgeartikel104_alias_1_, article2_.DocI3D as doci105_alias_1_, article2_.Geandert_am as geandert31_alias_1_, article2_.Geandert_von as geandert32_alias_1_, article2_.Angelegt_am as angelegt33_alias_1_, article2_.Angelegt_von as angelegt34_alias_1_, article2_.Nachkommastellen as nachkommastellen26_alias_1_, article2_.Mindestbestand as mindestbestand18_alias_1_, article2_.VK_1 as vk12_alias_1_, article2_.VK_2 as vk13_alias_1_, article2_.VK_3 as vk14_alias_1_, article2_.VK_4 as vk15_alias_1_, article2_.EVK as evk16_alias_1_, article2_.Listenpreis as listenpreis22_alias_1_, article2_.EK as ek23_alias_1_, article2_.MWStI3D as mwsti24_alias_1_, article2_.Mwst_Satz as mwst25_alias_1_, article2_.RohEK1 as rohek106_alias_1_, article2_.RohEK1Datum as rohek107_alias_1_, article2_.RohEK2 as rohek108_alias_1_, article2_.RohEK2Datum as rohek109_alias_1_, article2_.RohEK1I3D as rohek110_alias_1_, article2_.RohEK1Art as rohek111_alias_1_, article2_.RohEK2I3D as rohek112_alias_1_, article2_.RohEK2Art as rohek113_alias_1_, article2_.Einheit as einheit53_alias_1_, article2_.FremdwaehrungLandI3D as fremdwaehrunglandi56_alias_1_, article2_.FremdwaehrungFaktor as fremdwaehrungfaktor63_alias_1_, article2_.ErloesKTO as erloeskto114_alias_1_, article2_.EUErloesKTO as euerloeskto115_alias_1_, article2_.AuslandErloesKTO as auslanderloeskto116_alias_1_, article2_.RCErloesKTO as rcerloeskto117_alias_1_, article2_.AufwandKTO as aufwandkto118_alias_1_, article2_.EUAufwandKTO as euaufwandkto119_alias_1_, article2_.AuslandAufwandKTO as auslandaufwandkto120_alias_1_, article2_.RCAufwandKTO as rcaufwandkto121_alias_1_, article2_.Kostenstelle as kostenstelle122_alias_1_, article2_.Kostentraeger as kostentraeger123_alias_1_, article2_.WEEE as weee124_alias_1_, article2_.WEEEPflicht as weeepflicht125_alias_1_, article2_.KeineProduktfamilienPflicht as keineproduktfamilienpflicht126_alias_1_, article2_.ProduktfamilieI3D as produktfamiliei54_alias_1_, article2_.Produktlinie as produktlinie55_alias_1_, article2_.VertriebsInfo as vertriebsinfo127_alias_1_, article2_.VertriebsInfoAnzeigen as vertriebsinfoanzeigen128_alias_1_, article2_.Auftragsbestand as auftragsbestand19_alias_1_, article2_.LieferBestand as lieferbestand20_alias_1_, article2_.Reparaturbestand as reparaturbestand129_alias_1_, article2_.LagerortI3D as lagerorti130_alias_1_, article2_.LagerplatzI3D as lagerplatzi131_alias_1_, article2_.Lieferzeit as lieferzeit132_alias_1_, article2_.EOL as eol3_alias_1_, article2_.Abbuchung as abbuchung30_alias_1_, article2_.BarcodeScanen as barcodescanen28_alias_1_, article2_.Gesperrt as gesperrt43_alias_1_, article2_.Kommisionieren as kommisionieren47_alias_1_, article2_.Montieren as montieren48_alias_1_, article2_.IsObligatoryBooking as isobligatorybooking133_alias_1_, article2_.Nettogewicht as nettogewicht134_alias_1_, article2_.Bruttogewicht as bruttogewicht135_alias_1_, article2_.SpezGewicht as spezgewicht136_alias_1_, article2_.VK1_ErtragBasis as vk137_alias_1_, article2_.VK2_ErtragBasis as vk138_alias_1_, article2_.VK3_ErtragBasis as vk139_alias_1_, article2_.VK4_ErtragBasis as vk140_alias_1_, article2_.SondervereinbarungsI3D as sondervereinbarungsi141_alias_1_, article2_.Bild1 as bild142_alias_1_, article2_.Bild1Ext as bild143_alias_1_, article2_.Bild2 as bild144_alias_1_, article2_.Bild2Ext as bild145_alias_1_, article2_.Bild3 as bild146_alias_1_, article2_.Bild3Ext as bild147_alias_1_, article2_.Bild4 as bild148_alias_1_, article2_.Bild4Ext as bild149_alias_1_, article2_.Teilbar as teilbar42_alias_1_, article2_.IsArbeitswert as isarbeitswert38_alias_1_, article2_.AWRundung as awrundung69_alias_1_, article2_.AWFaktor as awfaktor40_alias_1_, article2_.Mindestpreis as mindestpreis17_alias_1_, article2_.LizenznehmerEintragen as lizenznehmereintragen150_alias_1_, article2_.ZubehoerArtikAutoEinfuegen as zubehoerartikautoeinfuegen151_alias_1_, article2_.EKgiltBis as ekgiltbis152_alias_1_, article2_.WEUeberpruefung as weueberpruefung51_alias_1_, article2_.HinweisText as hinweistext153_alias_1_, article2_.HinweisBei as hinweisbei154_alias_1_, article2_.RMAAnschrift as rmaanschrift155_alias_1_, article2_.RMAAnschriftI3D as rmaanschrifti156_alias_1_, article2_.RMACustomAnschrift as rmacustomanschrift157_alias_1_, article2_.RMALieferantI3D as rmalieferanti158_alias_1_, article2_.RMAPersonI3D as rmapersoni159_alias_1_, article2_.KlassenI3D1 as klasseni160_alias_1_, article2_.KlassenI3D2 as klasseni161_alias_1_, article2_.VKDatum as vkdatum162_alias_1_, article2_.isMietPortal as ismietportal41_alias_1_, article2_.CustomsNumber as customsnumber163_alias_1_, article2_.IntrastatNumber as intrastatnumber164_alias_1_, article2_.Maintenance as maintenance165_alias_1_, article2_.MaintenanceKind as maintenancekind166_alias_1_, article2_.MaintenanceArticleI3D as maintenancearticlei167_alias_1_, article2_.IsServiceArticle as isservicearticle52_alias_1_, article2_.CombineAdditionalItemsToPartList as combineadditionalitemstopartlist168_alias_1_, article2_.AdditionalItemsPartListI3D as additionalitemspartlisti169_alias_1_, article2_.IsContractArticle as iscontractarticle59_alias_1_, article2_.ContractArticleDurationTime as contractarticledurationtime170_alias_1_, article2_.ContractArticleDurationKind as contractarticledurationkind171_alias_1_, article2_.DefaultArticleSearchQuantity as defaultarticlesearchquantity172_alias_1_, article2_.NoEarlyPaymentDiscountAllowed as noearlypaymentdiscountallowed61_alias_1_, article2_.HasWorkItems as hasworkitems62_alias_1_, article2_.UpdateVKsInPartList as updatevksinpartlist173_alias_1_, article2_.WebCartAdditionalInfo as webcartadditionalinfo174_alias_1_, article2_.WebCartDataSheetUrl as webcartdatasheeturl175_alias_1_, article2_.IsAIEdited as isaiedited66_alias_1_, article2_.ParentArticleI3D as parentarticlei67_alias_1_, receiptcon3_.I3D as i1_alias_2_, receiptcon3_.Number as number2_alias_2_, receiptcon3_.State as state3_alias_2_, receiptcon3_.Date as date4_alias_2_, receiptcon3_.CustomerI3D as customeri5_alias_2_, receiptcon3_.MandatI3D as mandati6_alias_2_, receiptcon3_.Customer as customer7_alias_2_, receiptcon3_.SalesRepresentative as salesrepresentative8_alias_2_, receiptcon3_.OfficeStaff as officestaff9_alias_2_, receiptcon3_.ContractKindI3D as contractkindi10_alias_2_, receiptcon3_.BillingIntervalDuration as billingintervalduration11_alias_2_, receiptcon3_.BillingIntervalKind as billingintervalkind12_alias_2_, receiptcon3_.CounterIntervalDuration as counterintervalduration13_alias_2_, receiptcon3_.CounterIntervalKind as counterintervalkind14_alias_2_, receiptcon3_.CounterBillingKind as counterbillingkind15_alias_2_, receiptcon3_.CollectInvoice as collectinvoice16_alias_2_, receiptcon3_.ContractBegin as contractbegin17_alias_2_, receiptcon3_.FirstPaidDate as firstpaiddate18_alias_2_, receiptcon3_.LastPaidDate as lastpaiddate19_alias_2_, receiptcon3_.ContractEnd as contractend20_alias_2_, receiptcon3_.ContractTermination as contracttermination21_alias_2_, receiptcon3_.AutomatedBilling as automatedbilling22_alias_2_, receiptcon3_.AutomatedProlongation as automatedprolongation23_alias_2_, receiptcon3_.BillingKind as billingkind24_alias_2_, receiptcon3_.SendKind as sendkind25_alias_2_, receiptcon3_.SendKindCustomer as sendkindcustomer26_alias_2_, receiptcon3_.IsNormalize as isnormalize27_alias_2_, receiptcon3_.IsFullNormalizeAmount as isfullnormalizeamount28_alias_2_, receiptcon3_.InvoiceAddress as invoiceaddress29_alias_2_, receiptcon3_.InvoiceAddressCustomerI3D as invoiceaddresscustomeri30_alias_2_, receiptcon3_.InvoiceAddressAddressI3D as invoiceaddressaddressi31_alias_2_, receiptcon3_.InvoiceAddressContactPersonI3D as invoiceaddresscontactpersoni32_alias_2_, receiptcon3_.InvoiceAddressInformation as invoiceaddressinformation33_alias_2_, receiptcon3_.LicenseeAddress as licenseeaddress34_alias_2_, receiptcon3_.LicenseeAddressCustomerI3D as licenseeaddresscustomeri35_alias_2_, receiptcon3_.LicenseeAddressAddressI3D as licenseeaddressaddressi36_alias_2_, receiptcon3_.LicenseeAddressContactPersonI3D as licenseeaddresscontactpersoni37_alias_2_, receiptcon3_.LicenseeAddressInformation as licenseeaddressinformation38_alias_2_, receiptcon3_.Name as name39_alias_2_, receiptcon3_.ContractKindName as contractkindname40_alias_2_, receiptcon3_.ForeignContract as foreigncontract41_alias_2_, receiptcon3_.Receiver as receiver42_alias_2_, receiptcon3_.ReceiptConditionI3D as receiptconditioni43_alias_2_, receiptcon3_.ReceiptConditionText as receiptconditiontext44_alias_2_, receiptcon3_.DeliveryConditionI3D as deliveryconditioni45_alias_2_, receiptcon3_.DeliveryConditionText as deliveryconditiontext46_alias_2_, receiptcon3_.CurrencyI3D as currencyi47_alias_2_, receiptcon3_.CurrencyFactor as currencyfactor48_alias_2_, receiptcon3_.CurrencyString as currencystring49_alias_2_, receiptcon3_.ReferenceNumber as referencenumber50_alias_2_, receiptcon3_.MailRecipient as mailrecipient51_alias_2_, receiptcon3_.AlternativeMailRecipientI3D as alternativemailrecipienti52_alias_2_, receiptcon3_.AlternativeMailCCRecipients as alternativemailccrecipients53_alias_2_, receiptcon3_.ExtraKind as extrakind54_alias_2_, receiptcon3_.AlternativeReportI3D as alternativereporti55_alias_2_, receiptcon3_.LastInvoiceID as lastinvoiceid56_alias_2_, receiptcon3_.BillingToDoOffset as billingtodooffset57_alias_2_, receiptcon3_.CalculationKind as calculationkind58_alias_2_, receiptcon3_.CalcNeedKind as calcneedkind59_alias_2_, receiptcon3_.Prolongation as prolongation60_alias_2_, receiptcon3_.TerminationDeadlineKind1 as terminationdeadlinekind61_alias_2_, receiptcon3_.TerminationDeadlineKind2 as terminationdeadlinekind62_alias_2_, receiptcon3_.TerminationDeadlineDuration1 as terminationdeadlineduration63_alias_2_, receiptcon3_.TerminationDeadlineDuration2 as terminationdeadlineduration64_alias_2_, receiptcon3_.BranchI3D as branchi65_alias_2_, receiptcon3_.Branch as branch66_alias_2_, receiptcon3_.PurchaseOrderNumber as purchaseordernumber67_alias_2_, receiptcon3_.ProjectNumber as projectnumber68_alias_2_, receiptcon3_.ContingentBillingContractI3D as contingentbillingcontracti69_alias_2_, receiptcon3_.NetPrice as netprice70_alias_2_, receiptcon3_.NetPriceFC as netpricefc71_alias_2_, receiptcon3_.NetPriceFCComplete as netpricefccomplete72_alias_2_, receiptcon3_.CalculationPrio as calculationprio73_alias_2_, receiptcon3_.AddContingent as addcontingent74_alias_2_, receiptcon3_.CreateInvoiceOnCorporation as createinvoiceoncorporation75_alias_2_, articlewor4_.I3D as i1_alias_3_, articlewor4_.SortOrder as sortorder2_alias_3_, articlewor4_.ObjectKind as objectkind3_alias_3_, articlewor4_.ObjectI3D as objecti4_alias_3_, articlewor4_.Caption as caption5_alias_3_, articlewor4_.TextInRTF as textinrtf6_alias_3_, articlewor4_.DurationInHours as durationinhours7_alias_3_, articlewor4_.TicketPatternI3D as ticketpatterni8_alias_3_, articlewor4_.Price as price9_alias_3_, articlewor4_.PriceIsIncluded as priceisincluded10_alias_3_, articlewor4_.BillingArticleI3D as billingarticlei11_alias_3_, articlewor4_.CategoryI3D as categoryi12_alias_3_, articlewor4_.PurchasePrice as purchaseprice13_alias_3_, articlewor4_.OriginWorkItemI3D as originworkitemi14_alias_3_, articlewor4_.FixDurationForServiceEmployee as fixdurationforserviceemployee15_alias_3_, materialgr5_.I3D as i1_alias_4_, materialgr5_.Status as status2_alias_4_, materialgr5_.Warengruppe as warengruppe3_alias_4_, materialgr5_.Bezeichnung as bezeichnung4_alias_4_, materialgr5_.ErloesKTO as erloeskto6_alias_4_, materialgr5_.EUErloesKTO as euerloeskto7_alias_4_, materialgr5_.AuslandErloesKTO as auslanderloeskto8_alias_4_, materialgr5_.AufwandKTO as aufwandkto9_alias_4_, materialgr5_.EUAufwandKTO as euaufwandkto10_alias_4_, materialgr5_.AuslandAufwandKTO as auslandaufwandkto11_alias_4_, materialgr5_.Aufschlag_1 as aufschlag12_alias_4_, materialgr5_.Aufschlag_2 as aufschlag13_alias_4_, materialgr5_.Aufschlag_3 as aufschlag14_alias_4_, materialgr5_.Aufschlag_4 as aufschlag15_alias_4_, materialgr5_.Aufschlag_Evk as aufschlag16_alias_4_, materialgr5_.Aufschlag_Minpreis as aufschlag17_alias_4_, materialgr5_.Kommisionieren as kommisionieren18_alias_4_, materialgr5_.LagerI3D as lageri19_alias_4_, materialgr5_.LagerortI3D as lagerorti20_alias_4_, materialgr5_.LagerplatzI3D as lagerplatzi21_alias_4_, materialgr5_.StandardErtrag as standardertrag22_alias_4_, materialgr5_.NormAbwErtrag as normabwertrag23_alias_4_, materialgr5_.VK1_ErtragBasis as vk24_alias_4_, materialgr5_.VK2_ErtragBasis as vk25_alias_4_, materialgr5_.VK3_ErtragBasis as vk26_alias_4_, materialgr5_.VK4_ErtragBasis as vk27_alias_4_, materialgr5_.RCAufwandKTO as rcaufwandkto28_alias_4_, materialgr5_.RCErloesKTO as rcerloeskto29_alias_4_, materialgr5_.EinheitI3D as einheiti30_alias_4_, materialgr5_.KostenstelleI3D as kostenstellei31_alias_4_, materialgr5_.KostentraegerI3D as kostentraegeri32_alias_4_, materialgr5_.Nachkommastellen as nachkommastellen33_alias_4_, materialgr5_.ProvProz as provproz34_alias_4_, materialgr5_.ProvArt as provart35_alias_4_, materialgr5_.Lieferzeit as lieferzeit36_alias_4_, materialgr5_.VPE as vpe37_alias_4_, materialgr5_.TextAenderbar as textaenderbar38_alias_4_, materialgr5_.WebAenderbar as webaenderbar39_alias_4_, materialgr5_.ArticleSync as articlesync40_alias_4_, materialgr5_.SNbeiWarenabgang as snbeiwarenabgang41_alias_4_, materialgr5_.Lieferbar as lieferbar42_alias_4_, materialgr5_.EkgleichVk as ekgleichvk43_alias_4_, materialgr5_.Abbuchung as abbuchung44_alias_4_, materialgr5_.Teilbar as teilbar45_alias_4_, materialgr5_.Montieren as montieren46_alias_4_, materialgr5_.Garantie1Wert as garantie47_alias_4_, materialgr5_.Garantie1Art as garantie48_alias_4_, materialgr5_.Garantie2Wert as garantie49_alias_4_, materialgr5_.Garantie2Art as garantie50_alias_4_, materialgr5_.WEEE as weee51_alias_4_, materialgr5_.WEEEPflicht as weeepflicht52_alias_4_, materialgr5_.EOLauto as eolauto53_alias_4_, materialgr5_.Preisupdate as preisupdate54_alias_4_, materialgr5_.VarAttributes as varattributes55_alias_4_, materialgr5_.KeinMischEK as keinmischek56_alias_4_, materialgr5_.FremdwaehrungLandI3D as fremdwaehrunglandi57_alias_4_, materialgr5_.ProduktfamilienPflicht as produktfamilienpflicht58_alias_4_, materialgr5_.EVPAlsVKEintragen as evpalsvkeintragen59_alias_4_, materialgr5_.MwstI3D as mwsti60_alias_4_, materialgr5_.KeineFracht as keinefracht61_alias_4_, materialgr5_.PauschalWarengruppe as pauschalwarengruppe5_alias_4_, materialgr5_.IsReverseCharge as isreversecharge62_alias_4_, materialgr5_.IsWithCounter as iswithcounter63_alias_4_, materialgr5_.isMietPortal as ismietportal64_alias_4_, materialgr5_.IsServiceArticle as isservicearticle65_alias_4_, materialgr5_.NeedsCustomClearance as needscustomclearance66_alias_4_, materialgr5_.KulanzWarengruppe as kulanzwarengruppe67_alias_4_, materialgr5_.NotDiscountable as notdiscountable68_alias_4_, materialgr5_.IsObligatoryBooking as isobligatorybooking69_alias_4_, materialgr5_.TelekomDiveMaterialGroup as telekomdivematerialgroup70_alias_4_, materialgr5_.DocBeeTicketTemplateID as docbeetickettemplateid71_alias_4_, secondarym6_.I3D as i1_alias_5_, secondarym6_.Status as status2_alias_5_, secondarym6_.WarengruppenI3D as warengruppeni4_alias_5_, secondarym6_.ErloesKTO as erloeskto5_alias_5_, secondarym6_.EUErloesKTO as euerloeskto6_alias_5_, secondarym6_.AuslandErloesKTO as auslanderloeskto7_alias_5_, secondarym6_.AufwandKTO as aufwandkto8_alias_5_, secondarym6_.EUAufwandKTO as euaufwandkto9_alias_5_, secondarym6_.AuslandAufwandKTO as auslandaufwandkto10_alias_5_, secondarym6_.WarenI3D as wareni11_alias_5_, secondarym6_.Text as text3_alias_5_, secondarym6_.Nachkommastellen as nachkommastellen12_alias_5_, secondarym6_.LagerI3D as lageri13_alias_5_, secondarym6_.LagerortI3D as lagerorti14_alias_5_, secondarym6_.LagerplatzI3D as lagerplatzi15_alias_5_, secondarym6_.Lieferzeit as lieferzeit16_alias_5_, secondarym6_.VPE as vpe17_alias_5_, secondarym6_.EinheitI3D as einheiti18_alias_5_, secondarym6_.TextAenderbar as textaenderbar19_alias_5_, secondarym6_.WebAenderbar as webaenderbar20_alias_5_, secondarym6_.ArticleSync as articlesync21_alias_5_, secondarym6_.SNbeiWarenabgang as snbeiwarenabgang22_alias_5_, secondarym6_.Lieferbar as lieferbar23_alias_5_, secondarym6_.EkgleichVk as ekgleichvk24_alias_5_, secondarym6_.Abbuchung as abbuchung25_alias_5_, secondarym6_.Teilbar as teilbar26_alias_5_, secondarym6_.Montieren as montieren27_alias_5_, secondarym6_.Kommisionieren as kommisionieren28_alias_5_, secondarym6_.Garantie1Wert as garantie29_alias_5_, secondarym6_.Garantie1Art as garantie30_alias_5_, secondarym6_.Garantie2Wert as garantie31_alias_5_, secondarym6_.Garantie2Art as garantie32_alias_5_, secondarym6_.Aufschlag_1 as aufschlag33_alias_5_, secondarym6_.Aufschlag_2 as aufschlag34_alias_5_, secondarym6_.Aufschlag_3 as aufschlag35_alias_5_, secondarym6_.Aufschlag_4 as aufschlag36_alias_5_, secondarym6_.Aufschlag_Evk as aufschlag37_alias_5_, secondarym6_.Aufschlag_MinPreis as aufschlag38_alias_5_, secondarym6_.WEEE as weee39_alias_5_, secondarym6_.WEEEPflicht as weeepflicht40_alias_5_, secondarym6_.EOLauto as eolauto41_alias_5_, secondarym6_.PreisUpdate as preisupdate42_alias_5_, secondarym6_.KostenstelleI3D as kostenstellei43_alias_5_, secondarym6_.KostentraegerI3D as kostentraegeri44_alias_5_, secondarym6_.VarAttributes as varattributes45_alias_5_, secondarym6_.KeinMischEK as keinmischek46_alias_5_, secondarym6_.FremdwaehrungLandI3D as fremdwaehrunglandi47_alias_5_, secondarym6_.ProduktfamilienPflicht as produktfamilienpflicht48_alias_5_, secondarym6_.EVPAlsVKEintragen as evpalsvkeintragen49_alias_5_, secondarym6_.MwstI3D as mwsti50_alias_5_, secondarym6_.RCAufwandKTO as rcaufwandkto51_alias_5_, secondarym6_.RCErloesKTO as rcerloeskto52_alias_5_, secondarym6_.KeineFracht as keinefracht53_alias_5_, secondarym6_.IsReverseCharge as isreversecharge54_alias_5_, secondarym6_.IsWithCounter as iswithcounter55_alias_5_, secondarym6_.isMietPortal as ismietportal56_alias_5_, secondarym6_.IsServiceArticle as isservicearticle57_alias_5_, secondarym6_.NeedsCustomClearance as needscustomclearance58_alias_5_, secondarym6_.KulanzWarengruppe as kulanzwarengruppe59_alias_5_, secondarym6_.NotDiscountable as notdiscountable60_alias_5_, secondarym6_.IsObligatoryBooking as isobligatorybooking61_alias_5_, secondarym6_.TelekomDiveMaterialGroup as telekomdivematerialgroup62_alias_5_, secondarym6_.DocBeeTicketTemplateID as docbeetickettemplateid63_alias_5_, valueadded7_.I3D as i1_alias_6_, valueadded7_.Status as status2_alias_6_, valueadded7_.Mwst as mwst3_alias_6_, valueadded7_.Text as text4_alias_6_, valueadded7_.LandI3D as landi5_alias_6_, valueadded7_.ErloesKTO as erloeskto6_alias_6_, valueadded7_.ErloesKTODeak as erloesktodeak7_alias_6_, valueadded7_.MwstStandard as mwststandard8_alias_6_, valueadded7_.Steuerkennziffer as steuerkennziffer9_alias_6_, valueadded7_.AufwandKTO as aufwandkto10_alias_6_, valueadded7_.AufwandKTODeak as aufwandktodeak11_alias_6_, valueadded7_.AblaufDatum as ablaufdatum12_alias_6_, valueadded7_.FolgeMWStI3D as folgemwsti13_alias_6_, valueadded7_.SteuerKZEinkauf as steuerkzeinkauf14_alias_6_, valueadded7_.VerwFuerMwStNichtAusweisbar as verwfuermwstnichtausweisbar15_alias_6_, valueadded7_.GueltigAb as gueltigab16_alias_6_, employeear8_.I3D as i1_alias_7_, employeear8_.ArtikelCode as artikelcode2_alias_7_, employeear8_.StandardArtikel as standardartikel3_alias_7_, employeear8_.SpecialArticleKind as specialarticlekind4_alias_7_, employeear8_.MitarbeiterI3D as mitarbeiteri5_alias_7_, employeear8_.ArtikelI3D as artikeli6_alias_7_ FROM dbo.hlpdsk_timer helpdeskti0_ left outer join dbo.Personal employeeco1_ on helpdeskti0_.PersonalI3D=employeeco1_.I3D left outer join dbo.ARTIK article2_ on helpdeskti0_.ArtikelI3D=article2_.I3D left outer join dbo.cvw_ContractHead receiptcon3_ on helpdeskti0_.ContractI3D=receiptcon3_.I3D left outer join dbo.ArticleWorkItems articlewor4_ on helpdeskti0_.ArticleWorkItemI3D=articlewor4_.I3D left outer join dbo.WAREN materialgr5_ on article2_.Warengruppe=materialgr5_.Warengruppe left outer join dbo.UNTERWAREN secondarym6_ on article2_.WEBKategorie=secondarym6_.I3D left outer join dbo.MwstSatz valueadded7_ on article2_.MWStI3D=valueadded7_.I3D left outer join dbo.Mitarbeiterartikel employeear8_ on article2_.I3D=employeear8_.ArtikelI3D WHERE helpdeskti0_.RequestI3D=@p0',
'SELECT helpdeskti0_.I3D as i1_alias_0_, helpdeskti0_.Nummer as nummer5_alias_0_, helpdeskti0_.Bezeichnung as bezeichnung3_alias_0_, helpdeskti0_.Beschreibung as beschreibung4_alias_0_, helpdeskti0_.WithAddressSpecialArticle as withaddressspecialarticle6_alias_0_, helpdeskti0_.WithCustomerSpecialArticle as withcustomerspecialarticle7_alias_0_, helpdeskti0_.Color as color8_alias_0_, helpdeskti0_.Status as status2_alias_0_, helpdeskti0_.Deactivated as deactivated9_alias_0_, helpdeskti0_.IsDefault as isdefault10_alias_0_, helpdeskti0_.JourneyToRequired as journeytorequired11_alias_0_, helpdeskti0_.JourneyFromRequired as journeyfromrequired12_alias_0_, helpdeskti0_.ServiceBoardWebColor as serviceboardwebcolor13_alias_0_, helpdeskti0_.ServiceBoardWebIcon as serviceboardwebicon14_alias_0_ FROM dbo.hlpdsk_timer_typen helpdeskti0_ WHERE helpdeskti0_.I3D=@p0',
'select helpdeskhi0_.I3D as i1_alias_, helpdeskhi0_.RequestI3D as requesti2_alias_, helpdeskhi0_.Datum as datum3_alias_, helpdeskhi0_.Aktion as aktion4_alias_, helpdeskhi0_.BearbeiterI3D as bearbeiteri5_alias_, helpdeskhi0_.Empfaenger as empfaenger6_alias_, helpdeskhi0_.Loesung as loesung7_alias_, helpdeskhi0_.Bezeichnung as bezeichnung8_alias_, helpdeskhi0_.Beschreibung as beschreibung9_alias_, helpdeskhi0_.HauptkategorieI3D as hauptkategoriei10_alias_, helpdeskhi0_.Unterkategorie1I3D as unterkategorie11_alias_, helpdeskhi0_.Unterkategorie2I3D as unterkategorie12_alias_, helpdeskhi0_.giltAlle as giltalle13_alias_, helpdeskhi0_.KopiePerEMail as kopieperemail14_alias_, helpdeskhi0_.KopiePerSMS as kopiepersms15_alias_, helpdeskhi0_.KopieAnKunde as kopieankunde16_alias_, helpdeskhi0_.LoesungRichtext as loesungrichtext17_alias_, helpdeskhi0_.BeschreibungRichtext as beschreibungrichtext18_alias_, helpdeskhi0_.ActionType as actiontype19_alias_, helpdeskhi0_.Level as level20_alias_, helpdeskhi0_.ObjectKind as objectkind21_alias_, helpdeskhi0_.ObjectI3D as objecti22_alias_, helpdeskhi0_.Sender as sender23_alias_, helpdeskhi0_.AddedEmployeeI3DsCsv as addedemployeei24_alias_, helpdeskhi0_.RemovedEmployeeI3DsCsv as removedemployeei25_alias_, helpdeskhi0_.IsDeleted as isdeleted26_alias_, helpdeskhi0_.ChangedDate as changeddate27_alias_ from dbo.hlpdsk_history helpdeskhi0_ where helpdeskhi0_.RequestI3D=@p0 and not (helpdeskhi0_.IsDeleted=1)',
'SELECT employeeco0_.I3D as i1_alias_0_, employeeco0_.Status as status2_alias_0_, employeeco0_.Vorname as vorname3_alias_0_, employeeco0_.Name as name4_alias_0_, employeeco0_.KurzZeich as kurzzeich5_alias_0_, employeeco0_.Eintritt as eintritt6_alias_0_, employeeco0_.Austritt as austritt7_alias_0_, employeeco0_.Telefon1 as telefon8_alias_0_, employeeco0_.Email as email9_alias_0_, employeeco0_.VorgesetzterI3D as vorgesetzteri10_alias_0_, employeeco0_.FilialI3D as filiali11_alias_0_, employeeco0_.Dispatcher as dispatcher12_alias_0_, employeeco0_.IsActive as isactive13_alias_0_, employeeco0_.Availability as availability14_alias_0_, employeeco0_.LastAvailabilityChange as lastavailabilitychange15_alias_0_, employeeco0_.Resturlaub as resturlaub16_alias_0_, employeeco0_.Urlaubsanspruch as urlaubsanspruch17_alias_0_, employeeco0_.Personalnummer as personalnummer18_alias_0_, employeeco0_.GraphOdataDeltaLink as graphodatadeltalink19_alias_0_, employeeco0_.SupportLevelI3D as supportleveli20_alias_0_, employeeco0_.Sprachkenntnisse as sprachkenntnisse21_alias_0_ FROM dbo.Personal employeeco0_ WHERE employeeco0_.I3D=@p0',
'select TOP (1) rma0_.I3D as i1_alias_, rma0_.Number as number2_alias_, rma0_.AccountI3D as accounti3_alias_, rma0_.AccountName as accountname4_alias_, rma0_.AccountAddressI3D as accountaddressi5_alias_, rma0_.AccountAddressContactPersonI3D as accountaddresscontactpersoni6_alias_, rma0_.RmaKind as rmakind7_alias_, rma0_.HelpdeskI3D as helpdeski8_alias_, rma0_.Description as description9_alias_, rma0_.IsClosed as isclosed10_alias_, rma0_.SupplierNumber as suppliernumber11_alias_, rma0_.SupplierName as suppliername12_alias_, rma0_.SupplierAccountI3D as supplieraccounti13_alias_, rma0_.SupplierAccountName as supplieraccountname14_alias_, rma0_.SupplierAccountAddressI3D as supplieraccountaddressi15_alias_, rma0_.SupplierAccountAddressContactPerson as supplieraccountaddresscontactperson16_alias_, rma0_.RootDirI3D as rootdiri17_alias_, rma0_.CreatedByI3D as createdbyi18_alias_, rma0_.CreatedDate as createddate19_alias_, rma0_.CreatedVersion as createdversion20_alias_, rma0_.ChangedByI3D as changedbyi21_alias_, rma0_.ChangedDate as changeddate22_alias_, rma0_.ChangedVersion as changedversion23_alias_ from dbo.Rma rma0_ where rma0_.HelpdeskI3D=@p0 and (@p1=1 or rma0_.IsClosed<>@p2)',
'select TOP (1) objectfull0_.ObjectI3D as objecti1_alias_, objectfull0_.ObjectKind as objectkind2_alias_, objectfull0_.LastUpdate as lastupdate3_alias_, objectfull0_.IsUpdateRequested as isupdaterequested4_alias_ from dbo.ObjectFulltextIndexStats objectfull0_ where objectfull0_.ObjectKind=@p0 and objectfull0_.ObjectI3D=@p1',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'INSERT INTO dbo.ObjectFulltextIndex (TextValue, ObjectI3D, ObjectKind) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY()',
'UPDATE dbo.ObjectFulltextIndexStats SET LastUpdate = @p0, IsUpdateRequested = @p1 WHERE ObjectI3D = @p2 AND ObjectKind = @p3',
'delete from dbo.ObjectFulltextIndexStats where ObjectKind=@p0 and case when exists (select helpdesk1_.I3D from dbo.hlpdsk_requests helpdesk1_ where helpdesk1_.I3D=dbo.ObjectFulltextIndexStats.ObjectI3D) then 1 else 0 end=@p1',
'delete from dbo.ObjectFulltextIndex where ObjectKind=@p0 and case when exists (select helpdesk1_.I3D from dbo.hlpdsk_requests helpdesk1_ where helpdesk1_.I3D=dbo.ObjectFulltextIndex.ObjectI3D) then 1 else 0 end=@p1',
'select helpdesk0_.I3D as col_0_0_ from dbo.hlpdsk_requests helpdesk0_ where case when exists (select objectfull1_.ObjectI3D, objectfull1_.ObjectKind from dbo.ObjectFulltextIndexStats objectfull1_ where objectfull1_.ObjectKind=@p0 and objectfull1_.ObjectI3D=helpdesk0_.I3D) then 1 else 0 end=@p1 order by helpdesk0_.I3D desc',
'select objectfull0_.ObjectI3D as col_0_0_ from dbo.ObjectFulltextIndexStats objectfull0_ where objectfull0_.ObjectKind=@p0 and objectfull0_.IsUpdateRequested=1',
'delete from dbo.ObjectFulltextIndexStats where ObjectKind=@p0 and case when exists (select account1_.I3D from dbo.Accounts account1_ where account1_.I3D=dbo.ObjectFulltextIndexStats.ObjectI3D) then 1 else 0 end=@p1',
'delete from dbo.ObjectFulltextIndex where ObjectKind=@p0 and case when exists (select account1_.I3D from dbo.Accounts account1_ where account1_.I3D=dbo.ObjectFulltextIndex.ObjectI3D) then 1 else 0 end=@p1',
'select account0_.I3D as col_0_0_ from dbo.Accounts account0_ where case when exists (select objectfull1_.ObjectI3D, objectfull1_.ObjectKind from dbo.ObjectFulltextIndexStats objectfull1_ where objectfull1_.ObjectKind=@p0 and objectfull1_.ObjectI3D=account0_.I3D) then 1 else 0 end=@p1 order by account0_.I3D desc'
]
Reference in New Issue View Git Blame Copy Permalink