homepage
  • Your recently viewed scenarios
    • Goats to Lure the Tiger
      Bongiovanni played the scenario
      To the Rescue
      GOUREAU played the scenario
      Nothing Left to Lose
      toffee played the scenario
      Bailey's Bridge
      Jwil2020 played the scenario
      The French Perimeter
      Allister01 played the scenario
      For Hitler, For Allah
      Bongiovanni played the scenario
  • Not Logged In
  • Home
  • Shop for Scenarios
  • Article List
  • Reviews
  • Advanced Search
  • Scenario Map
  • 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,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='1552' group by scenario.id order by a desc)s