servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
41791 492 notice 2019-06-11T11:57:20.678500+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 493 notice 2019-06-11T11:57:28.431899+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 494 notice 2019-06-11T11:57:35.677279+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 495 notice 2019-06-11T11:57:48.595104+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 496 notice 2019-06-11T11:57:57.081594+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 497 notice 2019-06-11T11:57:57.943975+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 498 notice 2019-06-11T11:59:25.171414+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 499 notice 2019-06-11T11:59:37.948833+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 502 notice 2019-06-11T11:59:56.848537+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 503 notice 2019-06-11T11:59:57.926449+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 504 notice 2019-06-11T11:59:59.679244+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 505 notice 2019-06-11T12:00:00.694819+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 506 notice 2019-06-11T12:00:01.601231+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 507 notice 2019-06-11T12:00:02.398106+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 508 notice 2019-06-11T12:00:02.891922+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 509 notice 2019-06-11T12:00:03.429335+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 510 notice 2019-06-11T12:00:03.645540+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 511 notice 2019-06-11T12:00:03.953372+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 512 notice 2019-06-11T12:00:04.054096+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 513 notice 2019-06-11T12:00:04.208763+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 514 notice 2019-06-11T12:00:04.437045+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 515 notice 2019-06-11T12:00:04.637818+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 516 notice 2019-06-11T12:00:04.776828+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 517 notice 2019-06-11T12:00:05.013389+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 518 notice 2019-06-11T12:00:05.238639+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 519 notice 2019-06-11T12:00:05.455006+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 520 notice 2019-06-11T12:00:49.129587+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 521 notice 2019-06-11T12:00:50.255854+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 522 notice 2019-06-11T12:00:55.296703+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 523 notice 2019-06-11T12:00:57.065950+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 524 notice 2019-06-11T12:00:57.623120+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 525 notice 2019-06-11T12:00:57.914870+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 526 notice 2019-06-11T12:00:58.115939+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 527 notice 2019-06-11T12:00:58.347559+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 528 notice 2019-06-11T12:00:58.561904+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 529 notice 2019-06-11T12:00:58.762054+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 530 notice 2019-06-11T12:00:58.976828+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 531 notice 2019-06-11T12:00:59.155760+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 532 notice 2019-06-11T12:00:59.335303+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 533 notice 2019-06-11T12:00:59.528639+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 534 notice 2019-06-11T12:00:59.726014+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 535 notice 2019-06-11T12:00:59.928523+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 536 notice 2019-06-11T12:01:00.115673+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 537 notice 2019-06-11T12:01:00.339628+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 538 notice 2019-06-11T12:01:00.537380+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 539 notice 2019-06-11T12:01:00.739104+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 540 notice 2019-06-11T12:01:00.948293+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 541 notice 2019-06-11T12:01:01.159730+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 542 notice 2019-06-11T12:01:01.372240+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 543 notice 2019-06-11T12:01:01.591963+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 544 notice 2019-06-11T12:01:01.807979+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 545 notice 2019-06-11T12:01:02.016245+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 546 notice 2019-06-11T12:01:05.497333+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 547 notice 2019-06-11T12:43:46.030684+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
41791 548 notice 2019-06-11T12:43:57.419473+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 551 notice 2019-06-11T12:44:43.609118+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
41791 552 notice 2019-06-11T12:55:07.621609+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
39815 558 notice 2019-06-11T13:55:04.238399+0300   Vesi 22°C                
40258 563 notice 2019-06-11T16:54:41.556321+0300   Valvonta rannalla klo 10-20               Valvonta rannalla klo 10-20
40258 564 notice 2019-06-11T16:54:48.994385+0300   Valvonta rannalla klo 10-20               Valvonta rannalla klo 10-20
39815 571 notice 2019-06-11T18:08:23.283133+0300   Vesi 22°C                
39693 580 notice 2019-06-12T10:11:49.501941+0300   Veden lämpötila 18ºC.               Veden lämpötila 18ºC.
40559 585 notice 2019-06-12T10:20:33.968764+0300   18 astetta merivesi                
40142 594 notice 2019-06-12T10:48:07.814743+0300   Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa.                
40098 597 notice 2019-06-12T10:52:48.030271+0300   Uimaranta auki. Rannalla valvoja paikalla 3.6.-10.8.2019 saakka klo 10-18. Ranta hyvässä kunnossa.                
39815 600 notice 2019-06-12T11:38:15.940768+0300   Vesi 22°C                
39815 601 notice 2019-06-12T11:38:36.867384+0300   Vesi 19°C                
39815 602 notice 2019-06-12T11:38:39.391386+0300   Vesi 19°C                
39693 611 notice 2019-06-12T14:12:30.669916+0300   Veden lämpötila 19ºC.                
39815 614 notice 2019-06-12T14:29:09.152644+0300   Vesi 20°C                
39815 615 notice 2019-06-12T14:29:16.248553+0300   Vesi 20°C                
39815 616 notice 2019-06-12T14:29:24.895118+0300   Vesi 20°C                
39693 619 notice 2019-06-12T17:47:27.292592+0300   Veden lämpötila 19ºC.                
39815 624 notice 2019-06-12T18:06:30.742176+0300   Vesi 20°C                
39815 625 notice 2019-06-12T18:06:35.065574+0300   Vesi 20°C                
39815 626 notice 2019-06-12T18:06:36.776035+0300   Vesi 20°C                
39713 632 notice 2019-06-13T07:47:45.024184+0300                    
39713 633 notice 2019-06-13T07:48:24.793182+0300   Loistava                
40559 646 notice 2019-06-13T10:02:12.863732+0300   15 astetta merivesi                
39693 649 notice 2019-06-13T10:05:35.385699+0300   Veden lämpötila 17ºC.                
39693 650 notice 2019-06-13T10:05:48.204703+0300   Veden lämpötila 17ºC.                
39322 653 notice 2019-06-13T10:08:30.271759+0300   Valvontaa rannalla klo 8-20 joka päivä 11.8 saakka, tervetuloa!                
39815 666 notice 2019-06-13T10:50:29.819656+0300   Vesi n.17°C                
39815 667 notice 2019-06-13T10:50:33.186718+0300   Vesi n.17°C                
39815 668 notice 2019-06-13T10:50:33.835810+0300   Vesi n.17°C                
39693 683 notice 2019-06-13T14:06:31.000667+0300   Veden lämpötila 16ºC.                
39693 684 notice 2019-06-13T14:06:36.833511+0300   Veden lämpötila 16ºC.                
39693 729 notice 2019-06-14T10:25:30.945301+0300   Veden lämpötila 16ºC.                
39693 730 notice 2019-06-14T10:25:34.593999+0300   Veden lämpötila 16ºC.                
40559 733 notice 2019-06-14T10:30:12.299220+0300   15 astetta merivesi                
39815 738 notice 2019-06-14T13:50:10.000255+0300   Vesi n.17°C                
39815 739 notice 2019-06-14T13:50:17.065930+0300   Vesi n.17°C                
39693 742 notice 2019-06-14T14:07:57.720763+0300   Veden lämpötila 16ºC.                
39815 748 notice 2019-06-14T17:58:23.413294+0300   Vesi n.17°C                
39693 751 notice 2019-06-14T18:02:17.159506+0300   Veden lämpötila 16ºC.                
39815 755 notice 2019-06-15T10:01:43.662229+0300   Vesi n.17°C                
40559 763 notice 2019-06-15T10:11:36.052586+0300   14 astetta merivesi               14 astetta merivesi
39693 770 notice 2019-06-15T10:31:11.344561+0300   Veden lämpötila 16ºC.               Veden lämpötila 16ºC.
39693 771 notice 2019-06-15T10:31:14.677922+0300   Veden lämpötila 16ºC.                
40258 774 notice 2019-06-15T10:52:34.908360+0300   Valvonta rannalla klo 10-20                
40142 779 notice 2019-06-15T12:20:19.702037+0300   Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa.