Single query uses all system memory

A single large query is able to spend all the system memory (as reported by
top), and the oom_reaper kills postgres. See bottom of email for an example
query and logs.

Expected behavior would be that postgres is not killed and the query is
limited to the shared_buffer memory, potentially failing, but not killing
the postgres process.

Do I have some fundamental flaw in my understanding of this, or is there
some sort of configuration that should be in place that is missing? The
offending sample query has been

rewritten to not use joins, and will no longer crash postgres. I am not
asking anyone to spend a lot of time analyzing the query itself, it is just
provided as an example for when the problem will occur.

My question is more in a broader sense why one query is eating through all
system memory, and is there anything I can do to prevent this from
happening?

We have set shared_buffers to 256MB on a test-system that has 1GB memory.
Production machines have more resources, but the errors are happening in
exactly the same way, so I assume (perhaps wrongly) that using the test

system specs and logs might give me the answers I need to figure out what
is happening.

Technical details are provided below, a big thanks to anyone who can
provide any help or insight to this.

Regards,

Ivar Fredriksen

PostgreSQL version number:

PostgreSQL 10.4 (Debian 10.4-2.pgdg90+1) on x86_64-pc-linux-gnu, compiled
by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit

Installed with the debian packages for postgres found at: deb
http://apt.postgresql.org/pub/repos/apt/

Changes made to the settings in the postgresql.conf file:

name | current_setting
|
source

------------------------------+-----------------------------------------+----------------------

application_name | psql |
client

checkpoint_completion_target | 0.9 |
configuration file

client_encoding | UTF8 |
client

cluster_name | 10/main |
configuration file

DateStyle | ISO, MDY |
configuration file

default_statistics_target | 100 |
configuration file

default_text_search_config | pg_catalog.english |
configuration file

dynamic_shared_memory_type | posix |
configuration file

effective_cache_size | 1536MB |
configuration file

external_pid_file | /var/run/postgresql/10-main.pid |
configuration file

lc_messages | C |
configuration file

lc_monetary | C |
configuration file

lc_numeric | en_US.UTF-8 |
configuration file

lc_time | C |
configuration file

listen_addresses | * |
configuration file

log_line_prefix | %m [%p] %q%u(at)%d |
configuration file

log_timezone | UTC |
configuration file

maintenance_work_mem | 128MB |
configuration file

max_connections | 100 |
configuration file

max_stack_depth | 2MB |
environment variable

max_wal_size | 2GB |
configuration file

min_wal_size | 1GB |
configuration file

port | 5432 |
configuration file

search_path | "$user", public, pg_catalog |
configuration file

shared_buffers | 256MB |
configuration file

ssl | on |
configuration file

ssl_cert_file | /etc/ssl/certs/ssl-cert-snakeoil.pem |
configuration file

ssl_key_file | /etc/ssl/private/ssl-cert-snakeoil.key |
configuration file

standard_conforming_strings | off |
configuration file

stats_temp_directory | /var/run/postgresql/10-main.pg_stat_tmp |
configuration file

tcp_keepalives_idle | 0 |
configuration file

TimeZone | UTC |
configuration file

unix_socket_directories | /var/run/postgresql |
configuration file

wal_buffers | 16MB |
configuration file

work_mem | 1310kB |
configuration file

(35 rows)

Operating system and version:

Debian GNU/Linux 9.4 (stretch)

Linux ip-172-31-30-104 4.9.0-6-amd64 #1 SMP Debian 4.9.88-1 (2018-04-29)
x86_64 GNU/Linux

Machine specs:

CPU: Intel(R) Xeon(R) CPU E5-2676 v3 @ 2.40GHz

Memory: 1GB

HDD: General purpose SSD from amazon ec2, only one disk

What program you're using to connect to PostgreSQL:

dRofus 2.0.38 (http://www.drofus.no/en/download/) This is propriety
software, may or may not be relevant in this context.

### Syslog ###

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503972] postgres invoked
oom-killer: gfp_mask=0x24280ca(GFP_HIGHUSER_MOVABLE|__GFP_ZERO),
nodemask=0, order=0, oom_score_adj=0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503974] postgres cpuset=/
mems_allowed=0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503978] CPU: 0 PID: 24494
Comm: postgres Not tainted 4.9.0-6-amd64 #1 Debian 4.9.88-1

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503979] Hardware name: Xen
HVM domU, BIOS 4.2.amazon 08/24/2006

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503981] 0000000000000000
ffffffffa072f7e4 ffff9dc64323fcf0 ffff92057be290c0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503984] ffffffffa0603090
0000000000000000 0000000000000000 0000000ca074e669

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503986] ffff92057be290c0
ffffffffa0588ab7 0000004200000000 0000000000000001

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503988] Call Trace:

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503995] [<ffffffffa072f7e4>]
? dump_stack+0x5c/0x78

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.503997] [<ffffffffa0603090>]
? dump_header+0x78/0x1fd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504000] [<ffffffffa0588ab7>]
? get_page_from_freelist+0x3f7/0xb20

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504002] [<ffffffffa0584a2a>]
? oom_kill_process+0x21a/0x3e0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504003] [<ffffffffa05846ad>]
? oom_badness+0xed/0x170

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504004] [<ffffffffa0584ec1>]
? out_of_memory+0x111/0x470

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504006] [<ffffffffa058a137>]
? __alloc_pages_slowpath+0xbb7/0xbf0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504008] [<ffffffffa058a371>]
? __alloc_pages_nodemask+0x201/0x260

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504010] [<ffffffffa05dc9ce>]
? alloc_pages_vma+0xae/0x260

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504012] [<ffffffffa05b8295>]
? handle_mm_fault+0xf85/0x1280

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504014] [<ffffffffa0460f55>]
? __do_page_fault+0x255/0x4f0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504018] [<ffffffffa0a0dbc2>]
? schedule+0x32/0x80

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504019] [<ffffffffa0a13858>]
? page_fault+0x28/0x30

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504021] Mem-Info:

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] active_anon:221001
inactive_anon:10011 isolated_anon:0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] active_file:17
inactive_file:29 isolated_file:0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] unevictable:0
dirty:2 writeback:0 unstable:0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] slab_reclaimable:2581
slab_unreclaimable:3112

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] mapped:8649
shmem:12830 pagetables:1748 bounce:0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504024] free:12213
free_pcp:60 free_cma:0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504027] Node 0
active_anon:884004kB inactive_anon:40044kB active_file:68kB
inactive_file:116kB unevictable:0kB isolated(anon):0kB isolated(file):0kB
mapped:34596kB dirty:8kB writeback:0kB shmem:51320kB shmem_thp: 0kB
shmem_pmdmapped: 0kB anon_thp: 0kB writeback_tmp:0kB unstable:0kB
pages_scanned:202 all_unreclaimable? yes

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504027] Node 0 DMA
free:4536kB min:716kB low:892kB high:1068kB active_anon:11284kB
inactive_anon:0kB active_file:0kB inactive_file:0kB unevictable:0kB
writepending:0kB present:15988kB managed:15904kB mlocked:0kB
slab_reclaimable:12kB slab_unreclaimable:4kB kernel_stack:0kB
pagetables:20kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504031] lowmem_reserve[]:
0 957 957 957 957

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504034] Node 0 DMA32
free:44316kB min:44336kB low:55420kB high:66504kB active_anon:872708kB
inactive_anon:40044kB active_file:68kB inactive_file:116kB unevictable:0kB
writepending:8kB present:1032192kB managed:1002564kB mlocked:0kB
slab_reclaimable:10312kB slab_unreclaimable:12444kB kernel_stack:1776kB
pagetables:6972kB bounce:0kB free_pcp:240kB local_pcp:240kB free_cma:0kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504037] lowmem_reserve[]:
0 0 0 0 0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504040] Node 0 DMA: 4*4kB
(UE) 3*8kB (E) 3*16kB (E) 5*32kB (UE) 7*64kB (UME) 4*128kB (UME) 3*256kB
(ME) 3*512kB (ME) 1*1024kB (U) 0*2048kB 0*4096kB = 4536kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504049] Node 0 DMA32:
689*4kB (E) 423*8kB (UE) 264*16kB (UME) 141*32kB (UME) 104*64kB (UME)
66*128kB (UME) 32*256kB (ME) 8*512kB (ME) 0*1024kB 1*2048kB (M) 0*4096kB =
44316kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504074] Node 0
hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504074] 12885 total
pagecache pages

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504075] 0 pages in swap
cache

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504076] Swap cache stats:
add 0, delete 0, find 0/0

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504077] Free swap = 0kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504077] Total swap = 0kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504078] 262045 pages RAM

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504084] 0 pages
HighMem/MovableOnly

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504085] 7428 pages reserved

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504085] 0 pages hwpoisoned

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504086] [ pid ] uid tgid
total_vm rss nr_ptes nr_pmds swapents oom_score_adj name

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504089] [ 174] 0 174
14212 335 24 3 0 0 systemd-journal

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504091] [ 198] 0 198
11324 144 22 3 0 -1000 systemd-udevd Jun 25
11:55:30 ip-172-31-30-104 kernel: [455698.504093] [ 284] 0 284
5117 269 15 3 0 0 dhclient

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504094] [ 360] 0
360
5087 256 12 3 0 0 dhclient

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504096] [ 503] 0 503
11625 141 26 3 0 0 systemd-logind

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504097] [ 504] 0 504
62529 223 28 4 0 0 rsyslogd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504099] [ 505] 0
505
7400 82 20 3 0 0 cron

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504101] [ 506] 107 506
11280 121 25 3 0 -900 dbus-daemon

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504114] [ 525] 0
525
3578 36 12 3 0 0 agetty

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504115] [ 526] 0
526
3634 33 12 3 0 0 agetty

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504117] [ 527] 0 527
17486 193 39 3 0 -1000 sshd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504119] [ 7828] 0 7828
12468 124 27 3 0 0 rpcbind

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504120] [ 8200] 110 8200
25520 143 24 3 0 0 ntpd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504122] [32155] 111 32155
14038 185 30 3 0 0 exim4

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504124] [ 1715] 113
1715
5979 130 18 3 0 -500 nrpe

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504125] [15866] 0 15866
24826 248 52 3 0 0 sshd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504127] [15868] 1000 15868
16219 206 35 3 0 0 systemd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504128] [15869] 1000 15869
41652 443 45 3 0 0 (sd-pam)

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504130] [15875] 1000 15875
24826 261 50 3 0 0 sshd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504131] [15876] 1000
15876
5311 483 15 3 0 0 bash

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504133] [18827] 0 18827
13347 109 31 3 0 0 sudo

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504138] [18828] 0 18828
13756 107 31 3 0 0 su

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504139] [18829] 0
18829
4983 161 14 3 0 0 bash

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504141] [27607] 0 27607
24826 248 52 3 0 0 sshd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504142] [27613] 1000 27613
24826 260 50 3 0 0 sshd

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504144] [27614] 1000
27614
5324 499 15 3 0 0 bash

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504146] [29124] 112 29124
108832 6852 74 4 0 -900 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504147] [29806] 0 29806
13347 112 31 3 0 0 sudo

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504149] [29807] 0 29807
13756 107 30 4 0 0 su

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504150] [29808] 0
29808
5309 488 14 3 0 0 bash

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504152] [30173] 112 30173
108865 719 61 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504154] [30174] 112 30174
108832 905 57 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504155] [30175] 112 30175
108832 4588 61 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504157] [30176] 112 30176
108946 760 58 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504158] [30177] 112 30177
35895 508 51 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504160] [30178] 112 30178
108905 541 55 4 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504161] [24479] 0
24479
1469 18 7 3 0 0 tail

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504174] [24488] 0
24488
1469 17 8 3 0 0 tail

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504176] [24494] 112 24494
329997 214603 487 5 0 0 postgres

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.504177] Out of memory:
Kill process 24494 (postgres) score 844 or sacrifice child

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.507805] Killed process
24494 (postgres) total-vm:1319988kB, anon-rss:846800kB, file-rss:124kB,
shmem-rss:11488kB

Jun 25 11:55:30 ip-172-31-30-104 kernel: [455698.556431] oom_reaper: reaped
process 24494 (postgres), now anon-rss:0kB, file-rss:0kB, shmem-rss:11488kB

### PostgresLog ###

2018-06-25 11:55:30.423 UTC [29124] LOG: server process (PID 24494) was
terminated by signal 9: Killed

2018-06-25 11:55:30.423 UTC [29124] DETAIL: Failed process was running:
WITH limit_page AS (SELECT standard_room.id FROM standard_room
standard_room WHERE (standard_room.template_type IS NULL) ORDER BY
NULLIF(standard_room.room_func_no,'') ASC NULLS FIRST, standard_room.id
LIMIT 100 OFFSET 0) SELECT standard_room.equipment_list_type_id as f0,
standard_room.template_type as f1, standard_room.created_by as f2,
zone_std_room_map_11.zone_id as f3, zone_std_room_map_6.zone_id as f4,
zone_std_room_map_21.zone_id as f5, zone_std_room_map_19.zone_id as f6,
(COALESCE(standard_room.room_note, '') <> '') as f7,
COALESCE(created_by.first_name || ' ', '') ||
COALESCE(created_by.last_name, '') as f8, created_by.last_name as f9,
created_by.first_name as f10, created_by.email as f11, created_by.username
as f12, (SELECT username FROM article_std_room_quantity_version WHERE
room_id=standard_room.id AND equipment_list_type_id = 11 ORDER BY
version_start DESC LIMIT 1) as f13, (SELECT version_start FROM
article_std_room_quantity_version WHERE room_id=standard_room.id AND
equipment_list_type_id =

2018-06-25 11:55:30.433 UTC [29124] LOG: terminating any other active
server processes

2018-06-25 11:55:30.435 UTC [30176] WARNING: terminating connection
because of crash of another server process

2018-06-25 11:55:30.435 UTC [30176] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.

2018-06-25 11:55:30.435 UTC [30176] HINT: In a moment you should be able
to reconnect to the database and repeat your command.

2018-06-25 11:55:30.553 UTC [24495] ivarf(at)dev-template FATAL: the database
system is in recovery mode

2018-06-25 11:55:30.555 UTC [29124] LOG: all server processes terminated;
reinitializing

2018-06-25 11:55:30.588 UTC [24496] LOG: database system was interrupted;
last known up at 2018-06-25 01:33:25 UTC

2018-06-25 11:55:30.654 UTC [24496] LOG: database system was not properly
shut down; automatic recovery in progress

2018-06-25 11:55:30.658 UTC [24496] LOG: redo starts at 0/D9C26C8

2018-06-25 11:55:30.660 UTC [24496] LOG: invalid record length at
0/D9C49C8: wanted 24, got 0

2018-06-25 11:55:30.660 UTC [24496] LOG: redo done at 0/D9C4990

2018-06-25 11:55:30.662 UTC [24496] LOG: last completed transaction was at
log time 2018-06-25 11:55:17.529927+00

2018-06-25 11:55:30.682 UTC [29124] LOG: database system is ready to
accept connections

### Example Query that will crash postgres ###

WITH limit_page AS

(

SELECT standard_room.id

FROM standard_room standard_room

WHERE (

standard_room.template_type IS NULL)

ORDER BY Nullif(standard_room.room_func_no,'') ASC nulls first,

standard_room.id limit 100 offset 0)

SELECT standard_room.created_by AS f0,

standard_room.created AS f1,

standard_room.equipment_list_type_id AS f2,

standard_room.template_type AS f3,

rel_1.classification_entry_id AS f4,

rel_2.classification_entry_id AS f5,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 15) AS f6,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 14) AS f7,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 13) AS f8,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 9) AS f9,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 6) AS f10,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 5) AS f11,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 4) AS f12,

(

SELECT count(*)

FROM room_equipment_type

WHERE standard_room_id=standard_room.id

AND equipment_list_type_id = 2) AS f13,

(

SELECT count(id)

FROM room

WHERE rfp_standard_room = standard_room.id) AS f14,

rfp_std_values_22_10_10_10.numeric_data AS f15,

rfp_std_values_21_10_10_10.logical_data AS f16,

rfp_std_values_20_11_12_10.numeric_data AS f17,

rfp_std_values_20_11_11_10.text_data AS f18,

rfp_std_values_20_11_10_10.logical_data AS f19,

rfp_std_values_20_10_10_12.text_data AS f20,

rfp_std_values_18_11_10_10.text_data AS f21,

rfp_std_values_18_10_13_11.text_data AS f22,

rfp_std_values_18_10_13_10.logical_data AS f23,

rfp_std_values_18_10_10_11.text_data AS f24,

rfp_std_values_18_10_10_10.logical_data AS f25,

rfp_std_values_18_10_11_11.text_data AS f26,

rfp_std_values_18_10_11_10.logical_data AS f27,

rfp_std_values_18_10_12_11.text_data AS f28,

rfp_std_values_18_10_12_10.logical_data AS f29,

rfp_std_values_15_12_10_10.text_data AS f30,

rfp_std_values_15_11_12_11.text_data AS f31,

rfp_std_values_15_11_12_10.logical_data AS f32,

rfp_std_values_15_11_11_11.text_data AS f33,

rfp_std_values_15_11_11_10.logical_data AS f34,

rfp_std_values_15_11_10_11.text_data AS f35,

rfp_std_values_15_11_10_10.logical_data AS f36,

rfp_std_values_15_10_10_11.text_data AS f37,

rfp_std_values_15_10_10_10.logical_data AS f38,

rfp_std_values_19_14_10_10.text_data AS f39,

rfp_std_values_19_12_11_12.text_data AS f40,

rfp_std_values_19_12_11_11.numeric_data AS f41,

rfp_std_values_19_12_11_10.logical_data AS f42,

rfp_std_values_19_12_10_12.text_data AS f43,

rfp_std_values_19_12_10_11.numeric_data AS f44,

rfp_std_values_19_12_10_10.logical_data AS f45,

rfp_std_values_19_13_12_12.text_data AS f46,

rfp_std_values_19_13_12_11.numeric_data AS f47,

rfp_std_values_19_13_12_10.logical_data AS f48,

rfp_std_values_19_13_11_12.text_data AS f49,

rfp_std_values_19_13_11_11.numeric_data AS f50,

rfp_std_values_19_13_11_10.logical_data AS f51,

rfp_std_values_19_13_10_12.text_data AS f52,

rfp_std_values_19_13_10_11.numeric_data AS f53,

rfp_std_values_19_13_10_10.logical_data AS f54,

rfp_std_values_19_11_14_12.text_data AS f55,

rfp_std_values_19_11_14_11.numeric_data AS f56,

rfp_std_values_19_11_14_10.logical_data AS f57,

rfp_std_values_19_11_13_12.text_data AS f58,

rfp_std_values_19_11_13_11.numeric_data AS f59,

rfp_std_values_19_11_13_10.logical_data AS f60,

rfp_std_values_19_11_12_12.text_data AS f61,

rfp_std_values_19_11_12_11.numeric_data AS f62,

rfp_std_values_19_11_12_10.logical_data AS f63,

rfp_std_values_19_11_11_11.text_data AS f64,

rfp_std_values_19_11_11_10.numeric_data AS f65,

rfp_std_values_19_11_11_12.logical_data AS f66,

rfp_std_values_19_11_10_11.text_data AS f67,

rfp_std_values_19_11_10_10.numeric_data AS f68,

rfp_std_values_19_11_10_12.logical_data AS f69,

rfp_std_values_19_10_13_11.text_data AS f70,

rfp_std_values_19_10_13_10.numeric_data AS f71,

rfp_std_values_19_10_13_12.logical_data AS f72,

rfp_std_values_19_10_12_11.text_data AS f73,

rfp_std_values_19_10_12_10.numeric_data AS f74,

rfp_std_values_19_10_12_12.logical_data AS f75,

rfp_std_values_19_10_11_11.text_data AS f76,

rfp_std_values_19_10_11_10.numeric_data AS f77,

rfp_std_values_19_10_11_12.logical_data AS f78,

rfp_std_values_19_10_10_11.text_data AS f79,

rfp_std_values_19_10_10_10.numeric_data AS f80,

rfp_std_values_19_10_10_12.logical_data AS f81,

rfp_std_values_13_13_14_11.text_data AS f82,

rfp_std_values_13_13_14_10.numeric_data AS f83,

rfp_std_values_13_13_13_11.text_data AS f84,

rfp_std_values_13_13_13_10.logical_data AS f85,

rfp_std_values_13_13_12_11.text_data AS f86,

rfp_std_values_13_13_12_10.logical_data AS f87,

rfp_std_values_13_13_11_11.text_data AS f88,

rfp_std_values_13_13_11_10.logical_data AS f89,

rfp_std_values_13_13_10_11.text_data AS f90,

rfp_std_values_13_13_10_10.logical_data AS f91,

rfp_std_values_13_12_20_11.text_data AS f92,

rfp_std_values_13_12_20_10.logical_data AS f93,

rfp_std_values_13_12_19_11.text_data AS f94,

rfp_std_values_13_12_19_10.logical_data AS f95,

rfp_std_values_13_12_17_11.text_data AS f96,

rfp_std_values_13_12_17_10.logical_data AS f97,

rfp_std_values_13_12_16_11.text_data AS f98,

rfp_std_values_13_12_16_10.logical_data AS f99,

rfp_std_values_13_12_15_11.text_data AS f100,

rfp_std_values_13_12_15_10.logical_data AS f101,

rfp_std_values_13_12_14_11.text_data AS f102,

rfp_std_values_13_12_14_10.logical_data AS f103,

rfp_std_values_13_12_11_11.text_data AS f104,

rfp_std_values_13_12_11_10.logical_data AS f105,

rfp_std_values_13_12_13_11.text_data AS f106,

rfp_std_values_13_12_13_10.logical_data AS f107,

rfp_std_values_13_12_10_11.text_data AS f108,

rfp_std_values_13_12_10_10.logical_data AS f109,

rfp_std_values_13_11_16_11.text_data AS f110,

rfp_std_values_13_11_16_10.logical_data AS f111,

rfp_std_values_13_11_13_11.text_data AS f112,

rfp_std_values_13_11_13_10.logical_data AS f113,

rfp_std_values_13_11_11_11.text_data AS f114,

rfp_std_values_13_11_11_10.logical_data AS f115,

rfp_std_values_13_11_10_11.text_data AS f116,

rfp_std_values_13_11_10_10.logical_data AS f117,

rfp_std_values_13_10_15_11.text_data AS f118,

rfp_std_values_13_10_15_10.numeric_data AS f119,

rfp_std_values_13_10_14_11.text_data AS f120,

rfp_std_values_13_10_14_10.numeric_data AS f121,

rfp_std_values_13_10_12_11.text_data AS f122,

rfp_std_values_13_10_12_10.numeric_data AS f123,

rfp_std_values_13_10_11_11.text_data AS f124,

rfp_std_values_13_10_11_10.numeric_data AS f125,

rfp_std_values_13_10_10_11.text_data AS f126,

rfp_std_values_13_10_10_10.numeric_data AS f127,

rfp_std_values_12_10_18_12.text_data AS f128,

rfp_std_values_12_10_18_11.numeric_data AS f129,

rfp_std_values_12_10_18_10.logical_data AS f130,

rfp_std_values_12_10_20_12.text_data AS f131,

rfp_std_values_12_10_20_11.numeric_data AS f132,

rfp_std_values_12_10_20_10.logical_data AS f133,

rfp_std_values_12_10_17_12.text_data AS f134,

rfp_std_values_12_10_17_11.numeric_data AS f135,

rfp_std_values_12_10_17_10.logical_data AS f136,

rfp_std_values_12_10_16_12.text_data AS f137,

rfp_std_values_12_10_16_11.numeric_data AS f138,

rfp_std_values_12_10_16_10.logical_data AS f139,

rfp_std_values_12_10_15_11.text_data AS f140,

rfp_std_values_12_10_15_10.logical_data AS f141,

rfp_std_values_12_10_11_11.text_data AS f142,

rfp_std_values_12_10_11_10.logical_data AS f143,

rfp_std_values_12_10_12_11.text_data AS f144,

rfp_std_values_12_10_12_10.logical_data AS f145,

rfp_std_values_12_10_19_11.text_data AS f146,

rfp_std_values_12_10_19_10.logical_data AS f147,

rfp_std_values_12_10_10_11.text_data AS f148,

rfp_std_values_12_10_10_10.logical_data AS f149,

rfp_std_values_12_11_20_11.text_data AS f150,

rfp_std_values_12_11_20_10.logical_data AS f151,

rfp_std_values_12_11_18_12.numeric_data AS f152,

rfp_std_values_12_11_18_11.numeric_data AS f153,

rfp_std_values_12_11_18_10.numeric_data AS f154,

rfp_std_values_12_11_17_13.numeric_data AS f155,

rfp_std_values_12_11_17_12.numeric_data AS f156,

rfp_std_values_12_11_17_10.numeric_data AS f157,

rfp_std_values_12_11_19_10.numeric_data AS f158,

rfp_std_values_12_11_16_11.text_data AS f159,

rfp_std_values_12_11_16_10.logical_data AS f160,

rfp_std_values_12_11_21_11.text_data AS f161,

rfp_std_values_12_11_21_10.logical_data AS f162,

rfp_std_values_12_11_15_11.text_data AS f163,

rfp_std_values_12_11_15_10.logical_data AS f164,

rfp_std_values_12_11_12_11.text_data AS f165,

rfp_std_values_12_11_12_10.numeric_data AS f166,

rfp_std_values_12_11_11_11.text_data AS f167,

rfp_std_values_12_11_11_10.numeric_data AS f168,

rfp_std_values_12_11_25_11.text_data AS f169,

rfp_std_values_12_11_25_10.numeric_data AS f170,

rfp_std_values_16_14_20_11.text_data AS f171,

rfp_std_values_16_14_20_10.numeric_data AS f172,

rfp_std_values_16_14_22_11.text_data AS f173,

rfp_std_values_16_14_22_10.logical_data AS f174,

rfp_std_values_16_14_10_11.text_data AS f175,

rfp_std_values_16_14_10_10.logical_data AS f176,

rfp_std_values_16_14_11_11.text_data AS f177,

rfp_std_values_16_14_11_10.logical_data AS f178,

rfp_std_values_16_14_14_11.text_data AS f179,

rfp_std_values_16_14_14_10.logical_data AS f180,

rfp_std_values_16_14_24_11.text_data AS f181,

rfp_std_values_16_14_24_10.logical_data AS f182,

rfp_std_values_16_14_23_11.text_data AS f183,

rfp_std_values_16_14_23_10.logical_data AS f184,

rfp_std_values_16_14_13_11.text_data AS f185,

rfp_std_values_16_14_13_10.logical_data AS f186,

rfp_std_values_16_11_10_12.text_data AS f187,

rfp_std_values_16_11_10_11.numeric_data AS f188,

rfp_std_values_16_11_10_10.logical_data AS f189,

rfp_std_values_16_11_11_12.text_data AS f190,

rfp_std_values_16_11_11_11.numeric_data AS f191,

rfp_std_values_16_11_11_10.logical_data AS f192,

rfp_std_values_16_11_12_13.text_data AS f193,

rfp_std_values_16_11_12_12.numeric_data AS f194,

rfp_std_values_16_11_12_11.numeric_data AS f195,

rfp_std_values_16_11_12_10.logical_data AS f196,

rfp_std_values_16_11_13_11.text_data AS f197,

rfp_std_values_16_11_13_10.logical_data AS f198,

rfp_std_values_16_10_16_11.text_data AS f199,

rfp_std_values_16_10_16_10.logical_data AS f200,

rfp_std_values_16_10_14_11.text_data AS f201,

rfp_std_values_16_10_14_10.logical_data AS f202,

rfp_std_values_16_10_13_11.text_data AS f203,

rfp_std_values_16_10_13_10.logical_data AS f204,

rfp_std_values_16_10_15_11.text_data AS f205,

rfp_std_values_16_10_15_10.logical_data AS f206,

rfp_std_values_16_10_12_11.text_data AS f207,

rfp_std_values_16_10_12_10.logical_data AS f208,

rfp_std_values_16_10_11_13.text_data AS f209,

rfp_std_values_16_10_11_12.numeric_data AS f210,

rfp_std_values_16_10_11_11.numeric_data AS f211,

rfp_std_values_16_10_11_10.logical_data AS f212,

rfp_std_values_16_10_10_13.text_data AS f213,

rfp_std_values_16_10_10_12.numeric_data AS f214,

rfp_std_values_16_10_10_11.numeric_data AS f215,

rfp_std_values_16_10_10_10.logical_data AS f216,

rfp_std_values_14_15_25_11.text_data AS f217,

rfp_std_values_14_15_25_10.logical_data AS f218,

rfp_std_values_14_15_23_11.text_data AS f219,

rfp_std_values_14_15_23_10.numeric_data AS f220,

rfp_std_values_14_15_22_11.text_data AS f221,

rfp_std_values_14_15_22_10.numeric_data AS f222,

rfp_std_values_14_15_21_11.text_data AS f223,

rfp_std_values_14_15_21_10.numeric_data AS f224,

rfp_std_values_14_15_20_11.text_data AS f225,

rfp_std_values_14_15_20_10.numeric_data AS f226,

rfp_std_values_14_15_19_11.text_data AS f227,

rfp_std_values_14_15_19_10.numeric_data AS f228,

rfp_std_values_14_15_18_11.text_data AS f229,

rfp_std_values_14_15_18_10.numeric_data AS f230,

rfp_std_values_14_15_17_11.text_data AS f231,

rfp_std_values_14_15_17_10.numeric_data AS f232,

rfp_std_values_14_15_16_11.text_data AS f233,

rfp_std_values_14_15_16_10.numeric_data AS f234,

rfp_std_values_14_15_14_11.text_data AS f235,

rfp_std_values_14_15_14_10.numeric_data AS f236,

rfp_std_values_14_15_13_11.text_data AS f237,

rfp_std_values_14_15_13_10.numeric_data AS f238,

rfp_std_values_14_15_12_11.text_data AS f239,

rfp_std_values_14_15_12_10.numeric_data AS f240,

rfp_std_values_14_15_11_11.text_data AS f241,

rfp_std_values_14_15_11_10.numeric_data AS f242,

rfp_std_values_14_11_12_11.text_data AS f243,

rfp_std_values_14_11_12_10.logical_data AS f244,

rfp_std_values_14_11_10_11.text_data AS f245,

rfp_std_values_14_11_10_10.logical_data AS f246,

rfp_std_values_14_10_24_11.text_data AS f247,

rfp_std_values_14_10_24_10.logical_data AS f248,

rfp_std_values_14_10_19_11.text_data AS f249,

rfp_std_values_14_10_19_10.logical_data AS f250,

rfp_std_values_14_10_18_11.text_data AS f251,

rfp_std_values_14_10_18_10.logical_data AS f252,

rfp_std_values_14_10_25_12.text_data AS f253,

rfp_std_values_14_10_25_11.numeric_data AS f254,

rfp_std_values_14_10_25_10.logical_data AS f255,

rfp_std_values_14_10_13_11.text_data AS f256,

rfp_std_values_14_10_13_12.numeric_data AS f257,

rfp_std_values_14_10_13_10.logical_data AS f258,

rfp_std_values_14_10_12_11.text_data AS f259,

rfp_std_values_14_10_12_10.logical_data AS f260,

rfp_std_values_14_10_26_11.text_data AS f261,

rfp_std_values_14_10_26_10.logical_data AS f262,

rfp_std_values_14_10_11_11.text_data AS f263,

rfp_std_values_14_10_11_10.logical_data AS f264,

rfp_std_values_14_10_23_11.text_data AS f265,

rfp_std_values_14_10_23_10.numeric_data AS f266,

rfp_std_values_14_10_22_11.text_data AS f267,

rfp_std_values_14_10_22_10.numeric_data AS f268,

rfp_std_values_14_10_21_11.text_data AS f269,

rfp_std_values_14_10_21_10.numeric_data AS f270,

rfp_std_values_14_10_20_11.text_data AS f271,

rfp_std_values_14_10_20_10.numeric_data AS f272,

rfp_std_values_17_11_17_12.numeric_data AS f273,

rfp_std_values_17_11_17_11.text_data AS f274,

rfp_std_values_17_11_17_10.logical_data AS f275,

rfp_std_values_17_11_16_11.text_data AS f276,

rfp_std_values_17_11_16_10.logical_data AS f277,

rfp_std_values_17_11_14_11.text_data AS f278,

rfp_std_values_17_11_14_10.logical_data AS f279,

rfp_std_values_17_11_15_11.text_data AS f280,

rfp_std_values_17_11_15_10.logical_data AS f281,

rfp_std_values_17_11_13_11.text_data AS f282,

rfp_std_values_17_11_13_10.logical_data AS f283,

rfp_std_values_17_11_11_11.text_data AS f284,

rfp_std_values_17_11_11_10.logical_data AS f285,

rfp_std_values_17_14_20_11.text_data AS f286,

rfp_std_values_17_14_20_10.logical_data AS f287,

rfp_std_values_17_14_19_11.text_data AS f288,

rfp_std_values_17_14_19_10.logical_data AS f289,

rfp_std_values_17_14_18_11.text_data AS f290,

rfp_std_values_17_14_18_10.logical_data AS f291,

rfp_std_values_17_14_17_11.text_data AS f292,

rfp_std_values_17_14_17_10.logical_data AS f293,

rfp_std_values_17_14_16_11.text_data AS f294,

rfp_std_values_17_14_16_10.logical_data AS f295,

rfp_std_values_17_14_15_11.text_data AS f296,

rfp_std_values_17_14_15_10.logical_data AS f297,

rfp_std_values_17_14_21_11.text_data AS f298,

rfp_std_values_17_14_21_10.logical_data AS f299,

rfp_std_values_17_14_14_11.text_data AS f300,

rfp_std_values_17_14_14_10.logical_data AS f301,

rfp_std_values_17_14_13_11.text_data AS f302,

rfp_std_values_17_14_13_10.logical_data AS f303,

rfp_std_values_17_14_12_11.text_data AS f304,

rfp_std_values_17_14_12_10.logical_data AS f305,

rfp_std_values_17_14_11_11.text_data AS f306,

rfp_std_values_17_14_11_10.logical_data AS f307,

rfp_std_values_17_14_10_13.numeric_data AS f308,

rfp_std_values_17_14_10_12.numeric_data AS f309,

rfp_std_values_17_14_10_11.text_data AS f310,

rfp_std_values_17_14_10_10.logical_data AS f311,

rfp_std_values_11_15_23_10.numeric_data AS f312,

rfp_std_values_11_15_23_11.logical_data AS f313,

rfp_std_values_11_15_22_10.numeric_data AS f314,

rfp_std_values_11_15_22_11.logical_data AS f315,

rfp_std_values_11_15_21_10.numeric_data AS f316,

rfp_std_values_11_15_21_11.logical_data AS f317,

rfp_std_values_11_15_20_10.numeric_data AS f318,

rfp_std_values_11_15_20_11.logical_data AS f319,

rfp_std_values_11_15_19_11.numeric_data AS f320,

rfp_std_values_11_15_19_12.logical_data AS f321,

rfp_std_values_11_15_18_11.text_data AS f322,

rfp_std_values_11_15_18_10.logical_data AS f323,

rfp_std_values_11_15_24_11.text_data AS f324,

rfp_std_values_11_15_24_10.logical_data AS f325,

rfp_std_values_11_15_17_11.text_data AS f326,

rfp_std_values_11_15_17_10.logical_data AS f327,

rfp_std_values_11_15_15_11.text_data AS f328,

rfp_std_values_11_15_15_10.logical_data AS f329,

rfp_std_values_11_15_13_11.text_data AS f330,

rfp_std_values_11_15_13_10.logical_data AS f331,

rfp_std_values_11_15_26_11.text_data AS f332,

rfp_std_values_11_15_26_10.logical_data AS f333,

rfp_std_values_11_15_12_12.text_data AS f334,

rfp_std_values_11_15_12_10.logical_data AS f335,

rfp_std_values_11_15_11_11.text_data AS f336,

rfp_std_values_11_15_11_10.logical_data AS f337,

rfp_std_values_11_15_25_11.text_data AS f338,

rfp_std_values_11_15_25_10.logical_data AS f339,

rfp_std_values_11_15_10_11.text_data AS f340,

rfp_std_values_11_15_10_10.logical_data AS f341,

rfp_std_values_11_13_12_11.text_data AS f342,

rfp_std_values_11_13_12_10.logical_data AS f343,

rfp_std_values_11_13_11_11.text_data AS f344,

rfp_std_values_11_13_11_10.logical_data AS f345,

rfp_std_values_11_13_13_11.text_data AS f346,

rfp_std_values_11_13_13_10.logical_data AS f347,

rfp_std_values_11_13_10_11.text_data AS f348,

rfp_std_values_11_13_10_12.numeric_data AS f349,

rfp_std_values_11_13_10_10.logical_data AS f350,

rfp_std_values_11_10_12_11.text_data AS f351,

rfp_std_values_11_10_12_10.logical_data AS f352,

rfp_std_values_11_12_14_12.numeric_data AS f353,

rfp_std_values_11_12_14_11.text_data AS f354,

rfp_std_values_11_12_14_10.logical_data AS f355,

rfp_std_values_11_12_13_11.text_data AS f356,

rfp_std_values_11_12_13_10.logical_data AS f357,

rfp_std_values_11_12_11_11.text_data AS f358,

rfp_std_values_11_12_11_10.logical_data AS f359,

rfp_std_values_11_12_10_11.text_data AS f360,

rfp_std_values_11_12_10_10.logical_data AS f361,

rfp_std_values_10_14_10_10.text_data AS f362,

rfp_std_values_10_12_12_10.text_data AS f363,

rfp_std_values_10_12_11_11.text_data AS f364,

rfp_std_values_10_12_10_11.text_data AS f365,

rfp_std_values_10_12_10_10.logical_data AS f366,

rfp_std_values_10_13_18_11.text_data AS f367,

rfp_std_values_10_13_18_10.logical_data AS f368,

rfp_std_values_10_13_17_10.numeric_data AS f369,

rfp_std_values_10_13_14_11.text_data AS f370,

rfp_std_values_10_13_14_10.numeric_data AS f371,

rfp_std_values_10_13_15_12.text_data AS f372,

rfp_std_values_10_13_15_11.text_data AS f373,

rfp_std_values_10_13_15_10.text_data AS f374,

rfp_std_values_10_13_16_10.numeric_data AS f375,

rel_3.due_date AS f376,

rel_3.description AS f377,

rel_3.name AS f378,

rel_3.code AS f379,

rel_4.due_date AS f380,

rel_4.description AS f381,

rel_4.name AS f382,

rel_4.code AS f383,

standard_room.room_note AS f384,

standard_room.description AS f385,

standard_room.id AS f386,

standard_room.programmed_sqm AS f387,

standard_room.name AS f388,

standard_room.room_func_no AS f389,

rel_1.classification_type_id AS f390,

rel_1.standard_room_id AS f391,

rel_2.classification_type_id AS f392,

rel_2.standard_room_id AS f393,

rel_3.id AS f394,

(

SELECT count(*)

FROM classification_entry s2

WHERE s2.parent_id = rel_3.id) AS f395,

rel_3.parent_id AS f396,

rel_3.type_id AS f397,

rel_4.id AS f398,

(

SELECT count(*)

FROM classification_entry s2

WHERE s2.parent_id = rel_4.id) AS f399,

rel_4.parent_id AS f400,

rel_4.type_id AS f401

FROM standard_room standard_room

join limit_page

ON (

standard_room.id = limit_page.id)

left join standard_room_classification rel_1

ON (

rel_1.standard_room_id = standard_room.id

AND rel_1.classification_type_id = 114)

left join standard_room_classification rel_2

ON (

rel_2.standard_room_id = standard_room.id

AND rel_2.classification_type_id = 104)

left join rfp_std_values rfp_std_values_22_10_10_10

ON (

rfp_std_values_22_10_10_10.room = standard_room.id

AND rfp_std_values_22_10_10_10.flag_no = '22'

AND rfp_std_values_22_10_10_10.group_no = '10'

AND rfp_std_values_22_10_10_10.group_element_no = '10'

AND rfp_std_values_22_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_21_10_10_10

ON (

rfp_std_values_21_10_10_10.room = standard_room.id

AND rfp_std_values_21_10_10_10.flag_no = '21'

AND rfp_std_values_21_10_10_10.group_no = '10'

AND rfp_std_values_21_10_10_10.group_element_no = '10'

AND rfp_std_values_21_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_20_11_12_10

ON (

rfp_std_values_20_11_12_10.room = standard_room.id

AND rfp_std_values_20_11_12_10.flag_no = '20'

AND rfp_std_values_20_11_12_10.group_no = '11'

AND rfp_std_values_20_11_12_10.group_element_no = '12'

AND rfp_std_values_20_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_20_11_11_10

ON (

rfp_std_values_20_11_11_10.room = standard_room.id

AND rfp_std_values_20_11_11_10.flag_no = '20'

AND rfp_std_values_20_11_11_10.group_no = '11'

AND rfp_std_values_20_11_11_10.group_element_no = '11'

AND rfp_std_values_20_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_20_11_10_10

ON (

rfp_std_values_20_11_10_10.room = standard_room.id

AND rfp_std_values_20_11_10_10.flag_no = '20'

AND rfp_std_values_20_11_10_10.group_no = '11'

AND rfp_std_values_20_11_10_10.group_element_no = '10'

AND rfp_std_values_20_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_20_10_10_12

ON (

rfp_std_values_20_10_10_12.room = standard_room.id

AND rfp_std_values_20_10_10_12.flag_no = '20'

AND rfp_std_values_20_10_10_12.group_no = '10'

AND rfp_std_values_20_10_10_12.group_element_no = '10'

AND rfp_std_values_20_10_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_18_11_10_10

ON (

rfp_std_values_18_11_10_10.room = standard_room.id

AND rfp_std_values_18_11_10_10.flag_no = '18'

AND rfp_std_values_18_11_10_10.group_no = '11'

AND rfp_std_values_18_11_10_10.group_element_no = '10'

AND rfp_std_values_18_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_18_10_13_11

ON (

rfp_std_values_18_10_13_11.room = standard_room.id

AND rfp_std_values_18_10_13_11.flag_no = '18'

AND rfp_std_values_18_10_13_11.group_no = '10'

AND rfp_std_values_18_10_13_11.group_element_no = '13'

AND rfp_std_values_18_10_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_18_10_13_10

ON (

rfp_std_values_18_10_13_10.room = standard_room.id

AND rfp_std_values_18_10_13_10.flag_no = '18'

AND rfp_std_values_18_10_13_10.group_no = '10'

AND rfp_std_values_18_10_13_10.group_element_no = '13'

AND rfp_std_values_18_10_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_18_10_10_11

ON (

rfp_std_values_18_10_10_11.room = standard_room.id

AND rfp_std_values_18_10_10_11.flag_no = '18'

AND rfp_std_values_18_10_10_11.group_no = '10'

AND rfp_std_values_18_10_10_11.group_element_no = '10'

AND rfp_std_values_18_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_18_10_10_10

ON (

rfp_std_values_18_10_10_10.room = standard_room.id

AND rfp_std_values_18_10_10_10.flag_no = '18'

AND rfp_std_values_18_10_10_10.group_no = '10'

AND rfp_std_values_18_10_10_10.group_element_no = '10'

AND rfp_std_values_18_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_18_10_11_11

ON (

rfp_std_values_18_10_11_11.room = standard_room.id

AND rfp_std_values_18_10_11_11.flag_no = '18'

AND rfp_std_values_18_10_11_11.group_no = '10'

AND rfp_std_values_18_10_11_11.group_element_no = '11'

AND rfp_std_values_18_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_18_10_11_10

ON (

rfp_std_values_18_10_11_10.room = standard_room.id

AND rfp_std_values_18_10_11_10.flag_no = '18'

AND rfp_std_values_18_10_11_10.group_no = '10'

AND rfp_std_values_18_10_11_10.group_element_no = '11'

AND rfp_std_values_18_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_18_10_12_11

ON (

rfp_std_values_18_10_12_11.room = standard_room.id

AND rfp_std_values_18_10_12_11.flag_no = '18'

AND rfp_std_values_18_10_12_11.group_no = '10'

AND rfp_std_values_18_10_12_11.group_element_no = '12'

AND rfp_std_values_18_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_18_10_12_10

ON (

rfp_std_values_18_10_12_10.room = standard_room.id

AND rfp_std_values_18_10_12_10.flag_no = '18'

AND rfp_std_values_18_10_12_10.group_no = '10'

AND rfp_std_values_18_10_12_10.group_element_no = '12'

AND rfp_std_values_18_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_15_12_10_10

ON (

rfp_std_values_15_12_10_10.room = standard_room.id

AND rfp_std_values_15_12_10_10.flag_no = '15'

AND rfp_std_values_15_12_10_10.group_no = '12'

AND rfp_std_values_15_12_10_10.group_element_no = '10'

AND rfp_std_values_15_12_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_15_11_12_11

ON (

rfp_std_values_15_11_12_11.room = standard_room.id

AND rfp_std_values_15_11_12_11.flag_no = '15'

AND rfp_std_values_15_11_12_11.group_no = '11'

AND rfp_std_values_15_11_12_11.group_element_no = '12'

AND rfp_std_values_15_11_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_15_11_12_10

ON (

rfp_std_values_15_11_12_10.room = standard_room.id

AND rfp_std_values_15_11_12_10.flag_no = '15'

AND rfp_std_values_15_11_12_10.group_no = '11'

AND rfp_std_values_15_11_12_10.group_element_no = '12'

AND rfp_std_values_15_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_15_11_11_11

ON (

rfp_std_values_15_11_11_11.room = standard_room.id

AND rfp_std_values_15_11_11_11.flag_no = '15'

AND rfp_std_values_15_11_11_11.group_no = '11'

AND rfp_std_values_15_11_11_11.group_element_no = '11'

AND rfp_std_values_15_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_15_11_11_10

ON (

rfp_std_values_15_11_11_10.room = standard_room.id

AND rfp_std_values_15_11_11_10.flag_no = '15'

AND rfp_std_values_15_11_11_10.group_no = '11'

AND rfp_std_values_15_11_11_10.group_element_no = '11'

AND rfp_std_values_15_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_15_11_10_11

ON (

rfp_std_values_15_11_10_11.room = standard_room.id

AND rfp_std_values_15_11_10_11.flag_no = '15'

AND rfp_std_values_15_11_10_11.group_no = '11'

AND rfp_std_values_15_11_10_11.group_element_no = '10'

AND rfp_std_values_15_11_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_15_11_10_10

ON (

rfp_std_values_15_11_10_10.room = standard_room.id

AND rfp_std_values_15_11_10_10.flag_no = '15'

AND rfp_std_values_15_11_10_10.group_no = '11'

AND rfp_std_values_15_11_10_10.group_element_no = '10'

AND rfp_std_values_15_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_15_10_10_11

ON (

rfp_std_values_15_10_10_11.room = standard_room.id

AND rfp_std_values_15_10_10_11.flag_no = '15'

AND rfp_std_values_15_10_10_11.group_no = '10'

AND rfp_std_values_15_10_10_11.group_element_no = '10'

AND rfp_std_values_15_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_15_10_10_10

ON (

rfp_std_values_15_10_10_10.room = standard_room.id

AND rfp_std_values_15_10_10_10.flag_no = '15'

AND rfp_std_values_15_10_10_10.group_no = '10'

AND rfp_std_values_15_10_10_10.group_element_no = '10'

AND rfp_std_values_15_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_14_10_10

ON (

rfp_std_values_19_14_10_10.room = standard_room.id

AND rfp_std_values_19_14_10_10.flag_no = '19'

AND rfp_std_values_19_14_10_10.group_no = '14'

AND rfp_std_values_19_14_10_10.group_element_no = '10'

AND rfp_std_values_19_14_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_12_11_12

ON (

rfp_std_values_19_12_11_12.room = standard_room.id

AND rfp_std_values_19_12_11_12.flag_no = '19'

AND rfp_std_values_19_12_11_12.group_no = '12'

AND rfp_std_values_19_12_11_12.group_element_no = '11'

AND rfp_std_values_19_12_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_12_11_11

ON (

rfp_std_values_19_12_11_11.room = standard_room.id

AND rfp_std_values_19_12_11_11.flag_no = '19'

AND rfp_std_values_19_12_11_11.group_no = '12'

AND rfp_std_values_19_12_11_11.group_element_no = '11'

AND rfp_std_values_19_12_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_12_11_10

ON (

rfp_std_values_19_12_11_10.room = standard_room.id

AND rfp_std_values_19_12_11_10.flag_no = '19'

AND rfp_std_values_19_12_11_10.group_no = '12'

AND rfp_std_values_19_12_11_10.group_element_no = '11'

AND rfp_std_values_19_12_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_12_10_12

ON (

rfp_std_values_19_12_10_12.room = standard_room.id

AND rfp_std_values_19_12_10_12.flag_no = '19'

AND rfp_std_values_19_12_10_12.group_no = '12'

AND rfp_std_values_19_12_10_12.group_element_no = '10'

AND rfp_std_values_19_12_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_12_10_11

ON (

rfp_std_values_19_12_10_11.room = standard_room.id

AND rfp_std_values_19_12_10_11.flag_no = '19'

AND rfp_std_values_19_12_10_11.group_no = '12'

AND rfp_std_values_19_12_10_11.group_element_no = '10'

AND rfp_std_values_19_12_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_12_10_10

ON (

rfp_std_values_19_12_10_10.room = standard_room.id

AND rfp_std_values_19_12_10_10.flag_no = '19'

AND rfp_std_values_19_12_10_10.group_no = '12'

AND rfp_std_values_19_12_10_10.group_element_no = '10'

AND rfp_std_values_19_12_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_13_12_12

ON (

rfp_std_values_19_13_12_12.room = standard_room.id

AND rfp_std_values_19_13_12_12.flag_no = '19'

AND rfp_std_values_19_13_12_12.group_no = '13'

AND rfp_std_values_19_13_12_12.group_element_no = '12'

AND rfp_std_values_19_13_12_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_13_12_11

ON (

rfp_std_values_19_13_12_11.room = standard_room.id

AND rfp_std_values_19_13_12_11.flag_no = '19'

AND rfp_std_values_19_13_12_11.group_no = '13'

AND rfp_std_values_19_13_12_11.group_element_no = '12'

AND rfp_std_values_19_13_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_13_12_10

ON (

rfp_std_values_19_13_12_10.room = standard_room.id

AND rfp_std_values_19_13_12_10.flag_no = '19'

AND rfp_std_values_19_13_12_10.group_no = '13'

AND rfp_std_values_19_13_12_10.group_element_no = '12'

AND rfp_std_values_19_13_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_13_11_12

ON (

rfp_std_values_19_13_11_12.room = standard_room.id

AND rfp_std_values_19_13_11_12.flag_no = '19'

AND rfp_std_values_19_13_11_12.group_no = '13'

AND rfp_std_values_19_13_11_12.group_element_no = '11'

AND rfp_std_values_19_13_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_13_11_11

ON (

rfp_std_values_19_13_11_11.room = standard_room.id

AND rfp_std_values_19_13_11_11.flag_no = '19'

AND rfp_std_values_19_13_11_11.group_no = '13'

AND rfp_std_values_19_13_11_11.group_element_no = '11'

AND rfp_std_values_19_13_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_13_11_10

ON (

rfp_std_values_19_13_11_10.room = standard_room.id

AND rfp_std_values_19_13_11_10.flag_no = '19'

AND rfp_std_values_19_13_11_10.group_no = '13'

AND rfp_std_values_19_13_11_10.group_element_no = '11'

AND rfp_std_values_19_13_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_13_10_12

ON (

rfp_std_values_19_13_10_12.room = standard_room.id

AND rfp_std_values_19_13_10_12.flag_no = '19'

AND rfp_std_values_19_13_10_12.group_no = '13'

AND rfp_std_values_19_13_10_12.group_element_no = '10'

AND rfp_std_values_19_13_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_13_10_11

ON (

rfp_std_values_19_13_10_11.room = standard_room.id

AND rfp_std_values_19_13_10_11.flag_no = '19'

AND rfp_std_values_19_13_10_11.group_no = '13'

AND rfp_std_values_19_13_10_11.group_element_no = '10'

AND rfp_std_values_19_13_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_13_10_10

ON (

rfp_std_values_19_13_10_10.room = standard_room.id

AND rfp_std_values_19_13_10_10.flag_no = '19'

AND rfp_std_values_19_13_10_10.group_no = '13'

AND rfp_std_values_19_13_10_10.group_element_no = '10'

AND rfp_std_values_19_13_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_14_12

ON (

rfp_std_values_19_11_14_12.room = standard_room.id

AND rfp_std_values_19_11_14_12.flag_no = '19'

AND rfp_std_values_19_11_14_12.group_no = '11'

AND rfp_std_values_19_11_14_12.group_element_no = '14'

AND rfp_std_values_19_11_14_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_11_14_11

ON (

rfp_std_values_19_11_14_11.room = standard_room.id

AND rfp_std_values_19_11_14_11.flag_no = '19'

AND rfp_std_values_19_11_14_11.group_no = '11'

AND rfp_std_values_19_11_14_11.group_element_no = '14'

AND rfp_std_values_19_11_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_11_14_10

ON (

rfp_std_values_19_11_14_10.room = standard_room.id

AND rfp_std_values_19_11_14_10.flag_no = '19'

AND rfp_std_values_19_11_14_10.group_no = '11'

AND rfp_std_values_19_11_14_10.group_element_no = '14'

AND rfp_std_values_19_11_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_13_12

ON (

rfp_std_values_19_11_13_12.room = standard_room.id

AND rfp_std_values_19_11_13_12.flag_no = '19'

AND rfp_std_values_19_11_13_12.group_no = '11'

AND rfp_std_values_19_11_13_12.group_element_no = '13'

AND rfp_std_values_19_11_13_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_11_13_11

ON (

rfp_std_values_19_11_13_11.room = standard_room.id

AND rfp_std_values_19_11_13_11.flag_no = '19'

AND rfp_std_values_19_11_13_11.group_no = '11'

AND rfp_std_values_19_11_13_11.group_element_no = '13'

AND rfp_std_values_19_11_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_11_13_10

ON (

rfp_std_values_19_11_13_10.room = standard_room.id

AND rfp_std_values_19_11_13_10.flag_no = '19'

AND rfp_std_values_19_11_13_10.group_no = '11'

AND rfp_std_values_19_11_13_10.group_element_no = '13'

AND rfp_std_values_19_11_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_12_12

ON (

rfp_std_values_19_11_12_12.room = standard_room.id

AND rfp_std_values_19_11_12_12.flag_no = '19'

AND rfp_std_values_19_11_12_12.group_no = '11'

AND rfp_std_values_19_11_12_12.group_element_no = '12'

AND rfp_std_values_19_11_12_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_11_12_11

ON (

rfp_std_values_19_11_12_11.room = standard_room.id

AND rfp_std_values_19_11_12_11.flag_no = '19'

AND rfp_std_values_19_11_12_11.group_no = '11'

AND rfp_std_values_19_11_12_11.group_element_no = '12'

AND rfp_std_values_19_11_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_11_12_10

ON (

rfp_std_values_19_11_12_10.room = standard_room.id

AND rfp_std_values_19_11_12_10.flag_no = '19'

AND rfp_std_values_19_11_12_10.group_no = '11'

AND rfp_std_values_19_11_12_10.group_element_no = '12'

AND rfp_std_values_19_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_11_11

ON (

rfp_std_values_19_11_11_11.room = standard_room.id

AND rfp_std_values_19_11_11_11.flag_no = '19'

AND rfp_std_values_19_11_11_11.group_no = '11'

AND rfp_std_values_19_11_11_11.group_element_no = '11'

AND rfp_std_values_19_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_11_11_10

ON (

rfp_std_values_19_11_11_10.room = standard_room.id

AND rfp_std_values_19_11_11_10.flag_no = '19'

AND rfp_std_values_19_11_11_10.group_no = '11'

AND rfp_std_values_19_11_11_10.group_element_no = '11'

AND rfp_std_values_19_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_11_12

ON (

rfp_std_values_19_11_11_12.room = standard_room.id

AND rfp_std_values_19_11_11_12.flag_no = '19'

AND rfp_std_values_19_11_11_12.group_no = '11'

AND rfp_std_values_19_11_11_12.group_element_no = '11'

AND rfp_std_values_19_11_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_11_10_11

ON (

rfp_std_values_19_11_10_11.room = standard_room.id

AND rfp_std_values_19_11_10_11.flag_no = '19'

AND rfp_std_values_19_11_10_11.group_no = '11'

AND rfp_std_values_19_11_10_11.group_element_no = '10'

AND rfp_std_values_19_11_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_11_10_10

ON (

rfp_std_values_19_11_10_10.room = standard_room.id

AND rfp_std_values_19_11_10_10.flag_no = '19'

AND rfp_std_values_19_11_10_10.group_no = '11'

AND rfp_std_values_19_11_10_10.group_element_no = '10'

AND rfp_std_values_19_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_11_10_12

ON (

rfp_std_values_19_11_10_12.room = standard_room.id

AND rfp_std_values_19_11_10_12.flag_no = '19'

AND rfp_std_values_19_11_10_12.group_no = '11'

AND rfp_std_values_19_11_10_12.group_element_no = '10'

AND rfp_std_values_19_11_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_10_13_11

ON (

rfp_std_values_19_10_13_11.room = standard_room.id

AND rfp_std_values_19_10_13_11.flag_no = '19'

AND rfp_std_values_19_10_13_11.group_no = '10'

AND rfp_std_values_19_10_13_11.group_element_no = '13'

AND rfp_std_values_19_10_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_10_13_10

ON (

rfp_std_values_19_10_13_10.room = standard_room.id

AND rfp_std_values_19_10_13_10.flag_no = '19'

AND rfp_std_values_19_10_13_10.group_no = '10'

AND rfp_std_values_19_10_13_10.group_element_no = '13'

AND rfp_std_values_19_10_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_10_13_12

ON (

rfp_std_values_19_10_13_12.room = standard_room.id

AND rfp_std_values_19_10_13_12.flag_no = '19'

AND rfp_std_values_19_10_13_12.group_no = '10'

AND rfp_std_values_19_10_13_12.group_element_no = '13'

AND rfp_std_values_19_10_13_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_10_12_11

ON (

rfp_std_values_19_10_12_11.room = standard_room.id

AND rfp_std_values_19_10_12_11.flag_no = '19'

AND rfp_std_values_19_10_12_11.group_no = '10'

AND rfp_std_values_19_10_12_11.group_element_no = '12'

AND rfp_std_values_19_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_10_12_10

ON (

rfp_std_values_19_10_12_10.room = standard_room.id

AND rfp_std_values_19_10_12_10.flag_no = '19'

AND rfp_std_values_19_10_12_10.group_no = '10'

AND rfp_std_values_19_10_12_10.group_element_no = '12'

AND rfp_std_values_19_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_10_12_12

ON (

rfp_std_values_19_10_12_12.room = standard_room.id

AND rfp_std_values_19_10_12_12.flag_no = '19'

AND rfp_std_values_19_10_12_12.group_no = '10'

AND rfp_std_values_19_10_12_12.group_element_no = '12'

AND rfp_std_values_19_10_12_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_10_11_11

ON (

rfp_std_values_19_10_11_11.room = standard_room.id

AND rfp_std_values_19_10_11_11.flag_no = '19'

AND rfp_std_values_19_10_11_11.group_no = '10'

AND rfp_std_values_19_10_11_11.group_element_no = '11'

AND rfp_std_values_19_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_10_11_10

ON (

rfp_std_values_19_10_11_10.room = standard_room.id

AND rfp_std_values_19_10_11_10.flag_no = '19'

AND rfp_std_values_19_10_11_10.group_no = '10'

AND rfp_std_values_19_10_11_10.group_element_no = '11'

AND rfp_std_values_19_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_10_11_12

ON (

rfp_std_values_19_10_11_12.room = standard_room.id

AND rfp_std_values_19_10_11_12.flag_no = '19'

AND rfp_std_values_19_10_11_12.group_no = '10'

AND rfp_std_values_19_10_11_12.group_element_no = '11'

AND rfp_std_values_19_10_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_19_10_10_11

ON (

rfp_std_values_19_10_10_11.room = standard_room.id

AND rfp_std_values_19_10_10_11.flag_no = '19'

AND rfp_std_values_19_10_10_11.group_no = '10'

AND rfp_std_values_19_10_10_11.group_element_no = '10'

AND rfp_std_values_19_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_19_10_10_10

ON (

rfp_std_values_19_10_10_10.room = standard_room.id

AND rfp_std_values_19_10_10_10.flag_no = '19'

AND rfp_std_values_19_10_10_10.group_no = '10'

AND rfp_std_values_19_10_10_10.group_element_no = '10'

AND rfp_std_values_19_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_19_10_10_12

ON (

rfp_std_values_19_10_10_12.room = standard_room.id

AND rfp_std_values_19_10_10_12.flag_no = '19'

AND rfp_std_values_19_10_10_12.group_no = '10'

AND rfp_std_values_19_10_10_12.group_element_no = '10'

AND rfp_std_values_19_10_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_13_13_14_11

ON (

rfp_std_values_13_13_14_11.room = standard_room.id

AND rfp_std_values_13_13_14_11.flag_no = '13'

AND rfp_std_values_13_13_14_11.group_no = '13'

AND rfp_std_values_13_13_14_11.group_element_no = '14'

AND rfp_std_values_13_13_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_13_14_10

ON (

rfp_std_values_13_13_14_10.room = standard_room.id

AND rfp_std_values_13_13_14_10.flag_no = '13'

AND rfp_std_values_13_13_14_10.group_no = '13'

AND rfp_std_values_13_13_14_10.group_element_no = '14'

AND rfp_std_values_13_13_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_13_13_11

ON (

rfp_std_values_13_13_13_11.room = standard_room.id

AND rfp_std_values_13_13_13_11.flag_no = '13'

AND rfp_std_values_13_13_13_11.group_no = '13'

AND rfp_std_values_13_13_13_11.group_element_no = '13'

AND rfp_std_values_13_13_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_13_13_10

ON (

rfp_std_values_13_13_13_10.room = standard_room.id

AND rfp_std_values_13_13_13_10.flag_no = '13'

AND rfp_std_values_13_13_13_10.group_no = '13'

AND rfp_std_values_13_13_13_10.group_element_no = '13'

AND rfp_std_values_13_13_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_13_12_11

ON (

rfp_std_values_13_13_12_11.room = standard_room.id

AND rfp_std_values_13_13_12_11.flag_no = '13'

AND rfp_std_values_13_13_12_11.group_no = '13'

AND rfp_std_values_13_13_12_11.group_element_no = '12'

AND rfp_std_values_13_13_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_13_12_10

ON (

rfp_std_values_13_13_12_10.room = standard_room.id

AND rfp_std_values_13_13_12_10.flag_no = '13'

AND rfp_std_values_13_13_12_10.group_no = '13'

AND rfp_std_values_13_13_12_10.group_element_no = '12'

AND rfp_std_values_13_13_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_13_11_11

ON (

rfp_std_values_13_13_11_11.room = standard_room.id

AND rfp_std_values_13_13_11_11.flag_no = '13'

AND rfp_std_values_13_13_11_11.group_no = '13'

AND rfp_std_values_13_13_11_11.group_element_no = '11'

AND rfp_std_values_13_13_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_13_11_10

ON (

rfp_std_values_13_13_11_10.room = standard_room.id

AND rfp_std_values_13_13_11_10.flag_no = '13'

AND rfp_std_values_13_13_11_10.group_no = '13'

AND rfp_std_values_13_13_11_10.group_element_no = '11'

AND rfp_std_values_13_13_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_13_10_11

ON (

rfp_std_values_13_13_10_11.room = standard_room.id

AND rfp_std_values_13_13_10_11.flag_no = '13'

AND rfp_std_values_13_13_10_11.group_no = '13'

AND rfp_std_values_13_13_10_11.group_element_no = '10'

AND rfp_std_values_13_13_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_13_10_10

ON (

rfp_std_values_13_13_10_10.room = standard_room.id

AND rfp_std_values_13_13_10_10.flag_no = '13'

AND rfp_std_values_13_13_10_10.group_no = '13'

AND rfp_std_values_13_13_10_10.group_element_no = '10'

AND rfp_std_values_13_13_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_20_11

ON (

rfp_std_values_13_12_20_11.room = standard_room.id

AND rfp_std_values_13_12_20_11.flag_no = '13'

AND rfp_std_values_13_12_20_11.group_no = '12'

AND rfp_std_values_13_12_20_11.group_element_no = '20'

AND rfp_std_values_13_12_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_20_10

ON (

rfp_std_values_13_12_20_10.room = standard_room.id

AND rfp_std_values_13_12_20_10.flag_no = '13'

AND rfp_std_values_13_12_20_10.group_no = '12'

AND rfp_std_values_13_12_20_10.group_element_no = '20'

AND rfp_std_values_13_12_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_19_11

ON (

rfp_std_values_13_12_19_11.room = standard_room.id

AND rfp_std_values_13_12_19_11.flag_no = '13'

AND rfp_std_values_13_12_19_11.group_no = '12'

AND rfp_std_values_13_12_19_11.group_element_no = '19'

AND rfp_std_values_13_12_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_19_10

ON (

rfp_std_values_13_12_19_10.room = standard_room.id

AND rfp_std_values_13_12_19_10.flag_no = '13'

AND rfp_std_values_13_12_19_10.group_no = '12'

AND rfp_std_values_13_12_19_10.group_element_no = '19'

AND rfp_std_values_13_12_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_17_11

ON (

rfp_std_values_13_12_17_11.room = standard_room.id

AND rfp_std_values_13_12_17_11.flag_no = '13'

AND rfp_std_values_13_12_17_11.group_no = '12'

AND rfp_std_values_13_12_17_11.group_element_no = '17'

AND rfp_std_values_13_12_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_17_10

ON (

rfp_std_values_13_12_17_10.room = standard_room.id

AND rfp_std_values_13_12_17_10.flag_no = '13'

AND rfp_std_values_13_12_17_10.group_no = '12'

AND rfp_std_values_13_12_17_10.group_element_no = '17'

AND rfp_std_values_13_12_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_16_11

ON (

rfp_std_values_13_12_16_11.room = standard_room.id

AND rfp_std_values_13_12_16_11.flag_no = '13'

AND rfp_std_values_13_12_16_11.group_no = '12'

AND rfp_std_values_13_12_16_11.group_element_no = '16'

AND rfp_std_values_13_12_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_16_10

ON (

rfp_std_values_13_12_16_10.room = standard_room.id

AND rfp_std_values_13_12_16_10.flag_no = '13'

AND rfp_std_values_13_12_16_10.group_no = '12'

AND rfp_std_values_13_12_16_10.group_element_no = '16'

AND rfp_std_values_13_12_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_15_11

ON (

rfp_std_values_13_12_15_11.room = standard_room.id

AND rfp_std_values_13_12_15_11.flag_no = '13'

AND rfp_std_values_13_12_15_11.group_no = '12'

AND rfp_std_values_13_12_15_11.group_element_no = '15'

AND rfp_std_values_13_12_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_15_10

ON (

rfp_std_values_13_12_15_10.room = standard_room.id

AND rfp_std_values_13_12_15_10.flag_no = '13'

AND rfp_std_values_13_12_15_10.group_no = '12'

AND rfp_std_values_13_12_15_10.group_element_no = '15'

AND rfp_std_values_13_12_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_14_11

ON (

rfp_std_values_13_12_14_11.room = standard_room.id

AND rfp_std_values_13_12_14_11.flag_no = '13'

AND rfp_std_values_13_12_14_11.group_no = '12'

AND rfp_std_values_13_12_14_11.group_element_no = '14'

AND rfp_std_values_13_12_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_14_10

ON (

rfp_std_values_13_12_14_10.room = standard_room.id

AND rfp_std_values_13_12_14_10.flag_no = '13'

AND rfp_std_values_13_12_14_10.group_no = '12'

AND rfp_std_values_13_12_14_10.group_element_no = '14'

AND rfp_std_values_13_12_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_11_11

ON (

rfp_std_values_13_12_11_11.room = standard_room.id

AND rfp_std_values_13_12_11_11.flag_no = '13'

AND rfp_std_values_13_12_11_11.group_no = '12'

AND rfp_std_values_13_12_11_11.group_element_no = '11'

AND rfp_std_values_13_12_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_11_10

ON (

rfp_std_values_13_12_11_10.room = standard_room.id

AND rfp_std_values_13_12_11_10.flag_no = '13'

AND rfp_std_values_13_12_11_10.group_no = '12'

AND rfp_std_values_13_12_11_10.group_element_no = '11'

AND rfp_std_values_13_12_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_13_11

ON (

rfp_std_values_13_12_13_11.room = standard_room.id

AND rfp_std_values_13_12_13_11.flag_no = '13'

AND rfp_std_values_13_12_13_11.group_no = '12'

AND rfp_std_values_13_12_13_11.group_element_no = '13'

AND rfp_std_values_13_12_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_13_10

ON (

rfp_std_values_13_12_13_10.room = standard_room.id

AND rfp_std_values_13_12_13_10.flag_no = '13'

AND rfp_std_values_13_12_13_10.group_no = '12'

AND rfp_std_values_13_12_13_10.group_element_no = '13'

AND rfp_std_values_13_12_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_12_10_11

ON (

rfp_std_values_13_12_10_11.room = standard_room.id

AND rfp_std_values_13_12_10_11.flag_no = '13'

AND rfp_std_values_13_12_10_11.group_no = '12'

AND rfp_std_values_13_12_10_11.group_element_no = '10'

AND rfp_std_values_13_12_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_12_10_10

ON (

rfp_std_values_13_12_10_10.room = standard_room.id

AND rfp_std_values_13_12_10_10.flag_no = '13'

AND rfp_std_values_13_12_10_10.group_no = '12'

AND rfp_std_values_13_12_10_10.group_element_no = '10'

AND rfp_std_values_13_12_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_11_16_11

ON (

rfp_std_values_13_11_16_11.room = standard_room.id

AND rfp_std_values_13_11_16_11.flag_no = '13'

AND rfp_std_values_13_11_16_11.group_no = '11'

AND rfp_std_values_13_11_16_11.group_element_no = '16'

AND rfp_std_values_13_11_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_11_16_10

ON (

rfp_std_values_13_11_16_10.room = standard_room.id

AND rfp_std_values_13_11_16_10.flag_no = '13'

AND rfp_std_values_13_11_16_10.group_no = '11'

AND rfp_std_values_13_11_16_10.group_element_no = '16'

AND rfp_std_values_13_11_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_11_13_11

ON (

rfp_std_values_13_11_13_11.room = standard_room.id

AND rfp_std_values_13_11_13_11.flag_no = '13'

AND rfp_std_values_13_11_13_11.group_no = '11'

AND rfp_std_values_13_11_13_11.group_element_no = '13'

AND rfp_std_values_13_11_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_11_13_10

ON (

rfp_std_values_13_11_13_10.room = standard_room.id

AND rfp_std_values_13_11_13_10.flag_no = '13'

AND rfp_std_values_13_11_13_10.group_no = '11'

AND rfp_std_values_13_11_13_10.group_element_no = '13'

AND rfp_std_values_13_11_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_11_11_11

ON (

rfp_std_values_13_11_11_11.room = standard_room.id

AND rfp_std_values_13_11_11_11.flag_no = '13'

AND rfp_std_values_13_11_11_11.group_no = '11'

AND rfp_std_values_13_11_11_11.group_element_no = '11'

AND rfp_std_values_13_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_11_11_10

ON (

rfp_std_values_13_11_11_10.room = standard_room.id

AND rfp_std_values_13_11_11_10.flag_no = '13'

AND rfp_std_values_13_11_11_10.group_no = '11'

AND rfp_std_values_13_11_11_10.group_element_no = '11'

AND rfp_std_values_13_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_11_10_11

ON (

rfp_std_values_13_11_10_11.room = standard_room.id

AND rfp_std_values_13_11_10_11.flag_no = '13'

AND rfp_std_values_13_11_10_11.group_no = '11'

AND rfp_std_values_13_11_10_11.group_element_no = '10'

AND rfp_std_values_13_11_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_11_10_10

ON (

rfp_std_values_13_11_10_10.room = standard_room.id

AND rfp_std_values_13_11_10_10.flag_no = '13'

AND rfp_std_values_13_11_10_10.group_no = '11'

AND rfp_std_values_13_11_10_10.group_element_no = '10'

AND rfp_std_values_13_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_10_15_11

ON (

rfp_std_values_13_10_15_11.room = standard_room.id

AND rfp_std_values_13_10_15_11.flag_no = '13'

AND rfp_std_values_13_10_15_11.group_no = '10'

AND rfp_std_values_13_10_15_11.group_element_no = '15'

AND rfp_std_values_13_10_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_10_15_10

ON (

rfp_std_values_13_10_15_10.room = standard_room.id

AND rfp_std_values_13_10_15_10.flag_no = '13'

AND rfp_std_values_13_10_15_10.group_no = '10'

AND rfp_std_values_13_10_15_10.group_element_no = '15'

AND rfp_std_values_13_10_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_10_14_11

ON (

rfp_std_values_13_10_14_11.room = standard_room.id

AND rfp_std_values_13_10_14_11.flag_no = '13'

AND rfp_std_values_13_10_14_11.group_no = '10'

AND rfp_std_values_13_10_14_11.group_element_no = '14'

AND rfp_std_values_13_10_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_10_14_10

ON (

rfp_std_values_13_10_14_10.room = standard_room.id

AND rfp_std_values_13_10_14_10.flag_no = '13'

AND rfp_std_values_13_10_14_10.group_no = '10'

AND rfp_std_values_13_10_14_10.group_element_no = '14'

AND rfp_std_values_13_10_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_10_12_11

ON (

rfp_std_values_13_10_12_11.room = standard_room.id

AND rfp_std_values_13_10_12_11.flag_no = '13'

AND rfp_std_values_13_10_12_11.group_no = '10'

AND rfp_std_values_13_10_12_11.group_element_no = '12'

AND rfp_std_values_13_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_10_12_10

ON (

rfp_std_values_13_10_12_10.room = standard_room.id

AND rfp_std_values_13_10_12_10.flag_no = '13'

AND rfp_std_values_13_10_12_10.group_no = '10'

AND rfp_std_values_13_10_12_10.group_element_no = '12'

AND rfp_std_values_13_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_10_11_11

ON (

rfp_std_values_13_10_11_11.room = standard_room.id

AND rfp_std_values_13_10_11_11.flag_no = '13'

AND rfp_std_values_13_10_11_11.group_no = '10'

AND rfp_std_values_13_10_11_11.group_element_no = '11'

AND rfp_std_values_13_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_10_11_10

ON (

rfp_std_values_13_10_11_10.room = standard_room.id

AND rfp_std_values_13_10_11_10.flag_no = '13'

AND rfp_std_values_13_10_11_10.group_no = '10'

AND rfp_std_values_13_10_11_10.group_element_no = '11'

AND rfp_std_values_13_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_13_10_10_11

ON (

rfp_std_values_13_10_10_11.room = standard_room.id

AND rfp_std_values_13_10_10_11.flag_no = '13'

AND rfp_std_values_13_10_10_11.group_no = '10'

AND rfp_std_values_13_10_10_11.group_element_no = '10'

AND rfp_std_values_13_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_13_10_10_10

ON (

rfp_std_values_13_10_10_10.room = standard_room.id

AND rfp_std_values_13_10_10_10.flag_no = '13'

AND rfp_std_values_13_10_10_10.group_no = '10'

AND rfp_std_values_13_10_10_10.group_element_no = '10'

AND rfp_std_values_13_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_18_12

ON (

rfp_std_values_12_10_18_12.room = standard_room.id

AND rfp_std_values_12_10_18_12.flag_no = '12'

AND rfp_std_values_12_10_18_12.group_no = '10'

AND rfp_std_values_12_10_18_12.group_element_no = '18'

AND rfp_std_values_12_10_18_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_10_18_11

ON (

rfp_std_values_12_10_18_11.room = standard_room.id

AND rfp_std_values_12_10_18_11.flag_no = '12'

AND rfp_std_values_12_10_18_11.group_no = '10'

AND rfp_std_values_12_10_18_11.group_element_no = '18'

AND rfp_std_values_12_10_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_18_10

ON (

rfp_std_values_12_10_18_10.room = standard_room.id

AND rfp_std_values_12_10_18_10.flag_no = '12'

AND rfp_std_values_12_10_18_10.group_no = '10'

AND rfp_std_values_12_10_18_10.group_element_no = '18'

AND rfp_std_values_12_10_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_20_12

ON (

rfp_std_values_12_10_20_12.room = standard_room.id

AND rfp_std_values_12_10_20_12.flag_no = '12'

AND rfp_std_values_12_10_20_12.group_no = '10'

AND rfp_std_values_12_10_20_12.group_element_no = '20'

AND rfp_std_values_12_10_20_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_10_20_11

ON (

rfp_std_values_12_10_20_11.room = standard_room.id

AND rfp_std_values_12_10_20_11.flag_no = '12'

AND rfp_std_values_12_10_20_11.group_no = '10'

AND rfp_std_values_12_10_20_11.group_element_no = '20'

AND rfp_std_values_12_10_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_20_10

ON (

rfp_std_values_12_10_20_10.room = standard_room.id

AND rfp_std_values_12_10_20_10.flag_no = '12'

AND rfp_std_values_12_10_20_10.group_no = '10'

AND rfp_std_values_12_10_20_10.group_element_no = '20'

AND rfp_std_values_12_10_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_17_12

ON (

rfp_std_values_12_10_17_12.room = standard_room.id

AND rfp_std_values_12_10_17_12.flag_no = '12'

AND rfp_std_values_12_10_17_12.group_no = '10'

AND rfp_std_values_12_10_17_12.group_element_no = '17'

AND rfp_std_values_12_10_17_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_10_17_11

ON (

rfp_std_values_12_10_17_11.room = standard_room.id

AND rfp_std_values_12_10_17_11.flag_no = '12'

AND rfp_std_values_12_10_17_11.group_no = '10'

AND rfp_std_values_12_10_17_11.group_element_no = '17'

AND rfp_std_values_12_10_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_17_10

ON (

rfp_std_values_12_10_17_10.room = standard_room.id

AND rfp_std_values_12_10_17_10.flag_no = '12'

AND rfp_std_values_12_10_17_10.group_no = '10'

AND rfp_std_values_12_10_17_10.group_element_no = '17'

AND rfp_std_values_12_10_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_16_12

ON (

rfp_std_values_12_10_16_12.room = standard_room.id

AND rfp_std_values_12_10_16_12.flag_no = '12'

AND rfp_std_values_12_10_16_12.group_no = '10'

AND rfp_std_values_12_10_16_12.group_element_no = '16'

AND rfp_std_values_12_10_16_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_10_16_11

ON (

rfp_std_values_12_10_16_11.room = standard_room.id

AND rfp_std_values_12_10_16_11.flag_no = '12'

AND rfp_std_values_12_10_16_11.group_no = '10'

AND rfp_std_values_12_10_16_11.group_element_no = '16'

AND rfp_std_values_12_10_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_16_10

ON (

rfp_std_values_12_10_16_10.room = standard_room.id

AND rfp_std_values_12_10_16_10.flag_no = '12'

AND rfp_std_values_12_10_16_10.group_no = '10'

AND rfp_std_values_12_10_16_10.group_element_no = '16'

AND rfp_std_values_12_10_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_15_11

ON (

rfp_std_values_12_10_15_11.room = standard_room.id

AND rfp_std_values_12_10_15_11.flag_no = '12'

AND rfp_std_values_12_10_15_11.group_no = '10'

AND rfp_std_values_12_10_15_11.group_element_no = '15'

AND rfp_std_values_12_10_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_15_10

ON (

rfp_std_values_12_10_15_10.room = standard_room.id

AND rfp_std_values_12_10_15_10.flag_no = '12'

AND rfp_std_values_12_10_15_10.group_no = '10'

AND rfp_std_values_12_10_15_10.group_element_no = '15'

AND rfp_std_values_12_10_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_11_11

ON (

rfp_std_values_12_10_11_11.room = standard_room.id

AND rfp_std_values_12_10_11_11.flag_no = '12'

AND rfp_std_values_12_10_11_11.group_no = '10'

AND rfp_std_values_12_10_11_11.group_element_no = '11'

AND rfp_std_values_12_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_11_10

ON (

rfp_std_values_12_10_11_10.room = standard_room.id

AND rfp_std_values_12_10_11_10.flag_no = '12'

AND rfp_std_values_12_10_11_10.group_no = '10'

AND rfp_std_values_12_10_11_10.group_element_no = '11'

AND rfp_std_values_12_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_12_11

ON (

rfp_std_values_12_10_12_11.room = standard_room.id

AND rfp_std_values_12_10_12_11.flag_no = '12'

AND rfp_std_values_12_10_12_11.group_no = '10'

AND rfp_std_values_12_10_12_11.group_element_no = '12'

AND rfp_std_values_12_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_12_10

ON (

rfp_std_values_12_10_12_10.room = standard_room.id

AND rfp_std_values_12_10_12_10.flag_no = '12'

AND rfp_std_values_12_10_12_10.group_no = '10'

AND rfp_std_values_12_10_12_10.group_element_no = '12'

AND rfp_std_values_12_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_19_11

ON (

rfp_std_values_12_10_19_11.room = standard_room.id

AND rfp_std_values_12_10_19_11.flag_no = '12'

AND rfp_std_values_12_10_19_11.group_no = '10'

AND rfp_std_values_12_10_19_11.group_element_no = '19'

AND rfp_std_values_12_10_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_19_10

ON (

rfp_std_values_12_10_19_10.room = standard_room.id

AND rfp_std_values_12_10_19_10.flag_no = '12'

AND rfp_std_values_12_10_19_10.group_no = '10'

AND rfp_std_values_12_10_19_10.group_element_no = '19'

AND rfp_std_values_12_10_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_10_10_11

ON (

rfp_std_values_12_10_10_11.room = standard_room.id

AND rfp_std_values_12_10_10_11.flag_no = '12'

AND rfp_std_values_12_10_10_11.group_no = '10'

AND rfp_std_values_12_10_10_11.group_element_no = '10'

AND rfp_std_values_12_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_10_10_10

ON (

rfp_std_values_12_10_10_10.room = standard_room.id

AND rfp_std_values_12_10_10_10.flag_no = '12'

AND rfp_std_values_12_10_10_10.group_no = '10'

AND rfp_std_values_12_10_10_10.group_element_no = '10'

AND rfp_std_values_12_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_20_11

ON (

rfp_std_values_12_11_20_11.room = standard_room.id

AND rfp_std_values_12_11_20_11.flag_no = '12'

AND rfp_std_values_12_11_20_11.group_no = '11'

AND rfp_std_values_12_11_20_11.group_element_no = '20'

AND rfp_std_values_12_11_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_20_10

ON (

rfp_std_values_12_11_20_10.room = standard_room.id

AND rfp_std_values_12_11_20_10.flag_no = '12'

AND rfp_std_values_12_11_20_10.group_no = '11'

AND rfp_std_values_12_11_20_10.group_element_no = '20'

AND rfp_std_values_12_11_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_18_12

ON (

rfp_std_values_12_11_18_12.room = standard_room.id

AND rfp_std_values_12_11_18_12.flag_no = '12'

AND rfp_std_values_12_11_18_12.group_no = '11'

AND rfp_std_values_12_11_18_12.group_element_no = '18'

AND rfp_std_values_12_11_18_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_11_18_11

ON (

rfp_std_values_12_11_18_11.room = standard_room.id

AND rfp_std_values_12_11_18_11.flag_no = '12'

AND rfp_std_values_12_11_18_11.group_no = '11'

AND rfp_std_values_12_11_18_11.group_element_no = '18'

AND rfp_std_values_12_11_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_18_10

ON (

rfp_std_values_12_11_18_10.room = standard_room.id

AND rfp_std_values_12_11_18_10.flag_no = '12'

AND rfp_std_values_12_11_18_10.group_no = '11'

AND rfp_std_values_12_11_18_10.group_element_no = '18'

AND rfp_std_values_12_11_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_17_13

ON (

rfp_std_values_12_11_17_13.room = standard_room.id

AND rfp_std_values_12_11_17_13.flag_no = '12'

AND rfp_std_values_12_11_17_13.group_no = '11'

AND rfp_std_values_12_11_17_13.group_element_no = '17'

AND rfp_std_values_12_11_17_13.field_no = '13')

left join rfp_std_values rfp_std_values_12_11_17_12

ON (

rfp_std_values_12_11_17_12.room = standard_room.id

AND rfp_std_values_12_11_17_12.flag_no = '12'

AND rfp_std_values_12_11_17_12.group_no = '11'

AND rfp_std_values_12_11_17_12.group_element_no = '17'

AND rfp_std_values_12_11_17_12.field_no = '12')

left join rfp_std_values rfp_std_values_12_11_17_10

ON (

rfp_std_values_12_11_17_10.room = standard_room.id

AND rfp_std_values_12_11_17_10.flag_no = '12'

AND rfp_std_values_12_11_17_10.group_no = '11'

AND rfp_std_values_12_11_17_10.group_element_no = '17'

AND rfp_std_values_12_11_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_19_10

ON (

rfp_std_values_12_11_19_10.room = standard_room.id

AND rfp_std_values_12_11_19_10.flag_no = '12'

AND rfp_std_values_12_11_19_10.group_no = '11'

AND rfp_std_values_12_11_19_10.group_element_no = '19'

AND rfp_std_values_12_11_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_16_11

ON (

rfp_std_values_12_11_16_11.room = standard_room.id

AND rfp_std_values_12_11_16_11.flag_no = '12'

AND rfp_std_values_12_11_16_11.group_no = '11'

AND rfp_std_values_12_11_16_11.group_element_no = '16'

AND rfp_std_values_12_11_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_16_10

ON (

rfp_std_values_12_11_16_10.room = standard_room.id

AND rfp_std_values_12_11_16_10.flag_no = '12'

AND rfp_std_values_12_11_16_10.group_no = '11'

AND rfp_std_values_12_11_16_10.group_element_no = '16'

AND rfp_std_values_12_11_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_21_11

ON (

rfp_std_values_12_11_21_11.room = standard_room.id

AND rfp_std_values_12_11_21_11.flag_no = '12'

AND rfp_std_values_12_11_21_11.group_no = '11'

AND rfp_std_values_12_11_21_11.group_element_no = '21'

AND rfp_std_values_12_11_21_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_21_10

ON (

rfp_std_values_12_11_21_10.room = standard_room.id

AND rfp_std_values_12_11_21_10.flag_no = '12'

AND rfp_std_values_12_11_21_10.group_no = '11'

AND rfp_std_values_12_11_21_10.group_element_no = '21'

AND rfp_std_values_12_11_21_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_15_11

ON (

rfp_std_values_12_11_15_11.room = standard_room.id

AND rfp_std_values_12_11_15_11.flag_no = '12'

AND rfp_std_values_12_11_15_11.group_no = '11'

AND rfp_std_values_12_11_15_11.group_element_no = '15'

AND rfp_std_values_12_11_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_15_10

ON (

rfp_std_values_12_11_15_10.room = standard_room.id

AND rfp_std_values_12_11_15_10.flag_no = '12'

AND rfp_std_values_12_11_15_10.group_no = '11'

AND rfp_std_values_12_11_15_10.group_element_no = '15'

AND rfp_std_values_12_11_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_12_11

ON (

rfp_std_values_12_11_12_11.room = standard_room.id

AND rfp_std_values_12_11_12_11.flag_no = '12'

AND rfp_std_values_12_11_12_11.group_no = '11'

AND rfp_std_values_12_11_12_11.group_element_no = '12'

AND rfp_std_values_12_11_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_12_10

ON (

rfp_std_values_12_11_12_10.room = standard_room.id

AND rfp_std_values_12_11_12_10.flag_no = '12'

AND rfp_std_values_12_11_12_10.group_no = '11'

AND rfp_std_values_12_11_12_10.group_element_no = '12'

AND rfp_std_values_12_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_11_11

ON (

rfp_std_values_12_11_11_11.room = standard_room.id

AND rfp_std_values_12_11_11_11.flag_no = '12'

AND rfp_std_values_12_11_11_11.group_no = '11'

AND rfp_std_values_12_11_11_11.group_element_no = '11'

AND rfp_std_values_12_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_11_10

ON (

rfp_std_values_12_11_11_10.room = standard_room.id

AND rfp_std_values_12_11_11_10.flag_no = '12'

AND rfp_std_values_12_11_11_10.group_no = '11'

AND rfp_std_values_12_11_11_10.group_element_no = '11'

AND rfp_std_values_12_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_12_11_25_11

ON (

rfp_std_values_12_11_25_11.room = standard_room.id

AND rfp_std_values_12_11_25_11.flag_no = '12'

AND rfp_std_values_12_11_25_11.group_no = '11'

AND rfp_std_values_12_11_25_11.group_element_no = '25'

AND rfp_std_values_12_11_25_11.field_no = '11')

left join rfp_std_values rfp_std_values_12_11_25_10

ON (

rfp_std_values_12_11_25_10.room = standard_room.id

AND rfp_std_values_12_11_25_10.flag_no = '12'

AND rfp_std_values_12_11_25_10.group_no = '11'

AND rfp_std_values_12_11_25_10.group_element_no = '25'

AND rfp_std_values_12_11_25_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_20_11

ON (

rfp_std_values_16_14_20_11.room = standard_room.id

AND rfp_std_values_16_14_20_11.flag_no = '16'

AND rfp_std_values_16_14_20_11.group_no = '14'

AND rfp_std_values_16_14_20_11.group_element_no = '20'

AND rfp_std_values_16_14_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_20_10

ON (

rfp_std_values_16_14_20_10.room = standard_room.id

AND rfp_std_values_16_14_20_10.flag_no = '16'

AND rfp_std_values_16_14_20_10.group_no = '14'

AND rfp_std_values_16_14_20_10.group_element_no = '20'

AND rfp_std_values_16_14_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_22_11

ON (

rfp_std_values_16_14_22_11.room = standard_room.id

AND rfp_std_values_16_14_22_11.flag_no = '16'

AND rfp_std_values_16_14_22_11.group_no = '14'

AND rfp_std_values_16_14_22_11.group_element_no = '22'

AND rfp_std_values_16_14_22_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_22_10

ON (

rfp_std_values_16_14_22_10.room = standard_room.id

AND rfp_std_values_16_14_22_10.flag_no = '16'

AND rfp_std_values_16_14_22_10.group_no = '14'

AND rfp_std_values_16_14_22_10.group_element_no = '22'

AND rfp_std_values_16_14_22_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_10_11

ON (

rfp_std_values_16_14_10_11.room = standard_room.id

AND rfp_std_values_16_14_10_11.flag_no = '16'

AND rfp_std_values_16_14_10_11.group_no = '14'

AND rfp_std_values_16_14_10_11.group_element_no = '10'

AND rfp_std_values_16_14_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_10_10

ON (

rfp_std_values_16_14_10_10.room = standard_room.id

AND rfp_std_values_16_14_10_10.flag_no = '16'

AND rfp_std_values_16_14_10_10.group_no = '14'

AND rfp_std_values_16_14_10_10.group_element_no = '10'

AND rfp_std_values_16_14_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_11_11

ON (

rfp_std_values_16_14_11_11.room = standard_room.id

AND rfp_std_values_16_14_11_11.flag_no = '16'

AND rfp_std_values_16_14_11_11.group_no = '14'

AND rfp_std_values_16_14_11_11.group_element_no = '11'

AND rfp_std_values_16_14_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_11_10

ON (

rfp_std_values_16_14_11_10.room = standard_room.id

AND rfp_std_values_16_14_11_10.flag_no = '16'

AND rfp_std_values_16_14_11_10.group_no = '14'

AND rfp_std_values_16_14_11_10.group_element_no = '11'

AND rfp_std_values_16_14_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_14_11

ON (

rfp_std_values_16_14_14_11.room = standard_room.id

AND rfp_std_values_16_14_14_11.flag_no = '16'

AND rfp_std_values_16_14_14_11.group_no = '14'

AND rfp_std_values_16_14_14_11.group_element_no = '14'

AND rfp_std_values_16_14_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_14_10

ON (

rfp_std_values_16_14_14_10.room = standard_room.id

AND rfp_std_values_16_14_14_10.flag_no = '16'

AND rfp_std_values_16_14_14_10.group_no = '14'

AND rfp_std_values_16_14_14_10.group_element_no = '14'

AND rfp_std_values_16_14_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_24_11

ON (

rfp_std_values_16_14_24_11.room = standard_room.id

AND rfp_std_values_16_14_24_11.flag_no = '16'

AND rfp_std_values_16_14_24_11.group_no = '14'

AND rfp_std_values_16_14_24_11.group_element_no = '24'

AND rfp_std_values_16_14_24_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_24_10

ON (

rfp_std_values_16_14_24_10.room = standard_room.id

AND rfp_std_values_16_14_24_10.flag_no = '16'

AND rfp_std_values_16_14_24_10.group_no = '14'

AND rfp_std_values_16_14_24_10.group_element_no = '24'

AND rfp_std_values_16_14_24_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_23_11

ON (

rfp_std_values_16_14_23_11.room = standard_room.id

AND rfp_std_values_16_14_23_11.flag_no = '16'

AND rfp_std_values_16_14_23_11.group_no = '14'

AND rfp_std_values_16_14_23_11.group_element_no = '23'

AND rfp_std_values_16_14_23_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_23_10

ON (

rfp_std_values_16_14_23_10.room = standard_room.id

AND rfp_std_values_16_14_23_10.flag_no = '16'

AND rfp_std_values_16_14_23_10.group_no = '14'

AND rfp_std_values_16_14_23_10.group_element_no = '23'

AND rfp_std_values_16_14_23_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_14_13_11

ON (

rfp_std_values_16_14_13_11.room = standard_room.id

AND rfp_std_values_16_14_13_11.flag_no = '16'

AND rfp_std_values_16_14_13_11.group_no = '14'

AND rfp_std_values_16_14_13_11.group_element_no = '13'

AND rfp_std_values_16_14_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_14_13_10

ON (

rfp_std_values_16_14_13_10.room = standard_room.id

AND rfp_std_values_16_14_13_10.flag_no = '16'

AND rfp_std_values_16_14_13_10.group_no = '14'

AND rfp_std_values_16_14_13_10.group_element_no = '13'

AND rfp_std_values_16_14_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_11_10_12

ON (

rfp_std_values_16_11_10_12.room = standard_room.id

AND rfp_std_values_16_11_10_12.flag_no = '16'

AND rfp_std_values_16_11_10_12.group_no = '11'

AND rfp_std_values_16_11_10_12.group_element_no = '10'

AND rfp_std_values_16_11_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_16_11_10_11

ON (

rfp_std_values_16_11_10_11.room = standard_room.id

AND rfp_std_values_16_11_10_11.flag_no = '16'

AND rfp_std_values_16_11_10_11.group_no = '11'

AND rfp_std_values_16_11_10_11.group_element_no = '10'

AND rfp_std_values_16_11_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_11_10_10

ON (

rfp_std_values_16_11_10_10.room = standard_room.id

AND rfp_std_values_16_11_10_10.flag_no = '16'

AND rfp_std_values_16_11_10_10.group_no = '11'

AND rfp_std_values_16_11_10_10.group_element_no = '10'

AND rfp_std_values_16_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_11_11_12

ON (

rfp_std_values_16_11_11_12.room = standard_room.id

AND rfp_std_values_16_11_11_12.flag_no = '16'

AND rfp_std_values_16_11_11_12.group_no = '11'

AND rfp_std_values_16_11_11_12.group_element_no = '11'

AND rfp_std_values_16_11_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_16_11_11_11

ON (

rfp_std_values_16_11_11_11.room = standard_room.id

AND rfp_std_values_16_11_11_11.flag_no = '16'

AND rfp_std_values_16_11_11_11.group_no = '11'

AND rfp_std_values_16_11_11_11.group_element_no = '11'

AND rfp_std_values_16_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_11_11_10

ON (

rfp_std_values_16_11_11_10.room = standard_room.id

AND rfp_std_values_16_11_11_10.flag_no = '16'

AND rfp_std_values_16_11_11_10.group_no = '11'

AND rfp_std_values_16_11_11_10.group_element_no = '11'

AND rfp_std_values_16_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_11_12_13

ON (

rfp_std_values_16_11_12_13.room = standard_room.id

AND rfp_std_values_16_11_12_13.flag_no = '16'

AND rfp_std_values_16_11_12_13.group_no = '11'

AND rfp_std_values_16_11_12_13.group_element_no = '12'

AND rfp_std_values_16_11_12_13.field_no = '13')

left join rfp_std_values rfp_std_values_16_11_12_12

ON (

rfp_std_values_16_11_12_12.room = standard_room.id

AND rfp_std_values_16_11_12_12.flag_no = '16'

AND rfp_std_values_16_11_12_12.group_no = '11'

AND rfp_std_values_16_11_12_12.group_element_no = '12'

AND rfp_std_values_16_11_12_12.field_no = '12')

left join rfp_std_values rfp_std_values_16_11_12_11

ON (

rfp_std_values_16_11_12_11.room = standard_room.id

AND rfp_std_values_16_11_12_11.flag_no = '16'

AND rfp_std_values_16_11_12_11.group_no = '11'

AND rfp_std_values_16_11_12_11.group_element_no = '12'

AND rfp_std_values_16_11_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_11_12_10

ON (

rfp_std_values_16_11_12_10.room = standard_room.id

AND rfp_std_values_16_11_12_10.flag_no = '16'

AND rfp_std_values_16_11_12_10.group_no = '11'

AND rfp_std_values_16_11_12_10.group_element_no = '12'

AND rfp_std_values_16_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_11_13_11

ON (

rfp_std_values_16_11_13_11.room = standard_room.id

AND rfp_std_values_16_11_13_11.flag_no = '16'

AND rfp_std_values_16_11_13_11.group_no = '11'

AND rfp_std_values_16_11_13_11.group_element_no = '13'

AND rfp_std_values_16_11_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_11_13_10

ON (

rfp_std_values_16_11_13_10.room = standard_room.id

AND rfp_std_values_16_11_13_10.flag_no = '16'

AND rfp_std_values_16_11_13_10.group_no = '11'

AND rfp_std_values_16_11_13_10.group_element_no = '13'

AND rfp_std_values_16_11_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_16_11

ON (

rfp_std_values_16_10_16_11.room = standard_room.id

AND rfp_std_values_16_10_16_11.flag_no = '16'

AND rfp_std_values_16_10_16_11.group_no = '10'

AND rfp_std_values_16_10_16_11.group_element_no = '16'

AND rfp_std_values_16_10_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_16_10

ON (

rfp_std_values_16_10_16_10.room = standard_room.id

AND rfp_std_values_16_10_16_10.flag_no = '16'

AND rfp_std_values_16_10_16_10.group_no = '10'

AND rfp_std_values_16_10_16_10.group_element_no = '16'

AND rfp_std_values_16_10_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_14_11

ON (

rfp_std_values_16_10_14_11.room = standard_room.id

AND rfp_std_values_16_10_14_11.flag_no = '16'

AND rfp_std_values_16_10_14_11.group_no = '10'

AND rfp_std_values_16_10_14_11.group_element_no = '14'

AND rfp_std_values_16_10_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_14_10

ON (

rfp_std_values_16_10_14_10.room = standard_room.id

AND rfp_std_values_16_10_14_10.flag_no = '16'

AND rfp_std_values_16_10_14_10.group_no = '10'

AND rfp_std_values_16_10_14_10.group_element_no = '14'

AND rfp_std_values_16_10_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_13_11

ON (

rfp_std_values_16_10_13_11.room = standard_room.id

AND rfp_std_values_16_10_13_11.flag_no = '16'

AND rfp_std_values_16_10_13_11.group_no = '10'

AND rfp_std_values_16_10_13_11.group_element_no = '13'

AND rfp_std_values_16_10_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_13_10

ON (

rfp_std_values_16_10_13_10.room = standard_room.id

AND rfp_std_values_16_10_13_10.flag_no = '16'

AND rfp_std_values_16_10_13_10.group_no = '10'

AND rfp_std_values_16_10_13_10.group_element_no = '13'

AND rfp_std_values_16_10_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_15_11

ON (

rfp_std_values_16_10_15_11.room = standard_room.id

AND rfp_std_values_16_10_15_11.flag_no = '16'

AND rfp_std_values_16_10_15_11.group_no = '10'

AND rfp_std_values_16_10_15_11.group_element_no = '15'

AND rfp_std_values_16_10_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_15_10

ON (

rfp_std_values_16_10_15_10.room = standard_room.id

AND rfp_std_values_16_10_15_10.flag_no = '16'

AND rfp_std_values_16_10_15_10.group_no = '10'

AND rfp_std_values_16_10_15_10.group_element_no = '15'

AND rfp_std_values_16_10_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_12_11

ON (

rfp_std_values_16_10_12_11.room = standard_room.id

AND rfp_std_values_16_10_12_11.flag_no = '16'

AND rfp_std_values_16_10_12_11.group_no = '10'

AND rfp_std_values_16_10_12_11.group_element_no = '12'

AND rfp_std_values_16_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_12_10

ON (

rfp_std_values_16_10_12_10.room = standard_room.id

AND rfp_std_values_16_10_12_10.flag_no = '16'

AND rfp_std_values_16_10_12_10.group_no = '10'

AND rfp_std_values_16_10_12_10.group_element_no = '12'

AND rfp_std_values_16_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_11_13

ON (

rfp_std_values_16_10_11_13.room = standard_room.id

AND rfp_std_values_16_10_11_13.flag_no = '16'

AND rfp_std_values_16_10_11_13.group_no = '10'

AND rfp_std_values_16_10_11_13.group_element_no = '11'

AND rfp_std_values_16_10_11_13.field_no = '13')

left join rfp_std_values rfp_std_values_16_10_11_12

ON (

rfp_std_values_16_10_11_12.room = standard_room.id

AND rfp_std_values_16_10_11_12.flag_no = '16'

AND rfp_std_values_16_10_11_12.group_no = '10'

AND rfp_std_values_16_10_11_12.group_element_no = '11'

AND rfp_std_values_16_10_11_12.field_no = '12')

left join rfp_std_values rfp_std_values_16_10_11_11

ON (

rfp_std_values_16_10_11_11.room = standard_room.id

AND rfp_std_values_16_10_11_11.flag_no = '16'

AND rfp_std_values_16_10_11_11.group_no = '10'

AND rfp_std_values_16_10_11_11.group_element_no = '11'

AND rfp_std_values_16_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_11_10

ON (

rfp_std_values_16_10_11_10.room = standard_room.id

AND rfp_std_values_16_10_11_10.flag_no = '16'

AND rfp_std_values_16_10_11_10.group_no = '10'

AND rfp_std_values_16_10_11_10.group_element_no = '11'

AND rfp_std_values_16_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_16_10_10_13

ON (

rfp_std_values_16_10_10_13.room = standard_room.id

AND rfp_std_values_16_10_10_13.flag_no = '16'

AND rfp_std_values_16_10_10_13.group_no = '10'

AND rfp_std_values_16_10_10_13.group_element_no = '10'

AND rfp_std_values_16_10_10_13.field_no = '13')

left join rfp_std_values rfp_std_values_16_10_10_12

ON (

rfp_std_values_16_10_10_12.room = standard_room.id

AND rfp_std_values_16_10_10_12.flag_no = '16'

AND rfp_std_values_16_10_10_12.group_no = '10'

AND rfp_std_values_16_10_10_12.group_element_no = '10'

AND rfp_std_values_16_10_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_16_10_10_11

ON (

rfp_std_values_16_10_10_11.room = standard_room.id

AND rfp_std_values_16_10_10_11.flag_no = '16'

AND rfp_std_values_16_10_10_11.group_no = '10'

AND rfp_std_values_16_10_10_11.group_element_no = '10'

AND rfp_std_values_16_10_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_16_10_10_10

ON (

rfp_std_values_16_10_10_10.room = standard_room.id

AND rfp_std_values_16_10_10_10.flag_no = '16'

AND rfp_std_values_16_10_10_10.group_no = '10'

AND rfp_std_values_16_10_10_10.group_element_no = '10'

AND rfp_std_values_16_10_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_25_11

ON (

rfp_std_values_14_15_25_11.room = standard_room.id

AND rfp_std_values_14_15_25_11.flag_no = '14'

AND rfp_std_values_14_15_25_11.group_no = '15'

AND rfp_std_values_14_15_25_11.group_element_no = '25'

AND rfp_std_values_14_15_25_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_25_10

ON (

rfp_std_values_14_15_25_10.room = standard_room.id

AND rfp_std_values_14_15_25_10.flag_no = '14'

AND rfp_std_values_14_15_25_10.group_no = '15'

AND rfp_std_values_14_15_25_10.group_element_no = '25'

AND rfp_std_values_14_15_25_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_23_11

ON (

rfp_std_values_14_15_23_11.room = standard_room.id

AND rfp_std_values_14_15_23_11.flag_no = '14'

AND rfp_std_values_14_15_23_11.group_no = '15'

AND rfp_std_values_14_15_23_11.group_element_no = '23'

AND rfp_std_values_14_15_23_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_23_10

ON (

rfp_std_values_14_15_23_10.room = standard_room.id

AND rfp_std_values_14_15_23_10.flag_no = '14'

AND rfp_std_values_14_15_23_10.group_no = '15'

AND rfp_std_values_14_15_23_10.group_element_no = '23'

AND rfp_std_values_14_15_23_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_22_11

ON (

rfp_std_values_14_15_22_11.room = standard_room.id

AND rfp_std_values_14_15_22_11.flag_no = '14'

AND rfp_std_values_14_15_22_11.group_no = '15'

AND rfp_std_values_14_15_22_11.group_element_no = '22'

AND rfp_std_values_14_15_22_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_22_10

ON (

rfp_std_values_14_15_22_10.room = standard_room.id

AND rfp_std_values_14_15_22_10.flag_no = '14'

AND rfp_std_values_14_15_22_10.group_no = '15'

AND rfp_std_values_14_15_22_10.group_element_no = '22'

AND rfp_std_values_14_15_22_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_21_11

ON (

rfp_std_values_14_15_21_11.room = standard_room.id

AND rfp_std_values_14_15_21_11.flag_no = '14'

AND rfp_std_values_14_15_21_11.group_no = '15'

AND rfp_std_values_14_15_21_11.group_element_no = '21'

AND rfp_std_values_14_15_21_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_21_10

ON (

rfp_std_values_14_15_21_10.room = standard_room.id

AND rfp_std_values_14_15_21_10.flag_no = '14'

AND rfp_std_values_14_15_21_10.group_no = '15'

AND rfp_std_values_14_15_21_10.group_element_no = '21'

AND rfp_std_values_14_15_21_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_20_11

ON (

rfp_std_values_14_15_20_11.room = standard_room.id

AND rfp_std_values_14_15_20_11.flag_no = '14'

AND rfp_std_values_14_15_20_11.group_no = '15'

AND rfp_std_values_14_15_20_11.group_element_no = '20'

AND rfp_std_values_14_15_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_20_10

ON (

rfp_std_values_14_15_20_10.room = standard_room.id

AND rfp_std_values_14_15_20_10.flag_no = '14'

AND rfp_std_values_14_15_20_10.group_no = '15'

AND rfp_std_values_14_15_20_10.group_element_no = '20'

AND rfp_std_values_14_15_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_19_11

ON (

rfp_std_values_14_15_19_11.room = standard_room.id

AND rfp_std_values_14_15_19_11.flag_no = '14'

AND rfp_std_values_14_15_19_11.group_no = '15'

AND rfp_std_values_14_15_19_11.group_element_no = '19'

AND rfp_std_values_14_15_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_19_10

ON (

rfp_std_values_14_15_19_10.room = standard_room.id

AND rfp_std_values_14_15_19_10.flag_no = '14'

AND rfp_std_values_14_15_19_10.group_no = '15'

AND rfp_std_values_14_15_19_10.group_element_no = '19'

AND rfp_std_values_14_15_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_18_11

ON (

rfp_std_values_14_15_18_11.room = standard_room.id

AND rfp_std_values_14_15_18_11.flag_no = '14'

AND rfp_std_values_14_15_18_11.group_no = '15'

AND rfp_std_values_14_15_18_11.group_element_no = '18'

AND rfp_std_values_14_15_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_18_10

ON (

rfp_std_values_14_15_18_10.room = standard_room.id

AND rfp_std_values_14_15_18_10.flag_no = '14'

AND rfp_std_values_14_15_18_10.group_no = '15'

AND rfp_std_values_14_15_18_10.group_element_no = '18'

AND rfp_std_values_14_15_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_17_11

ON (

rfp_std_values_14_15_17_11.room = standard_room.id

AND rfp_std_values_14_15_17_11.flag_no = '14'

AND rfp_std_values_14_15_17_11.group_no = '15'

AND rfp_std_values_14_15_17_11.group_element_no = '17'

AND rfp_std_values_14_15_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_17_10

ON (

rfp_std_values_14_15_17_10.room = standard_room.id

AND rfp_std_values_14_15_17_10.flag_no = '14'

AND rfp_std_values_14_15_17_10.group_no = '15'

AND rfp_std_values_14_15_17_10.group_element_no = '17'

AND rfp_std_values_14_15_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_16_11

ON (

rfp_std_values_14_15_16_11.room = standard_room.id

AND rfp_std_values_14_15_16_11.flag_no = '14'

AND rfp_std_values_14_15_16_11.group_no = '15'

AND rfp_std_values_14_15_16_11.group_element_no = '16'

AND rfp_std_values_14_15_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_16_10

ON (

rfp_std_values_14_15_16_10.room = standard_room.id

AND rfp_std_values_14_15_16_10.flag_no = '14'

AND rfp_std_values_14_15_16_10.group_no = '15'

AND rfp_std_values_14_15_16_10.group_element_no = '16'

AND rfp_std_values_14_15_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_14_11

ON (

rfp_std_values_14_15_14_11.room = standard_room.id

AND rfp_std_values_14_15_14_11.flag_no = '14'

AND rfp_std_values_14_15_14_11.group_no = '15'

AND rfp_std_values_14_15_14_11.group_element_no = '14'

AND rfp_std_values_14_15_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_14_10

ON (

rfp_std_values_14_15_14_10.room = standard_room.id

AND rfp_std_values_14_15_14_10.flag_no = '14'

AND rfp_std_values_14_15_14_10.group_no = '15'

AND rfp_std_values_14_15_14_10.group_element_no = '14'

AND rfp_std_values_14_15_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_13_11

ON (

rfp_std_values_14_15_13_11.room = standard_room.id

AND rfp_std_values_14_15_13_11.flag_no = '14'

AND rfp_std_values_14_15_13_11.group_no = '15'

AND rfp_std_values_14_15_13_11.group_element_no = '13'

AND rfp_std_values_14_15_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_13_10

ON (

rfp_std_values_14_15_13_10.room = standard_room.id

AND rfp_std_values_14_15_13_10.flag_no = '14'

AND rfp_std_values_14_15_13_10.group_no = '15'

AND rfp_std_values_14_15_13_10.group_element_no = '13'

AND rfp_std_values_14_15_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_12_11

ON (

rfp_std_values_14_15_12_11.room = standard_room.id

AND rfp_std_values_14_15_12_11.flag_no = '14'

AND rfp_std_values_14_15_12_11.group_no = '15'

AND rfp_std_values_14_15_12_11.group_element_no = '12'

AND rfp_std_values_14_15_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_12_10

ON (

rfp_std_values_14_15_12_10.room = standard_room.id

AND rfp_std_values_14_15_12_10.flag_no = '14'

AND rfp_std_values_14_15_12_10.group_no = '15'

AND rfp_std_values_14_15_12_10.group_element_no = '12'

AND rfp_std_values_14_15_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_15_11_11

ON (

rfp_std_values_14_15_11_11.room = standard_room.id

AND rfp_std_values_14_15_11_11.flag_no = '14'

AND rfp_std_values_14_15_11_11.group_no = '15'

AND rfp_std_values_14_15_11_11.group_element_no = '11'

AND rfp_std_values_14_15_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_15_11_10

ON (

rfp_std_values_14_15_11_10.room = standard_room.id

AND rfp_std_values_14_15_11_10.flag_no = '14'

AND rfp_std_values_14_15_11_10.group_no = '15'

AND rfp_std_values_14_15_11_10.group_element_no = '11'

AND rfp_std_values_14_15_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_11_12_11

ON (

rfp_std_values_14_11_12_11.room = standard_room.id

AND rfp_std_values_14_11_12_11.flag_no = '14'

AND rfp_std_values_14_11_12_11.group_no = '11'

AND rfp_std_values_14_11_12_11.group_element_no = '12'

AND rfp_std_values_14_11_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_11_12_10

ON (

rfp_std_values_14_11_12_10.room = standard_room.id

AND rfp_std_values_14_11_12_10.flag_no = '14'

AND rfp_std_values_14_11_12_10.group_no = '11'

AND rfp_std_values_14_11_12_10.group_element_no = '12'

AND rfp_std_values_14_11_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_11_10_11

ON (

rfp_std_values_14_11_10_11.room = standard_room.id

AND rfp_std_values_14_11_10_11.flag_no = '14'

AND rfp_std_values_14_11_10_11.group_no = '11'

AND rfp_std_values_14_11_10_11.group_element_no = '10'

AND rfp_std_values_14_11_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_11_10_10

ON (

rfp_std_values_14_11_10_10.room = standard_room.id

AND rfp_std_values_14_11_10_10.flag_no = '14'

AND rfp_std_values_14_11_10_10.group_no = '11'

AND rfp_std_values_14_11_10_10.group_element_no = '10'

AND rfp_std_values_14_11_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_24_11

ON (

rfp_std_values_14_10_24_11.room = standard_room.id

AND rfp_std_values_14_10_24_11.flag_no = '14'

AND rfp_std_values_14_10_24_11.group_no = '10'

AND rfp_std_values_14_10_24_11.group_element_no = '24'

AND rfp_std_values_14_10_24_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_24_10

ON (

rfp_std_values_14_10_24_10.room = standard_room.id

AND rfp_std_values_14_10_24_10.flag_no = '14'

AND rfp_std_values_14_10_24_10.group_no = '10'

AND rfp_std_values_14_10_24_10.group_element_no = '24'

AND rfp_std_values_14_10_24_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_19_11

ON (

rfp_std_values_14_10_19_11.room = standard_room.id

AND rfp_std_values_14_10_19_11.flag_no = '14'

AND rfp_std_values_14_10_19_11.group_no = '10'

AND rfp_std_values_14_10_19_11.group_element_no = '19'

AND rfp_std_values_14_10_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_19_10

ON (

rfp_std_values_14_10_19_10.room = standard_room.id

AND rfp_std_values_14_10_19_10.flag_no = '14'

AND rfp_std_values_14_10_19_10.group_no = '10'

AND rfp_std_values_14_10_19_10.group_element_no = '19'

AND rfp_std_values_14_10_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_18_11

ON (

rfp_std_values_14_10_18_11.room = standard_room.id

AND rfp_std_values_14_10_18_11.flag_no = '14'

AND rfp_std_values_14_10_18_11.group_no = '10'

AND rfp_std_values_14_10_18_11.group_element_no = '18'

AND rfp_std_values_14_10_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_18_10

ON (

rfp_std_values_14_10_18_10.room = standard_room.id

AND rfp_std_values_14_10_18_10.flag_no = '14'

AND rfp_std_values_14_10_18_10.group_no = '10'

AND rfp_std_values_14_10_18_10.group_element_no = '18'

AND rfp_std_values_14_10_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_25_12

ON (

rfp_std_values_14_10_25_12.room = standard_room.id

AND rfp_std_values_14_10_25_12.flag_no = '14'

AND rfp_std_values_14_10_25_12.group_no = '10'

AND rfp_std_values_14_10_25_12.group_element_no = '25'

AND rfp_std_values_14_10_25_12.field_no = '12')

left join rfp_std_values rfp_std_values_14_10_25_11

ON (

rfp_std_values_14_10_25_11.room = standard_room.id

AND rfp_std_values_14_10_25_11.flag_no = '14'

AND rfp_std_values_14_10_25_11.group_no = '10'

AND rfp_std_values_14_10_25_11.group_element_no = '25'

AND rfp_std_values_14_10_25_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_25_10

ON (

rfp_std_values_14_10_25_10.room = standard_room.id

AND rfp_std_values_14_10_25_10.flag_no = '14'

AND rfp_std_values_14_10_25_10.group_no = '10'

AND rfp_std_values_14_10_25_10.group_element_no = '25'

AND rfp_std_values_14_10_25_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_13_11

ON (

rfp_std_values_14_10_13_11.room = standard_room.id

AND rfp_std_values_14_10_13_11.flag_no = '14'

AND rfp_std_values_14_10_13_11.group_no = '10'

AND rfp_std_values_14_10_13_11.group_element_no = '13'

AND rfp_std_values_14_10_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_13_12

ON (

rfp_std_values_14_10_13_12.room = standard_room.id

AND rfp_std_values_14_10_13_12.flag_no = '14'

AND rfp_std_values_14_10_13_12.group_no = '10'

AND rfp_std_values_14_10_13_12.group_element_no = '13'

AND rfp_std_values_14_10_13_12.field_no = '12')

left join rfp_std_values rfp_std_values_14_10_13_10

ON (

rfp_std_values_14_10_13_10.room = standard_room.id

AND rfp_std_values_14_10_13_10.flag_no = '14'

AND rfp_std_values_14_10_13_10.group_no = '10'

AND rfp_std_values_14_10_13_10.group_element_no = '13'

AND rfp_std_values_14_10_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_12_11

ON (

rfp_std_values_14_10_12_11.room = standard_room.id

AND rfp_std_values_14_10_12_11.flag_no = '14'

AND rfp_std_values_14_10_12_11.group_no = '10'

AND rfp_std_values_14_10_12_11.group_element_no = '12'

AND rfp_std_values_14_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_12_10

ON (

rfp_std_values_14_10_12_10.room = standard_room.id

AND rfp_std_values_14_10_12_10.flag_no = '14'

AND rfp_std_values_14_10_12_10.group_no = '10'

AND rfp_std_values_14_10_12_10.group_element_no = '12'

AND rfp_std_values_14_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_26_11

ON (

rfp_std_values_14_10_26_11.room = standard_room.id

AND rfp_std_values_14_10_26_11.flag_no = '14'

AND rfp_std_values_14_10_26_11.group_no = '10'

AND rfp_std_values_14_10_26_11.group_element_no = '26'

AND rfp_std_values_14_10_26_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_26_10

ON (

rfp_std_values_14_10_26_10.room = standard_room.id

AND rfp_std_values_14_10_26_10.flag_no = '14'

AND rfp_std_values_14_10_26_10.group_no = '10'

AND rfp_std_values_14_10_26_10.group_element_no = '26'

AND rfp_std_values_14_10_26_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_11_11

ON (

rfp_std_values_14_10_11_11.room = standard_room.id

AND rfp_std_values_14_10_11_11.flag_no = '14'

AND rfp_std_values_14_10_11_11.group_no = '10'

AND rfp_std_values_14_10_11_11.group_element_no = '11'

AND rfp_std_values_14_10_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_11_10

ON (

rfp_std_values_14_10_11_10.room = standard_room.id

AND rfp_std_values_14_10_11_10.flag_no = '14'

AND rfp_std_values_14_10_11_10.group_no = '10'

AND rfp_std_values_14_10_11_10.group_element_no = '11'

AND rfp_std_values_14_10_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_23_11

ON (

rfp_std_values_14_10_23_11.room = standard_room.id

AND rfp_std_values_14_10_23_11.flag_no = '14'

AND rfp_std_values_14_10_23_11.group_no = '10'

AND rfp_std_values_14_10_23_11.group_element_no = '23'

AND rfp_std_values_14_10_23_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_23_10

ON (

rfp_std_values_14_10_23_10.room = standard_room.id

AND rfp_std_values_14_10_23_10.flag_no = '14'

AND rfp_std_values_14_10_23_10.group_no = '10'

AND rfp_std_values_14_10_23_10.group_element_no = '23'

AND rfp_std_values_14_10_23_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_22_11

ON (

rfp_std_values_14_10_22_11.room = standard_room.id

AND rfp_std_values_14_10_22_11.flag_no = '14'

AND rfp_std_values_14_10_22_11.group_no = '10'

AND rfp_std_values_14_10_22_11.group_element_no = '22'

AND rfp_std_values_14_10_22_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_22_10

ON (

rfp_std_values_14_10_22_10.room = standard_room.id

AND rfp_std_values_14_10_22_10.flag_no = '14'

AND rfp_std_values_14_10_22_10.group_no = '10'

AND rfp_std_values_14_10_22_10.group_element_no = '22'

AND rfp_std_values_14_10_22_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_21_11

ON (

rfp_std_values_14_10_21_11.room = standard_room.id

AND rfp_std_values_14_10_21_11.flag_no = '14'

AND rfp_std_values_14_10_21_11.group_no = '10'

AND rfp_std_values_14_10_21_11.group_element_no = '21'

AND rfp_std_values_14_10_21_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_21_10

ON (

rfp_std_values_14_10_21_10.room = standard_room.id

AND rfp_std_values_14_10_21_10.flag_no = '14'

AND rfp_std_values_14_10_21_10.group_no = '10'

AND rfp_std_values_14_10_21_10.group_element_no = '21'

AND rfp_std_values_14_10_21_10.field_no = '10')

left join rfp_std_values rfp_std_values_14_10_20_11

ON (

rfp_std_values_14_10_20_11.room = standard_room.id

AND rfp_std_values_14_10_20_11.flag_no = '14'

AND rfp_std_values_14_10_20_11.group_no = '10'

AND rfp_std_values_14_10_20_11.group_element_no = '20'

AND rfp_std_values_14_10_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_14_10_20_10

ON (

rfp_std_values_14_10_20_10.room = standard_room.id

AND rfp_std_values_14_10_20_10.flag_no = '14'

AND rfp_std_values_14_10_20_10.group_no = '10'

AND rfp_std_values_14_10_20_10.group_element_no = '20'

AND rfp_std_values_14_10_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_17_12

ON (

rfp_std_values_17_11_17_12.room = standard_room.id

AND rfp_std_values_17_11_17_12.flag_no = '17'

AND rfp_std_values_17_11_17_12.group_no = '11'

AND rfp_std_values_17_11_17_12.group_element_no = '17'

AND rfp_std_values_17_11_17_12.field_no = '12')

left join rfp_std_values rfp_std_values_17_11_17_11

ON (

rfp_std_values_17_11_17_11.room = standard_room.id

AND rfp_std_values_17_11_17_11.flag_no = '17'

AND rfp_std_values_17_11_17_11.group_no = '11'

AND rfp_std_values_17_11_17_11.group_element_no = '17'

AND rfp_std_values_17_11_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_17_10

ON (

rfp_std_values_17_11_17_10.room = standard_room.id

AND rfp_std_values_17_11_17_10.flag_no = '17'

AND rfp_std_values_17_11_17_10.group_no = '11'

AND rfp_std_values_17_11_17_10.group_element_no = '17'

AND rfp_std_values_17_11_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_16_11

ON (

rfp_std_values_17_11_16_11.room = standard_room.id

AND rfp_std_values_17_11_16_11.flag_no = '17'

AND rfp_std_values_17_11_16_11.group_no = '11'

AND rfp_std_values_17_11_16_11.group_element_no = '16'

AND rfp_std_values_17_11_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_16_10

ON (

rfp_std_values_17_11_16_10.room = standard_room.id

AND rfp_std_values_17_11_16_10.flag_no = '17'

AND rfp_std_values_17_11_16_10.group_no = '11'

AND rfp_std_values_17_11_16_10.group_element_no = '16'

AND rfp_std_values_17_11_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_14_11

ON (

rfp_std_values_17_11_14_11.room = standard_room.id

AND rfp_std_values_17_11_14_11.flag_no = '17'

AND rfp_std_values_17_11_14_11.group_no = '11'

AND rfp_std_values_17_11_14_11.group_element_no = '14'

AND rfp_std_values_17_11_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_14_10

ON (

rfp_std_values_17_11_14_10.room = standard_room.id

AND rfp_std_values_17_11_14_10.flag_no = '17'

AND rfp_std_values_17_11_14_10.group_no = '11'

AND rfp_std_values_17_11_14_10.group_element_no = '14'

AND rfp_std_values_17_11_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_15_11

ON (

rfp_std_values_17_11_15_11.room = standard_room.id

AND rfp_std_values_17_11_15_11.flag_no = '17'

AND rfp_std_values_17_11_15_11.group_no = '11'

AND rfp_std_values_17_11_15_11.group_element_no = '15'

AND rfp_std_values_17_11_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_15_10

ON (

rfp_std_values_17_11_15_10.room = standard_room.id

AND rfp_std_values_17_11_15_10.flag_no = '17'

AND rfp_std_values_17_11_15_10.group_no = '11'

AND rfp_std_values_17_11_15_10.group_element_no = '15'

AND rfp_std_values_17_11_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_13_11

ON (

rfp_std_values_17_11_13_11.room = standard_room.id

AND rfp_std_values_17_11_13_11.flag_no = '17'

AND rfp_std_values_17_11_13_11.group_no = '11'

AND rfp_std_values_17_11_13_11.group_element_no = '13'

AND rfp_std_values_17_11_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_13_10

ON (

rfp_std_values_17_11_13_10.room = standard_room.id

AND rfp_std_values_17_11_13_10.flag_no = '17'

AND rfp_std_values_17_11_13_10.group_no = '11'

AND rfp_std_values_17_11_13_10.group_element_no = '13'

AND rfp_std_values_17_11_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_11_11_11

ON (

rfp_std_values_17_11_11_11.room = standard_room.id

AND rfp_std_values_17_11_11_11.flag_no = '17'

AND rfp_std_values_17_11_11_11.group_no = '11'

AND rfp_std_values_17_11_11_11.group_element_no = '11'

AND rfp_std_values_17_11_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_11_11_10

ON (

rfp_std_values_17_11_11_10.room = standard_room.id

AND rfp_std_values_17_11_11_10.flag_no = '17'

AND rfp_std_values_17_11_11_10.group_no = '11'

AND rfp_std_values_17_11_11_10.group_element_no = '11'

AND rfp_std_values_17_11_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_20_11

ON (

rfp_std_values_17_14_20_11.room = standard_room.id

AND rfp_std_values_17_14_20_11.flag_no = '17'

AND rfp_std_values_17_14_20_11.group_no = '14'

AND rfp_std_values_17_14_20_11.group_element_no = '20'

AND rfp_std_values_17_14_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_20_10

ON (

rfp_std_values_17_14_20_10.room = standard_room.id

AND rfp_std_values_17_14_20_10.flag_no = '17'

AND rfp_std_values_17_14_20_10.group_no = '14'

AND rfp_std_values_17_14_20_10.group_element_no = '20'

AND rfp_std_values_17_14_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_19_11

ON (

rfp_std_values_17_14_19_11.room = standard_room.id

AND rfp_std_values_17_14_19_11.flag_no = '17'

AND rfp_std_values_17_14_19_11.group_no = '14'

AND rfp_std_values_17_14_19_11.group_element_no = '19'

AND rfp_std_values_17_14_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_19_10

ON (

rfp_std_values_17_14_19_10.room = standard_room.id

AND rfp_std_values_17_14_19_10.flag_no = '17'

AND rfp_std_values_17_14_19_10.group_no = '14'

AND rfp_std_values_17_14_19_10.group_element_no = '19'

AND rfp_std_values_17_14_19_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_18_11

ON (

rfp_std_values_17_14_18_11.room = standard_room.id

AND rfp_std_values_17_14_18_11.flag_no = '17'

AND rfp_std_values_17_14_18_11.group_no = '14'

AND rfp_std_values_17_14_18_11.group_element_no = '18'

AND rfp_std_values_17_14_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_18_10

ON (

rfp_std_values_17_14_18_10.room = standard_room.id

AND rfp_std_values_17_14_18_10.flag_no = '17'

AND rfp_std_values_17_14_18_10.group_no = '14'

AND rfp_std_values_17_14_18_10.group_element_no = '18'

AND rfp_std_values_17_14_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_17_11

ON (

rfp_std_values_17_14_17_11.room = standard_room.id

AND rfp_std_values_17_14_17_11.flag_no = '17'

AND rfp_std_values_17_14_17_11.group_no = '14'

AND rfp_std_values_17_14_17_11.group_element_no = '17'

AND rfp_std_values_17_14_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_17_10

ON (

rfp_std_values_17_14_17_10.room = standard_room.id

AND rfp_std_values_17_14_17_10.flag_no = '17'

AND rfp_std_values_17_14_17_10.group_no = '14'

AND rfp_std_values_17_14_17_10.group_element_no = '17'

AND rfp_std_values_17_14_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_16_11

ON (

rfp_std_values_17_14_16_11.room = standard_room.id

AND rfp_std_values_17_14_16_11.flag_no = '17'

AND rfp_std_values_17_14_16_11.group_no = '14'

AND rfp_std_values_17_14_16_11.group_element_no = '16'

AND rfp_std_values_17_14_16_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_16_10

ON (

rfp_std_values_17_14_16_10.room = standard_room.id

AND rfp_std_values_17_14_16_10.flag_no = '17'

AND rfp_std_values_17_14_16_10.group_no = '14'

AND rfp_std_values_17_14_16_10.group_element_no = '16'

AND rfp_std_values_17_14_16_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_15_11

ON (

rfp_std_values_17_14_15_11.room = standard_room.id

AND rfp_std_values_17_14_15_11.flag_no = '17'

AND rfp_std_values_17_14_15_11.group_no = '14'

AND rfp_std_values_17_14_15_11.group_element_no = '15'

AND rfp_std_values_17_14_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_15_10

ON (

rfp_std_values_17_14_15_10.room = standard_room.id

AND rfp_std_values_17_14_15_10.flag_no = '17'

AND rfp_std_values_17_14_15_10.group_no = '14'

AND rfp_std_values_17_14_15_10.group_element_no = '15'

AND rfp_std_values_17_14_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_21_11

ON (

rfp_std_values_17_14_21_11.room = standard_room.id

AND rfp_std_values_17_14_21_11.flag_no = '17'

AND rfp_std_values_17_14_21_11.group_no = '14'

AND rfp_std_values_17_14_21_11.group_element_no = '21'

AND rfp_std_values_17_14_21_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_21_10

ON (

rfp_std_values_17_14_21_10.room = standard_room.id

AND rfp_std_values_17_14_21_10.flag_no = '17'

AND rfp_std_values_17_14_21_10.group_no = '14'

AND rfp_std_values_17_14_21_10.group_element_no = '21'

AND rfp_std_values_17_14_21_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_14_11

ON (

rfp_std_values_17_14_14_11.room = standard_room.id

AND rfp_std_values_17_14_14_11.flag_no = '17'

AND rfp_std_values_17_14_14_11.group_no = '14'

AND rfp_std_values_17_14_14_11.group_element_no = '14'

AND rfp_std_values_17_14_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_14_10

ON (

rfp_std_values_17_14_14_10.room = standard_room.id

AND rfp_std_values_17_14_14_10.flag_no = '17'

AND rfp_std_values_17_14_14_10.group_no = '14'

AND rfp_std_values_17_14_14_10.group_element_no = '14'

AND rfp_std_values_17_14_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_13_11

ON (

rfp_std_values_17_14_13_11.room = standard_room.id

AND rfp_std_values_17_14_13_11.flag_no = '17'

AND rfp_std_values_17_14_13_11.group_no = '14'

AND rfp_std_values_17_14_13_11.group_element_no = '13'

AND rfp_std_values_17_14_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_13_10

ON (

rfp_std_values_17_14_13_10.room = standard_room.id

AND rfp_std_values_17_14_13_10.flag_no = '17'

AND rfp_std_values_17_14_13_10.group_no = '14'

AND rfp_std_values_17_14_13_10.group_element_no = '13'

AND rfp_std_values_17_14_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_12_11

ON (

rfp_std_values_17_14_12_11.room = standard_room.id

AND rfp_std_values_17_14_12_11.flag_no = '17'

AND rfp_std_values_17_14_12_11.group_no = '14'

AND rfp_std_values_17_14_12_11.group_element_no = '12'

AND rfp_std_values_17_14_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_12_10

ON (

rfp_std_values_17_14_12_10.room = standard_room.id

AND rfp_std_values_17_14_12_10.flag_no = '17'

AND rfp_std_values_17_14_12_10.group_no = '14'

AND rfp_std_values_17_14_12_10.group_element_no = '12'

AND rfp_std_values_17_14_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_11_11

ON (

rfp_std_values_17_14_11_11.room = standard_room.id

AND rfp_std_values_17_14_11_11.flag_no = '17'

AND rfp_std_values_17_14_11_11.group_no = '14'

AND rfp_std_values_17_14_11_11.group_element_no = '11'

AND rfp_std_values_17_14_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_11_10

ON (

rfp_std_values_17_14_11_10.room = standard_room.id

AND rfp_std_values_17_14_11_10.flag_no = '17'

AND rfp_std_values_17_14_11_10.group_no = '14'

AND rfp_std_values_17_14_11_10.group_element_no = '11'

AND rfp_std_values_17_14_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_17_14_10_13

ON (

rfp_std_values_17_14_10_13.room = standard_room.id

AND rfp_std_values_17_14_10_13.flag_no = '17'

AND rfp_std_values_17_14_10_13.group_no = '14'

AND rfp_std_values_17_14_10_13.group_element_no = '10'

AND rfp_std_values_17_14_10_13.field_no = '13')

left join rfp_std_values rfp_std_values_17_14_10_12

ON (

rfp_std_values_17_14_10_12.room = standard_room.id

AND rfp_std_values_17_14_10_12.flag_no = '17'

AND rfp_std_values_17_14_10_12.group_no = '14'

AND rfp_std_values_17_14_10_12.group_element_no = '10'

AND rfp_std_values_17_14_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_17_14_10_11

ON (

rfp_std_values_17_14_10_11.room = standard_room.id

AND rfp_std_values_17_14_10_11.flag_no = '17'

AND rfp_std_values_17_14_10_11.group_no = '14'

AND rfp_std_values_17_14_10_11.group_element_no = '10'

AND rfp_std_values_17_14_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_17_14_10_10

ON (

rfp_std_values_17_14_10_10.room = standard_room.id

AND rfp_std_values_17_14_10_10.flag_no = '17'

AND rfp_std_values_17_14_10_10.group_no = '14'

AND rfp_std_values_17_14_10_10.group_element_no = '10'

AND rfp_std_values_17_14_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_23_10

ON (

rfp_std_values_11_15_23_10.room = standard_room.id

AND rfp_std_values_11_15_23_10.flag_no = '11'

AND rfp_std_values_11_15_23_10.group_no = '15'

AND rfp_std_values_11_15_23_10.group_element_no = '23'

AND rfp_std_values_11_15_23_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_23_11

ON (

rfp_std_values_11_15_23_11.room = standard_room.id

AND rfp_std_values_11_15_23_11.flag_no = '11'

AND rfp_std_values_11_15_23_11.group_no = '15'

AND rfp_std_values_11_15_23_11.group_element_no = '23'

AND rfp_std_values_11_15_23_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_22_10

ON (

rfp_std_values_11_15_22_10.room = standard_room.id

AND rfp_std_values_11_15_22_10.flag_no = '11'

AND rfp_std_values_11_15_22_10.group_no = '15'

AND rfp_std_values_11_15_22_10.group_element_no = '22'

AND rfp_std_values_11_15_22_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_22_11

ON (

rfp_std_values_11_15_22_11.room = standard_room.id

AND rfp_std_values_11_15_22_11.flag_no = '11'

AND rfp_std_values_11_15_22_11.group_no = '15'

AND rfp_std_values_11_15_22_11.group_element_no = '22'

AND rfp_std_values_11_15_22_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_21_10

ON (

rfp_std_values_11_15_21_10.room = standard_room.id

AND rfp_std_values_11_15_21_10.flag_no = '11'

AND rfp_std_values_11_15_21_10.group_no = '15'

AND rfp_std_values_11_15_21_10.group_element_no = '21'

AND rfp_std_values_11_15_21_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_21_11

ON (

rfp_std_values_11_15_21_11.room = standard_room.id

AND rfp_std_values_11_15_21_11.flag_no = '11'

AND rfp_std_values_11_15_21_11.group_no = '15'

AND rfp_std_values_11_15_21_11.group_element_no = '21'

AND rfp_std_values_11_15_21_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_20_10

ON (

rfp_std_values_11_15_20_10.room = standard_room.id

AND rfp_std_values_11_15_20_10.flag_no = '11'

AND rfp_std_values_11_15_20_10.group_no = '15'

AND rfp_std_values_11_15_20_10.group_element_no = '20'

AND rfp_std_values_11_15_20_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_20_11

ON (

rfp_std_values_11_15_20_11.room = standard_room.id

AND rfp_std_values_11_15_20_11.flag_no = '11'

AND rfp_std_values_11_15_20_11.group_no = '15'

AND rfp_std_values_11_15_20_11.group_element_no = '20'

AND rfp_std_values_11_15_20_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_19_11

ON (

rfp_std_values_11_15_19_11.room = standard_room.id

AND rfp_std_values_11_15_19_11.flag_no = '11'

AND rfp_std_values_11_15_19_11.group_no = '15'

AND rfp_std_values_11_15_19_11.group_element_no = '19'

AND rfp_std_values_11_15_19_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_19_12

ON (

rfp_std_values_11_15_19_12.room = standard_room.id

AND rfp_std_values_11_15_19_12.flag_no = '11'

AND rfp_std_values_11_15_19_12.group_no = '15'

AND rfp_std_values_11_15_19_12.group_element_no = '19'

AND rfp_std_values_11_15_19_12.field_no = '12')

left join rfp_std_values rfp_std_values_11_15_18_11

ON (

rfp_std_values_11_15_18_11.room = standard_room.id

AND rfp_std_values_11_15_18_11.flag_no = '11'

AND rfp_std_values_11_15_18_11.group_no = '15'

AND rfp_std_values_11_15_18_11.group_element_no = '18'

AND rfp_std_values_11_15_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_18_10

ON (

rfp_std_values_11_15_18_10.room = standard_room.id

AND rfp_std_values_11_15_18_10.flag_no = '11'

AND rfp_std_values_11_15_18_10.group_no = '15'

AND rfp_std_values_11_15_18_10.group_element_no = '18'

AND rfp_std_values_11_15_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_24_11

ON (

rfp_std_values_11_15_24_11.room = standard_room.id

AND rfp_std_values_11_15_24_11.flag_no = '11'

AND rfp_std_values_11_15_24_11.group_no = '15'

AND rfp_std_values_11_15_24_11.group_element_no = '24'

AND rfp_std_values_11_15_24_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_24_10

ON (

rfp_std_values_11_15_24_10.room = standard_room.id

AND rfp_std_values_11_15_24_10.flag_no = '11'

AND rfp_std_values_11_15_24_10.group_no = '15'

AND rfp_std_values_11_15_24_10.group_element_no = '24'

AND rfp_std_values_11_15_24_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_17_11

ON (

rfp_std_values_11_15_17_11.room = standard_room.id

AND rfp_std_values_11_15_17_11.flag_no = '11'

AND rfp_std_values_11_15_17_11.group_no = '15'

AND rfp_std_values_11_15_17_11.group_element_no = '17'

AND rfp_std_values_11_15_17_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_17_10

ON (

rfp_std_values_11_15_17_10.room = standard_room.id

AND rfp_std_values_11_15_17_10.flag_no = '11'

AND rfp_std_values_11_15_17_10.group_no = '15'

AND rfp_std_values_11_15_17_10.group_element_no = '17'

AND rfp_std_values_11_15_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_15_11

ON (

rfp_std_values_11_15_15_11.room = standard_room.id

AND rfp_std_values_11_15_15_11.flag_no = '11'

AND rfp_std_values_11_15_15_11.group_no = '15'

AND rfp_std_values_11_15_15_11.group_element_no = '15'

AND rfp_std_values_11_15_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_15_10

ON (

rfp_std_values_11_15_15_10.room = standard_room.id

AND rfp_std_values_11_15_15_10.flag_no = '11'

AND rfp_std_values_11_15_15_10.group_no = '15'

AND rfp_std_values_11_15_15_10.group_element_no = '15'

AND rfp_std_values_11_15_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_13_11

ON (

rfp_std_values_11_15_13_11.room = standard_room.id

AND rfp_std_values_11_15_13_11.flag_no = '11'

AND rfp_std_values_11_15_13_11.group_no = '15'

AND rfp_std_values_11_15_13_11.group_element_no = '13'

AND rfp_std_values_11_15_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_13_10

ON (

rfp_std_values_11_15_13_10.room = standard_room.id

AND rfp_std_values_11_15_13_10.flag_no = '11'

AND rfp_std_values_11_15_13_10.group_no = '15'

AND rfp_std_values_11_15_13_10.group_element_no = '13'

AND rfp_std_values_11_15_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_26_11

ON (

rfp_std_values_11_15_26_11.room = standard_room.id

AND rfp_std_values_11_15_26_11.flag_no = '11'

AND rfp_std_values_11_15_26_11.group_no = '15'

AND rfp_std_values_11_15_26_11.group_element_no = '26'

AND rfp_std_values_11_15_26_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_26_10

ON (

rfp_std_values_11_15_26_10.room = standard_room.id

AND rfp_std_values_11_15_26_10.flag_no = '11'

AND rfp_std_values_11_15_26_10.group_no = '15'

AND rfp_std_values_11_15_26_10.group_element_no = '26'

AND rfp_std_values_11_15_26_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_12_12

ON (

rfp_std_values_11_15_12_12.room = standard_room.id

AND rfp_std_values_11_15_12_12.flag_no = '11'

AND rfp_std_values_11_15_12_12.group_no = '15'

AND rfp_std_values_11_15_12_12.group_element_no = '12'

AND rfp_std_values_11_15_12_12.field_no = '12')

left join rfp_std_values rfp_std_values_11_15_12_10

ON (

rfp_std_values_11_15_12_10.room = standard_room.id

AND rfp_std_values_11_15_12_10.flag_no = '11'

AND rfp_std_values_11_15_12_10.group_no = '15'

AND rfp_std_values_11_15_12_10.group_element_no = '12'

AND rfp_std_values_11_15_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_11_11

ON (

rfp_std_values_11_15_11_11.room = standard_room.id

AND rfp_std_values_11_15_11_11.flag_no = '11'

AND rfp_std_values_11_15_11_11.group_no = '15'

AND rfp_std_values_11_15_11_11.group_element_no = '11'

AND rfp_std_values_11_15_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_11_10

ON (

rfp_std_values_11_15_11_10.room = standard_room.id

AND rfp_std_values_11_15_11_10.flag_no = '11'

AND rfp_std_values_11_15_11_10.group_no = '15'

AND rfp_std_values_11_15_11_10.group_element_no = '11'

AND rfp_std_values_11_15_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_25_11

ON (

rfp_std_values_11_15_25_11.room = standard_room.id

AND rfp_std_values_11_15_25_11.flag_no = '11'

AND rfp_std_values_11_15_25_11.group_no = '15'

AND rfp_std_values_11_15_25_11.group_element_no = '25'

AND rfp_std_values_11_15_25_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_25_10

ON (

rfp_std_values_11_15_25_10.room = standard_room.id

AND rfp_std_values_11_15_25_10.flag_no = '11'

AND rfp_std_values_11_15_25_10.group_no = '15'

AND rfp_std_values_11_15_25_10.group_element_no = '25'

AND rfp_std_values_11_15_25_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_15_10_11

ON (

rfp_std_values_11_15_10_11.room = standard_room.id

AND rfp_std_values_11_15_10_11.flag_no = '11'

AND rfp_std_values_11_15_10_11.group_no = '15'

AND rfp_std_values_11_15_10_11.group_element_no = '10'

AND rfp_std_values_11_15_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_15_10_10

ON (

rfp_std_values_11_15_10_10.room = standard_room.id

AND rfp_std_values_11_15_10_10.flag_no = '11'

AND rfp_std_values_11_15_10_10.group_no = '15'

AND rfp_std_values_11_15_10_10.group_element_no = '10'

AND rfp_std_values_11_15_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_13_12_11

ON (

rfp_std_values_11_13_12_11.room = standard_room.id

AND rfp_std_values_11_13_12_11.flag_no = '11'

AND rfp_std_values_11_13_12_11.group_no = '13'

AND rfp_std_values_11_13_12_11.group_element_no = '12'

AND rfp_std_values_11_13_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_13_12_10

ON (

rfp_std_values_11_13_12_10.room = standard_room.id

AND rfp_std_values_11_13_12_10.flag_no = '11'

AND rfp_std_values_11_13_12_10.group_no = '13'

AND rfp_std_values_11_13_12_10.group_element_no = '12'

AND rfp_std_values_11_13_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_13_11_11

ON (

rfp_std_values_11_13_11_11.room = standard_room.id

AND rfp_std_values_11_13_11_11.flag_no = '11'

AND rfp_std_values_11_13_11_11.group_no = '13'

AND rfp_std_values_11_13_11_11.group_element_no = '11'

AND rfp_std_values_11_13_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_13_11_10

ON (

rfp_std_values_11_13_11_10.room = standard_room.id

AND rfp_std_values_11_13_11_10.flag_no = '11'

AND rfp_std_values_11_13_11_10.group_no = '13'

AND rfp_std_values_11_13_11_10.group_element_no = '11'

AND rfp_std_values_11_13_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_13_13_11

ON (

rfp_std_values_11_13_13_11.room = standard_room.id

AND rfp_std_values_11_13_13_11.flag_no = '11'

AND rfp_std_values_11_13_13_11.group_no = '13'

AND rfp_std_values_11_13_13_11.group_element_no = '13'

AND rfp_std_values_11_13_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_13_13_10

ON (

rfp_std_values_11_13_13_10.room = standard_room.id

AND rfp_std_values_11_13_13_10.flag_no = '11'

AND rfp_std_values_11_13_13_10.group_no = '13'

AND rfp_std_values_11_13_13_10.group_element_no = '13'

AND rfp_std_values_11_13_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_13_10_11

ON (

rfp_std_values_11_13_10_11.room = standard_room.id

AND rfp_std_values_11_13_10_11.flag_no = '11'

AND rfp_std_values_11_13_10_11.group_no = '13'

AND rfp_std_values_11_13_10_11.group_element_no = '10'

AND rfp_std_values_11_13_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_13_10_12

ON (

rfp_std_values_11_13_10_12.room = standard_room.id

AND rfp_std_values_11_13_10_12.flag_no = '11'

AND rfp_std_values_11_13_10_12.group_no = '13'

AND rfp_std_values_11_13_10_12.group_element_no = '10'

AND rfp_std_values_11_13_10_12.field_no = '12')

left join rfp_std_values rfp_std_values_11_13_10_10

ON (

rfp_std_values_11_13_10_10.room = standard_room.id

AND rfp_std_values_11_13_10_10.flag_no = '11'

AND rfp_std_values_11_13_10_10.group_no = '13'

AND rfp_std_values_11_13_10_10.group_element_no = '10'

AND rfp_std_values_11_13_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_10_12_11

ON (

rfp_std_values_11_10_12_11.room = standard_room.id

AND rfp_std_values_11_10_12_11.flag_no = '11'

AND rfp_std_values_11_10_12_11.group_no = '10'

AND rfp_std_values_11_10_12_11.group_element_no = '12'

AND rfp_std_values_11_10_12_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_10_12_10

ON (

rfp_std_values_11_10_12_10.room = standard_room.id

AND rfp_std_values_11_10_12_10.flag_no = '11'

AND rfp_std_values_11_10_12_10.group_no = '10'

AND rfp_std_values_11_10_12_10.group_element_no = '12'

AND rfp_std_values_11_10_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_12_14_12

ON (

rfp_std_values_11_12_14_12.room = standard_room.id

AND rfp_std_values_11_12_14_12.flag_no = '11'

AND rfp_std_values_11_12_14_12.group_no = '12'

AND rfp_std_values_11_12_14_12.group_element_no = '14'

AND rfp_std_values_11_12_14_12.field_no = '12')

left join rfp_std_values rfp_std_values_11_12_14_11

ON (

rfp_std_values_11_12_14_11.room = standard_room.id

AND rfp_std_values_11_12_14_11.flag_no = '11'

AND rfp_std_values_11_12_14_11.group_no = '12'

AND rfp_std_values_11_12_14_11.group_element_no = '14'

AND rfp_std_values_11_12_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_12_14_10

ON (

rfp_std_values_11_12_14_10.room = standard_room.id

AND rfp_std_values_11_12_14_10.flag_no = '11'

AND rfp_std_values_11_12_14_10.group_no = '12'

AND rfp_std_values_11_12_14_10.group_element_no = '14'

AND rfp_std_values_11_12_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_12_13_11

ON (

rfp_std_values_11_12_13_11.room = standard_room.id

AND rfp_std_values_11_12_13_11.flag_no = '11'

AND rfp_std_values_11_12_13_11.group_no = '12'

AND rfp_std_values_11_12_13_11.group_element_no = '13'

AND rfp_std_values_11_12_13_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_12_13_10

ON (

rfp_std_values_11_12_13_10.room = standard_room.id

AND rfp_std_values_11_12_13_10.flag_no = '11'

AND rfp_std_values_11_12_13_10.group_no = '12'

AND rfp_std_values_11_12_13_10.group_element_no = '13'

AND rfp_std_values_11_12_13_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_12_11_11

ON (

rfp_std_values_11_12_11_11.room = standard_room.id

AND rfp_std_values_11_12_11_11.flag_no = '11'

AND rfp_std_values_11_12_11_11.group_no = '12'

AND rfp_std_values_11_12_11_11.group_element_no = '11'

AND rfp_std_values_11_12_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_12_11_10

ON (

rfp_std_values_11_12_11_10.room = standard_room.id

AND rfp_std_values_11_12_11_10.flag_no = '11'

AND rfp_std_values_11_12_11_10.group_no = '12'

AND rfp_std_values_11_12_11_10.group_element_no = '11'

AND rfp_std_values_11_12_11_10.field_no = '10')

left join rfp_std_values rfp_std_values_11_12_10_11

ON (

rfp_std_values_11_12_10_11.room = standard_room.id

AND rfp_std_values_11_12_10_11.flag_no = '11'

AND rfp_std_values_11_12_10_11.group_no = '12'

AND rfp_std_values_11_12_10_11.group_element_no = '10'

AND rfp_std_values_11_12_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_11_12_10_10

ON (

rfp_std_values_11_12_10_10.room = standard_room.id

AND rfp_std_values_11_12_10_10.flag_no = '11'

AND rfp_std_values_11_12_10_10.group_no = '12'

AND rfp_std_values_11_12_10_10.group_element_no = '10'

AND rfp_std_values_11_12_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_14_10_10

ON (

rfp_std_values_10_14_10_10.room = standard_room.id

AND rfp_std_values_10_14_10_10.flag_no = '10'

AND rfp_std_values_10_14_10_10.group_no = '14'

AND rfp_std_values_10_14_10_10.group_element_no = '10'

AND rfp_std_values_10_14_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_12_12_10

ON (

rfp_std_values_10_12_12_10.room = standard_room.id

AND rfp_std_values_10_12_12_10.flag_no = '10'

AND rfp_std_values_10_12_12_10.group_no = '12'

AND rfp_std_values_10_12_12_10.group_element_no = '12'

AND rfp_std_values_10_12_12_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_12_11_11

ON (

rfp_std_values_10_12_11_11.room = standard_room.id

AND rfp_std_values_10_12_11_11.flag_no = '10'

AND rfp_std_values_10_12_11_11.group_no = '12'

AND rfp_std_values_10_12_11_11.group_element_no = '11'

AND rfp_std_values_10_12_11_11.field_no = '11')

left join rfp_std_values rfp_std_values_10_12_10_11

ON (

rfp_std_values_10_12_10_11.room = standard_room.id

AND rfp_std_values_10_12_10_11.flag_no = '10'

AND rfp_std_values_10_12_10_11.group_no = '12'

AND rfp_std_values_10_12_10_11.group_element_no = '10'

AND rfp_std_values_10_12_10_11.field_no = '11')

left join rfp_std_values rfp_std_values_10_12_10_10

ON (

rfp_std_values_10_12_10_10.room = standard_room.id

AND rfp_std_values_10_12_10_10.flag_no = '10'

AND rfp_std_values_10_12_10_10.group_no = '12'

AND rfp_std_values_10_12_10_10.group_element_no = '10'

AND rfp_std_values_10_12_10_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_13_18_11

ON (

rfp_std_values_10_13_18_11.room = standard_room.id

AND rfp_std_values_10_13_18_11.flag_no = '10'

AND rfp_std_values_10_13_18_11.group_no = '13'

AND rfp_std_values_10_13_18_11.group_element_no = '18'

AND rfp_std_values_10_13_18_11.field_no = '11')

left join rfp_std_values rfp_std_values_10_13_18_10

ON (

rfp_std_values_10_13_18_10.room = standard_room.id

AND rfp_std_values_10_13_18_10.flag_no = '10'

AND rfp_std_values_10_13_18_10.group_no = '13'

AND rfp_std_values_10_13_18_10.group_element_no = '18'

AND rfp_std_values_10_13_18_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_13_17_10

ON (

rfp_std_values_10_13_17_10.room = standard_room.id

AND rfp_std_values_10_13_17_10.flag_no = '10'

AND rfp_std_values_10_13_17_10.group_no = '13'

AND rfp_std_values_10_13_17_10.group_element_no = '17'

AND rfp_std_values_10_13_17_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_13_14_11

ON (

rfp_std_values_10_13_14_11.room = standard_room.id

AND rfp_std_values_10_13_14_11.flag_no = '10'

AND rfp_std_values_10_13_14_11.group_no = '13'

AND rfp_std_values_10_13_14_11.group_element_no = '14'

AND rfp_std_values_10_13_14_11.field_no = '11')

left join rfp_std_values rfp_std_values_10_13_14_10

ON (

rfp_std_values_10_13_14_10.room = standard_room.id

AND rfp_std_values_10_13_14_10.flag_no = '10'

AND rfp_std_values_10_13_14_10.group_no = '13'

AND rfp_std_values_10_13_14_10.group_element_no = '14'

AND rfp_std_values_10_13_14_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_13_15_12

ON (

rfp_std_values_10_13_15_12.room = standard_room.id

AND rfp_std_values_10_13_15_12.flag_no = '10'

AND rfp_std_values_10_13_15_12.group_no = '13'

AND rfp_std_values_10_13_15_12.group_element_no = '15'

AND rfp_std_values_10_13_15_12.field_no = '12')

left join rfp_std_values rfp_std_values_10_13_15_11

ON (

rfp_std_values_10_13_15_11.room = standard_room.id

AND rfp_std_values_10_13_15_11.flag_no = '10'

AND rfp_std_values_10_13_15_11.group_no = '13'

AND rfp_std_values_10_13_15_11.group_element_no = '15'

AND rfp_std_values_10_13_15_11.field_no = '11')

left join rfp_std_values rfp_std_values_10_13_15_10

ON (

rfp_std_values_10_13_15_10.room = standard_room.id

AND rfp_std_values_10_13_15_10.flag_no = '10'

AND rfp_std_values_10_13_15_10.group_no = '13'

AND rfp_std_values_10_13_15_10.group_element_no = '15'

AND rfp_std_values_10_13_15_10.field_no = '10')

left join rfp_std_values rfp_std_values_10_13_16_10

ON (

rfp_std_values_10_13_16_10.room = standard_room.id

AND rfp_std_values_10_13_16_10.flag_no = '10'

AND rfp_std_values_10_13_16_10.group_no = '13'

AND rfp_std_values_10_13_16_10.group_element_no = '16'

AND rfp_std_values_10_13_16_10.field_no = '10')

left join classification_entry rel_3

ON (

rel_3.id = rel_1.classification_entry_id)

left join classification_entry rel_4

ON (

rel_4.id = rel_2.classification_entry_id)

WHERE (

standard_room.template_type IS NULL)

ORDER BY nullif(standard_room.room_func_no,'') ASC nulls first,

standard_room.id