matchesbyteam
:vschema:
SELECT m.matid,
m.team1 as teama,
m.team2 as teamb,
m.score1 as scorea,
m.score2 as scoreb,
m.venue,
m.descr as mdescr,
ta.tname as atname,
ta.area as aarea,
ta.ttype,
tb.tname as btname,
tb.area as barea,
e.year,
e.descr as edesc,
to_char( timestamp 'now', 'DD-Mon-YYYY HH12:MIam') as when,
(select case when ':event:' <> '' then 'at ' || e.descr end) as titleevent
from tmatches m join events e on (m.venue = e.ename )
join teams_v ta on( team1 = ta.sname)
join teams_v tb on (team2 = tb.sname)
WHERE 1=1
:vttype: :vevent: :vteam:
ORDER BY venue, atname
matid, teama, teamb, scorea, scoreb, venue, mdescr,
atname, aarea, ttype, btname, barea, year, edescr, when, titleevent
venue, matid
Rugby Matches by Team
:area: :ttype: Team Matches :titleteam: _titleevent_ |
| _edescr_ |
Score |
Match |
| _atname_ vs. _btname_ |
_scorea_-_scoreb_ |
_mdescr_ |
| _atname_ vs. _btname_ |
_scorea_-_scoreb_ |
_mdescr_ |
Report Run: _when_
| Team | Area | Event |
| :team: | :area: | :event: |