Single query uses all system memory - Mailing list pgsql-general
| From | Ivar Fredriksen |
|---|---|
| Subject | Single query uses all system memory |
| Date | |
| Msg-id | CAJp6f4DsDCwZ_o3xfQOzBzTGvu_x-XSi0PuCSH0+cesBNoS2vA@mail.gmail.com Whole thread Raw |
| Responses |
Re: Single query uses all system memory
(Magnus Hagander <magnus@hagander.net>)
|
| List | pgsql-general |
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@%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@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,
pgsql-general by date: