Search Postgresql Archives

Single query uses all system memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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,

          standard_room.id

 

 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux