Exclusive new construction projects
A unique selection of luxury new build apartments and villas for sale.
-13 Remaining
SELECT BlogCategories.Name AS BlogCategoryName, BlogCategories.NameTranslations AS BlogCategoryNameTranslations, RepositoryFiles.RepositoryDirectoryID, RepositoryFiles.Name as FileName, RepositoryFiles.Width, RepositoryFiles.Height, RepositoryFiles.Extension, RepositoryFiles.ResizeSizes, RepositoryFiles.OriginalResized, RD.Name AS DirName, IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName, RD.RepositoryDirectoryID AS CurrentDirID, JD.RepositoryDirectoryID AS ParentDirID, Blogs.*, DATE_FORMAT(FROM_UNIXTIME(Blogs.DatePublication), '%d %M %Y') AS FormattedDatePublication, null AS Photos, null AS Tags, null AS URL FROM Blogs LEFT JOIN RepositoryFiles ON Blogs.RepositoryFileID = RepositoryFiles.RepositoryFileID LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID LEFT JOIN BlogCountries ON Blogs.BlogID = BlogCountries.BlogID INNER JOIN BlogCategories ON Blogs.BlogCategoryID = BlogCategories.BlogCategoryID LEFT JOIN BlogPhotos ON Blogs.BlogID = BlogPhotos.BlogID LEFT JOIN BlogRelTags ON Blogs.BlogID = BlogRelTags.BlogID LEFT JOIN BlogTags ON BlogRelTags.BlogTagID = BlogTags.BlogTagID WHERE (BlogCountries.CountryID = 20) AND (BlogCategories.BlogMainCategoryID = 2) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = 6) AND (Blogs.BlogID != ) AND (DatePublication < (select MAX(DatePublication) FROM Blogs WHERE Blogs.BlogCategoryID = 6)) GROUP BY Blogs.BlogID ORDER BY Blogs.DatePublication DESC LIMIT 0, 12
SELECT BlogCategories.Name AS BlogCategoryName, BlogCategories.NameTranslations AS BlogCategoryNameTranslations, RepositoryFiles.RepositoryDirectoryID, RepositoryFiles.Name as FileName, RepositoryFiles.Width, RepositoryFiles.Height, RepositoryFiles.Extension, RepositoryFiles.ResizeSizes, RepositoryFiles.OriginalResized, RD.Name AS DirName, IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName, RD.RepositoryDirectoryID AS CurrentDirID, JD.RepositoryDirectoryID AS ParentDirID, Blogs.*, DATE_FORMAT(FROM_UNIXTIME(Blogs.DatePublication), '%d %M %Y') AS FormattedDatePublication, null AS Photos, null AS Tags, null AS URL FROM Blogs LEFT JOIN RepositoryFiles ON Blogs.RepositoryFileID = RepositoryFiles.RepositoryFileID LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID LEFT JOIN BlogCountries ON Blogs.BlogID = BlogCountries.BlogID INNER JOIN BlogCategories ON Blogs.BlogCategoryID = BlogCategories.BlogCategoryID LEFT JOIN BlogPhotos ON Blogs.BlogID = BlogPhotos.BlogID LEFT JOIN BlogRelTags ON Blogs.BlogID = BlogRelTags.BlogID LEFT JOIN BlogTags ON BlogRelTags.BlogTagID = BlogTags.BlogTagID WHERE (BlogCountries.CountryID = 20) AND (BlogCategories.BlogMainCategoryID = 2) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = 6) AND (Blogs.BlogID != ) AND (DatePublication < (select MAX(DatePublication) FROM Blogs WHERE Blogs.BlogCategoryID = 6)) GROUP BY Blogs.BlogID ORDER BY Blogs.DatePublication DESC LIMIT 0, 12You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (DatePublication < (select MAX(DatePublication) FROM Blogs WHERE Blogs.Blo' at line 24
A unique selection of luxury new build apartments and villas for sale.
This website uses cookies. View cookie policy.