WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'caql_veto.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2024-04-27 13:15:52' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC


Schedules in Vancouver. Your feedback solicited!

UBC is returning. So we’ll have 7 teams in Vancouver.

Now here are some possible schedules for the round-robin.
If team G can staff 3 rooms, we can do it in 10 rounds.
This is the schedule we used last year:

 1. DE CF    | ABG
 2. BG EF    | ACD
 3. AC DG    | BEF
 4. AE FG    | BCD
 5. AG BD    | CEF
 6. BF CE    | ADG
 7. AB CG    | DEF
 8. BC DF    | AEG
 9. AD EG    | BCF
10. AF BE CD | G

We can reduce by one more round, to 9, if we combine three rounds into two.
Then we’ll have three teams that will have to staff 3 rooms.

1. DE CF    | ABG
2. BG EF    | ACD
3. AC DG    | BEF
4. AE FG    | BCD
5. AG BD    | CEF
6. BF CE    | ADG
7. AB CG DF | E
8. AD BC EG | F
9. AF BE CD | G

Restriction: B2B must have a bye when Daniel’s packet is read.
As a consequence, Daniel’s team cannot be E/F/G.

Here is a possible matching, listing who will bring each packet:
A: FARSIDE (Peter) - rounds 1 (author), 2 (author)
B: Brittany/Geoff/Dean/Tariq
C: UBC (Mike/Fred/Lavan) - round 5 (Toronto)
D: Daniel/Brendan/Ciarán Llachlan/Angus - rounds 6 (author), 4 (Toronto)
E: Junta (Carlos/Hanson/Mike/Shaun) - rounds 7 (author), 3 (Toronto)
F: Joanne/Mischa/Paulman/Ross - round 8 (Toronto)
G: B2B (Brock/Bruce/Victoria/Zhan) - rounds 6 (contributor), 9 (author)

Note that the ordering of the rounds in the schedule is completely arbitrary. We usually read home-grown packets first; B2B’s packet need not be the last one read!
Perhaps it would make more sense to play the rounds requiring three rooms first instead of last.

Also, speak up if you see an error in this schedule.

Comments are closed.