homepage
  • Your recently viewed scenarios
    • Failure to Communicate
      Kydder played the scenario
      The Volga is Reached!
      von Garvin played the scenario
      Priests on the Line
      buser333 played the scenario
      Simple Equation
      Jwil2020 played the scenario
      Riverfront Property
      Kydder played the scenario
      Jungle Fighters
      Kydder played the scenario
  • Not Logged In
  • Home
  • Shop for Scenarios
  • Article List
  • Reviews
  • Advanced Search
  • Games Wanted
  • Publications
  • Scenario Picker
  • 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,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='2155' group by scenario.id order by a desc)s