Symfony Profiler

INSERT INTO object_collection_vcloudContentblock_localized_vcloud_ccskirun (
  `ooo_id`, `language`, `fieldname`,
  `index`, `header`, `description`,
  `links`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudContentblock_localized_vcloud_ccskirun (`ooo_id`, `language`, `fieldname`, `index`, `header`, `description`, `links`) VALUES (14016, 'de', 'contentblocks', 0, 'Ausgangspunkt - Wegbeschreibung - Endpunkt', '<p><strong>Ausgangspunkt</strong><br />Tschagguns, Montafoner Schanzenzentrum</p><p><strong>Wegbeschreibung</strong><br />Der Einstieg in die Übungsrunde befindet sich direkt beim Montafoner Schanzenzentrum. Die Strecke umfasst einen kleinen Übungsachter für Skating sowie eine separate Übungsrunde für den klassischen Stil und führt jeweils wieder zurück zum Ausgangspunkt.</p><p><strong>Endpunkt</strong><br />Tschagguns, Montafoner Schanzenzentrum</p><p><strong>Bitte beachte:</strong> Je nach Schnee- und Witterungssituation können sich die Loipenführung und der Einstieg kurzfristig ändern.</p>
', 'a:0:{}');

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 99423;

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/VCloud/CrossCountrySkiRun/', `id` = 14016, `creationDate` = 1793636033, `modificationDate` = 1793808178, `versionCount` = 0, `userOwner` = 0, `userModification` = 0, `parentId` = 11236, `type` = 'object', `key` = 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)_32da4db0-8dcc-47d4-b9df-5176ba369539', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'vcloud_ccskirun', `published` = 1, `className` = 'CCSkiRun' WHERE `id` = 14016;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_ccskirun';

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/VCloud/CrossCountrySkiRun/', 14016, 1793636033, 1793808178, 0, 0, 0, 11236, 'object', 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)_32da4db0-8dcc-47d4-b9df-5176ba369539', 0, NULL, NULL, 'vcloud_ccskirun', 1, 'CCSkiRun');

SELECT
  *
FROM
  object_store_vcloud_ccskirun
WHERE
  oo_id = ?

SELECT * FROM object_store_vcloud_ccskirun WHERE oo_id = 14016;

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_ccskirun
where
  language = 'de'
  and ooo_id = 14016
  and fieldname = 'contentblocks'
  and `index` = 2

select `links` from object_collection_vcloudContentblock_localized_vcloud_ccskirun where language = 'de' and  ooo_id  = 14016 and fieldname = 'contentblocks' and `index` =  2;

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/webhook/' AND `key` = BINARY 'update-live-data';

UPDATE
  object_store_vcloud_ccskirun
SET
  `oo_id` = ?,
  `reference` = ?,
  `lastUpdated` = ?,
  `redirectReference` = ?,
  `tourStatus` = ?,
  `isOpen` = ?,
  `openingStatus` = ?,
  `feratelOpeningStatus` = ?,
  `duration` = ?,
  `length` = ?,
  `highest` = ?,
  `lowest` = ?,
  `uphill` = ?,
  `downhill` = ?,
  `stamina` = ?,
  `skill` = ?,
  `difficulty` = ?,
  `adventure` = ?,
  `scenery` = ?,
  `runType` = ?,
  `level` = ?,
  `months` = ?,
  `geoData` = ?,
  `elevationProfile` = ?,
  `linestring` = ?,
  `gallery__images` = ?,
  `gallery__hotspots` = ?
WHERE
  `oo_id` = ?

UPDATE object_store_vcloud_ccskirun SET `oo_id` = 14016, `reference` = '32da4db0-8dcc-47d4-b9df-5176ba369539', `lastUpdated` = NULL, `redirectReference` = '21266725', `tourStatus` = 'closed', `isOpen` = 0, `openingStatus` = 'closed', `feratelOpeningStatus` = '', `duration` = '00:03', `length` = 248, `highest` = 680, `lowest` = 679, `uphill` = 1, `downhill` = 1, `stamina` = NULL, `skill` = NULL, `difficulty` = 1, `adventure` = NULL, `scenery` = NULL, `runType` = 'classic', `level` = 'odta:Easy', `months` = '1,2,3,4,12', `geoData` = 'a:45:{i:0;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:1;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:2;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:3;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:4;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159223;s:11:\"\0*\0latitude\";d:47.0672433;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:5;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159953;s:11:\"\0*\0latitude\";d:47.0671802;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:6;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9161203;s:11:\"\0*\0latitude\";d:47.067117;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:7;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162766;s:11:\"\0*\0latitude\";d:47.0670857;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:8;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164252;s:11:\"\0*\0latitude\";d:47.0670821;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:9;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:10;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:11;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:12;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:13;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9167838;s:11:\"\0*\0latitude\";d:47.0671376;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:14;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9169407;s:11:\"\0*\0latitude\";d:47.0671371;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:15;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9170487;s:11:\"\0*\0latitude\";d:47.0671313;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:16;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9172039;s:11:\"\0*\0latitude\";d:47.0671044;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:17;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:18;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:19;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:20;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:21;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:22;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:23;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:24;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:25;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:26;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:27;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:28;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:29;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:30;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:31;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:32;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:33;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:34;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:35;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:36;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:37;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:38;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:39;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164739;s:11:\"\0*\0latitude\";d:47.0671938;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:40;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9163341;s:11:\"\0*\0latitude\";d:47.0672649;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:41;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:42;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:43;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:44;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9160605;s:11:\"\0*\0latitude\";d:47.0673338;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}}', `elevationProfile` = '[{\"x\":0,\"y\":678},{\"x\":7.73,\"y\":678},{\"x\":16.66,\"y\":678},{\"x\":28.45,\"y\":678},{\"x\":40.79,\"y\":679},{\"x\":52.05,\"y\":679},{\"x\":64.33,\"y\":679},{\"x\":79.91,\"y\":679},{\"x\":91.79,\"y\":678},{\"x\":100,\"y\":679},{\"x\":112.13,\"y\":679},{\"x\":116.99,\"y\":679.02},{\"x\":122.17,\"y\":679.08},{\"x\":127.51,\"y\":679.15},{\"x\":132.61,\"y\":679.2},{\"x\":138.7,\"y\":679.21},{\"x\":143.66,\"y\":679.17},{\"x\":148.36,\"y\":679.22},{\"x\":174.17,\"y\":679},{\"x\":189.14,\"y\":679},{\"x\":215.2,\"y\":678},{\"x\":228.42,\"y\":678},{\"x\":240.01,\"y\":678},{\"x\":250.8,\"y\":678}]', `linestring` = '[{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.0672433\",\"lng\":\"9.9159223\",\"z\":\"678.0\"},{\"lat\":\"47.0671802\",\"lng\":\"9.9159953\",\"z\":\"678.0\"},{\"lat\":\"47.067117\",\"lng\":\"9.9161203\",\"z\":\"678.0\"},{\"lat\":\"47.0670857\",\"lng\":\"9.9162766\",\"z\":\"679.0\"},{\"lat\":\"47.0670821\",\"lng\":\"9.9164252\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.0671376\",\"lng\":\"9.9167838\",\"z\":\"679.0\"},{\"lat\":\"47.0671371\",\"lng\":\"9.9169407\",\"z\":\"678.0\"},{\"lat\":\"47.0671313\",\"lng\":\"9.9170487\",\"z\":\"679.0\"},{\"lat\":\"47.0671044\",\"lng\":\"9.9172039\",\"z\":\"679.0\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.0671938\",\"lng\":\"9.9164739\",\"z\":\"678.0\"},{\"lat\":\"47.0672649\",\"lng\":\"9.9163341\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673338\",\"lng\":\"9.9160605\",\"z\":\"678.0\"}]', `gallery__images` = ',99423,99424,', `gallery__hotspots` = 'a:2:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}' WHERE `oo_id` = 14016;

DELETE FROM
  object_collection_vcloudContentblock_vcloud_ccskirun
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudContentblock_vcloud_ccskirun WHERE id = 14016 AND fieldname = 'contentblocks';

"COMMIT"

"COMMIT";

INSERT INTO object_collection_vcloudContentblock_vcloud_ccskirun (
  `id`, `index`, `fieldname`, `gallery__images`,
  `gallery__hotspots`
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudContentblock_vcloud_ccskirun (`id`, `index`, `fieldname`, `gallery__images`, `gallery__hotspots`) VALUES (14016, 0, 'contentblocks', '', 'a:0:{}');

UPDATE
  object_localized_data_vcloud_ccskirun
SET
  `ooo_id` = ?,
  `language` = ?,
  `title` = ?,
  `description` = ?,
  `text` = ?,
  `slug` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_data_vcloud_ccskirun SET `ooo_id` = 14016, `language` = 'de', `title` = 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)', `description` = '<p>Die Übungsrunde beim Montafoner Schanzenzentrum bietet eine kleine Runde für klassisches Langlaufen und Skating. Sie eignet sich ideal für erste Versuche, Technikübungen oder eine kurze Trainingseinheit auf einer schneesicheren Loipe.</p>', `text` = NULL, `slug` = 'nr-32-uebungsrunde-schanze-tschagguns-klassisch-skating-1' WHERE `ooo_id` = 14016 AND `language` = 'de';

SELECT
  *
FROM
  object_localized_data_vcloud_poi
WHERE
  ooo_id = ?
  AND language IN ('de', 'en', 'nl', 'fr')

SELECT * FROM object_localized_data_vcloud_poi WHERE ooo_id = 4002 AND language IN ('de','en','nl','fr');

SELECT
  *
FROM
  object_localized_query_vcloud_ccskirun_fr
WHERE
  ooo_id = 14016
  AND language = 'fr'

SELECT * FROM object_localized_query_vcloud_ccskirun_fr WHERE ooo_id = 14016 AND language = 'fr';

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_ccskirun
where
  language = 'de'
  and ooo_id = 14016
  and fieldname = 'contentblocks'
  and `index` = 0

select `links` from object_collection_vcloudContentblock_localized_vcloud_ccskirun where language = 'de' and  ooo_id  = 14016 and fieldname = 'contentblocks' and `index` =  0;

UPDATE
  object_query_vcloud_ccskirun
SET
  `reference` = ?,
  `lastUpdated` = ?,
  `redirectReference` = ?,
  `tourStatus` = ?,
  `isOpen` = ?,
  `openingStatus` = ?,
  `feratelOpeningStatus` = ?,
  `duration` = ?,
  `length` = ?,
  `highest` = ?,
  `lowest` = ?,
  `uphill` = ?,
  `downhill` = ?,
  `stamina` = ?,
  `skill` = ?,
  `difficulty` = ?,
  `adventure` = ?,
  `scenery` = ?,
  `tourType` = ?,
  `runType` = ?,
  `level` = ?,
  `start__id` = ?,
  `start__type` = ?,
  `finish__id` = ?,
  `finish__type` = ?,
  `months` = ?,
  `geoData` = ?,
  `elevationProfile` = ?,
  `linestring` = ?,
  `gallery__images` = ?,
  `gallery__hotspots` = ?,
  `municipality` = ?,
  `categories` = ?,
  `waypoints` = ?,
  `sections` = ?,
  `linkedThings` = ?,
  `safetyTips` = ?,
  `portals` = ?,
  `oo_id` = ?
WHERE
  `oo_id` = ?

UPDATE object_query_vcloud_ccskirun SET `reference` = '32da4db0-8dcc-47d4-b9df-5176ba369539', `lastUpdated` = NULL, `redirectReference` = '21266725', `tourStatus` = 'closed', `isOpen` = 0, `openingStatus` = 'closed', `feratelOpeningStatus` = '', `duration` = '00:03', `length` = 248, `highest` = 680, `lowest` = 679, `uphill` = 1, `downhill` = 1, `stamina` = NULL, `skill` = NULL, `difficulty` = 1, `adventure` = NULL, `scenery` = NULL, `tourType` = ',8522,', `runType` = 'classic', `level` = 'odta:Easy', `start__id` = 4002, `start__type` = 'object', `finish__id` = 4002, `finish__type` = 'object', `months` = ',1,2,3,4,12,', `geoData` = 'a:45:{i:0;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:1;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:2;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:3;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:4;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159223;s:11:\"\0*\0latitude\";d:47.0672433;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:5;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159953;s:11:\"\0*\0latitude\";d:47.0671802;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:6;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9161203;s:11:\"\0*\0latitude\";d:47.067117;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:7;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162766;s:11:\"\0*\0latitude\";d:47.0670857;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:8;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164252;s:11:\"\0*\0latitude\";d:47.0670821;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:9;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:10;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:11;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:12;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:13;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9167838;s:11:\"\0*\0latitude\";d:47.0671376;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:14;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9169407;s:11:\"\0*\0latitude\";d:47.0671371;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:15;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9170487;s:11:\"\0*\0latitude\";d:47.0671313;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:16;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9172039;s:11:\"\0*\0latitude\";d:47.0671044;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:17;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:18;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:19;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:20;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:21;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:22;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:23;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:24;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:25;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:26;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:27;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:28;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:29;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:30;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:31;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:32;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:33;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:34;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:35;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:36;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:37;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:38;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:39;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164739;s:11:\"\0*\0latitude\";d:47.0671938;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:40;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9163341;s:11:\"\0*\0latitude\";d:47.0672649;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:41;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:42;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:43;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:44;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9160605;s:11:\"\0*\0latitude\";d:47.0673338;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}}', `elevationProfile` = '[{\"x\":0,\"y\":678},{\"x\":7.73,\"y\":678},{\"x\":16.66,\"y\":678},{\"x\":28.45,\"y\":678},{\"x\":40.79,\"y\":679},{\"x\":52.05,\"y\":679},{\"x\":64.33,\"y\":679},{\"x\":79.91,\"y\":679},{\"x\":91.79,\"y\":678},{\"x\":100,\"y\":679},{\"x\":112.13,\"y\":679},{\"x\":116.99,\"y\":679.02},{\"x\":122.17,\"y\":679.08},{\"x\":127.51,\"y\":679.15},{\"x\":132.61,\"y\":679.2},{\"x\":138.7,\"y\":679.21},{\"x\":143.66,\"y\":679.17},{\"x\":148.36,\"y\":679.22},{\"x\":174.17,\"y\":679},{\"x\":189.14,\"y\":679},{\"x\":215.2,\"y\":678},{\"x\":228.42,\"y\":678},{\"x\":240.01,\"y\":678},{\"x\":250.8,\"y\":678}]', `linestring` = '[{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.0672433\",\"lng\":\"9.9159223\",\"z\":\"678.0\"},{\"lat\":\"47.0671802\",\"lng\":\"9.9159953\",\"z\":\"678.0\"},{\"lat\":\"47.067117\",\"lng\":\"9.9161203\",\"z\":\"678.0\"},{\"lat\":\"47.0670857\",\"lng\":\"9.9162766\",\"z\":\"679.0\"},{\"lat\":\"47.0670821\",\"lng\":\"9.9164252\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.0671376\",\"lng\":\"9.9167838\",\"z\":\"679.0\"},{\"lat\":\"47.0671371\",\"lng\":\"9.9169407\",\"z\":\"678.0\"},{\"lat\":\"47.0671313\",\"lng\":\"9.9170487\",\"z\":\"679.0\"},{\"lat\":\"47.0671044\",\"lng\":\"9.9172039\",\"z\":\"679.0\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.0671938\",\"lng\":\"9.9164739\",\"z\":\"678.0\"},{\"lat\":\"47.0672649\",\"lng\":\"9.9163341\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673338\",\"lng\":\"9.9160605\",\"z\":\"678.0\"}]', `gallery__images` = ',99423,99424,', `gallery__hotspots` = 'a:2:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', `municipality` = ',7124,7129,', `categories` = ',13034,', `waypoints` = NULL, `sections` = NULL, `linkedThings` = NULL, `safetyTips` = ',7159,', `portals` = NULL, `oo_id` = 14016 WHERE `oo_id` = 14016;

SELECT
  *
FROM
  object_relations_vcloud_ccskirun
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_ccskirun WHERE src_id = 14016;

SELECT
  *
FROM
  object_collection_vcloudContentblock_localized_vcloud_ccskirun
WHERE
  ooo_id = ?
  AND language IN ('de', 'en', 'nl', 'fr')
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_ccskirun WHERE ooo_id = 14016 AND language IN ('de','en','nl','fr') AND `fieldname` = 'contentblocks' AND `index` = 0;

SELECT
  *
FROM
  object_relations_vcloud_poi
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_poi WHERE src_id = 4002;

INSERT INTO object_localized_query_vcloud_ccskirun_en (
  `ooo_id`, `language`, `title`, `description`,
  `text`, `slug`, `search_index`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_query_vcloud_ccskirun_en (`ooo_id`, `language`, `title`, `description`, `text`, `slug`, `search_index`) VALUES (14016, 'en', 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)', '<p>Die Übungsrunde beim Montafoner Schanzenzentrum bietet eine kleine Runde für klassisches Langlaufen und Skating. Sie eignet sich ideal für erste Versuche, Technikübungen oder eine kurze Trainingseinheit auf einer schneesicheren Loipe.</p>', NULL, 'nr-32-uebungsrunde-schanze-tschagguns-klassisch-skating-1', '');

SELECT
  *
FROM
  object_relations_vcloud_safety_tip
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_safety_tip WHERE src_id = 7159;

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 14016;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 14016 AND ctype = 'object';

INSERT INTO object_localized_data_vcloud_ccskirun (
  `ooo_id`, `language`, `title`, `description`,
  `text`, `slug`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_data_vcloud_ccskirun (`ooo_id`, `language`, `title`, `description`, `text`, `slug`) VALUES (14016, 'de', 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)', '<p>Die Übungsrunde beim Montafoner Schanzenzentrum bietet eine kleine Runde für klassisches Langlaufen und Skating. Sie eignet sich ideal für erste Versuche, Technikübungen oder eine kurze Trainingseinheit auf einer schneesicheren Loipe.</p>', NULL, 'nr-32-uebungsrunde-schanze-tschagguns-klassisch-skating-1');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 14016;

SELECT
  *
FROM
  object_store_vcloud_safety_tip
WHERE
  oo_id = ?

SELECT * FROM object_store_vcloud_safety_tip WHERE oo_id = 7159;

INSERT INTO object_localized_query_vcloud_ccskirun_nl (
  `ooo_id`, `language`, `title`, `description`,
  `text`, `slug`, `search_index`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_query_vcloud_ccskirun_nl (`ooo_id`, `language`, `title`, `description`, `text`, `slug`, `search_index`) VALUES (14016, 'nl', 'Nr. 32: Übungsrunde Schanze Tschagguns (klassisch & skating)', '<p>Die Übungsrunde beim Montafoner Schanzenzentrum bietet eine kleine Runde für klassisches Langlaufen und Skating. Sie eignet sich ideal für erste Versuche, Technikübungen oder eine kurze Trainingseinheit auf einer schneesicheren Loipe.</p>', NULL, 'nr-32-uebungsrunde-schanze-tschagguns-klassisch-skating-1', '');

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_ccskirun
where
  language = 'nl'
  and ooo_id = 14016
  and fieldname = 'contentblocks'
  and `index` = 0

select `links` from object_collection_vcloudContentblock_localized_vcloud_ccskirun where language = 'nl' and  ooo_id  = 14016 and fieldname = 'contentblocks' and `index` =  0;

INSERT INTO object_query_vcloud_ccskirun (
  `reference`, `lastUpdated`, `redirectReference`,
  `tourStatus`, `isOpen`, `openingStatus`,
  `feratelOpeningStatus`, `duration`,
  `length`, `highest`, `lowest`, `uphill`,
  `downhill`, `stamina`, `skill`, `difficulty`,
  `adventure`, `scenery`, `tourType`,
  `runType`, `level`, `start__id`,
  `start__type`, `finish__id`, `finish__type`,
  `months`, `geoData`, `elevationProfile`,
  `linestring`, `gallery__images`,
  `gallery__hotspots`, `municipality`,
  `categories`, `waypoints`, `sections`,
  `linkedThings`, `safetyTips`, `portals`,
  `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_query_vcloud_ccskirun (`reference`, `lastUpdated`, `redirectReference`, `tourStatus`, `isOpen`, `openingStatus`, `feratelOpeningStatus`, `duration`, `length`, `highest`, `lowest`, `uphill`, `downhill`, `stamina`, `skill`, `difficulty`, `adventure`, `scenery`, `tourType`, `runType`, `level`, `start__id`, `start__type`, `finish__id`, `finish__type`, `months`, `geoData`, `elevationProfile`, `linestring`, `gallery__images`, `gallery__hotspots`, `municipality`, `categories`, `waypoints`, `sections`, `linkedThings`, `safetyTips`, `portals`, `oo_id`) VALUES ('32da4db0-8dcc-47d4-b9df-5176ba369539', NULL, '21266725', 'closed', 0, 'closed', '', '00:03', 248, 680, 679, 1, 1, NULL, NULL, 1, NULL, NULL, ',8522,', 'classic', 'odta:Easy', 4002, 'object', 4002, 'object', ',1,2,3,4,12,', 'a:45:{i:0;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:1;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:2;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:3;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:4;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159223;s:11:\"\0*\0latitude\";d:47.0672433;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:5;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159953;s:11:\"\0*\0latitude\";d:47.0671802;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:6;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9161203;s:11:\"\0*\0latitude\";d:47.067117;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:7;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162766;s:11:\"\0*\0latitude\";d:47.0670857;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:8;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164252;s:11:\"\0*\0latitude\";d:47.0670821;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:9;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:10;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:11;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:12;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:13;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9167838;s:11:\"\0*\0latitude\";d:47.0671376;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:14;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9169407;s:11:\"\0*\0latitude\";d:47.0671371;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:15;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9170487;s:11:\"\0*\0latitude\";d:47.0671313;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:16;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9172039;s:11:\"\0*\0latitude\";d:47.0671044;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:17;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:18;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:19;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:20;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:21;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:22;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:23;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:24;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:25;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:26;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:27;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:28;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:29;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:30;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:31;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:32;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:33;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:34;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:35;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:36;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:37;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:38;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:39;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164739;s:11:\"\0*\0latitude\";d:47.0671938;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:40;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9163341;s:11:\"\0*\0latitude\";d:47.0672649;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:41;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:42;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:43;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:44;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9160605;s:11:\"\0*\0latitude\";d:47.0673338;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}}', '[{\"x\":0,\"y\":678},{\"x\":7.73,\"y\":678},{\"x\":16.66,\"y\":678},{\"x\":28.45,\"y\":678},{\"x\":40.79,\"y\":679},{\"x\":52.05,\"y\":679},{\"x\":64.33,\"y\":679},{\"x\":79.91,\"y\":679},{\"x\":91.79,\"y\":678},{\"x\":100,\"y\":679},{\"x\":112.13,\"y\":679},{\"x\":116.99,\"y\":679.02},{\"x\":122.17,\"y\":679.08},{\"x\":127.51,\"y\":679.15},{\"x\":132.61,\"y\":679.2},{\"x\":138.7,\"y\":679.21},{\"x\":143.66,\"y\":679.17},{\"x\":148.36,\"y\":679.22},{\"x\":174.17,\"y\":679},{\"x\":189.14,\"y\":679},{\"x\":215.2,\"y\":678},{\"x\":228.42,\"y\":678},{\"x\":240.01,\"y\":678},{\"x\":250.8,\"y\":678}]', '[{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.0672433\",\"lng\":\"9.9159223\",\"z\":\"678.0\"},{\"lat\":\"47.0671802\",\"lng\":\"9.9159953\",\"z\":\"678.0\"},{\"lat\":\"47.067117\",\"lng\":\"9.9161203\",\"z\":\"678.0\"},{\"lat\":\"47.0670857\",\"lng\":\"9.9162766\",\"z\":\"679.0\"},{\"lat\":\"47.0670821\",\"lng\":\"9.9164252\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.0671376\",\"lng\":\"9.9167838\",\"z\":\"679.0\"},{\"lat\":\"47.0671371\",\"lng\":\"9.9169407\",\"z\":\"678.0\"},{\"lat\":\"47.0671313\",\"lng\":\"9.9170487\",\"z\":\"679.0\"},{\"lat\":\"47.0671044\",\"lng\":\"9.9172039\",\"z\":\"679.0\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.0671938\",\"lng\":\"9.9164739\",\"z\":\"678.0\"},{\"lat\":\"47.0672649\",\"lng\":\"9.9163341\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673338\",\"lng\":\"9.9160605\",\"z\":\"678.0\"}]', ',99423,99424,', 'a:2:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', ',7124,7129,', ',13034,', NULL, NULL, NULL, ',7159,', NULL, 14016);

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook/update-live-data';

SELECT
  object_localized_vcloud_ccskirun_en.id as id,
  object_localized_vcloud_ccskirun_en.type as `type`
FROM
  object_localized_vcloud_ccskirun_en
WHERE
  (
    `reference` = '32da4db0-8dcc-47d4-b9df-5176ba369539'
    AND object_localized_vcloud_ccskirun_en.type IN ('variant', 'object')
  )
  AND object_localized_vcloud_ccskirun_en.published = 1
LIMIT
  1

SELECT object_localized_vcloud_ccskirun_en.id as id, object_localized_vcloud_ccskirun_en.type as `type` FROM object_localized_vcloud_ccskirun_en WHERE (`reference` = '32da4db0-8dcc-47d4-b9df-5176ba369539'  AND  object_localized_vcloud_ccskirun_en.type IN ('variant','object')) AND object_localized_vcloud_ccskirun_en.published = 1 LIMIT 1;

SELECT
  *
FROM
  assets_metadata
WHERE
  cid = ?

SELECT * FROM assets_metadata WHERE cid = 99423;

DELETE FROM
  object_relations_vcloud_ccskirun
WHERE
  src_id = '14016'
  AND ownertype = 'localizedfield'
  AND ownername LIKE '/fieldcollection~contentblocks/0/%'

DELETE FROM object_relations_vcloud_ccskirun WHERE src_id = '14016' AND ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~contentblocks/0/%';

INSERT INTO object_store_vcloud_ccskirun (
  `oo_id`, `reference`, `lastUpdated`,
  `redirectReference`, `tourStatus`,
  `isOpen`, `openingStatus`, `feratelOpeningStatus`,
  `duration`, `length`, `highest`,
  `lowest`, `uphill`, `downhill`, `stamina`,
  `skill`, `difficulty`, `adventure`,
  `scenery`, `runType`, `level`, `months`,
  `geoData`, `elevationProfile`, `linestring`,
  `gallery__images`, `gallery__hotspots`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_store_vcloud_ccskirun (`oo_id`, `reference`, `lastUpdated`, `redirectReference`, `tourStatus`, `isOpen`, `openingStatus`, `feratelOpeningStatus`, `duration`, `length`, `highest`, `lowest`, `uphill`, `downhill`, `stamina`, `skill`, `difficulty`, `adventure`, `scenery`, `runType`, `level`, `months`, `geoData`, `elevationProfile`, `linestring`, `gallery__images`, `gallery__hotspots`) VALUES (14016, '32da4db0-8dcc-47d4-b9df-5176ba369539', NULL, '21266725', 'closed', 0, 'closed', '', '00:03', 248, 680, 679, 1, 1, NULL, NULL, 1, NULL, NULL, 'classic', 'odta:Easy', '1,2,3,4,12', 'a:45:{i:0;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:1;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:2;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:3;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159378;s:11:\"\0*\0latitude\";d:47.067312;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:4;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159223;s:11:\"\0*\0latitude\";d:47.0672433;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:5;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9159953;s:11:\"\0*\0latitude\";d:47.0671802;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:6;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9161203;s:11:\"\0*\0latitude\";d:47.067117;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:7;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162766;s:11:\"\0*\0latitude\";d:47.0670857;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:8;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164252;s:11:\"\0*\0latitude\";d:47.0670821;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:9;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:10;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:11;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:12;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9165837;s:11:\"\0*\0latitude\";d:47.067105;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:13;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9167838;s:11:\"\0*\0latitude\";d:47.0671376;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:14;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9169407;s:11:\"\0*\0latitude\";d:47.0671371;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:15;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9170487;s:11:\"\0*\0latitude\";d:47.0671313;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:16;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9172039;s:11:\"\0*\0latitude\";d:47.0671044;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:17;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:18;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:19;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:20;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917257225583455;s:11:\"\0*\0latitude\";d:47.067080032512564;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:21;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:22;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917308187554454;s:11:\"\0*\0latitude\";d:47.06704897411129;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:23;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:24;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91731891639003;s:11:\"\0*\0latitude\";d:47.06700147299139;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:25;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:26;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917313551972768;s:11:\"\0*\0latitude\";d:47.066955798797466;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:27;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:28;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.91727868325549;s:11:\"\0*\0latitude\";d:47.066906470624644;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:29;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:30;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917225039074793;s:11:\"\0*\0latitude\";d:47.06688089303566;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:31;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:32;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.917163022729454;s:11:\"\0*\0latitude\";d:47.06687798407748;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:33;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:34;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:35;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:36;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9168289;s:11:\"\0*\0latitude\";d:47.0669234;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:37;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:38;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9166654;s:11:\"\0*\0latitude\";d:47.066999;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:39;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9164739;s:11:\"\0*\0latitude\";d:47.0671938;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:40;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9163341;s:11:\"\0*\0latitude\";d:47.0672649;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:41;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:42;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:43;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9162005;s:11:\"\0*\0latitude\";d:47.0673158;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}i:44;O:44:\"Pimcore\\Model\\DataObject\\Data\\GeoCoordinates\":5:{s:12:\"\0*\0longitude\";d:9.9160605;s:11:\"\0*\0latitude\";d:47.0673338;s:9:\"\0*\0_owner\";N;s:13:\"\0*\0_fieldname\";N;s:12:\"\0*\0_language\";N;}}', '[{\"x\":0,\"y\":678},{\"x\":7.73,\"y\":678},{\"x\":16.66,\"y\":678},{\"x\":28.45,\"y\":678},{\"x\":40.79,\"y\":679},{\"x\":52.05,\"y\":679},{\"x\":64.33,\"y\":679},{\"x\":79.91,\"y\":679},{\"x\":91.79,\"y\":678},{\"x\":100,\"y\":679},{\"x\":112.13,\"y\":679},{\"x\":116.99,\"y\":679.02},{\"x\":122.17,\"y\":679.08},{\"x\":127.51,\"y\":679.15},{\"x\":132.61,\"y\":679.2},{\"x\":138.7,\"y\":679.21},{\"x\":143.66,\"y\":679.17},{\"x\":148.36,\"y\":679.22},{\"x\":174.17,\"y\":679},{\"x\":189.14,\"y\":679},{\"x\":215.2,\"y\":678},{\"x\":228.42,\"y\":678},{\"x\":240.01,\"y\":678},{\"x\":250.8,\"y\":678}]', '[{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.067312\",\"lng\":\"9.9159378\",\"z\":\"678.0\"},{\"lat\":\"47.0672433\",\"lng\":\"9.9159223\",\"z\":\"678.0\"},{\"lat\":\"47.0671802\",\"lng\":\"9.9159953\",\"z\":\"678.0\"},{\"lat\":\"47.067117\",\"lng\":\"9.9161203\",\"z\":\"678.0\"},{\"lat\":\"47.0670857\",\"lng\":\"9.9162766\",\"z\":\"679.0\"},{\"lat\":\"47.0670821\",\"lng\":\"9.9164252\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.067105\",\"lng\":\"9.9165837\",\"z\":\"679.0\"},{\"lat\":\"47.0671376\",\"lng\":\"9.9167838\",\"z\":\"679.0\"},{\"lat\":\"47.0671371\",\"lng\":\"9.9169407\",\"z\":\"678.0\"},{\"lat\":\"47.0671313\",\"lng\":\"9.9170487\",\"z\":\"679.0\"},{\"lat\":\"47.0671044\",\"lng\":\"9.9172039\",\"z\":\"679.0\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.067080032512564\",\"lng\":\"9.917257225583455\",\"z\":\"679.0195507775959\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06704897411129\",\"lng\":\"9.917308187554454\",\"z\":\"679.0838148414002\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.06700147299139\",\"lng\":\"9.91731891639003\",\"z\":\"679.1463182975306\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066955798797466\",\"lng\":\"9.917313551972768\",\"z\":\"679.198540919308\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.066906470624644\",\"lng\":\"9.91727868325549\",\"z\":\"679.2058820588163\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06688089303566\",\"lng\":\"9.917225039074793\",\"z\":\"679.165978351958\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.06687798407748\",\"lng\":\"9.917163022729454\",\"z\":\"679.2161412421182\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.0669234\",\"lng\":\"9.9168289\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.066999\",\"lng\":\"9.9166654\",\"z\":\"679.0\"},{\"lat\":\"47.0671938\",\"lng\":\"9.9164739\",\"z\":\"678.0\"},{\"lat\":\"47.0672649\",\"lng\":\"9.9163341\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673158\",\"lng\":\"9.9162005\",\"z\":\"678.0\"},{\"lat\":\"47.0673338\",\"lng\":\"9.9160605\",\"z\":\"678.0\"}]', ',99423,99424,', 'a:2:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}');

SELECT
  *
FROM
  object_brick_store_Address_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Address_vcloud_poi WHERE id = 4002 AND fieldname = 'address';

SHOW COLUMNS
FROM
  object_collection_vcloudContentblock_localized_vcloud_ccskirun

SHOW COLUMNS FROM object_collection_vcloudContentblock_localized_vcloud_ccskirun;

SELECT
  id,
  targetType,
  targetId
FROM
  dependencies
WHERE
  sourceType = ?
  AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 14016;

SELECT
  *
FROM
  object_relations_vcloud_skiresort
WHERE
  dest_id = ?
  AND fieldname = ?
  AND ownertype = 'object'

SELECT * FROM object_relations_vcloud_skiresort WHERE dest_id = 14016 AND fieldname = 'slopes' AND ownertype = 'object';

DELETE FROM
  object_relations_vcloud_ccskirun
WHERE
  src_id = '14016'
  AND ownertype = 'localizedfield'
  AND ownername LIKE '/fieldcollection~contentblocks/3/%'

DELETE FROM object_relations_vcloud_ccskirun WHERE src_id = '14016' AND ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~contentblocks/3/%';

SELECT
  `id`
FROM
  `object_collection_vcloudContentblock_vcloud_ccskirun`
WHERE
  `id` = '14016'
  AND `fieldname` = 'contentblocks'
LIMIT
  1

SELECT `id` FROM `object_collection_vcloudContentblock_vcloud_ccskirun` WHERE `id` = '14016' AND `fieldname` = 'contentblocks' LIMIT 1;

DELETE FROM
  object_relations_vcloud_ccskirun
WHERE
  src_id = '14016'
  AND ownertype = 'localizedfield'
  AND ownername LIKE '/fieldcollection~contentblocks/1/%'

DELETE FROM object_relations_vcloud_ccskirun WHERE src_id = '14016' AND ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~contentblocks/1/%';

SHOW COLUMNS
FROM
  object_query_vcloud_ccskirun

SHOW COLUMNS FROM object_query_vcloud_ccskirun;

SELECT
  *
FROM
  object_query_vcloud_ccskirun
WHERE
  oo_id = ?

SELECT * FROM object_query_vcloud_ccskirun WHERE oo_id = 14016;

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SHOW COLUMNS
FROM
  object_localized_query_vcloud_ccskirun_de

SHOW COLUMNS FROM object_localized_query_vcloud_ccskirun_de;

DELETE FROM
  object_relations_vcloud_ccskirun
WHERE
  src_id = '14016'
  AND ownertype = 'localizedfield'
  AND ownername LIKE '/fieldcollection~contentblocks/2/%'

DELETE FROM object_relations_vcloud_ccskirun WHERE src_id = '14016' AND ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~contentblocks/2/%';

SELECT
  `id`
FROM
  `object_collection_vcloudExternalLink_vcloud_ccskirun`
WHERE
  `id` = '14016'
  AND `fieldname` = 'externalLinks'
LIMIT
  1

SELECT `id` FROM `object_collection_vcloudExternalLink_vcloud_ccskirun` WHERE `id` = '14016' AND `fieldname` = 'externalLinks' LIMIT 1;

SHOW COLUMNS
FROM
  object_localized_data_vcloud_ccskirun

SHOW COLUMNS FROM object_localized_data_vcloud_ccskirun;

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SHOW COLUMNS
FROM
  object_localized_query_vcloud_ccskirun_fr

SHOW COLUMNS FROM object_localized_query_vcloud_ccskirun_fr;

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_ccskirun
where
  language = 'fr'
  and ooo_id = 14016
  and fieldname = 'contentblocks'
  and `index` = 1

select `links` from object_collection_vcloudContentblock_localized_vcloud_ccskirun where language = 'fr' and  ooo_id  = 14016 and fieldname = 'contentblocks' and `index` =  1;

SHOW COLUMNS
FROM
  object_localized_query_vcloud_ccskirun_nl

SHOW COLUMNS FROM object_localized_query_vcloud_ccskirun_nl;

SHOW COLUMNS
FROM
  object_localized_query_vcloud_ccskirun_en

SHOW COLUMNS FROM object_localized_query_vcloud_ccskirun_en;

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 0;

SHOW COLUMNS
FROM
  object_store_vcloud_ccskirun

SHOW COLUMNS FROM object_store_vcloud_ccskirun;