|
1
|
select
|
|
2
|
|
|
3
|
3 as type,
|
|
4
|
snDatabase.AUID as db_id,
|
|
5
|
fldTitle as title,
|
|
6
|
fldArtistName as artist,
|
|
7
|
snCat1.fldMusicType as category,
|
|
8
|
snCat2.fldMusicType as attrib_Attr2,
|
|
9
|
snCat3.fldMusicType as attrib_Attr3,
|
|
10
|
snCat1b.fldMusicType as attrib_Attr4,
|
|
11
|
snCat1c.fldMusicType as attrib_Attr5,
|
|
12
|
|
|
13
|
fldYear as year_num,
|
|
14
|
snVocalPresent.fldVocalPresent as attrib_Vocal,
|
|
15
|
|
|
16
|
'd:\tmp\jazz' + right(fldFilename,len(fldFilename) - 17) as file_full_name,
|
|
17
|
|
|
18
|
clng(fldStartPos*1000) as start_ms,
|
|
19
|
clng(fldDuration*1000) as duration_ms,
|
|
20
|
clng(fldIntroPos*1000) as intro1_ms,
|
|
21
|
clng((fldStartPos+fldDuration-fldMixPos)*1000) as start_next_ms,
|
|
22
|
|
|
23
|
clng(fldFadeInDur*1000) as fade_in_ms,
|
|
24
|
clng(fldFadeDur*1000) as fade_out_ms,
|
|
25
|
|
|
26
|
'7' as modify_str_1
|
|
27
|
|
|
28
|
from (
|
|
29
|
(((((snDatabase left join snCat1 on snCat1.auid=snDatabase.fldCat1a)
|
|
30
|
left join snCat2 on snCat2.auid=snDatabase.fldCat2)
|
|
31
|
left join snCat3 on snCat3.auid=snDatabase.fldCat3)
|
|
32
|
left join snCat1 as snCat1b on snCat1b.auid=snDatabase.fldCat1b)
|
|
33
|
left join snCat1 as snCat1c on snCat1c.auid=snDatabase.fldCat1c)
|
|
34
|
left join snVocalPresent on snVocalPresent.auid=snDatabase.fldVocalPresent
|
|
35
|
|
|
36
|
)
|
|
37
|
|
|
38
|
|
