SELECT project.judul, projectcategory.category
FROM "projectcategory"
JOIN project on projectcategory.project_id=project.id 
WHERE projectcategory.category='Redesign'