SELECT Applications.*,
Applications.NameTranslations AS MultiNameTranslations ,ApplicationCategories.Name AS CategoryName,
ApplicationCategories.NameTranslations AS CategoryNameTranslations,
ApplicationCategories.ApplicationCategoryID AS CategoryID,ApplicationMainCategories.Name AS MainCategoryName,
ApplicationMainCategories.NameTranslations AS MainCategoryNameTranslations,
ApplicationMainCategories.Description AS MainCategoryDescription,
ApplicationMainCategories.DescriptionTranslations AS MainCategoryDescriptionTranslations,
ApplicationMainCategories.ApplicationMainCategoryID AS MainCategoryID,Applications.RepositoryFileID,
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 ParentDirIDName FROM Applications LEFT JOIN ApplicationCategories ON ApplicationCategories.ApplicationCategoryID = Applications.ApplicationCategoryID LEFT JOIN ApplicationMainCategories ON ApplicationMainCategories.ApplicationMainCategoryID = ApplicationCategories.ApplicationMainCategoryID INNER JOIN RepositoryFiles ON Applications.RepositoryFileID = RepositoryFiles.RepositoryFileID INNER JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID INNER JOIN PageApplications ON PageApplications.ApplicationID = Applications.ApplicationID WHERE PageApplications.PageID = AND Applications.Status = 1
SELECT Applications.*,
Applications.NameTranslations AS MultiNameTranslations ,ApplicationCategories.Name AS CategoryName,
ApplicationCategories.NameTranslations AS CategoryNameTranslations,
ApplicationCategories.ApplicationCategoryID AS CategoryID,ApplicationMainCategories.Name AS MainCategoryName,
ApplicationMainCategories.NameTranslations AS MainCategoryNameTranslations,
ApplicationMainCategories.Description AS MainCategoryDescription,
ApplicationMainCategories.DescriptionTranslations AS MainCategoryDescriptionTranslations,
ApplicationMainCategories.ApplicationMainCategoryID AS MainCategoryID,Applications.RepositoryFileID,
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 ParentDirIDName FROM Applications LEFT JOIN ApplicationCategories ON ApplicationCategories.ApplicationCategoryID = Applications.ApplicationCategoryID LEFT JOIN ApplicationMainCategories ON ApplicationMainCategories.ApplicationMainCategoryID = ApplicationCategories.ApplicationMainCategoryID INNER JOIN RepositoryFiles ON Applications.RepositoryFileID = RepositoryFiles.RepositoryFileID INNER JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID INNER JOIN PageApplications ON PageApplications.ApplicationID = Applications.ApplicationID WHERE PageApplications.PageID = AND Applications.Status = 1
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 Applications.Status = 1' at line 19 Bestand " /home/artimpex/domains/cryonomic.com/public_html/frontend/flexibles/multi.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/artimpex/domains/cryonomic.com/public_html/frontend/flexibles/multi.php op lijn 218
Implementatie bestand /home/artimpex/domains/cryonomic.com/public_html/pages/product_detail.php op lijn 105Artimpex