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, 12

You 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
Bestand " /home/luxevastgo/domains/luxevastgoed.be/public_html/core/frontend/blog/blogs.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/luxevastgo/domains/luxevastgoed.be/public_html/core/frontend/blog/blogs.php op lijn 217
Implementatie bestand /home/luxevastgo/domains/luxevastgoed.be/public_html/core/frontend/blog/blogcontroller.php op lijn 246immodeluxe.fr

Projets exclusifs de nouvelles constructions

Une sélection unique d'appartements et de villas neufs de luxe à vendre.

min

-13 Reste à faire

De nouvelles constructions à un niveau élevé.

Vous cherchez une nouvelle villa ou un nouvel appartement ? Découvrez sur lprojetsdeluxe.be une sélection unique de projets immobiliers neufs exclusifs à vendre. Tous les projets sont efficaces sur le plan énergétique et équipés des derniers gadgets. Toujours conçus par des architectes ayant le souci du détail.

420 PropriétésBientôt disponible

Ce site web utilise des cookies. Voir la politique sur les cookies.