Projets exclusifs de nouvelles constructions
Une sélection unique d'appartements et de villas neufs de luxe à vendre.
-13 Reste à faire
Ce site web utilise des cookies. Voir la politique sur les cookies.
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 = 73) AND (BlogCategories.BlogMainCategoryID = 2) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = 1) AND (Blogs.BlogID != ) AND (DatePublication < (select MAX(DatePublication) FROM Blogs WHERE Blogs.BlogCategoryID = 1)) 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 = 73) AND (BlogCategories.BlogMainCategoryID = 2) AND (Blogs.Status = 1) AND (Blogs.BlogCategoryID = 1) AND (Blogs.BlogID != ) AND (DatePublication < (select MAX(DatePublication) FROM Blogs WHERE Blogs.BlogCategoryID = 1)) 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
Une sélection unique d'appartements et de villas neufs de luxe à vendre.
Ce site web utilise des cookies. Voir la politique sur les cookies.