homepage
  • Your recently viewed scenarios
    • By Dawn's Early Light
      Pte Parts played the scenario
      The Gin Drinker's Line
      Pte Parts played the scenario
      Black Day in Hatten
      Pte Parts played the scenario
      The Road to Lyon
      Danno played the scenario
      War of the Rats
      toffee played the scenario
      Stutzpunkt Lezongar
      Jude 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='1268' group by scenario.id order by a desc)s