current_projects | Lists a user 's active github projects | Awesome List library

Since this is one rather long question-thank in advance to those who bother to read it! I am doing a personal blog website project, and in the index page, I want to achieve a slideshow header (contains a background picture, a title and a button redirecting user to the actual psot) to display featured blog posts dynamically. I also wanted fade-in effect when the header transform into another one. My html for the header looks like this:

I'm trying to write a report that lists all the rows from a master table and inserts a field ("Y"/"N") if the key exists in a current-use table. For example, the COLOR_MASTER table has 256 colors by COLOR_NAME (field/key). The CURRENT_PROJECTS has a row for each project and the COLOR_NAME (field). I want to list all the COLOR_MASTER rows and then on the same print line a "Y" or "N" if that COLOR_NAME is used in the CURRENT_PROJECTS table.

I've tried to mess around with it in the Design View and have had no luck. The JOIN that was created looks basically like this and how I want the report is following the dashes:

I'm using the Bullet gem to see where there are n+1 queries in my application. It's telling me to eager load my association taggings when calling my serializer. My code looks something like this:

I have a Project Model where a user can add a Project with an associated Position(s) for the Project. As an example, Website would be project whereas web developer would be the Position. Here are two models.