• Welcome
  • Follow AABC
    • All AABC World Series
    • All AABC Regionals
    • All AABC Qualifiers
  • Tournaments
    • AABC Pee Wee Reese World Series
    • Registered Teams
    • Team Player Signup & Free Player Profile
    • Schedules
    • Standings
    • Brackets
  • Resources
    • Online Payments
    • AABC Handbook – Rules
    • Required Coach Background Check & Zero Tolerance Policy
    • Field Locations
    • Sponsors
  • Hotels and Travel
    • Hotels and Travel
  • Contact Us
    • Contact Us
  • Members / Login
    • Coaches Dugout
    • Log Out
AABC West AABC West AABC West AABC West
  • Welcome
  • Follow AABC
    • All AABC World Series
    • All AABC Regionals
    • All AABC Qualifiers
  • Tournaments
    • AABC Pee Wee Reese World Series
    • Registered Teams
    • Team Player Signup & Free Player Profile
    • Schedules
    • Standings
    • Brackets
  • Resources
    • Online Payments
    • AABC Handbook – Rules
    • Required Coach Background Check & Zero Tolerance Policy
    • Field Locations
    • Sponsors
  • Hotels and Travel
    • Hotels and Travel
  • Contact Us
    • Contact Us
  • Members / Login
    • Coaches Dugout
    • Log Out

002: SELECT ET.*, EV.*, MP.username FROM `event` AS EV JOIN `eventtypes` AS ET ON EV.event_id = ET.event_id LEFT JOIN `memberprofile` as MP on ET.event_access_level = MP.level_access WHERE EV.publish_event = "y" AND EV.year >= '2022' AND ET.aabc_region = GROUP BY EV.year, ET.event_name, EV.level ORDER BY EV.year DESC, EV.start_date, ET.event_name, EV.level
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY EV.year, ET.event_name, EV.level ORDER BY EV.year DESC, EV.start_d' at line 5