| vinayakb | 38b7ca4 | 2012-03-05 05:44:15 +0000 | [diff] [blame] | 1 | for $event in dataset('Event') |
| 2 | where $event.name = "The Night of the Ad Eaters, 29th edition" |
| 3 | let $collocated_events := |
| 4 | for $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 | return { "event_name" : $collocated_event.name } |
| 10 | return { "collocated_evnets" : $collocated_events } |