[wp-meta] [Making WordPress.org] #2994: Make WordCamps sticky in the Events API

[Making WordPress.org]

#2994: Make WordCamps sticky in the Events API
--------------------------------------+-----------------------
 Reporter:  iandunn                   |       Owner:
     Type:  enhancement               |      Status:  assigned
 Priority:  high                      |   Milestone:
Component:  API                       |  Resolution:
 Keywords:  good-first-bug has-patch  |
--------------------------------------+-----------------------

Comment (by iandunn):

 Thanks @metalandcoffee! I tested this out today and it's working well :)

 I think we might want to optimize the queries, by grabbing the extra camps
 in the initial query, rather than making an additional one. That kind of
 approach isn't always faster, but it seems like it will be in this case.
 We'd need to move the `date_utc` clause so that it just applies to
 meetups, and then increase the `LIMIT` to `~25`. That introduces a
 `filesort` to the first query, but it doesn't seem to add a significant
 delay the the execution time, and the second query also requires a
 `filesort` anyway. I haven't tested a lot of different cities yet, though.

 That change could make the PHP logic more complex than it needs to be,
 though, so it might not be a great tradeoff. I'm still playing around with
 some options to see what might be best.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/2994#comment:9>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org