select tttID, ttName, ttCity, ttTecmoOrder, ttoff, franchise from standings where tttID = 30 - DB AND ttlUID = 1 AND ttsUID = 2008