select tttID, ttName, ttCity, ttTecmoOrder, ttoff, franchise from standings where tttID = AND ttlUID = 1 AND ttsUID = 2004