open [OPEN_QUERY] @83:1
q-checkout [QUERY] @83:12
for [KW_FOR] @84:4
each [KW_EACH] @84:8
record phrase [RECORD_PHRASE] @0:0
checkout [TABLE] @84:13
no-lock [KW_NO_LOCK] @84:22
each [KW_EACH] @85:8
record phrase [RECORD_PHRASE] @0:0
reservation [TABLE] @85:13
where [KW_WHERE] @86:10
expression [EXPRESSION] @0:0
and [KW_AND] @86:69
= [EQUALS] @86:43
reservation.reservation-id [FIELD_INT] @86:16
checkout.reservation-id [FIELD_INT] @86:45
( [LPARENS] @88:17
or [KW_OR] @88:39
= [EQUALS] @88:33
checkout.state [FIELD_CHAR] @88:18
'I' [STRING] @88:35
= [EQUALS] @88:57
checkout.state [FIELD_CHAR] @88:42
"O" [STRING] @88:59
no-lock [KW_NO_LOCK] @88:64
use-index [KW_USE_IDX] @88:72
idx-r-id [INDEX] @88:82
|