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

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


--# title: freshcode database schema
--# version: 0.7

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