open [OPEN_QUERY] @100:4
q-room [QUERY] @100:15
for [KW_FOR] @101:7
each [KW_EACH] @101:11
record phrase [RECORD_PHRASE] @0:0
t-floor [TEMP_TABLE] @101:16
where [KW_WHERE] @101:24
expression [EXPRESSION] @0:0
( [LPARENS] @101:30
if [FUNC_POLY] @101:31
= [EQUALS] @101:51
current-floor-no [VAR_INT] @101:34
? [UNKNOWN_VAL] @101:53
true [BOOL_TRUE] @101:60
= [EQUALS] @101:84
t-floor.floor [FIELD_INT] @101:70
current-floor-no [VAR_INT] @101:86
each [KW_EACH] @102:10
record phrase [RECORD_PHRASE] @0:0
t-room-type [TEMP_TABLE] @102:15
where [KW_WHERE] @102:27
expression [EXPRESSION] @0:0
( [LPARENS] @102:33
if [FUNC_POLY] @102:34
= [EQUALS] @102:55
current-room-type [VAR_INT] @102:37
? [UNKNOWN_VAL] @102:57
true [BOOL_TRUE] @102:64
= [EQUALS] @102:91
t-room-type.type [FIELD_INT] @102:74
current-room-type [VAR_INT] @102:93
each [KW_EACH] @103:10
record phrase [RECORD_PHRASE] @0:0
rate [TABLE] @103:15
where [KW_WHERE] @103:20
expression [EXPRESSION] @0:0
and [KW_AND] @103:53
= [EQUALS] @103:37
rate.floor [FIELD_INT] @103:26
t-floor.floor [FIELD_INT] @103:39
= [EQUALS] @104:44
rate.type-of-room [FIELD_INT] @104:26
t-room-type.type [FIELD_INT] @104:46
outer-join [KW_OUT_JOIN] @105:20
use-index [KW_USE_IDX] @106:20
idx-rate-e-date [INDEX] @106:30
|