WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND a.WorkoutDate >= DATE_SUB(NOW(), INTERVAL 14 DAY) AND a.WorkoutDate <= ...' at line 7]SELECT a.Member, a.WorkoutDate, a.TotalPoints, a.WorkoutScheduleID, b.Workout, b.AutoID, c.AutoID, c.WorkoutName
FROM MemberPoints a
INNER JOIN WorkoutSchedule b
ON a.WorkoutScheduleID = b.AutoID
INNER JOIN Workouts c
ON b.Workout = c.AutoID
WHERE (a.Member = 1000 OR a.Member = ) AND a.WorkoutDate >= DATE_SUB(NOW(), INTERVAL 14 DAY) AND a.WorkoutDate <= NOW() ORDER BY a.WorkoutDate ASC
WordPress database error: [Query was empty]