SELECT
project.ProjectID,
project.ProjectCategory,
project.ProjectName,
project.Slug,
project.City,
project.Country,
project.ScopeOfService,
project.ProjectOwner,
project.BuiltArea,
project.ConstructionCost,
project.WorksPhoto,
project.ProjectStatus
FROM
project
WHERE
project.ProjectStatus = 'Open' AND
(project.ProjectCategory like '4' OR
project.ProjectCategory like '4,%' OR
project.ProjectCategory like '%,4,%' OR
project.ProjectCategory like '%,4')
ORDER BY project.Ordering-
-