Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
SELECT DISTINCT SKUNDEN.NAME1 AS "Name of carrier", ATOUR.TOURNUMMER AS "Tour number", ATOUR.PREISVORGABEBETRAGGS AS "Price for transport", SWAEHRUNG.ISOWAEHRUNGSCODE AS "Currency", MIN(ATASEND.VONLADEDATUM) AS "Loading date", MAX(ATASEND.VONLIEFERDATUM) AS "Unloading date", SHIERARCHIE.EXTERNEREFERENZ1 AS "Team", CONCAT(CONCAT(ATOUR.LKWKZ, '/') ,ATOUR.ANHAENGERKZ) AS "Truck and Trailer number" FROM ATOUR LEFT JOIN SKUNDEN ON SKUNDEN.NR = ATOUR.UNTERNEHMER LEFT JOIN ATASEND ON atour.NR = atasend.TOURNR LEFT JOIN SHIERARCHIE ON SHIERARCHIE.ID = ATOUR.HIERARCHIE LEFT JOIN swaehrung ON SWAEHRUNG.ID = ATOUR.PREISVORGABEWAEHRUNGIDGS GROUP BY SKUNDEN.NAME1, ATOUR.TOURNUMMER, ATOUR.PREISVORGABEBETRAGGS, SWAEHRUNG.ISOWAEHRUNGSCODE, SHIERARCHIE.EXTERNEREFERENZ1, ATOUR.LKWKZ, ATOUR.ANHAENGERKZ ORDER BY ATOUR.TOURNUMMER DESC, MIN(ATASEND.VONLADEDATUM) ASC, MAX(ATASEND.VONLIEFERDATUM);
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
