select battles.*,count(battleimages.ImageName) as NumImages,TimeGroups.TimeName from battles left join battleimages on battleimages.BattleID=battles.BattleID left join TimeGroups on TimeGroups.TimeGroup=battles.Universe where battles.BattleID=:BattleID group by battles.BattleID; The Valley of Death - Notes
Mobile Site Shops eMail Author Caption Comp Monthly Poll Sudden Death Colour Key Statistics Cookie Usage
Ships Fleets Weaponry Species People Timelines Calculators Photo Galleries
Stations Design Lineage Size Charts Battles Science / Tech Temporal Styling Maps / Politics
Articles Reviews Lists Recreation Search Site Guide What's New Forum