'Space' property highlights in Surrey
The presence of Space may change how useful, flexible or attractive a property feels. Explore properties whose descriptions mention Space as a particular room, area or type of usable space.
The presence of Space may change how useful, flexible or attractive a property feels. Explore properties whose descriptions mention Space as a particular room, area or type of usable space.
[0.56 ms] #1 | 0.56 ms | OK | sp_get_point
SELECT * FROM `BookmarkSearches` WHERE Search = 'space' LIMIT 1
[303.33 ms] point_page: enter
[304.00 ms] #2 | 0.51 ms | OK
SELECT
ba.Id,
ba.Name,
ba.LegacyAreaId,
bsa.Sequence,
ba.LocationIdentifier
FROM BookmarkSearchAreas bsa
INNER JOIN BookmarkAreas ba
ON ba.Id = bsa.AreaId
WHERE bsa.SearchId = 2116
ORDER BY
bsa.Sequence,
ba.Name
[304.27 ms] #3 | 0.25 ms | OK | point_page
SELECT Section FROM `BookmarkSearches` WHERE Section = 'space' GROUP BY Section
[304.50 ms] #4 | 0.21 ms | OK | point_page
SELECT Container FROM `BookmarkSearchesSections` WHERE Container = 'space'
[304.79 ms] #5 | 0.24 ms | OK
SELECT
ba.Id,
ba.Name,
ba.LegacyAreaId,
bsa.Sequence,
ba.LocationIdentifier
FROM BookmarkSearchAreas bsa
INNER JOIN BookmarkAreas ba
ON ba.Id = bsa.AreaId
WHERE bsa.SearchId = 2116
ORDER BY
bsa.Sequence,
ba.Name
[305.26 ms] #6 | 0.44 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[305.79 ms] #7 | 0.41 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'space' ORDER BY Search
[306.22 ms] #8 | 0.28 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[307.93 ms] #9 | 1.44 ms | OK | point_page
SELECT s.*, sec.Description AS SectionDescription FROM dafdebbf_HOMM.BookmarkSearches s LEFT JOIN dafdebbf_HOMM.BookmarkSearchesSections sec ON sec.Section = s.Section WHERE s.Section = 'space' ORDER BY Search
[308.35 ms] #10 | 0.25 ms | OK | point_page
SELECT Id AS id, Name AS name, LocationIdentifier AS RMLocation FROM `BookmarkAreas` WHERE LOWER(Slug) = 'surrey' OR LOWER(Name) = 'surrey'
[308.74 ms] #11 | 0.31 ms | OK | getText
SELECT * FROM dafdebbf_HOMM.BookmarkTexts WHERE Point IN ('Space','Buildings')
[309.10 ms] #12 | 0.26 ms | OK
SELECT
ba.Id,
ba.Name,
ba.LegacyAreaId,
bsa.Sequence,
ba.LocationIdentifier
FROM BookmarkSearchAreas bsa
INNER JOIN BookmarkAreas ba
ON ba.Id = bsa.AreaId
WHERE bsa.SearchId = 2116
ORDER BY
bsa.Sequence,
ba.Name
[309.57 ms] #13 | 0.43 ms | OK
SELECT Search, SearchTitle FROM dafdebbf_HOMM.BookmarkSearches WHERE Level = 1 ORDER BY COALESCE(NULLIF(SearchTitle, ''), Search)
[310.07 ms] #14 | 0.42 ms | OK
SELECT Search, SearchTitle, Section FROM dafdebbf_HOMM.BookmarkSearches WHERE Section = 'space' ORDER BY Search
[310.40 ms] #15 | 0.24 ms | OK
SELECT Name AS name, Slug AS value FROM dafdebbf_HOMM.BookmarkAreas ORDER BY Sequence DESC, Name
[310.84 ms] sp_point_properties: BEFORE READLIST
[313.26 ms] #16 | 2.39 ms | OK
INSERT INTO BookmarkPointSearches
(
Point,
CountyId,
Tenure,
Portal,
MaxPrice,
PropertyCount,
VisitorHash,
Source
)
VALUES
(
'Space',
124,
'sale',
'rightmove',
0,
0,
'c2786a9017f8c5d7aba3430177b3f3afd37cbc04db0a0eab272acdf4e36791cc',
'point'
)
ON DUPLICATE KEY UPDATE
SearchCount = SearchCount + 1,
PropertyCount = VALUES(PropertyCount),
LastSeen = CURRENT_TIMESTAMP
[313.28 ms] point_page: exit
[389.59 ms] #17 | 0.70 ms | OK
SELECT Search
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 1
ORDER BY Search
[389.98 ms] #18 | 0.36 ms | OK
SELECT Name, Slug
FROM dafdebbf_HOMM.BookmarkAreas
ORDER BY Sequence DESC, Name
[393.30 ms] #19 | 3.26 ms | OK
SELECT Search, SearchTitle
FROM dafdebbf_HOMM.BookmarkSearches
WHERE
Level = 0
AND LOWER(Section) = 'space'
ORDER BY Search