homepage
  • Your recently viewed scenarios
    • No Dunkirk
      GeneralFG played the scenario
      Gambit
      grumblejones played the scenario
      Gambit
      Danno played the scenario
      Tip of the Spear
      GOUREAU played the scenario
      Hunters from the Sky
      dmareske played the scenario
      Hunters from the Sky
      Danno played the scenario
  • Not Logged In
  • Home
  • Shop for Scenarios
  • Article List
  • Reviews
  • Advanced Search
  • Game Search
  • Maps
  • Scenario Map
  • Games Wanted
  • Tournaments
  • 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 archive_roar_table on archive_roar_table.arc_scen_id=scenario.id and archive_roar_table.arc_roar_id!='' left join roardata on roardata.scen_id=archive_roar_table.arc_roar_id where pubs.publish_id=publishers.publisher_id and pubs.id=scenario.pub_id and pubs.id='1496' group by scenario.id order by a desc)s