-

SELECT targets.id, targets.name, traits.id, traits.name
FROM Traits INNER JOIN People AS targets ON
targets.id != me
LEFT OUTER JOIN Opinions AS ops ON
ops.person_id = me AND
ops.trait_id = traits.id AND
ops.about_id = targets.id
GROUP BY targets.id, traits.id
HAVING(MAX(ops.update_at)
WHERE ops.rating IS NULL 
ORDER BY targets.name, traits.name

LEFT OUTER JOIN skips ON
skips.from_id = me AND
skips.about_id = targets.id AND
skips.trait_id
WHERE skips.id IS NULL














ActiveRecord::Base.connection.execute(“SELECT targets.id, targets.name, traits.id, traits.name FROM Traits INNER JOIN People AS targets LEFT OUTER JOIN Opinions AS ops ON ops.person_id = 7 AND ops.trait_id = traits.id AND ops.about_id = targets.id WHERE ops.rating IS NULL GROUP BY targets.id, traits.id HAVING(MAX(ops.update_at)) ORDER BY targets.name, traits.name”)