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 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 (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 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 (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

Projets

min

Voir

Trier par région

Tous les sitesLa CôteAnversFlandre orientaleBruxelles Flandre occidentale

Charger plus de projets-13 Reste à faire

528 PropriétésBientôt disponible

• Belgique
• France
• Espagne

• les Pays-bas

• Luxembourg

• nl
• fr
• en

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

Accepter