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