SELECT
       				Jobs.JobID,
					JobMainCategories.JobMainCategoryID,
					JobCategories.JobCategoryID,      				
       				Staff.StaffID AS StaffID,
       				Regions.RegionID,
       				Jobs.Name,
       				Jobs.NameTranslations,
       				JobMainCategories.Name AS MainCategoryName,
       				JobMainCategories.NameTranslations AS MainCategoryNameTranslations,
       				JobCategories.Name AS CategoryName,
       				JobCategories.NameTranslations AS CategoryNameTranslations,
       				Staff.Name AS StaffName,
       				Regions.Name AS Region,
       				Regions.NameTranslations AS RegionTranslations,
       				NULL AS RequiredLanguages,
       				NULL AS ContractTypes,
       				Jobs.*
				FROM Jobs
				INNER JOIN JobCategories ON Jobs.JobCategoryID = JobCategories.JobCategoryID
				INNER JOIN JobMainCategories ON JobCategories.JobMainCategoryID = JobMainCategories.JobMainCategoryID
				LEFT JOIN Staff ON Jobs.StaffID = Staff.StaffID
				LEFT JOIN LanguagesJobLinks ON Jobs.JobID = LanguagesJobLinks.JobID
				LEFT JOIN Languages ON LanguagesJobLinks.LanguageID = Languages.LanguageID
				LEFT JOIN Regions ON Jobs.RegionID = Regions.RegionID
				LEFT JOIN ContractTypeLinks ON ContractTypeLinks.JobID = Jobs.JobID
                LEFT JOIN ContractTypes ON ContractTypeLinks.ContractTypeID = ContractTypes.ContractTypeID
                LEFT JOIN JobSectors ON Jobs.JobSectorID = JobSectors.JobSectorID
                LEFT JOIN TranslationLanguagesJobLinks ON Jobs.JobID = TranslationLanguagesJobLinks.JobID
                LEFT JOIN TranslationLanguages on TranslationLanguagesJobLinks.TranslationLanguageID = TranslationLanguages.TranslationLanguageID WHERE (Jobs.Status = 1) AND (Jobs.JobID != ) AND (JobMainCategories.JobMainCategoryID = ) AND (TranslationLanguages.Code = "en") GROUP BY Jobs.JobID ORDER BY Jobs.Position LIMIT 0, 3
SELECT
       				Jobs.JobID,
					JobMainCategories.JobMainCategoryID,
					JobCategories.JobCategoryID,      				
       				Staff.StaffID AS StaffID,
       				Regions.RegionID,
       				Jobs.Name,
       				Jobs.NameTranslations,
       				JobMainCategories.Name AS MainCategoryName,
       				JobMainCategories.NameTranslations AS MainCategoryNameTranslations,
       				JobCategories.Name AS CategoryName,
       				JobCategories.NameTranslations AS CategoryNameTranslations,
       				Staff.Name AS StaffName,
       				Regions.Name AS Region,
       				Regions.NameTranslations AS RegionTranslations,
       				NULL AS RequiredLanguages,
       				NULL AS ContractTypes,
       				Jobs.*
				FROM Jobs
				INNER JOIN JobCategories ON Jobs.JobCategoryID = JobCategories.JobCategoryID
				INNER JOIN JobMainCategories ON JobCategories.JobMainCategoryID = JobMainCategories.JobMainCategoryID
				LEFT JOIN Staff ON Jobs.StaffID = Staff.StaffID
				LEFT JOIN LanguagesJobLinks ON Jobs.JobID = LanguagesJobLinks.JobID
				LEFT JOIN Languages ON LanguagesJobLinks.LanguageID = Languages.LanguageID
				LEFT JOIN Regions ON Jobs.RegionID = Regions.RegionID
				LEFT JOIN ContractTypeLinks ON ContractTypeLinks.JobID = Jobs.JobID
                LEFT JOIN ContractTypes ON ContractTypeLinks.ContractTypeID = ContractTypes.ContractTypeID
                LEFT JOIN JobSectors ON Jobs.JobSectorID = JobSectors.JobSectorID
                LEFT JOIN TranslationLanguagesJobLinks ON Jobs.JobID = TranslationLanguagesJobLinks.JobID
                LEFT JOIN TranslationLanguages on TranslationLanguagesJobLinks.TranslationLanguageID = TranslationLanguages.TranslationLanguageID WHERE (Jobs.Status = 1) AND (Jobs.JobID != ) AND (JobMainCategories.JobMainCategoryID = ) AND (TranslationLanguages.Code = "en") GROUP BY Jobs.JobID ORDER BY Jobs.Position LIMIT 0, 3
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 (JobMainCategories.JobMainCategoryID = ) AND (TranslationLanguages.Code = ' at line 30
Bestand " /home/rainbow/domains/rainbowgroup.be/public_html/core/frontend/jobs/jobs.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/rainbow/domains/rainbowgroup.be/public_html/core/frontend/jobs/jobs.php op lijn 137
Implementatie bestand /home/rainbow/domains/rainbowgroup.be/public_html/pages/jobs_detail.php op lijn 51
SELECT
       				JobMainCategories.*,
       				RepositoryFiles.RepositoryDirectoryID,
					RepositoryFiles.Name as FileName,
					RepositoryFiles.Width,
					RepositoryFiles.Height,
					RepositoryFiles.Extension,
					RepositoryFiles.ResizeSizes,
					RepositoryFiles.OriginalResized,
                    IF (ParentDirectory.RepositoryDirectoryID IS NULL, Directory.Name, CONCAT(ParentDirectory.Name,'/',Directory.Name)) AS FolderName,
					Directory.RepositoryDirectoryID AS CurrentDirID,
					ParentDirectory.RepositoryDirectoryID AS ParentDirID,
					NULL AS JobCategories,
       				NULL AS Photos
				FROM Jobs
				INNER JOIN JobCategories ON Jobs.JobCategoryID = JobCategories.JobCategoryID
				INNER JOIN JobMainCategories ON JobCategories.JobMainCategoryID = JobMainCategories.JobMainCategoryID
				INNER JOIN RepositoryFiles ON JobMainCategories.RepositoryFileID = RepositoryFiles.RepositoryFileID
				LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
                LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID WHERE (JobMainCategories.JobMainCategoryID = ) GROUP BY JobMainCategories.JobMainCategoryID ORDER BY JobMainCategories.Position
SELECT
       				JobMainCategories.*,
       				RepositoryFiles.RepositoryDirectoryID,
					RepositoryFiles.Name as FileName,
					RepositoryFiles.Width,
					RepositoryFiles.Height,
					RepositoryFiles.Extension,
					RepositoryFiles.ResizeSizes,
					RepositoryFiles.OriginalResized,
                    IF (ParentDirectory.RepositoryDirectoryID IS NULL, Directory.Name, CONCAT(ParentDirectory.Name,'/',Directory.Name)) AS FolderName,
					Directory.RepositoryDirectoryID AS CurrentDirID,
					ParentDirectory.RepositoryDirectoryID AS ParentDirID,
					NULL AS JobCategories,
       				NULL AS Photos
				FROM Jobs
				INNER JOIN JobCategories ON Jobs.JobCategoryID = JobCategories.JobCategoryID
				INNER JOIN JobMainCategories ON JobCategories.JobMainCategoryID = JobMainCategories.JobMainCategoryID
				INNER JOIN RepositoryFiles ON JobMainCategories.RepositoryFileID = RepositoryFiles.RepositoryFileID
				LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
                LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID WHERE (JobMainCategories.JobMainCategoryID = ) GROUP BY JobMainCategories.JobMainCategoryID ORDER BY JobMainCategories.Position
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 ') GROUP BY JobMainCategories.JobMainCategoryID ORDER BY JobMainCategories.Positi' at line 20
Bestand " /home/rainbow/domains/rainbowgroup.be/public_html/core/frontend/jobs/jobmaincategories.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/rainbow/domains/rainbowgroup.be/public_html/core/frontend/jobs/jobmaincategories.php op lijn 122
Implementatie bestand /home/rainbow/domains/rainbowgroup.be/public_html/pages/jobs_detail.php op lijn 71
Rainbowgroup
1

This job offering is not available in your language

This job is currently not available in the selected language, check our other related jobs or choose another language.

This website uses cookies. Read our cookie policy.