Grab single model SNe spectrum of the model type DD2D 2.5 days after explosion and at a viewing angle ~99

select m.m_id,m.t_expl,m.mu,f.luminosity from jonasb.meta_dd2d as m, jonasb.fluxvals as f where m.t_expl=2.5 and floor(m.mu)=99 and m.m_id=f.m_id;

 

Grab all model SNe spectra of the model type DD2D 2.5 days after explosion

select m.m_id,m.t_expl,m.mu,f.wavelength, f.luminosity from jonasb.meta_dd2d as m, jonasb.fluxvals as f where m.t_expl=2.5 and m.m_id=f.m_id;

 

 

 

 

Grab 5 random model SNe spectra of the model type DD2D

select m.m_id,m.t_expl,m.mu,f.wavelength, f.luminosity from jonasb.meta_dd2d as m, jonasb.fluxvals as f where m.m_id in (1,100,500,1000) and m.m_id=f.m_id order by m.m_id,f.wavelength;