SELECT artist.id                 AS artistid,
       artist.name               AS artistname,
       artist.username           AS artistnick,
       artist.email              AS email,
       artist.contactmethod      AS contactmethod,
       artist.doesprojectwork    AS doesprojectwork,
       track.id                  AS id,
       track.online              AS online,
       track.title               AS title,
       track.duration            AS duration,
       track.bpm                 AS bpm,
       track.genre               AS genreid,
       genre.genre               AS genre,
       track.category            AS categoryid,
       category.category         AS category,
       track.mood                AS mood,
       track.section             AS section,
       track.description         AS description,
       track.freewarelicense     AS freewarelicense,
       track.nonexclusivelicense AS nonexclusivelicense,
       track.exclusivelicense    AS exclusivelicense,
       file.url                  AS url,
       file.tag                  AS tag,
       file.filesize             AS filesize,
       file.filetype             AS filetypeid,
       filetype.filetype         AS filetype,
       file.resolution           AS resolution,
       file.frequency            AS frequency,
       file.channels             AS channels,
       file.polyphony            AS polyphony,
       file.nonexclusiveprice    AS nonexclusiveprice,
       file.exclusiveprice       AS exclusiveprice,
       file.note                 AS filenote,
       preview.name              AS previewname,
       preview.url               AS previewurl,
       preview.note              AS previewnote,
       file.id                   AS fileid
FROM   artist,
       track,
       file,
       filetype,
       genre,
       category
       LEFT JOIN preview
              ON file.id = preview.fileid
WHERE  artist.id = track.artistid
       AND category.id = track.category
       AND genre.id = track.genre
       AND track.id = file.trackid
       AND file.filetype = filetype.id
       AND track.id = 1013
ORDER  BY title ASC,
          filetype ASC,
          preview.name ASC