Public feed #725740

Unnamed

public sql v1 · immutable
Raw Edit
·published 2007-10-04 17:47 UTC
rendered paste body
SELECT 	id, 	date, 	(SELECT SUBTIME((SELECT arrival_actual FROM delays), (SELECT arrival_planned FROM delays)) AS forsinkelse), 	departure_station AS departureStation, 	departure_planned AS departurePlanned, 	departure_actual AS departureActual, 	arrival_station AS arrivalStation, 	arrival_planned AS arrivalPlanned, 	arrival_actual AS arrivalActualFROM	delaysORDER BY	dateDESC