aud14_ldascore.sql

select 	
a1.docid, 	
topic0score, 	
topic1score, 	
topic2score, 	
word as doc 	
from ( 	
	select 
	docid, 
	max(case when topicid=0 then score else null end) as topic0score, 
	max(case when topicid=1 then score else null end) as topic1score, 
	max(case when topicid=2 then score else null end) as topic2score 
	from jumbo.aud13_ldascore 
	group by 1 
) a1 left outer join ( 	
	select 
	docid, 
	word 
	from jumbo.aud11_denorm
) a2 	
on a1.docid=a2.docid 	
order by 1 	
;