| buyingyi | 2fd7fa6 | 2014-11-24 19:31:55 -0800 | [diff] [blame] | 1 | from $event in dataset('Event') |
| 2 | where $event.name = "The Night of the Ad Eaters, 29th edition" |
| 3 | with $collocated_events := |
| 4 | from $collocated_event in dataset('Events') |
| 5 | where $collocated_event.location.street ~= $event.location.street |
| 6 | and $collocated_event.location.city = $event.location.city |
| 7 | and $collocated_event.location.state = $event.location.state |
| 8 | and $collocated_event.location.zip = $event.location.zip |
| 9 | select { "event_name" : $collocated_event.name } |
| 10 | select { "collocated_evnets" : $collocated_events } |