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 Wrath of Khan - 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