| 1 |
2.55 ms |
SELECT t0.id AS id_1, t0.belegnr AS belegnr_2, t0.belegdat AS belegdat_3, t0.nlid AS nlid_4, t0.adrcode AS adrcode_5, t0.plzkunde AS plzkunde_6, t0.vortext AS vortext_7, t0.marktid AS marktid_8, t0.internetbnr AS internetbnr_9, t0.nachtext AS nachtext_10, t0.zahlungsart AS zahlungsart_11, t0.bezahltam AS bezahltam_12, t0.gedruckt AS gedruckt_13, t0.kabid AS kabid_14, t0.fiktiv AS fiktiv_15, t0.lastuser AS lastuser_16, t0.lastchange AS lastchange_17 FROM kassenbeleg t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.belegnr AS belegnr_2, t0.belegdat AS belegdat_3, t0.nlid AS nlid_4, t0.adrcode AS adrcode_5, t0.plzkunde AS plzkunde_6, t0.vortext AS vortext_7, t0.marktid AS marktid_8, t0.internetbnr AS internetbnr_9, t0.nachtext AS nachtext_10, t0.zahlungsart AS zahlungsart_11, t0.bezahltam AS bezahltam_12, t0.gedruckt AS gedruckt_13, t0.kabid AS kabid_14, t0.fiktiv AS fiktiv_15, t0.lastuser AS lastuser_16, t0.lastchange AS lastchange_17 FROM kassenbeleg t0 WHERE t0.id = '7796';
|
| 2 |
4.12 ms |
SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.akadtitel AS akadtitel_3, t0.nachname AS nachname_4, t0.vorname AS vorname_5, t0.firmenname AS firmenname_6, t0.taetigkeit AS taetigkeit_7, t0.abteilung AS abteilung_8, t0.adresszusatz AS adresszusatz_9, t0.strasse AS strasse_10, t0.plz AS plz_11, t0.ort AS ort_12, t0.bundesland AS bundesland_13, t0.land AS land_14, t0.kundennummer AS kundennummer_15, t0.adresstyp AS adresstyp_16, t0.geburtsdatum AS geburtsdatum_17, t0.privatdienstl AS privatdienstl_18, t0.notizen AS notizen_19, t0.internetbesteller AS internetbesteller_20, t0.eigeneadresse AS eigeneadresse_21, t0.lastuser AS lastuser_22, t0.lastchange AS lastchange_23 FROM sdadressen t0 ORDER BY t0.nachname ASC, t0.vorname ASC
SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.akadtitel AS akadtitel_3, t0.nachname AS nachname_4, t0.vorname AS vorname_5, t0.firmenname AS firmenname_6, t0.taetigkeit AS taetigkeit_7, t0.abteilung AS abteilung_8, t0.adresszusatz AS adresszusatz_9, t0.strasse AS strasse_10, t0.plz AS plz_11, t0.ort AS ort_12, t0.bundesland AS bundesland_13, t0.land AS land_14, t0.kundennummer AS kundennummer_15, t0.adresstyp AS adresstyp_16, t0.geburtsdatum AS geburtsdatum_17, t0.privatdienstl AS privatdienstl_18, t0.notizen AS notizen_19, t0.internetbesteller AS internetbesteller_20, t0.eigeneadresse AS eigeneadresse_21, t0.lastuser AS lastuser_22, t0.lastchange AS lastchange_23 FROM sdadressen t0 ORDER BY t0.nachname ASC, t0.vorname ASC;
|
| 4 |
2.19 ms |
SELECT t0.id AS id_1, t0.vontag AS vontag_2, t0.bistag AS bistag_3, t0.ort AS ort_4, t0.anlass AS anlass_5, t0.entfernung AS entfernung_6, t0.bemerkung AS bemerkung_7, t0.veranstalter AS veranstalter_8, t0.status AS status_9, t0.lastuser AS lastuser_10, t0.lastchange AS lastchange_11 FROM maerkte t0 ORDER BY t0.vontag DESC
SELECT t0.id AS id_1, t0.vontag AS vontag_2, t0.bistag AS bistag_3, t0.ort AS ort_4, t0.anlass AS anlass_5, t0.entfernung AS entfernung_6, t0.bemerkung AS bemerkung_7, t0.veranstalter AS veranstalter_8, t0.status AS status_9, t0.lastuser AS lastuser_10, t0.lastchange AS lastchange_11 FROM maerkte t0 ORDER BY t0.vontag DESC;
|