gistfile1.txt

SELECT
	stars.name,
	obs.id,
	fit_gridchi_1.vcorr,
	fit_gridchi_1.teff,
	fit_gridchi_1.logg,
	fit_gridchi_1.feh,
	fit_gridchi_1.chi,
	fit_minuit_1.teff,
	fit_minuit_1.logg,
	fit_minuit_1.feh,
	fit_minuit_1.chi,
	stelparam_phot.teff,
	stelparam_laird.teffvk,
	stelparam_laird.fehvk

	from spectra

	inner join stars
		on spectra.star_id=stars.id
	inner join obs
		on spectra.obs_id=obs.id
	inner join stars
		on spectra.star_id
	inner join fit_gridchi_1
		on spectra.id=fit_gridchi_1.id
	inner join fit_minuit_1
		on spectra.id=fit_minuit_1.id
	left join stelparam_phot
		on spectra.star_id=stelparam_phot.id

	left join stelparam_laird
		on spectra.star_id=stelparam_laird.star_id
	order by stars.name