• Skip to main content
  • Skip to primary sidebar
Menu
  • Home
  • About
      • WGASC History
      • Corporate Partners
      • Honors
      • Media
      • Blog
      • Contact Us
      • Santa-Monica-CFX23548-TBG
    • Close
  • Calendar
      • Color Guard Events
      • Percussion/IPA Events
    • Close
  • Ensembles/Events
      • Guards
          • Schedules, Scores, and Show Information – Guard
          • News – WGASC News / Information
          • Guard Ensemble Roster
          • Guard Ensemble Profiles
          • New Ensemble Registration
          • Registering My Ensemble
          • Classifieds – Classified sales and announcements
          • Guard Score Archives
          • Scholarship Info
        • Close
      • Percussion/IPA
          • Schedules, Scores, and Show Info – Percussion/IPA
          • News
          • Percussion/IPA Ensembles Roster
          • Percussion/IPA Ensemble Profile
          • New Ensemble Registration
          • Percussion Score Archives
          • Classifieds – Classified sales and announcements
        • Close
    • Close
  • Resources
      • 2021 Solo Competition
      • Scholarship Application
      • WGASC/ADLA/IPA New Ensemble Registration
      • WGASC Virtual Series
    • WGASC-Dance3-Menu-200
    • Close
    • Close
    • ADLA RSS
    • WGASC RSS
    • Close
    • ADLA facebook
    • WGASC facebook
    • Close

WGASC/ADLA

WGASC/ADLA is SoCal's Premier Winter Guard and Indoor Percussion Circuit

Community Email
Weekly Update

Return of the Jedi

dbConnect::getResultSet() Error
mySQL Error:
Query: SELECT d.divisionName, en.ensembleName, ts.total FROM mast_vwTotalScores AS ts, mast_Divisions as d, mast_Ensembles AS en, mast_showRounds AS sr WHERE ts.ensembleID = en.ensembleID AND ts.showRoundID = sr.showRoundID AND sr.showID = 111 AND sr.divisionID = d.divisionID ORDER BY d.displayOrder ASC, ts.total DESC