BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /TrafficCount/trunk/sql/report.sql @ 964

  → /TrafficCount/trunk/sql/report.sql @ 965

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 964 → Rev 965

/TrafficCount/trunk/sql/report.sql
0,0 → 1,11
--
-- total traffic report for mercury
--
select d1.source, d2.source, d1.day,
round((d1.endvalue-d1.beginvalue+d2.endvalue-d2.beginvalue) / 1024 / 1024) as count
from tdays d1
left join tdays d2 on (d2.day = d1.day and d2.source='fw_out')
where d1.day >= '1 Jan 2004'
and d1.source = 'fw_in'
order by d1.source, d1.day;