2024-10-04 21:01:44.664 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302539/16556799067002090568945.44469248_74e9bfd4f5_1268.webp-original.jpg?1728061584' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:44.909 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302539', @p2=NULL, @p3=NULL, @p4='30883110', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:45.134 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302539/2025710640670020907a08a1.10617662_ffaf112721_1275.webp-original.jpg?1728061584' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:45.358 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302539', @p2=NULL, @p3=NULL, @p4='30883111', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:45.585 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:45.808 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479989', @p2='25.02588' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:46.035 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:46.247 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479990', @p2='36.97613' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:46.468 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:46.696 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479991', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:46.697 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302539'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:01:46.937 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479925'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:47.163 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479926'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:47.441 +00:00 [INF] Executed DbCommand (44ms) [Parameters=[@p0='479927'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:47.444 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302539'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:01:47.659 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204210'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:47.877 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204211'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:48.096 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204212'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:48.315 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:48.541 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='479992', @p2='Νεόδμητο Διαμέρισμα 45τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:48.760 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 45τ.μ. στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Διαθέτει ιδιωτική πισίνα διαστάσεων 2x7 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 119 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:01:48.982 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:49.209 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='479993', @p2='Newly built Apartment 45 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:49.435 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 45 sq.m. apartment for sale. in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. It has a private swimming pool measuring 2x7 meters, while the total area of ​​the property is 119 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:01:49.655 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:01:49.881 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479994', @p2='Appartement nouvellement construit 45 m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:50.100 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302539', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 45 m² à vendre. à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Elle dispose d'une piscine privée mesurant 2x7 mètres, tandis que la superficie totale de la propriété est de 119 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:01:50.126 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='8', @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`id`, `s`.`LanguageID`, `s`.`name`, `s`.`StateID`
FROM `statelanguage` AS `s`
WHERE (`s`.`StateID` = @__ToUInt64_0) AND (`s`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:01:50.127 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToLower_0='south aegean' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`id`, `r`.`LanguageID`, `r`.`Name`, `r`.`RegionID`
FROM `regionlanguage` AS `r`
WHERE (TRIM(LOWER(`r`.`Name`)) = @__ToLower_0) AND (`r`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:01:50.129 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='adiparos' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`id`, `c`.`CityID`, `c`.`LanguageID`, `c`.`Name`
FROM `citylanguage` AS `c`
WHERE (TRIM(LOWER(`c`.`Name`)) = @__ToLower_0) AND (`c`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:01:50.358 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='85302528', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='50' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Adiparos' (Size = 255), @p8='30', @p9='1', @p10='20170', @p11='EUR' (Size = 5), @p12='False' (Nullable = true), @p13='False' (Nullable = true), @p14='2' (Nullable = true), @p15=NULL (Size = 255), @p16=NULL (Size = 255), @p17=NULL (DbType = Int32), @p18=NULL (Size = 255), @p19='0' (Size = 10), @p20='0' (Nullable = true), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25='50' (Nullable = true), @p26=NULL, @p27=NULL, @p28=NULL, @p29=NULL (Size = 255), @p30=NULL, @p31=NULL (Size = 255), @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34='0' (Nullable = true), @p35='0' (Nullable = true), @p36='315000' (Nullable = true), @p37='1', @p38='9917STAV' (Size = 255), @p39='58637' (Nullable = true), @p40='75408' (Nullable = true), @p41='4' (Nullable = true), @p42=NULL (DbType = Double), @p43='1' (Size = 255), @p44='8' (Nullable = true), @p45='1', @p46='17', @p47=NULL (DbType = Int32), @p48='2024-10-04T21:01:50.1297288+00:00' (Nullable = true) (DbType = DateTime), @p49='840 07' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
UPDATE `estate` SET `Address1` = @p0, `Address2` = @p1, `Area` = @p2, `Bathrooms` = @p3, `BlockPublication` = @p4, `Box` = @p5, `CanHaveChildren` = @p6, `City` = @p7, `CountryID` = @p8, `CrmClientID` = @p9, `CrmOfficeID` = @p10, `Currency` = @p11, `DisplayAddress` = @p12, `DisplayPrice` = @p13, `DisplayStatusID` = @p14, `EnergyClass` = @p15, `EnergyValue` = @p16, `EstateOrder` = @p17, `Evaluation` = @p18, `Floor` = @p19, `Fronts` = @p20, `Furnished` = @p21, `Garage` = @p22, `Garden` = @p23, `GardenArea` = @p24, `GroundArea` = @p25, `InvestmentEstate` = @p26, `IsTopParent` = @p27, `IsTypeEstate` = @p28, `Link3DModel` = @p29, `LinkRouteDesc` = @p30, `LinkVirtualVisit` = @p31, `Name` = @p32, `Number` = @p33, `ParentID` = @p34, `Parking` = @p35, `Price` = @p36, `PurposeStatusID` = @p37, `ReferenceNumber` = @p38, `RegionID` = @p39, `RepresentativeID` = @p40, `Rooms` = @p41, `SoldPrice` = @p42, `Stages` = @p43, `StateID` = @p44, `StatusID` = @p45, `SubCategoryID` = @p46, `Terrace` = @p47, `UpdateDateTime` = @p48, `Zip` = @p49
WHERE `EstateID` = @p50;
SELECT ROW_COUNT();
2024-10-04 21:01:50.359 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302528'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`id`, `e`.`DetailID`, `e`.`EstateID`, `e`.`Is3D`, `e`.`IsPlan`, `e`.`PictureID`, `e`.`UpdateDateTime`
FROM `estatepicture` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:01:50.601 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941394'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:50.603 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883018'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:50.833 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883018'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.042 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941395'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.044 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883019'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:51.272 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883019'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.488 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941396'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.490 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883020'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:51.717 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883020'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.943 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941397'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:51.945 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883021'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:52.169 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883021'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:52.393 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941398'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:52.396 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883022'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:52.621 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883022'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:52.845 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941399'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:52.847 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883023'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:53.077 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883023'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:53.296 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941400'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:53.298 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883024'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:53.512 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883024'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:53.736 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941401'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:53.753 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883025'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:53.957 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883025'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:54.176 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941402'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:54.179 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883026'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:54.401 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883026'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:54.641 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941403'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:54.643 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883027'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:54.850 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883027'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:55.081 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941404'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:55.083 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883028'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:01:55.312 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883028'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:01:55.518 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/47414515867001e9b51f570.39465723_ad92b1943e_1268.webp-original.jpg?1728061084' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:55.749 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883112', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:55.974 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='2' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/158245019167001e9fd48042.18855283_2222b959e5_1274.webp-original.jpg?1728061088' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:56.215 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883113', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:56.422 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='3' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/74947404767001ea63a2110.81558215_08cb4ce9e7_1267.webp-original.jpg?1728061095' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:56.654 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883114', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:56.859 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='4' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/162335344467001eab011d59.79894416_988f953691_1276.webp-original.jpg?1728061100' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:57.060 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883115', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:57.266 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='5' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/83291891167001eaf8359a1.69605394_bba3deb453_1274.webp-original.jpg?1728061104' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:57.486 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883116', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:57.705 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='6' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/19406215967001eb4914795.15089525_20e7965905_1271.webp-original.jpg?1728061109' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:57.925 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883117', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:58.139 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='7' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/30508740467001eb979da15.17872493_48769bbfe8_1277.webp-original.jpg?1728061114' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:58.362 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883118', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:58.569 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='8' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/3419207667001ebe634224.10543565_5b97d2bcc4_1272.webp-original.jpg?1728061119' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:58.791 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883119', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:59.007 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='9' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/147905543167001ec24618b6.64703886_735b6bae9b_1273.webp-original.jpg?1728061123' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:59.237 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883120', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:59.443 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/87011466367001ec71d7381.23162418_97d826ffa4_1268.webp-original.jpg?1728061128' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:01:59.645 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883121', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:01:59.856 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302528/29152778067001ecb0aa0a5.51138595_b11a298131_1275.webp-original.jpg?1728061131' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:00.079 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302528', @p2=NULL, @p3=NULL, @p4='30883122', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:00.294 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:00.515 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479995', @p2='25.02588' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:00.718 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:00.937 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479996', @p2='36.97613' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:01.146 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:01.360 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='479997', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:01.361 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302528'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:02:01.565 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479931'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:01.790 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479932'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:02.004 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479933'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:02.005 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302528'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:02.220 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204213'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:02.428 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204214'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:02.651 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204215'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:02.862 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:03.091 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='479998', @p2='Νεόδμητο Διαμέρισμα 50τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:03.341 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 50τ.μ. στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Διαθέτει ιδιωτική πισίνα διαστάσεων 2x7 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 163 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:03.549 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:03.758 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='479999', @p2='Newly built Apartment 50 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:03.968 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 50 sq.m. apartment for sale. in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. It has a private swimming pool measuring 2x7 meters, while the total area of ​​the property is 163 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:04.213 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='85302528', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:04.429 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480000', @p2='Appartement nouvellement construit 50 m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:04.646 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302528', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 50 m² à vendre. à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Elle dispose d'une piscine privée mesurant 2x7 mètres, tandis que la superficie totale de la propriété est de 163 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:04.772 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='8', @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`id`, `s`.`LanguageID`, `s`.`name`, `s`.`StateID`
FROM `statelanguage` AS `s`
WHERE (`s`.`StateID` = @__ToUInt64_0) AND (`s`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:04.774 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='south aegean' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`id`, `r`.`LanguageID`, `r`.`Name`, `r`.`RegionID`
FROM `regionlanguage` AS `r`
WHERE (TRIM(LOWER(`r`.`Name`)) = @__ToLower_0) AND (`r`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:04.775 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='adiparos' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`id`, `c`.`CityID`, `c`.`LanguageID`, `c`.`Name`
FROM `citylanguage` AS `c`
WHERE (TRIM(LOWER(`c`.`Name`)) = @__ToLower_0) AND (`c`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:05.005 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='85302545', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='51' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Adiparos' (Size = 255), @p8='30', @p9='1', @p10='20170', @p11='EUR' (Size = 5), @p12='False' (Nullable = true), @p13='False' (Nullable = true), @p14='2' (Nullable = true), @p15=NULL (Size = 255), @p16=NULL (Size = 255), @p17=NULL (DbType = Int32), @p18=NULL (Size = 255), @p19='0' (Size = 10), @p20='0' (Nullable = true), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25='51' (Nullable = true), @p26=NULL, @p27=NULL, @p28=NULL, @p29=NULL (Size = 255), @p30=NULL, @p31=NULL (Size = 255), @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34='0' (Nullable = true), @p35='0' (Nullable = true), @p36='315000' (Nullable = true), @p37='1', @p38='9919STAV' (Size = 255), @p39='58637' (Nullable = true), @p40='75408' (Nullable = true), @p41='4' (Nullable = true), @p42=NULL (DbType = Double), @p43='2' (Size = 255), @p44='8' (Nullable = true), @p45='1', @p46='18', @p47=NULL (DbType = Int32), @p48='2024-10-04T21:02:04.7761089+00:00' (Nullable = true) (DbType = DateTime), @p49='840 07' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
UPDATE `estate` SET `Address1` = @p0, `Address2` = @p1, `Area` = @p2, `Bathrooms` = @p3, `BlockPublication` = @p4, `Box` = @p5, `CanHaveChildren` = @p6, `City` = @p7, `CountryID` = @p8, `CrmClientID` = @p9, `CrmOfficeID` = @p10, `Currency` = @p11, `DisplayAddress` = @p12, `DisplayPrice` = @p13, `DisplayStatusID` = @p14, `EnergyClass` = @p15, `EnergyValue` = @p16, `EstateOrder` = @p17, `Evaluation` = @p18, `Floor` = @p19, `Fronts` = @p20, `Furnished` = @p21, `Garage` = @p22, `Garden` = @p23, `GardenArea` = @p24, `GroundArea` = @p25, `InvestmentEstate` = @p26, `IsTopParent` = @p27, `IsTypeEstate` = @p28, `Link3DModel` = @p29, `LinkRouteDesc` = @p30, `LinkVirtualVisit` = @p31, `Name` = @p32, `Number` = @p33, `ParentID` = @p34, `Parking` = @p35, `Price` = @p36, `PurposeStatusID` = @p37, `ReferenceNumber` = @p38, `RegionID` = @p39, `RepresentativeID` = @p40, `Rooms` = @p41, `SoldPrice` = @p42, `Stages` = @p43, `StateID` = @p44, `StatusID` = @p45, `SubCategoryID` = @p46, `Terrace` = @p47, `UpdateDateTime` = @p48, `Zip` = @p49
WHERE `EstateID` = @p50;
SELECT ROW_COUNT();
2024-10-04 21:02:05.006 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302545'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`id`, `e`.`DetailID`, `e`.`EstateID`, `e`.`Is3D`, `e`.`IsPlan`, `e`.`PictureID`, `e`.`UpdateDateTime`
FROM `estatepicture` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:05.230 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941405'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:05.231 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883029'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:05.462 +00:00 [INF] Executed DbCommand (11ms) [Parameters=[@p0='30883029'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:05.679 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941406'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:05.682 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883030'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:05.898 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883030'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.107 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941407'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.109 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883031'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:06.298 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883031'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.507 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941408'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.508 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883032'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:06.715 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883032'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.933 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941409'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:06.935 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883033'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:07.148 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883033'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:07.350 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941410'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:07.352 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883034'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:07.573 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883034'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:07.786 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941411'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:07.788 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883035'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:08.005 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883035'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:08.229 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941412'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:08.231 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883036'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:08.444 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883036'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:08.657 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941413'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:08.659 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883037'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:08.881 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883037'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:09.095 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941414'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:09.097 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883038'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:09.340 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883038'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:09.578 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941415'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:09.580 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883039'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:09.791 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883039'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:10.021 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/4230277446700231f461ec2.48288541_b8d61db27e_1268.webp-original.jpg?1728062240' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:10.248 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883123', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:10.468 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='2' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/40714510367002323db32a5.08781513_75ca2358c6_1274.webp-original.jpg?1728062244' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:10.687 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883124', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:10.902 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='3' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/14049518386700232a1241d8.92391502_d8c1e81ef8_1267.webp-original.jpg?1728062251' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:11.132 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883125', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:11.357 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='4' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/17214381546700232ee50aa5.16245734_51dfa9234d_1276.webp-original.jpg?1728062255' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:11.595 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883126', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:11.822 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='5' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/1040603045670023337043c6.68563879_bb08760166_1274.webp-original.jpg?1728062260' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:12.044 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883127', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:12.260 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='6' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/185484523567002337ee7e42.33354391_8c83e01577_1271.webp-original.jpg?1728062264' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:12.472 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883128', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:12.685 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='7' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/4784283536700233c11b7c9.66741478_25cc264e28_1277.webp-original.jpg?1728062269' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:12.890 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883129', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:13.131 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='8' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/30375054067002340d641b8.52999744_87f3164ba4_1272.webp-original.jpg?1728062273' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:13.364 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883130', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:13.597 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='9' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/13659044296700234544a0a7.34657023_2168c7de48_1273.webp-original.jpg?1728062278' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:13.829 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883131', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:14.064 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/1022327326700234ab58a00.36227012_e114810fa4_1268.webp-original.jpg?1728062283' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:14.263 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883132', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:14.477 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302545/17646529786700234f043363.51763828_181db78476_1275.webp-original.jpg?1728062287' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:14.705 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302545', @p2=NULL, @p3=NULL, @p4='30883133', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:14.929 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:15.139 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480001', @p2='25.02677' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:15.354 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:15.565 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480002', @p2='36.97927' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:15.770 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:16.011 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480003', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:16.012 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302545'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:02:16.220 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479937'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:16.449 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479938'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:16.684 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479939'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:16.685 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302545'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:16.897 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='204216'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:17.124 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204217'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:17.331 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204218'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:17.566 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:17.785 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='480004', @p2='Νεόδμητο Διώροφο Διαμέρισμα 51τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:18.003 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 51τ.μ. 2 επιπέδων στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Το ισόγειο έχει έκταση 26τμ και ο όροφος 24τμ.  Διαθέτει ιδιωτική πισίνα διαστάσεων 2x7 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 93 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:18.216 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:18.431 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='480005', @p2='Newly built two-storey apartment 51 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:18.650 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 51 sq.m. apartment for sale. 2 levels in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. The ground floor has an area of ​​26 sq m and the first floor 24 sq m. It has a private swimming pool measuring 2x7 meters, while the total area of ​​the property is 93 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:18.870 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:19.071 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480006', @p2='Appartement de deux étages nouvellement construit 51 m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:19.288 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302545', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 51 m² à vendre. 2 niveaux à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Le rez-de-chaussée a une superficie de 26 m² et le premier étage de 24 m². Elle dispose d'une piscine privée mesurant 2x7 mètres, tandis que la superficie totale de la propriété est de 93 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:19.355 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='8', @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`id`, `s`.`LanguageID`, `s`.`name`, `s`.`StateID`
FROM `statelanguage` AS `s`
WHERE (`s`.`StateID` = @__ToUInt64_0) AND (`s`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:19.357 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='south aegean' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`id`, `r`.`LanguageID`, `r`.`Name`, `r`.`RegionID`
FROM `regionlanguage` AS `r`
WHERE (TRIM(LOWER(`r`.`Name`)) = @__ToLower_0) AND (`r`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:19.359 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='adiparos' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`id`, `c`.`CityID`, `c`.`LanguageID`, `c`.`Name`
FROM `citylanguage` AS `c`
WHERE (TRIM(LOWER(`c`.`Name`)) = @__ToLower_0) AND (`c`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:19.603 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='85302555', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='57' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Adiparos' (Size = 255), @p8='30', @p9='1', @p10='20170', @p11='EUR' (Size = 5), @p12='False' (Nullable = true), @p13='False' (Nullable = true), @p14='2' (Nullable = true), @p15=NULL (Size = 255), @p16=NULL (Size = 255), @p17=NULL (DbType = Int32), @p18=NULL (Size = 255), @p19='0' (Size = 10), @p20='0' (Nullable = true), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25='57' (Nullable = true), @p26=NULL, @p27=NULL, @p28=NULL, @p29=NULL (Size = 255), @p30=NULL, @p31=NULL (Size = 255), @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34='0' (Nullable = true), @p35='0' (Nullable = true), @p36='360000' (Nullable = true), @p37='1', @p38='9920STAV' (Size = 255), @p39='58637' (Nullable = true), @p40='75408' (Nullable = true), @p41='4' (Nullable = true), @p42=NULL (DbType = Double), @p43='2' (Size = 255), @p44='8' (Nullable = true), @p45='1', @p46='18', @p47=NULL (DbType = Int32), @p48='2024-10-04T21:02:19.3597179+00:00' (Nullable = true) (DbType = DateTime), @p49='840 07' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
UPDATE `estate` SET `Address1` = @p0, `Address2` = @p1, `Area` = @p2, `Bathrooms` = @p3, `BlockPublication` = @p4, `Box` = @p5, `CanHaveChildren` = @p6, `City` = @p7, `CountryID` = @p8, `CrmClientID` = @p9, `CrmOfficeID` = @p10, `Currency` = @p11, `DisplayAddress` = @p12, `DisplayPrice` = @p13, `DisplayStatusID` = @p14, `EnergyClass` = @p15, `EnergyValue` = @p16, `EstateOrder` = @p17, `Evaluation` = @p18, `Floor` = @p19, `Fronts` = @p20, `Furnished` = @p21, `Garage` = @p22, `Garden` = @p23, `GardenArea` = @p24, `GroundArea` = @p25, `InvestmentEstate` = @p26, `IsTopParent` = @p27, `IsTypeEstate` = @p28, `Link3DModel` = @p29, `LinkRouteDesc` = @p30, `LinkVirtualVisit` = @p31, `Name` = @p32, `Number` = @p33, `ParentID` = @p34, `Parking` = @p35, `Price` = @p36, `PurposeStatusID` = @p37, `ReferenceNumber` = @p38, `RegionID` = @p39, `RepresentativeID` = @p40, `Rooms` = @p41, `SoldPrice` = @p42, `Stages` = @p43, `StateID` = @p44, `StatusID` = @p45, `SubCategoryID` = @p46, `Terrace` = @p47, `UpdateDateTime` = @p48, `Zip` = @p49
WHERE `EstateID` = @p50;
SELECT ROW_COUNT();
2024-10-04 21:02:19.605 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302555'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`id`, `e`.`DetailID`, `e`.`EstateID`, `e`.`Is3D`, `e`.`IsPlan`, `e`.`PictureID`, `e`.`UpdateDateTime`
FROM `estatepicture` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:19.830 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941416'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:19.832 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883040'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:20.055 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883040'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:20.296 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941417'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:20.298 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883041'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:20.506 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883041'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:20.716 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941418'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:20.718 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883042'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:20.938 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883042'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:21.151 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941419'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:21.153 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883043'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:21.360 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883043'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:21.595 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941420'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:21.597 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883044'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:21.832 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883044'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.047 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941421'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.050 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='30883045'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:22.265 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883045'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.482 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941422'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.484 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883046'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:22.707 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883046'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.930 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941423'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:22.932 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883047'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:23.143 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883047'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:23.374 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941424'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:23.376 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883048'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:23.578 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883048'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:23.788 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941425'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:23.790 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883049'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:23.991 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883049'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:24.187 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941426'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:24.189 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883050'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:24.429 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883050'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:24.634 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/849305279670025029e8a92.70395459_980c67ed09_1268.webp-original.jpg?1728062722' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:24.845 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883134', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:25.057 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='2' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/169490433867002502d5c684.58637168_246c53a5de_1274.webp-original.jpg?1728062722' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:25.274 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883135', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:25.493 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='3' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/12255629466700250306ed95.41817566_a87fff94a0_1267.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:25.721 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883136', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:25.945 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='4' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/2126869691670025032f0728.92154891_28a41430fc_1276.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:26.158 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883137', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:26.373 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='5' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/11931791246700250348a785.11208415_ed4b8574fd_1274.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:26.582 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883138', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:26.794 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='6' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/42396181767002503650527.47716167_b5de3bbf96_1271.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:27.010 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883139', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:27.214 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='7' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/1122291285670025037da561.54561140_1006d0b5ab_1277.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:27.423 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883140', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:27.625 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='8' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/5409515886700250398c572.85497193_936db980c4_1272.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:27.843 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883141', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:28.058 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='9' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/89769988667002503c4e944.93057340_a6a802c0c3_1273.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:28.273 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883142', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:28.496 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/54968617867002503e0a9a6.02365503_610f37e16e_1268.webp-original.jpg?1728062723' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:28.730 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883143', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:28.945 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302555/189179529767002504053873.89208832_57d803cc04_1275.webp-original.jpg?1728062724' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:29.184 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302555', @p2=NULL, @p3=NULL, @p4='30883144', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:29.402 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:29.613 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480007', @p2='25.02677' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:29.829 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:30.059 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480008', @p2='36.97927' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:30.299 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:30.524 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480009', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:30.525 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302555'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:02:30.743 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479943'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:30.952 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479944'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:31.168 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479945'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:31.169 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302555'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:31.384 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204219'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:31.606 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204220'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:31.828 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204221'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:32.049 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:32.256 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='480010', @p2='Νεόδμητο Διώροφο Διαμέρισμα 57τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:32.677 +00:00 [INF] Executed DbCommand (215ms) [Parameters=[@p0='85302555', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 57τ.μ. 2 επιπέδων στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Το ισόγειο έχει έκταση 35τμ και ο όροφος 21τμ.  Διαθέτει ιδιωτική πισίνα διαστάσεων 2x7 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 92 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:32.890 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:33.087 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='480011', @p2='Newly built two-storey apartment 57 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:33.306 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 57 sq.m. apartment for sale. 2 levels in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. The ground floor has an area of ​​35 square meters and the first floor 21 square meters. It has a private swimming pool measuring 2x7 meters, while the total area of ​​the property is 92 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:33.518 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:33.721 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480012', @p2='Appartement de deux étages nouvellement construit 57 m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:33.924 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302555', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 57 m² à vendre. 2 niveaux à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Le rez-de-chaussée a une superficie de 35 mètres carrés et le premier étage de 21 mètres carrés. Elle dispose d'une piscine privée mesurant 2x7 mètres, tandis que la superficie totale de la propriété est de 92 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:33.940 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__ToUInt64_0='8', @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`id`, `s`.`LanguageID`, `s`.`name`, `s`.`StateID`
FROM `statelanguage` AS `s`
WHERE (`s`.`StateID` = @__ToUInt64_0) AND (`s`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:33.942 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='south aegean' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`id`, `r`.`LanguageID`, `r`.`Name`, `r`.`RegionID`
FROM `regionlanguage` AS `r`
WHERE (TRIM(LOWER(`r`.`Name`)) = @__ToLower_0) AND (`r`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:33.944 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='adiparos' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`id`, `c`.`CityID`, `c`.`LanguageID`, `c`.`Name`
FROM `citylanguage` AS `c`
WHERE (TRIM(LOWER(`c`.`Name`)) = @__ToLower_0) AND (`c`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:34.150 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='85302557', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='52' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Adiparos' (Size = 255), @p8='30', @p9='1', @p10='20170', @p11='EUR' (Size = 5), @p12='False' (Nullable = true), @p13='False' (Nullable = true), @p14='2' (Nullable = true), @p15=NULL (Size = 255), @p16=NULL (Size = 255), @p17=NULL (DbType = Int32), @p18=NULL (Size = 255), @p19='0' (Size = 10), @p20='0' (Nullable = true), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25='52' (Nullable = true), @p26=NULL, @p27=NULL, @p28=NULL, @p29=NULL (Size = 255), @p30=NULL, @p31=NULL (Size = 255), @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34='0' (Nullable = true), @p35='0' (Nullable = true), @p36='325000' (Nullable = true), @p37='1', @p38='9921STAV' (Size = 255), @p39='58637' (Nullable = true), @p40='75408' (Nullable = true), @p41='4' (Nullable = true), @p42=NULL (DbType = Double), @p43='1' (Size = 255), @p44='8' (Nullable = true), @p45='1', @p46='17', @p47=NULL (DbType = Int32), @p48='2024-10-04T21:02:33.9448325+00:00' (Nullable = true) (DbType = DateTime), @p49='840 07' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
UPDATE `estate` SET `Address1` = @p0, `Address2` = @p1, `Area` = @p2, `Bathrooms` = @p3, `BlockPublication` = @p4, `Box` = @p5, `CanHaveChildren` = @p6, `City` = @p7, `CountryID` = @p8, `CrmClientID` = @p9, `CrmOfficeID` = @p10, `Currency` = @p11, `DisplayAddress` = @p12, `DisplayPrice` = @p13, `DisplayStatusID` = @p14, `EnergyClass` = @p15, `EnergyValue` = @p16, `EstateOrder` = @p17, `Evaluation` = @p18, `Floor` = @p19, `Fronts` = @p20, `Furnished` = @p21, `Garage` = @p22, `Garden` = @p23, `GardenArea` = @p24, `GroundArea` = @p25, `InvestmentEstate` = @p26, `IsTopParent` = @p27, `IsTypeEstate` = @p28, `Link3DModel` = @p29, `LinkRouteDesc` = @p30, `LinkVirtualVisit` = @p31, `Name` = @p32, `Number` = @p33, `ParentID` = @p34, `Parking` = @p35, `Price` = @p36, `PurposeStatusID` = @p37, `ReferenceNumber` = @p38, `RegionID` = @p39, `RepresentativeID` = @p40, `Rooms` = @p41, `SoldPrice` = @p42, `Stages` = @p43, `StateID` = @p44, `StatusID` = @p45, `SubCategoryID` = @p46, `Terrace` = @p47, `UpdateDateTime` = @p48, `Zip` = @p49
WHERE `EstateID` = @p50;
SELECT ROW_COUNT();
2024-10-04 21:02:34.151 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302557'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`id`, `e`.`DetailID`, `e`.`EstateID`, `e`.`Is3D`, `e`.`IsPlan`, `e`.`PictureID`, `e`.`UpdateDateTime`
FROM `estatepicture` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:34.357 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941427'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:34.359 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883051'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:34.566 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883051'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:34.769 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941428'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:34.771 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883052'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:34.972 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883052'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.163 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941429'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.165 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883053'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:35.365 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883053'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.566 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941430'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.567 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883054'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:35.772 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883054'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.988 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941431'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:35.993 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883055'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:36.201 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883055'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:36.416 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941432'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:36.418 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883056'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:36.628 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883056'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:36.830 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941433'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:36.832 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883057'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:37.028 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883057'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:37.231 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941434'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:37.232 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883058'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:37.436 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883058'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:37.655 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941435'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:37.657 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883059'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:37.870 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883059'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:38.070 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941436'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:38.071 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883060'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:38.277 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883060'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:38.474 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941437'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:38.475 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883061'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:38.687 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883061'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:38.900 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/169043556167002657737680.63215809_7c4157c199_1268.webp-original.jpg?1728063063' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:39.103 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883145', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:39.312 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='2' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/202255464267002657bca3e0.95396532_c364647977_1274.webp-original.jpg?1728063063' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:39.520 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883146', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:39.719 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='3' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/135380433067002657ed16c7.06550692_b8d506a182_1267.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:39.920 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883147', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:40.118 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='4' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/91070109267002658171499.56447536_d144c4255e_1276.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:40.317 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883148', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:40.528 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='5' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/157243418670026583ff4d5.26903656_bd7b13f045_1274.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:40.749 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883149', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:40.957 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='6' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/104018250670026585ab7c2.59370724_3dd888740e_1271.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:41.159 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883150', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:41.381 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='7' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/1014557746670026587f1bc6.69970312_eebe467309_1277.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:41.602 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883151', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:41.804 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='8' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/1303615488670026589a3933.44375312_5f4131e379_1272.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:42.007 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883152', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:42.220 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='9' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/115486463567002658be08d6.33062918_29a992880d_1273.webp-original.jpg?1728063064' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:42.430 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883153', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:42.633 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/206623227367002658e255f9.39080704_b0b8b03f98_1268.webp-original.jpg?1728063065' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:42.849 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883154', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:43.052 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302557/175164455167002659147be3.44777734_b5e4729027_1275.webp-original.jpg?1728063065' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:43.263 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302557', @p2=NULL, @p3=NULL, @p4='30883155', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:43.465 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:43.670 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480013', @p2='25.02588' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:43.894 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:44.119 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480014', @p2='36.97613' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:44.325 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:44.549 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480015', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:44.551 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302557'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:02:44.760 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479949'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:44.970 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479950'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:45.178 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479951'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:45.179 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302557'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:45.392 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204222'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:45.610 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204223'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:45.810 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204224'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:46.010 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:46.230 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='480016', @p2='Νεόδμητο Διαμέρισμα 52τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:46.433 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='85302557', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 52τ.μ. στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Διαθέτει ιδιωτική πισίνα διαστάσεων 2x8 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 169 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:46.637 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:46.861 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='480017', @p2='Newly built Apartment 52 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:47.137 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 52 sq.m. apartment for sale. in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. It has a private swimming pool measuring 2x8 meters, while the total area of ​​the property amounts to 169 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:47.351 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:47.561 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480018', @p2='Appartement nouvellement construit 52m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:47.772 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302557', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 52 m² à vendre. à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Elle dispose d'une piscine privée mesurant 2x8 mètres, tandis que la superficie totale de la propriété s'élève à 169 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:02:47.831 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='8', @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`id`, `s`.`LanguageID`, `s`.`name`, `s`.`StateID`
FROM `statelanguage` AS `s`
WHERE (`s`.`StateID` = @__ToUInt64_0) AND (`s`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:47.833 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='south aegean' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`id`, `r`.`LanguageID`, `r`.`Name`, `r`.`RegionID`
FROM `regionlanguage` AS `r`
WHERE (TRIM(LOWER(`r`.`Name`)) = @__ToLower_0) AND (`r`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:47.835 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='adiparos' (Size = 4000), @__languageCode_1='fr-BE' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`id`, `c`.`CityID`, `c`.`LanguageID`, `c`.`Name`
FROM `citylanguage` AS `c`
WHERE (TRIM(LOWER(`c`.`Name`)) = @__ToLower_0) AND (`c`.`LanguageID` = @__languageCode_1)
LIMIT 2
2024-10-04 21:02:48.044 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='85302558', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='68' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Adiparos' (Size = 255), @p8='30', @p9='1', @p10='20170', @p11='EUR' (Size = 5), @p12='False' (Nullable = true), @p13='False' (Nullable = true), @p14='2' (Nullable = true), @p15=NULL (Size = 255), @p16=NULL (Size = 255), @p17=NULL (DbType = Int32), @p18=NULL (Size = 255), @p19='0' (Size = 10), @p20='0' (Nullable = true), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25='68' (Nullable = true), @p26=NULL, @p27=NULL, @p28=NULL, @p29=NULL (Size = 255), @p30=NULL, @p31=NULL (Size = 255), @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34='0' (Nullable = true), @p35='0' (Nullable = true), @p36='420000' (Nullable = true), @p37='1', @p38='9922STAV' (Size = 255), @p39='58637' (Nullable = true), @p40='75408' (Nullable = true), @p41='6' (Nullable = true), @p42=NULL (DbType = Double), @p43='1' (Size = 255), @p44='8' (Nullable = true), @p45='1', @p46='17', @p47=NULL (DbType = Int32), @p48='2024-10-04T21:02:47.8356082+00:00' (Nullable = true) (DbType = DateTime), @p49='840 07' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
UPDATE `estate` SET `Address1` = @p0, `Address2` = @p1, `Area` = @p2, `Bathrooms` = @p3, `BlockPublication` = @p4, `Box` = @p5, `CanHaveChildren` = @p6, `City` = @p7, `CountryID` = @p8, `CrmClientID` = @p9, `CrmOfficeID` = @p10, `Currency` = @p11, `DisplayAddress` = @p12, `DisplayPrice` = @p13, `DisplayStatusID` = @p14, `EnergyClass` = @p15, `EnergyValue` = @p16, `EstateOrder` = @p17, `Evaluation` = @p18, `Floor` = @p19, `Fronts` = @p20, `Furnished` = @p21, `Garage` = @p22, `Garden` = @p23, `GardenArea` = @p24, `GroundArea` = @p25, `InvestmentEstate` = @p26, `IsTopParent` = @p27, `IsTypeEstate` = @p28, `Link3DModel` = @p29, `LinkRouteDesc` = @p30, `LinkVirtualVisit` = @p31, `Name` = @p32, `Number` = @p33, `ParentID` = @p34, `Parking` = @p35, `Price` = @p36, `PurposeStatusID` = @p37, `ReferenceNumber` = @p38, `RegionID` = @p39, `RepresentativeID` = @p40, `Rooms` = @p41, `SoldPrice` = @p42, `Stages` = @p43, `StateID` = @p44, `StatusID` = @p45, `SubCategoryID` = @p46, `Terrace` = @p47, `UpdateDateTime` = @p48, `Zip` = @p49
WHERE `EstateID` = @p50;
SELECT ROW_COUNT();
2024-10-04 21:02:48.045 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302558'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`id`, `e`.`DetailID`, `e`.`EstateID`, `e`.`Is3D`, `e`.`IsPlan`, `e`.`PictureID`, `e`.`UpdateDateTime`
FROM `estatepicture` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:48.251 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941438'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:48.253 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883062'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:48.463 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883062'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:48.679 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941439'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:48.680 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883063'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:48.883 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883063'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.084 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941440'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.086 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883064'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:49.299 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883064'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.501 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941441'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.503 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883065'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:49.715 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='30883065'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.915 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941442'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:49.917 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883066'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:50.129 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883066'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:50.333 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941443'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:50.336 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883067'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:50.524 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883067'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:50.743 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941444'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:50.745 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883068'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:50.962 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883068'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:51.186 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941445'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:51.188 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30883069'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:51.382 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883069'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:51.583 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941446'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:51.588 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883070'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:51.804 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883070'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:52.010 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='941447'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:52.013 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883071'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:52.219 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883071'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:52.438 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='941448'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:52.440 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30883072'], CommandType='"Text"', CommandTimeout='30']
SELECT `p`.`PictureID`, `p`.`CrmOfficeID`, `p`.`MaxResolution`, `p`.`Order`, `p`.`Orientation`, `p`.`Size`, `p`.`Url`
FROM `picture` AS `p`
WHERE `p`.`PictureID` = @__p_0
LIMIT 1
2024-10-04 21:02:52.646 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30883072'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:52.853 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/210159103670027ab3ebbb1.62443173_4d32dca3a6_1268.webp-original.jpg?1728063403' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:53.053 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883156', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:53.263 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='2' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/696066884670027ab88c265.63081535_a416219620_1274.webp-original.jpg?1728063403' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:53.480 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883157', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:53.692 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='3' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/165440000670027abaabe65.94569764_6ac436e395_1267.webp-original.jpg?1728063403' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:53.892 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883158', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:54.094 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='4' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/177338828670027abd3d771.07146927_86d337bac6_1276.webp-original.jpg?1728063403' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:54.335 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883159', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:54.553 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='5' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/447321802670027ac083406.80101945_a387f88033_1274.webp-original.jpg?1728063404' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:54.763 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883160', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:54.969 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='6' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/179960719670027ac2910f5.29873181_55631f7b3b_1271.webp-original.jpg?1728063404' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:55.183 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883161', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:55.395 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='7' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/350719790670027ac72da52.93597978_7be24e483b_1277.webp-original.jpg?1728063404' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:55.593 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883162', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:55.813 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='8' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/1139486827670027ac9f2f52.84977004_af7eeaa45c_1272.webp-original.jpg?1728063404' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:56.013 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883163', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:56.217 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='9' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/1153814481670027acc201a4.61235609_8501aedf87_1273.webp-original.jpg?1728063404' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:56.430 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883164', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:56.626 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='10' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/293806561670027aceca2e7.90860605_5bee197276_1268.webp-original.jpg?1728063405' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:56.842 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883165', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:57.052 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='11' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://media.apimo.pro/picture/85303/85302558/18537322670027ad2d92e0.99479897_3aab137e53_1275.webp-original.jpg?1728063405' (Nullable = false) (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `picture` (`CrmOfficeID`, `MaxResolution`, `Order`, `Orientation`, `Size`, `Url`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `PictureID`
FROM `picture`
WHERE ROW_COUNT() = 1 AND `PictureID` = LAST_INSERT_ID();
2024-10-04 21:02:57.253 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='85302558', @p2=NULL, @p3=NULL, @p4='30883166', @p5=NULL (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatepicture` (`DetailID`, `EstateID`, `Is3D`, `IsPlan`, `PictureID`, `UpdateDateTime`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5);
SELECT `id`
FROM `estatepicture`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:57.462 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='99'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:57.671 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480019', @p2='25.02588' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:57.889 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='100'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:58.091 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480020', @p2='36.97613' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:58.298 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='85302558', @p1='1'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:02:58.498 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480021', @p2='2026' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:02:58.499 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='85302558'], CommandType='"Text"', CommandTimeout='30']
SELECT `s`.`SubDetailValueID`, `s`.`EstateID`, `s`.`SubDetailID`
FROM `subdetailvalue` AS `s`
WHERE (`s`.`SubDetailID` = 107) AND (`s`.`EstateID` = @__estate_EstateId_0)
2024-10-04 21:02:58.702 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479955'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:58.914 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479956'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:59.116 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='479957'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:59.117 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='85302558'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateLanguageID`, `e`.`EstateID`, `e`.`LanguageID`, `e`.`PublicationText`, `e`.`ShortDescription`, `e`.`Sms`
FROM `estatedescription` AS `e`
WHERE `e`.`EstateID` = @__estate_EstateId_0
2024-10-04 21:02:59.319 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204225'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:59.531 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204226'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:59.738 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='204227'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2024-10-04 21:02:59.937 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='85302558', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:03:00.140 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='480022', @p2='Νεόδμητο Διαμέρισμα 68τ.μ. με Ιδιωτική Πισίνα και Κήπο στην Αντίπαρο' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:03:00.342 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται νεόδμητο διαμέρισμα 68τ.μ. στην Αντίπαρο, με μεγάλο ιδιωτικό κήπο, το οποίο αποτελεί μέρος ενός νέου πολυτελούς πρότζεκτ. Το διαμέρισμα προσφέρει υψηλής ποιότητας ανέσεις και μοντέρνο σχεδιασμό, ιδανικό για όσους επιθυμούν μια άνετη και χαλαρωτική διαμονή. Αποτελείται από ένα υπνοδωμάτιο, σαλόνι, κουζίνα και μπάνιο, ενώ προσφέρει μοναδική θέα και βρίσκεται σε κοντινή απόσταση από την παραλία. Διαθέτει ιδιωτική πισίνα διαστάσεων 2x7 μέτρα, ενώ η συνολική έκταση του ακινήτου ανέρχεται στα 222 τ.μ., προσφέροντας άφθονο χώρο για χαλάρωση και απόλαυση της φυσικής ομορφιάς του νησιού.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:03:00.557 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:03:00.759 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='480023', @p2='Newly built Apartment 68 sq.m. with Private Pool and Garden in Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:03:00.959 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Newly built 68 sq.m. apartment for sale. in Antiparos, with a large private garden, which is part of a new luxury project. The apartment offers high quality amenities and modern design, ideal for those who want a comfortable and relaxing stay. It consists of a bedroom, living room, kitchen and bathroom, while it offers a unique view and is located close to the beach. It has a private swimming pool measuring 2x7 meters, while the total area of ​​the property is 222 sq.m., offering plenty of space to relax and enjoy the natural beauty of the island.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:03:01.165 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='85302558', @p1='107'], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvalue` (`EstateID`, `SubDetailID`)
VALUES (@p0, @p1);
SELECT `SubDetailValueID`
FROM `subdetailvalue`
WHERE ROW_COUNT() = 1 AND `SubDetailValueID` = LAST_INSERT_ID();
2024-10-04 21:03:01.374 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='480024', @p2='Appartement nouvellement construit 68m². avec piscine privée et jardin à Antiparos' (Size = 1000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `subdetailvaluelanguage` (`LanguageID`, `SubDetailValueID`, `TextValue`)
VALUES (@p0, @p1, @p2);
SELECT `id`
FROM `subdetailvaluelanguage`
WHERE ROW_COUNT() = 1 AND `id` = LAST_INSERT_ID();
2024-10-04 21:03:01.591 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='85302558', @p1='fr-BE' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Appartement nouvellement construit de 68 m² à vendre. à Antiparos, avec un grand jardin privé, qui fait partie d'un nouveau projet de luxe. L'appartement offre des équipements de haute qualité et un design moderne, idéal pour ceux qui souhaitent passer un séjour confortable et relaxant. Il se compose d'une chambre, d'un salon, d'une cuisine et d'une salle de bain, tout en offrant une vue unique et situé à proximité de la plage. Elle dispose d'une piscine privée mesurant 2x7 mètres, tandis que la superficie totale de la propriété est de 222 m², offrant beaucoup d'espace pour se détendre et profiter de la beauté naturelle de l'île.' (Size = 4000), @p4=NULL (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estatedescription` (`EstateID`, `LanguageID`, `PublicationText`, `ShortDescription`, `Sms`)
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT `EstateLanguageID`
FROM `estatedescription`
WHERE ROW_COUNT() = 1 AND `EstateLanguageID` = LAST_INSERT_ID();
2024-10-04 21:03:01.630 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateID`, `e`.`Address1`, `e`.`Address2`, `e`.`Area`, `e`.`Bathrooms`, `e`.`BlockPublication`, `e`.`Box`, `e`.`CanHaveChildren`, `e`.`City`, `e`.`CountryID`, `e`.`CrmClientID`, `e`.`CrmOfficeID`, `e`.`Currency`, `e`.`DisplayAddress`, `e`.`DisplayPrice`, `e`.`DisplayStatusID`, `e`.`EnergyClass`, `e`.`EnergyValue`, `e`.`EstateOrder`, `e`.`Evaluation`, `e`.`Floor`, `e`.`Fronts`, `e`.`Furnished`, `e`.`Garage`, `e`.`Garden`, `e`.`GardenArea`, `e`.`GroundArea`, `e`.`InvestmentEstate`, `e`.`IsTopParent`, `e`.`IsTypeEstate`, `e`.`Link3DModel`, `e`.`LinkRouteDesc`, `e`.`LinkVirtualVisit`, `e`.`Name`, `e`.`Number`, `e`.`ParentID`, `e`.`Parking`, `e`.`Price`, `e`.`PurposeStatusID`, `e`.`ReferenceNumber`, `e`.`RegionID`, `e`.`RepresentativeID`, `e`.`Rooms`, `e`.`SoldPrice`, `e`.`Stages`, `e`.`StateID`, `e`.`StatusID`, `e`.`SubCategoryID`, `e`.`Terrace`, `e`.`UpdateDateTime`, `e`.`Zip`
FROM `estate` AS `e`
INNER JOIN `crmoffice` AS `c` ON `e`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-04 21:03:01.638 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`RepresentativeID`, `r`.`CrmOfficeID`, `r`.`Directline`, `r`.`Email`, `r`.`First_name`, `r`.`Last_name`, `r`.`PictureID`, `r`.`StatusID`, `r`.`UpdateDateTime`
FROM `representatives` AS `r`
INNER JOIN `crmoffice` AS `c` ON `r`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-04 21:03:04.221 +00:00 [INF] Get  76 properties for  AgencyID 20242 from APIMO
2024-10-04 21:03:04.221 +00:00 [INF] New Properties :  17 properties for  AgencyID 20242 from APIMO
2024-10-04 21:03:04.221 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2024-10-04 21:03:04.221 +00:00 [INF] Properties for delete:  0 properties
2024-10-04 21:03:04.222 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2024-10-04 21:03:04.222 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 182776.4378ms
2024-10-04 21:03:04.222 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2024-10-04 21:03:04.225 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 182781.4240ms
2024-10-05 00:00:01.369 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0
2024-10-05 00:00:01.371 +00:00 [INF] Executing endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2024-10-05 00:00:01.371 +00:00 [INF] Route matched with {action = "CreateEstatesFromApimo", controller = "ApiWork"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] CreateEstatesFromApimo() on controller VITEXPORT.Controllers.ApiWorkController (VITEXPORT).
2024-10-05 00:00:01.371 +00:00 [INF] Entity Framework Core 5.0.11 initialized 'VitexportContext' using provider 'Pomelo.EntityFrameworkCore.MySql' with options: SensitiveDataLoggingEnabled DetailedErrorsEnabled ServerVersion 8.0.27-mysql 
2024-10-05 00:00:01.388 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CrmOfficeID`, `c`.`Address1`, `c`.`Address2`, `c`.`Box`, `c`.`City`, `c`.`CompleteSync`, `c`.`CountryID`, `c`.`CrmClientID`, `c`.`CrmID`, `c`.`Email`, `c`.`Fax`, `c`.`LicenceNumber`, `c`.`Mobile`, `c`.`Name`, `c`.`Number`, `c`.`ProfessionalInsurance`, `c`.`Status`, `c`.`StatusID`, `c`.`Telephone`, `c`.`UpdateDateTime`, `c`.`VAT`, `c`.`Website`, `c`.`Zip`
FROM `crmoffice` AS `c`
2024-10-05 00:00:01.787 +00:00 [INF] Get  2 Agencies from APIMO 
2024-10-05 00:00:01.790 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToUInt64_0='30'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2024-10-05 00:00:01.794 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToUInt64_0='1'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2024-10-05 00:00:01.798 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__id_0='20170'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateID`, `e`.`Address1`, `e`.`Address2`, `e`.`Area`, `e`.`Bathrooms`, `e`.`BlockPublication`, `e`.`Box`, `e`.`CanHaveChildren`, `e`.`City`, `e`.`CountryID`, `e`.`CrmClientID`, `e`.`CrmOfficeID`, `e`.`Currency`, `e`.`DisplayAddress`, `e`.`DisplayPrice`, `e`.`DisplayStatusID`, `e`.`EnergyClass`, `e`.`EnergyValue`, `e`.`EstateOrder`, `e`.`Evaluation`, `e`.`Floor`, `e`.`Fronts`, `e`.`Furnished`, `e`.`Garage`, `e`.`Garden`, `e`.`GardenArea`, `e`.`GroundArea`, `e`.`InvestmentEstate`, `e`.`IsTopParent`, `e`.`IsTypeEstate`, `e`.`Link3DModel`, `e`.`LinkRouteDesc`, `e`.`LinkVirtualVisit`, `e`.`Name`, `e`.`Number`, `e`.`ParentID`, `e`.`Parking`, `e`.`Price`, `e`.`PurposeStatusID`, `e`.`ReferenceNumber`, `e`.`RegionID`, `e`.`RepresentativeID`, `e`.`Rooms`, `e`.`SoldPrice`, `e`.`Stages`, `e`.`StateID`, `e`.`StatusID`, `e`.`SubCategoryID`, `e`.`Terrace`, `e`.`UpdateDateTime`, `e`.`Zip`
FROM `estate` AS `e`
INNER JOIN `crmoffice` AS `c` ON `e`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 00:00:02.021 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20170'], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`RepresentativeID`, `r`.`CrmOfficeID`, `r`.`Directline`, `r`.`Email`, `r`.`First_name`, `r`.`Last_name`, `r`.`PictureID`, `r`.`StatusID`, `r`.`UpdateDateTime`
FROM `representatives` AS `r`
INNER JOIN `crmoffice` AS `c` ON `r`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 00:01:16.181 +00:00 [INF] Get  5151 properties for  AgencyID 20170 from APIMO
2024-10-05 00:01:16.329 +00:00 [INF] New Properties :  2215 properties for  AgencyID 20170 from APIMO
2024-10-05 00:01:16.483 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20170 from APIMO
2024-10-05 00:01:16.615 +00:00 [INF] Properties for delete:  0 properties
2024-10-05 00:01:16.620 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateID`, `e`.`Address1`, `e`.`Address2`, `e`.`Area`, `e`.`Bathrooms`, `e`.`BlockPublication`, `e`.`Box`, `e`.`CanHaveChildren`, `e`.`City`, `e`.`CountryID`, `e`.`CrmClientID`, `e`.`CrmOfficeID`, `e`.`Currency`, `e`.`DisplayAddress`, `e`.`DisplayPrice`, `e`.`DisplayStatusID`, `e`.`EnergyClass`, `e`.`EnergyValue`, `e`.`EstateOrder`, `e`.`Evaluation`, `e`.`Floor`, `e`.`Fronts`, `e`.`Furnished`, `e`.`Garage`, `e`.`Garden`, `e`.`GardenArea`, `e`.`GroundArea`, `e`.`InvestmentEstate`, `e`.`IsTopParent`, `e`.`IsTypeEstate`, `e`.`Link3DModel`, `e`.`LinkRouteDesc`, `e`.`LinkVirtualVisit`, `e`.`Name`, `e`.`Number`, `e`.`ParentID`, `e`.`Parking`, `e`.`Price`, `e`.`PurposeStatusID`, `e`.`ReferenceNumber`, `e`.`RegionID`, `e`.`RepresentativeID`, `e`.`Rooms`, `e`.`SoldPrice`, `e`.`Stages`, `e`.`StateID`, `e`.`StatusID`, `e`.`SubCategoryID`, `e`.`Terrace`, `e`.`UpdateDateTime`, `e`.`Zip`
FROM `estate` AS `e`
INNER JOIN `crmoffice` AS `c` ON `e`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 00:01:16.624 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`RepresentativeID`, `r`.`CrmOfficeID`, `r`.`Directline`, `r`.`Email`, `r`.`First_name`, `r`.`Last_name`, `r`.`PictureID`, `r`.`StatusID`, `r`.`UpdateDateTime`
FROM `representatives` AS `r`
INNER JOIN `crmoffice` AS `c` ON `r`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 00:01:19.357 +00:00 [INF] Get  76 properties for  AgencyID 20242 from APIMO
2024-10-05 00:01:19.357 +00:00 [INF] New Properties :  17 properties for  AgencyID 20242 from APIMO
2024-10-05 00:01:19.358 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2024-10-05 00:01:19.358 +00:00 [INF] Properties for delete:  0 properties
2024-10-05 00:01:19.363 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2024-10-05 00:01:19.363 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 77992.6351ms
2024-10-05 00:01:19.363 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2024-10-05 00:01:19.367 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 77997.9401ms
2024-10-05 03:00:01.541 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0
2024-10-05 03:00:01.543 +00:00 [INF] Executing endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2024-10-05 03:00:01.543 +00:00 [INF] Route matched with {action = "CreateEstatesFromApimo", controller = "ApiWork"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] CreateEstatesFromApimo() on controller VITEXPORT.Controllers.ApiWorkController (VITEXPORT).
2024-10-05 03:00:01.544 +00:00 [INF] Entity Framework Core 5.0.11 initialized 'VitexportContext' using provider 'Pomelo.EntityFrameworkCore.MySql' with options: SensitiveDataLoggingEnabled DetailedErrorsEnabled ServerVersion 8.0.27-mysql 
2024-10-05 03:00:01.565 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CrmOfficeID`, `c`.`Address1`, `c`.`Address2`, `c`.`Box`, `c`.`City`, `c`.`CompleteSync`, `c`.`CountryID`, `c`.`CrmClientID`, `c`.`CrmID`, `c`.`Email`, `c`.`Fax`, `c`.`LicenceNumber`, `c`.`Mobile`, `c`.`Name`, `c`.`Number`, `c`.`ProfessionalInsurance`, `c`.`Status`, `c`.`StatusID`, `c`.`Telephone`, `c`.`UpdateDateTime`, `c`.`VAT`, `c`.`Website`, `c`.`Zip`
FROM `crmoffice` AS `c`
2024-10-05 03:00:01.669 +00:00 [INF] Get  2 Agencies from APIMO 
2024-10-05 03:00:01.672 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToUInt64_0='30'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2024-10-05 03:00:01.673 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToUInt64_0='1'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2024-10-05 03:00:01.677 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__id_0='20170'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateID`, `e`.`Address1`, `e`.`Address2`, `e`.`Area`, `e`.`Bathrooms`, `e`.`BlockPublication`, `e`.`Box`, `e`.`CanHaveChildren`, `e`.`City`, `e`.`CountryID`, `e`.`CrmClientID`, `e`.`CrmOfficeID`, `e`.`Currency`, `e`.`DisplayAddress`, `e`.`DisplayPrice`, `e`.`DisplayStatusID`, `e`.`EnergyClass`, `e`.`EnergyValue`, `e`.`EstateOrder`, `e`.`Evaluation`, `e`.`Floor`, `e`.`Fronts`, `e`.`Furnished`, `e`.`Garage`, `e`.`Garden`, `e`.`GardenArea`, `e`.`GroundArea`, `e`.`InvestmentEstate`, `e`.`IsTopParent`, `e`.`IsTypeEstate`, `e`.`Link3DModel`, `e`.`LinkRouteDesc`, `e`.`LinkVirtualVisit`, `e`.`Name`, `e`.`Number`, `e`.`ParentID`, `e`.`Parking`, `e`.`Price`, `e`.`PurposeStatusID`, `e`.`ReferenceNumber`, `e`.`RegionID`, `e`.`RepresentativeID`, `e`.`Rooms`, `e`.`SoldPrice`, `e`.`Stages`, `e`.`StateID`, `e`.`StatusID`, `e`.`SubCategoryID`, `e`.`Terrace`, `e`.`UpdateDateTime`, `e`.`Zip`
FROM `estate` AS `e`
INNER JOIN `crmoffice` AS `c` ON `e`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 03:00:01.822 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20170'], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`RepresentativeID`, `r`.`CrmOfficeID`, `r`.`Directline`, `r`.`Email`, `r`.`First_name`, `r`.`Last_name`, `r`.`PictureID`, `r`.`StatusID`, `r`.`UpdateDateTime`
FROM `representatives` AS `r`
INNER JOIN `crmoffice` AS `c` ON `r`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 03:01:20.963 +00:00 [INF] Get  5151 properties for  AgencyID 20170 from APIMO
2024-10-05 03:01:21.102 +00:00 [INF] New Properties :  2215 properties for  AgencyID 20170 from APIMO
2024-10-05 03:01:21.257 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20170 from APIMO
2024-10-05 03:01:21.380 +00:00 [INF] Properties for delete:  0 properties
2024-10-05 03:01:21.384 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `e`.`EstateID`, `e`.`Address1`, `e`.`Address2`, `e`.`Area`, `e`.`Bathrooms`, `e`.`BlockPublication`, `e`.`Box`, `e`.`CanHaveChildren`, `e`.`City`, `e`.`CountryID`, `e`.`CrmClientID`, `e`.`CrmOfficeID`, `e`.`Currency`, `e`.`DisplayAddress`, `e`.`DisplayPrice`, `e`.`DisplayStatusID`, `e`.`EnergyClass`, `e`.`EnergyValue`, `e`.`EstateOrder`, `e`.`Evaluation`, `e`.`Floor`, `e`.`Fronts`, `e`.`Furnished`, `e`.`Garage`, `e`.`Garden`, `e`.`GardenArea`, `e`.`GroundArea`, `e`.`InvestmentEstate`, `e`.`IsTopParent`, `e`.`IsTypeEstate`, `e`.`Link3DModel`, `e`.`LinkRouteDesc`, `e`.`LinkVirtualVisit`, `e`.`Name`, `e`.`Number`, `e`.`ParentID`, `e`.`Parking`, `e`.`Price`, `e`.`PurposeStatusID`, `e`.`ReferenceNumber`, `e`.`RegionID`, `e`.`RepresentativeID`, `e`.`Rooms`, `e`.`SoldPrice`, `e`.`Stages`, `e`.`StateID`, `e`.`StatusID`, `e`.`SubCategoryID`, `e`.`Terrace`, `e`.`UpdateDateTime`, `e`.`Zip`
FROM `estate` AS `e`
INNER JOIN `crmoffice` AS `c` ON `e`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 03:01:21.387 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__id_0='20242'], CommandType='"Text"', CommandTimeout='30']
SELECT `r`.`RepresentativeID`, `r`.`CrmOfficeID`, `r`.`Directline`, `r`.`Email`, `r`.`First_name`, `r`.`Last_name`, `r`.`PictureID`, `r`.`StatusID`, `r`.`UpdateDateTime`
FROM `representatives` AS `r`
INNER JOIN `crmoffice` AS `c` ON `r`.`CrmOfficeID` = `c`.`CrmOfficeID`
WHERE `c`.`CrmOfficeID` = @__id_0
2024-10-05 03:01:22.285 +00:00 [INF] Get  76 properties for  AgencyID 20242 from APIMO
2024-10-05 03:01:22.285 +00:00 [INF] New Properties :  17 properties for  AgencyID 20242 from APIMO
2024-10-05 03:01:22.285 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2024-10-05 03:01:22.285 +00:00 [INF] Properties for delete:  0 properties
2024-10-05 03:01:22.286 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2024-10-05 03:01:22.286 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 80743.0974ms
2024-10-05 03:01:22.286 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2024-10-05 03:01:22.289 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 80747.8690ms