homepage
  • Your recently viewed scenarios
    • Charge You Bastards!
      jgarlic79@gmail.com played the scenario
      Make Way for the King
      hennies played the scenario
      Schoolhouse Rock
      JimT1277 played the scenario
      The 11th Hour
      JimT1277 played the scenario
      Unlucky Thirteenth
      RJenulis played the scenario
      Italian Behemoth
      jwert02 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='2250' group by scenario.id order by a desc)s