select

3 as type,
snDatabase.AUID as db_id,
fldTitle as title,
fldArtistName as artist,
snCat1.fldMusicType as category,
snCat2.fldMusicType as attrib_Attr2,
snCat3.fldMusicType as attrib_Attr3,
snCat1b.fldMusicType as attrib_Attr4,
snCat1c.fldMusicType as attrib_Attr5,

fldYear as year_num,
snVocalPresent.fldVocalPresent as attrib_Vocal,

'd:\tmp\jazz' + right(fldFilename,len(fldFilename) - 17) as file_full_name,

clng(fldStartPos*1000) as start_ms,
clng(fldDuration*1000) as duration_ms,
clng(fldIntroPos*1000) as intro1_ms,
clng((fldStartPos+fldDuration-fldMixPos)*1000) as start_next_ms,

clng(fldFadeInDur*1000) as fade_in_ms,
clng(fldFadeDur*1000) as fade_out_ms,

'7' as modify_str_1

from (
     (((((snDatabase left join snCat1 on snCat1.auid=snDatabase.fldCat1a)
     left join snCat2 on snCat2.auid=snDatabase.fldCat2)
     left join snCat3 on snCat3.auid=snDatabase.fldCat3)
     left join snCat1 as snCat1b on snCat1b.auid=snDatabase.fldCat1b)
     left join snCat1 as snCat1c on snCat1c.auid=snDatabase.fldCat1c)
     left join snVocalPresent on snVocalPresent.auid=snDatabase.fldVocalPresent

)


