|
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
|
|
|
|
)
|
|
|
|
|
