        SELECT *,
               MAX( t_changed ) AS _order
          FROM release_ordered
-        WHERE NOTdeleted
+        WHERE NOT deleted
         GROUP BY name,
                  version
         ORDER BY t_published DESC;

#
# title: freshcode database schema
# version: 0.6
#

CREATE TABLE [release] ( 
    name              VARCHAR( 100 )     NOT NULL,

    image             TEXT,
    social_links      INT                DEFAULT ( 0 ),
    submitter_image   VARCHAR( 200 ),
    via               VARCHAR( 16 ),
    editor_note       TEXT,
    autoupdate_delay  REAL,
    CONSTRAINT 'release_revisions' UNIQUE ( name, version COLLATE 'NOCASE', t_published, t_changed ) 
);

