homepage
  • Your recently viewed scenarios
    • Hell's Headache
      GOUREAU played the scenario
      French Courage
      Dougban played the scenario
      Disgraceful Victory
      Pantera played the scenario
      3rd RTR in the Rain
      Pantera played the scenario
      The Cloak of Disorder
      Pantera played the scenario
      To The Cider Crossroads
      Pantera 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='1827' group by scenario.id order by a desc)s