homepage
  • Your recently viewed scenarios
    • Kempf at Melikhovo
      Andy_Bagley played the scenario
      Ninety Minute War
      Dave played the scenario
      Le Hérisson
      igycrctl played the scenario
      The Ring
      buser333 played the scenario
      Acts of Defiance
      ASLSKGwahlur played the scenario
      Siam Sambal
      Pte Parts 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 pub_id='2085' group by scenario.id order by a desc)s