SELECT 'daDiff' AS "cassette",
                                "date" + INTERVAL '1 day' AS "date"
                                FROM core_dev."times_raw"
        WHERE "action" = 'lmp'
          AND "date" + INTERVAL '1 day' NOT IN
                (SELECT DISTINCT "date" FROM core_dev."times_cassette"
                WHERE "cassette" = 'daDiff')
          AND "date" >= '2016-10-28'
          AND "date" <= '2016-10-27'

SELECT 'Random' AS "cassette",
                                "date" + INTERVAL '1 day' AS "date"
                                FROM core_dev."times_raw"
        WHERE "action" = 'lmp'
          AND "date" + INTERVAL '1 day' NOT IN
                (SELECT DISTINCT "date" FROM core_dev."times_cassette"
                WHERE "cassette" = 'Random')
          AND "date" >= '2016-10-28'
          AND "date" <= '2016-10-27'

SELECT 'xDelta' AS "cassette",
                                "date" + INTERVAL '1 day' AS "date"
                                FROM core_dev."times_raw"
        WHERE "action" = 'lmp'
          AND "date" + INTERVAL '1 day' NOT IN
                (SELECT DISTINCT "date" FROM core_dev."times_cassette"
                WHERE "cassette" = 'xDelta')
          AND "date" >= '2016-10-28'
          AND "date" <= '2016-10-27'

SELECT '30Day' AS "cassette",
                                "date" + INTERVAL '1 day' AS "date"
                                FROM core_dev."times_raw"
        WHERE "action" = 'lmp'
          AND "date" + INTERVAL '1 day' NOT IN
                (SELECT DISTINCT "date" FROM core_dev."times_cassette"
                WHERE "cassette" = '30Day')
          AND "date" >= '2016-10-28'
          AND "date" <= '2016-10-27'

SELECT 'da2Trend' AS "cassette",
                                "date" + INTERVAL '1 day' AS "date"
                                FROM core_dev."times_raw"
        WHERE "action" = 'lmp'
          AND "date" + INTERVAL '1 day' NOT IN
                (SELECT DISTINCT "date" FROM core_dev."times_cassette"
                WHERE "cassette" = 'da2Trend')
          AND "date" >= '2016-10-28'
          AND "date" <= '2016-10-27'

SELECT "cassette",
                                                                                r."date" AS "date"
                    FROM core_dev."times_raw" r, core_dev."times_cassette" c
                    WHERE r."action" = 'lmp'
                      AND c.cassette IN ('daDiff','Random','xDelta','30Day','da2Trend')
                      AND r."date" = c."date"
                      AND r."calc_time" > c."time"
                      AND r."date" >= '2016-10-28'
                      AND r."date" <= '2016-10-27'