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 '10' OR
project.ProjectCategory like '10,%' OR
project.ProjectCategory like '%,10,%' OR
project.ProjectCategory like '%,10')
ORDER BY project.Ordering-
-