2023-01-18 21:00:23.224 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661719', @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();
2023-01-18 21:00:23.387 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='14' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/10370571036329fff7e81900.30780293_1600.jpg' (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();
2023-01-18 21:00:23.514 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661720', @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();
2023-01-18 21:00:23.675 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='15' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1123757966329fed1988526.59500506_640.jpg' (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();
2023-01-18 21:00:23.832 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661721', @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();
2023-01-18 21:00:24.010 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='16' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/11651249246329fee5d2c8c1.22192228_640.jpg' (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();
2023-01-18 21:00:24.194 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661722', @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();
2023-01-18 21:00:24.331 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='17' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1089296836329fefb046117.63030618_640.jpg' (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();
2023-01-18 21:00:24.493 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661723', @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();
2023-01-18 21:00:24.661 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='18' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/16720276306329ff0f8cd077.90692310_1200.jpg' (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();
2023-01-18 21:00:24.808 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661724', @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();
2023-01-18 21:00:24.946 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='19' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/20279569486329ff458c7db6.13640101_640.jpg' (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();
2023-01-18 21:00:25.131 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661725', @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();
2023-01-18 21:00:25.252 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='20' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/17607597816329ff5e63ac86.32013380_640.jpg' (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();
2023-01-18 21:00:25.399 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661726', @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();
2023-01-18 21:00:25.571 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='21' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/730741377632a0002e16cd2.76021090_1200.jpg' (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();
2023-01-18 21:00:25.709 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661727', @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();
2023-01-18 21:00:25.848 +00:00 [INF] Executed DbCommand (14ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='22' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1382578717632a000ab2c733.34398283_1600.jpg' (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();
2023-01-18 21:00:25.983 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661728', @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();
2023-01-18 21:00:26.129 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='23' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1887321961632a001a5fe273.12502763_1600.jpg' (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();
2023-01-18 21:00:26.259 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661729', @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();
2023-01-18 21:00:26.387 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='24' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1108215400632a0022747ee1.43391879_1600.jpg' (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();
2023-01-18 21:00:26.535 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661730', @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();
2023-01-18 21:00:26.674 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='25' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1104524523632a0011d53a60.20664397_1600.jpg' (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();
2023-01-18 21:00:26.821 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661731', @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();
2023-01-18 21:00:26.980 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='26' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/856325075632a00299a0167.85044638_1600.jpg' (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();
2023-01-18 21:00:27.119 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661732', @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();
2023-01-18 21:00:27.269 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='27' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/1906466438632a00312f5692.95886682_1600.jpg' (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();
2023-01-18 21:00:27.387 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661733', @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();
2023-01-18 21:00:27.499 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='28' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/7409/7408619/186888720632a0039839686.15271487_1600.jpg' (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();
2023-01-18 21:00:27.637 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='7408619', @p2=NULL, @p3=NULL, @p4='30661734', @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();
2023-01-18 21:00:27.790 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @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();
2023-01-18 21:00:27.914 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426521', @p2='23.7781' (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();
2023-01-18 21:00:28.077 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @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();
2023-01-18 21:00:28.216 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426522', @p2='37.85502' (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();
2023-01-18 21:00:28.365 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @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();
2023-01-18 21:00:28.499 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426523', @p2='1988' (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();
2023-01-18 21:00:28.631 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @p1='1003'], 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();
2023-01-18 21:00:28.771 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426524', @p2='3' (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();
2023-01-18 21:00:28.773 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__estate_EstateId_0='7408619'], 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)
2023-01-18 21:00:28.895 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='426497'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-18 21:00:29.032 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='426498'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-18 21:00:29.034 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='7408619'], 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
2023-01-18 21:00:29.149 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181329'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-18 21:00:29.311 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181330'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-18 21:00:29.421 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @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();
2023-01-18 21:00:29.559 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='426525', @p2='Μονοκατοικία' (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();
2023-01-18 21:00:29.706 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Τριώροφη μονοκατοικία προς πώληση, Πανόραμα, Βούλα. 310τμ, 1.700.000€. Ισόγειο, 1ος όροφος, 2ος όροφος. Σε καλή κατάσταση.
Όμορφη θέα στη θάλασσα σε Σαρωνικό, Βούλα, Καβούρι από όλα τα επίπεδα του σπιτιού.
Νοτιοανατολικό προσανατολισμό. Διαθέτει 3 υπνοδωμάτια εκ των οποίων τα 2 είναι μεγάλα και το 1 μπορεί να γίνει δεύτερο σαλόνι. 2 μπάνια, 2 WC, 2 κουζίνες, 1 σαλόνι, 3 τζάκια, κήπος και BBQ.' (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();
2023-01-18 21:00:29.852 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @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();
2023-01-18 21:00:29.992 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='426526', @p2='House' (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();
2023-01-18 21:00:30.107 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='7408619', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='3 floor house for sale, Panorama,Voula. 310sqm, 1,700.000€. Ground level, 1st floor, 2nd floor. In good condition. 
Beautiful seaview of Saroniko, Voula, Kavouri from all levels of the house.
South-east oriented. Has 3 bedrooms of which 2 are large and 1 can be made into a second livingroom. 2 bathrooms,  2 WC, 2 kitchens, 1 livingroom , 3 fireplaces a garden and BBQ.' (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();
2023-01-18 21:00:30.147 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='3', @__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
2023-01-18 21:00:30.149 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='attica' (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
2023-01-18 21:00:30.150 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='athens' (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
2023-01-18 21:00:30.323 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @p1=NULL (Size = 500), @p2=NULL (Size = 500), @p3='900' (Nullable = true), @p4=NULL (DbType = Int32), @p5=NULL, @p6=NULL (Size = 255), @p7=NULL, @p8='Athens' (Size = 255), @p9='30', @p10='1', @p11='20170', @p12='EUR' (Size = 5), @p13='False' (Nullable = true), @p14='True' (Nullable = true), @p15='2' (Nullable = true), @p16=NULL (Size = 255), @p17=NULL (Size = 255), @p18=NULL (DbType = Int32), @p19=NULL (Size = 255), @p20=NULL (Size = 10), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Int32), @p25=NULL (DbType = Double), @p26=NULL (DbType = Double), @p27=NULL, @p28=NULL, @p29=NULL, @p30=NULL (Size = 255), @p31=NULL, @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34=NULL (Size = 255), @p35='0' (Nullable = true), @p36='0' (Nullable = true), @p37='1500000' (Nullable = true), @p38='1', @p39='3817KS' (Size = 255), @p40='58634' (Nullable = true), @p41='75413' (Nullable = true), @p42='60' (Nullable = true), @p43=NULL (DbType = Double), @p44='6' (Size = 255), @p45='3' (Nullable = true), @p46='1', @p47='41', @p48=NULL (DbType = Int32), @p49='2023-01-18T21:00:30.1509362+00:00' (Nullable = true) (DbType = DateTime), @p50='104 34' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estate` (`EstateID`, `Address1`, `Address2`, `Area`, `Bathrooms`, `BlockPublication`, `Box`, `CanHaveChildren`, `City`, `CountryID`, `CrmClientID`, `CrmOfficeID`, `Currency`, `DisplayAddress`, `DisplayPrice`, `DisplayStatusID`, `EnergyClass`, `EnergyValue`, `EstateOrder`, `Evaluation`, `Floor`, `Fronts`, `Furnished`, `Garage`, `Garden`, `GardenArea`, `GroundArea`, `InvestmentEstate`, `IsTopParent`, `IsTypeEstate`, `Link3DModel`, `LinkRouteDesc`, `LinkVirtualVisit`, `Name`, `Number`, `ParentID`, `Parking`, `Price`, `PurposeStatusID`, `ReferenceNumber`, `RegionID`, `RepresentativeID`, `Rooms`, `SoldPrice`, `Stages`, `StateID`, `StatusID`, `SubCategoryID`, `Terrace`, `UpdateDateTime`, `Zip`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50);
2023-01-18 21:00:30.470 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047533/108166796263c85495ce3088.19846047_1200.jpg' (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();
2023-01-18 21:00:30.612 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047533', @p2=NULL, @p3=NULL, @p4='30661735', @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();
2023-01-18 21:00:30.766 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047533/22545241463c854975c4723.88550062_1200.jpg' (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();
2023-01-18 21:00:30.921 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047533', @p2=NULL, @p3=NULL, @p4='30661736', @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();
2023-01-18 21:00:31.056 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-18 21:00:31.188 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426527', @p2='23.73052' (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();
2023-01-18 21:00:31.362 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-18 21:00:31.504 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426528', @p2='37.9843' (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();
2023-01-18 21:00:31.625 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-18 21:00:31.761 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426529', @p2='2004' (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();
2023-01-18 21:00:31.921 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-18 21:00:32.066 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='426530', @p2='Πωλείται κτίριο στο κέντρο της Αθήνας. 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-18 21:00:32.195 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='8047533', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται κτίριο 900τμ στο κέντρο της Αθήνας. Κατασκευάστηκε το 2004, σε έναν ήσυχο πεζόδρομο. 6 ορόφων με υπόγειο και αποθήκες. Με 16 στούντιο, κατάλληλα για airbnb ή ξενοδοχείο. Κοντά στο Πανεπιστήμιο, 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-18 21:00:32.357 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-18 21:00:32.486 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='426531', @p2='Building for sale in Athens center. 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-18 21:00:32.614 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Building 900sqm for sale in Athens center. Constructed in 2004, on a pedestrian quiet street. 6 floors with basement and storages. With 16 studios, suitable for airbnb or a hotel. Close to University, 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-18 21:00:32.662 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='3', @__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
2023-01-18 21:00:32.665 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='attica' (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
2023-01-18 21:00:32.667 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='athens' (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
2023-01-18 21:00:32.814 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='8047566', @p1=NULL (Size = 500), @p2=NULL (Size = 500), @p3='900' (Nullable = true), @p4=NULL (DbType = Int32), @p5=NULL, @p6=NULL (Size = 255), @p7=NULL, @p8='Athens' (Size = 255), @p9='30', @p10='1', @p11='20170', @p12='EUR' (Size = 5), @p13='False' (Nullable = true), @p14='True' (Nullable = true), @p15='2' (Nullable = true), @p16=NULL (Size = 255), @p17=NULL (Size = 255), @p18=NULL (DbType = Int32), @p19=NULL (Size = 255), @p20=NULL (Size = 10), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Int32), @p25=NULL (DbType = Double), @p26=NULL (DbType = Double), @p27=NULL, @p28=NULL, @p29=NULL, @p30=NULL (Size = 255), @p31=NULL, @p32=NULL (Size = 255), @p33=NULL (Size = 255), @p34=NULL (Size = 255), @p35='0' (Nullable = true), @p36='0' (Nullable = true), @p37='5500' (Nullable = true), @p38='2', @p39='3818KS' (Size = 255), @p40='58634' (Nullable = true), @p41='75413' (Nullable = true), @p42='60' (Nullable = true), @p43=NULL (DbType = Double), @p44='6' (Size = 255), @p45='3' (Nullable = true), @p46='1', @p47='41', @p48=NULL (DbType = Int32), @p49='2023-01-18T21:00:32.6679360+00:00' (Nullable = true) (DbType = DateTime), @p50='104 34' (Size = 255)], CommandType='"Text"', CommandTimeout='30']
INSERT INTO `estate` (`EstateID`, `Address1`, `Address2`, `Area`, `Bathrooms`, `BlockPublication`, `Box`, `CanHaveChildren`, `City`, `CountryID`, `CrmClientID`, `CrmOfficeID`, `Currency`, `DisplayAddress`, `DisplayPrice`, `DisplayStatusID`, `EnergyClass`, `EnergyValue`, `EstateOrder`, `Evaluation`, `Floor`, `Fronts`, `Furnished`, `Garage`, `Garden`, `GardenArea`, `GroundArea`, `InvestmentEstate`, `IsTopParent`, `IsTypeEstate`, `Link3DModel`, `LinkRouteDesc`, `LinkVirtualVisit`, `Name`, `Number`, `ParentID`, `Parking`, `Price`, `PurposeStatusID`, `ReferenceNumber`, `RegionID`, `RepresentativeID`, `Rooms`, `SoldPrice`, `Stages`, `StateID`, `StatusID`, `SubCategoryID`, `Terrace`, `UpdateDateTime`, `Zip`)
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50);
2023-01-18 21:00:33.007 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047566/24907949263c854ec7f5508.66882381_1200.jpg' (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();
2023-01-18 21:00:33.188 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047566', @p2=NULL, @p3=NULL, @p4='30661737', @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();
2023-01-18 21:00:33.361 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047566/9100237163c854eccfdeb7.59921266_1200.jpg' (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();
2023-01-18 21:00:33.507 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047566', @p2=NULL, @p3=NULL, @p4='30661738', @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();
2023-01-18 21:00:33.648 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-18 21:00:33.785 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426532', @p2='23.73052' (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();
2023-01-18 21:00:33.906 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-18 21:00:34.073 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426533', @p2='37.9843' (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();
2023-01-18 21:00:34.221 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-18 21:00:34.357 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426534', @p2='2004' (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();
2023-01-18 21:00:34.488 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-18 21:00:34.624 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='426535', @p2='Kτίριο στο κέντρο της Αθήνας. 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-18 21:00:34.765 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Kτίριο 900τμ στο κέντρο της Αθήνας. Κατασκευάστηκε το 2004, σε έναν ήσυχο πεζόδρομο. 6 ορόφων με υπόγειο και αποθήκες. Με 16 στούντιο, κατάλληλα για airbnb ή ξενοδοχείο. Κοντά στο Πανεπιστήμιο, 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-18 21:00:34.904 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-18 21:00:35.049 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='426536', @p2='Building in Athens center. 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-18 21:00:35.191 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='8047566', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Building 900sqm in Athens center. Constructed in 2004, on a pedestrian quiet street. 6 floors with basement and storages. With 16 studios, suitable for airbnb or a hotel. Close to University, 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-18 21:00:35.328 +00:00 [INF] Executed DbCommand (3ms) [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
2023-01-18 21:00:35.338 +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
2023-01-18 21:00:35.963 +00:00 [INF] Get  103 properties for  AgencyID 20242 from APIMO
2023-01-18 21:00:35.963 +00:00 [INF] New Properties :  26 properties for  AgencyID 20242 from APIMO
2023-01-18 21:00:35.964 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2023-01-18 21:00:35.964 +00:00 [INF] Properties for delete:  0 properties
2023-01-18 21:00:35.964 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2023-01-18 21:00:35.964 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 34125.6331ms
2023-01-18 21:00:35.965 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-18 21:00:35.968 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 34130.2087ms
2023-01-19 00:00:01.232 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0
2023-01-19 00:00:01.233 +00:00 [INF] Executing endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 00:00:01.233 +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).
2023-01-19 00:00:01.234 +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 
2023-01-19 00:00:01.257 +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`
2023-01-19 00:00:01.381 +00:00 [INF] Get  2 Agencies from APIMO 
2023-01-19 00:00:01.384 +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
2023-01-19 00:00:01.385 +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
2023-01-19 00:00:01.390 +00:00 [INF] Executed DbCommand (4ms) [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
2023-01-19 00:00:01.537 +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
2023-01-19 00:00:09.290 +00:00 [INF] Get  2120 properties for  AgencyID 20170 from APIMO
2023-01-19 00:00:09.338 +00:00 [INF] New Properties :  257 properties for  AgencyID 20170 from APIMO
2023-01-19 00:00:09.373 +00:00 [INF] Properties for update:  2 properties for  AgencyID 20170 from APIMO
2023-01-19 00:00:09.412 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 00:00:09.415 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='3', @__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
2023-01-19 00:00:09.416 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__ToLower_0='attica' (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
2023-01-19 00:00:09.418 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='athens' (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
2023-01-19 00:00:09.558 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p50='8047533', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='900' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Athens' (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=NULL (Size = 10), @p20=NULL (DbType = Int32), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25=NULL (DbType = Double), @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='1500000' (Nullable = true), @p37='1', @p38='3817KS' (Size = 255), @p39='58634' (Nullable = true), @p40='75413' (Nullable = true), @p41='60' (Nullable = true), @p42=NULL (DbType = Double), @p43='6' (Size = 255), @p44='3' (Nullable = true), @p45='1', @p46='41', @p47=NULL (DbType = Int32), @p48='2023-01-19T00:00:09.4190089+00:00' (Nullable = true) (DbType = DateTime), @p49='104 34' (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();
2023-01-19 00:00:09.560 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__estate_EstateId_0='8047533'], 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
2023-01-19 00:00:09.736 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='720112'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:00:09.738 +00:00 [INF] Executed DbCommand (0ms) [Parameters=[@__p_0='30661735'], 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
2023-01-19 00:00:09.906 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30661735'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:00:10.114 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='720113'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:00:10.116 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30661736'], 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
2023-01-19 00:00:10.277 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30661736'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:00:10.665 +00:00 [INF] Executed DbCommand (218ms) [Parameters=[@p0='20170', @p1=NULL (DbType = Int32), @p2='1' (Nullable = true), @p3=NULL (Size = 255), @p4=NULL (Size = 255), @p5='https://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047533/108166796263c85495ce3088.19846047_1200.jpg' (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();
2023-01-19 00:00:12.383 +00:00 [INF] Executed DbCommand (1,508ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047533', @p2=NULL, @p3=NULL, @p4='30661739', @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();
2023-01-19 00:00:12.580 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047533/22545241463c854975c4723.88550062_1200.jpg' (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();
2023-01-19 00:00:12.795 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047533', @p2=NULL, @p3=NULL, @p4='30661740', @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();
2023-01-19 00:00:13.134 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-19 00:00:13.319 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426537', @p2='23.73052' (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();
2023-01-19 00:00:31.501 +00:00 [INF] Executed DbCommand (18,003ms) [Parameters=[@p0='8047533', @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();
2023-01-19 00:00:57.975 +00:00 [INF] Executed DbCommand (26,206ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426538', @p2='37.9843' (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();
2023-01-19 00:00:58.141 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='8047533', @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();
2023-01-19 00:00:58.292 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426539', @p2='2004' (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();
2023-01-19 00:01:09.784 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__estate_EstateId_0='8047533'], 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)
2023-01-19 00:01:09.944 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='426530'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:10.114 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='426531'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:10.117 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='8047533'], 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
2023-01-19 00:01:10.285 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181342'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:10.883 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181343'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:21.808 +00:00 [INF] Executed DbCommand (10,653ms) [Parameters=[@p0='8047533', @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();
2023-01-19 00:01:21.997 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='426540', @p2='Πωλείται κτίριο στο κέντρο της Αθήνας. 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-19 00:01:23.082 +00:00 [INF] Executed DbCommand (914ms) [Parameters=[@p0='8047533', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Πωλείται κτίριο 900τμ στο κέντρο της Αθήνας. Κατασκευάστηκε το 2004, σε έναν ήσυχο πεζόδρομο. 6 ορόφων με υπόγειο και αποθήκες. Με 16 στούντιο, κατάλληλα για airbnb ή ξενοδοχείο. Κοντά στο Πανεπιστήμιο, 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-19 00:01:23.258 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047533', @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();
2023-01-19 00:01:23.465 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='426541', @p2='Building for sale in Athens center. 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-19 00:01:24.405 +00:00 [INF] Executed DbCommand (783ms) [Parameters=[@p0='8047533', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Building 900sqm for sale in Athens center. Constructed in 2004, on a pedestrian quiet street. 6 floors with basement and storages. With 16 studios, suitable for airbnb or a hotel. Close to University, 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-19 00:01:25.404 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='3', @__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
2023-01-19 00:01:25.406 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='attica' (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
2023-01-19 00:01:25.408 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToLower_0='athens' (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
2023-01-19 00:01:25.600 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p50='8047566', @p0=NULL (Size = 500), @p1=NULL (Size = 500), @p2='900' (Nullable = true), @p3=NULL (DbType = Int32), @p4=NULL, @p5=NULL (Size = 255), @p6=NULL, @p7='Athens' (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=NULL (Size = 10), @p20=NULL (DbType = Int32), @p21=NULL (DbType = Int32), @p22=NULL (DbType = Int32), @p23=NULL (DbType = Int32), @p24=NULL (DbType = Double), @p25=NULL (DbType = Double), @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='5500' (Nullable = true), @p37='2', @p38='3818KS' (Size = 255), @p39='58634' (Nullable = true), @p40='75413' (Nullable = true), @p41='60' (Nullable = true), @p42=NULL (DbType = Double), @p43='6' (Size = 255), @p44='3' (Nullable = true), @p45='1', @p46='41', @p47=NULL (DbType = Int32), @p48='2023-01-19T00:01:25.4088249+00:00' (Nullable = true) (DbType = DateTime), @p49='104 34' (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();
2023-01-19 00:01:25.603 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='8047566'], 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
2023-01-19 00:01:25.975 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='720114'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:25.981 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__p_0='30661737'], 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
2023-01-19 00:01:26.132 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='30661737'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:26.309 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='720115'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatepicture`
WHERE `id` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:26.311 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='30661738'], 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
2023-01-19 00:01:26.481 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='30661738'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `picture`
WHERE `PictureID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:33.646 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047566/24907949263c854ec7f5508.66882381_1200.jpg' (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();
2023-01-19 00:01:37.409 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047566', @p2=NULL, @p3=NULL, @p4='30661741', @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();
2023-01-19 00:01:38.201 +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://d1qfj231ug7wdu.cloudfront.net/pictures/estate/8048/8047566/9100237163c854eccfdeb7.59921266_1200.jpg' (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();
2023-01-19 00:01:51.859 +00:00 [INF] Executed DbCommand (12,601ms) [Parameters=[@p0=NULL (DbType = UInt64), @p1='8047566', @p2=NULL, @p3=NULL, @p4='30661742', @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();
2023-01-19 00:01:52.016 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-19 00:01:52.183 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426542', @p2='23.73052' (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();
2023-01-19 00:01:52.547 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-19 00:01:52.716 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426543', @p2='37.9843' (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();
2023-01-19 00:01:52.882 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-19 00:01:53.036 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='fr-BE' (Nullable = false) (Size = 255), @p1='426544', @p2='2004' (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();
2023-01-19 00:01:53.054 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='8047566'], 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)
2023-01-19 00:01:53.243 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='426535'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:53.736 +00:00 [INF] Executed DbCommand (131ms) [Parameters=[@p0='426536'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `subdetailvalue`
WHERE `SubDetailValueID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:53.738 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__estate_EstateId_0='8047566'], 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
2023-01-19 00:01:53.874 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181344'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:54.047 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='181345'], CommandType='"Text"', CommandTimeout='30']
DELETE FROM `estatedescription`
WHERE `EstateLanguageID` = @p0;
SELECT ROW_COUNT();
2023-01-19 00:01:54.223 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @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();
2023-01-19 00:02:03.463 +00:00 [INF] Executed DbCommand (8,684ms) [Parameters=[@p0='el-GR' (Nullable = false) (Size = 255), @p1='426545', @p2='Kτίριο στο κέντρο της Αθήνας. 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-19 00:02:03.615 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='8047566', @p1='el-GR' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Kτίριο 900τμ στο κέντρο της Αθήνας. Κατασκευάστηκε το 2004, σε έναν ήσυχο πεζόδρομο. 6 ορόφων με υπόγειο και αποθήκες. Με 16 στούντιο, κατάλληλα για airbnb ή ξενοδοχείο. Κοντά στο Πανεπιστήμιο, 350μ από το σιδηροδρομικό σταθμό Viktoria, 450μ από το σιδηροδρομικό σταθμό Λαρίσης.' (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();
2023-01-19 00:02:04.034 +00:00 [INF] Executed DbCommand (271ms) [Parameters=[@p0='8047566', @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();
2023-01-19 00:02:04.219 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='en-GB' (Nullable = false) (Size = 255), @p1='426546', @p2='Building in Athens center. 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-19 00:02:04.484 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='8047566', @p1='en-GB' (Nullable = false) (Size = 255), @p2=NULL (Size = 4000), @p3='Building 900sqm in Athens center. Constructed in 2004, on a pedestrian quiet street. 6 floors with basement and storages. With 16 studios, suitable for airbnb or a hotel. Close to University, 350m from Viktoria train station, 450m from Larissis train station.' (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();
2023-01-19 00:02:04.981 +00:00 [INF] Executed DbCommand (3ms) [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
2023-01-19 00:02:04.988 +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
2023-01-19 00:02:05.562 +00:00 [INF] Get  103 properties for  AgencyID 20242 from APIMO
2023-01-19 00:02:05.562 +00:00 [INF] New Properties :  26 properties for  AgencyID 20242 from APIMO
2023-01-19 00:02:05.562 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2023-01-19 00:02:05.563 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 00:02:05.563 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2023-01-19 00:02:05.563 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 124329.7885ms
2023-01-19 00:02:05.563 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 00:02:05.566 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 124334.6127ms
2023-01-19 03:00:01.770 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0
2023-01-19 03:00:01.771 +00:00 [INF] Executing endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 03:00:01.771 +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).
2023-01-19 03:00:01.771 +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 
2023-01-19 03:00:01.796 +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`
2023-01-19 03:00:01.895 +00:00 [INF] Get  2 Agencies from APIMO 
2023-01-19 03:00:01.898 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='30'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2023-01-19 03:00:01.901 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__ToUInt64_0='1'], CommandType='"Text"', CommandTimeout='30']
SELECT `c`.`CountryID`
FROM `country` AS `c`
WHERE `c`.`CountryID` = @__ToUInt64_0
LIMIT 2
2023-01-19 03:00:01.907 +00:00 [INF] Executed DbCommand (4ms) [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
2023-01-19 03:00:01.995 +00:00 [INF] Executed DbCommand (0ms) [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
2023-01-19 03:00:09.056 +00:00 [INF] Get  2120 properties for  AgencyID 20170 from APIMO
2023-01-19 03:00:09.096 +00:00 [INF] New Properties :  257 properties for  AgencyID 20170 from APIMO
2023-01-19 03:00:09.149 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20170 from APIMO
2023-01-19 03:00:09.209 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 03:00:09.214 +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
2023-01-19 03:00:09.225 +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
2023-01-19 03:00:09.733 +00:00 [INF] Get  103 properties for  AgencyID 20242 from APIMO
2023-01-19 03:00:09.733 +00:00 [INF] New Properties :  26 properties for  AgencyID 20242 from APIMO
2023-01-19 03:00:09.733 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2023-01-19 03:00:09.733 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 03:00:09.734 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2023-01-19 03:00:09.734 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 7963.2793ms
2023-01-19 03:00:09.734 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 03:00:09.737 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 7967.7407ms
2023-01-19 06:00:01.948 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0
2023-01-19 06:00:01.949 +00:00 [INF] Executing endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 06:00:01.949 +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).
2023-01-19 06:00:01.950 +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 
2023-01-19 06:00:01.976 +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`
2023-01-19 06:00:02.326 +00:00 [INF] Get  2 Agencies from APIMO 
2023-01-19 06:00:02.328 +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
2023-01-19 06:00:02.328 +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
2023-01-19 06:00:02.333 +00:00 [INF] Executed DbCommand (4ms) [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
2023-01-19 06:00:02.403 +00:00 [INF] Executed DbCommand (0ms) [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
2023-01-19 06:00:10.192 +00:00 [INF] Get  2120 properties for  AgencyID 20170 from APIMO
2023-01-19 06:00:10.220 +00:00 [INF] New Properties :  257 properties for  AgencyID 20170 from APIMO
2023-01-19 06:00:10.252 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20170 from APIMO
2023-01-19 06:00:10.296 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 06:00:10.301 +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
2023-01-19 06:00:10.316 +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
2023-01-19 06:00:10.883 +00:00 [INF] Get  103 properties for  AgencyID 20242 from APIMO
2023-01-19 06:00:10.884 +00:00 [INF] New Properties :  26 properties for  AgencyID 20242 from APIMO
2023-01-19 06:00:10.884 +00:00 [INF] Properties for update:  0 properties for  AgencyID 20242 from APIMO
2023-01-19 06:00:10.884 +00:00 [INF] Properties for delete:  0 properties
2023-01-19 06:00:10.886 +00:00 [INF] Executing HttpStatusCodeResult, setting HTTP status code 200
2023-01-19 06:00:10.886 +00:00 [INF] Executed action VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT) in 8936.7191ms
2023-01-19 06:00:10.886 +00:00 [INF] Executed endpoint 'VITEXPORT.Controllers.ApiWorkController.CreateEstatesFromApimo (VITEXPORT)'
2023-01-19 06:00:10.891 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5000/api/ApiWork/CreateEstatesFromApimo - 0 - 200 0 - 8943.6046ms