gistfile1.txt

    WITH d AS
      (
        SELECT *
        FROM atable
        WHERE date >= CURRENT_TIMESTAMP - INTERVAL '1 YEAR'
      )
    SELECT *
    FROM d
    UNION ALL
    SELECT *
    FROM atable
    WHERE date < CURRENT_TIMESTAMP - INTERVAL '1 YEAR'
    ORDER BY date DESC
    LIMIT GREATEST(0, 50 - (SELECT COUNT(*) FROM d)) ;