homepage
  • Your recently viewed scenarios
    • Insufficient Resolve
      lt_steiner played the scenario
      Supply Detail
      lechiquier94 played the scenario
      Urban Nightmare
      Bongiovanni played the scenario
      Raid on Rodimtsev
      Bongiovanni played the scenario
      Terror At Twilight
      Bongiovanni played the scenario
      Cellar Dwellers
      Bongiovanni 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='2015' group by scenario.id order by a desc)s