homepage
  • Your recently viewed scenarios
    • Few and Far Between
      strategos played the scenario
      Operation Wheatfield
      A15.4er played the scenario
      Goats to Lure the Tiger
      A15.4er played the scenario
      The Hellenic Expedition
      grumblejones played the scenario
      The Hellenic Expedition
      Danno played the scenario
      Sting 'em at Zingem
      Kydder played the scenario
  • Not Logged In
  • Home
  • Shop for Scenarios
  • Article List
  • Reviews
  • Advanced Search
  • Game Search
  • Maps
  • Scenario Map
  • Games Wanted
  • Publications
  • Scenario Picker
  • Reports
    • Balance
    • Statistics
  • Contact
  • Events
  • Scenario Lists
  • Information
    • REST API
    • Privacy policy
    • Terms and Conditions
  • Login/Register
    • Login
    • Register
Failed Query: Select sum(tot_playings) tot from (select ifnull(count(playings.sc_id),0)+ifnull(side1wins,0)+ifnull(side2wins,0) tot_playings,night,pubs.id pid,pubs.intro,theatre,scen_date,scen_location,time_to_play,gps_long,gps_lat,scenario.sc_id,scenario.id,title,pubs.publish_id,publishers.publisher_name publ,pubs.pub_name n,attacker,defender from publishers,pubs,scenario left join playings on playings.sc_id=scenario.id left join roardata on roardata.scen_name=scenario.title where pubs.publish_id=publishers.publisher_id and pubs.id=scenario.pub_id and pubs.id='1529' group by scenario.id order by a desc)s