for [KW_FOR] @391:13
each [KW_EACH] @391:17
record phrase [RECORD_PHRASE] @0:0
b-guest [BUFFER] @391:22
where [KW_WHERE] @392:16
expression [EXPRESSION] @0:0
and [KW_AND] @393:104
and [KW_AND] @392:105
( [LPARENS] @392:22
if [FUNC_POLY] @392:23
or [KW_OR] @392:36
= [EQUALS] @392:32
g-f-n [VAR_CHAR] @392:26
? [UNKNOWN_VAL] @392:34
= [EQUALS] @392:45
g-f-n [VAR_CHAR] @392:39
"" [STRING] @392:47
true [BOOL_TRUE] @392:55
matches [KW_MATCHES] @392:84
b-guest.first-name [FIELD_CHAR] @392:65
+ [PLUS] @392:98
g-f-n [VAR_CHAR] @392:92
"*" [STRING] @392:100
( [LPARENS] @393:22
if [FUNC_POLY] @393:23
or [KW_OR] @393:36
= [EQUALS] @393:32
g-l-n [VAR_CHAR] @393:26
? [UNKNOWN_VAL] @393:34
= [EQUALS] @393:45
g-l-n [VAR_CHAR] @393:39
"" [STRING] @393:47
true [BOOL_TRUE] @393:55
matches [KW_MATCHES] @393:83
b-guest.last-name [FIELD_CHAR] @393:65
+ [PLUS] @393:97
g-l-n [VAR_CHAR] @393:91
"*" [STRING] @393:99
( [LPARENS] @394:22
if [FUNC_POLY] @394:23
= [EQUALS] @394:32
g-dob [VAR_DATE] @394:26
? [UNKNOWN_VAL] @394:34
true [BOOL_TRUE] @394:41
= [EQUALS] @394:73
b-guest.date-of-birth [FIELD_DATE] @394:51
g-dob [VAR_DATE] @394:75
no-lock [KW_NO_LOCK] @394:82
first [KW_FIRST] @395:17
record phrase [RECORD_PHRASE] @0:0
b-res [BUFFER] @395:23
where [KW_WHERE] @395:29
expression [EXPRESSION] @0:0
and [KW_AND] @395:69
= [EQUALS] @395:50
b-res.guest-id [FIELD_INT] @395:35
b-guest.guest-id [FIELD_INT] @395:52
>= [GTE] @395:88
b-res.checkout [FIELD_DATE] @395:73
today [FUNC_DATE] @395:91
use-index [KW_USE_IDX] @395:97
idx-r-checkin [INDEX] @395:107
|