All pastes #931314 Raw Edit

Unnamed

public sql v1 · immutable
·published 2008-03-07 02:26 UTC
rendered paste body
select count(asac1.abssolutionid) from abstractcomponent ac1inner join abssolutionabscomponent asac1 on asac1.abscompid = ac1.idinner join abssolutionabscomponent asac2 on asac1.abssolutionid = asac2.abssolutionidinner join abstractcomponent ac2 on ac2.id = asac2.abscompidwhere(	asac1.weightfraction = .9 and	(		ac1.inchistring = 'H2O' or		((ac1.inchistring is null or ac1.inchistring = '') and ac1.name = 'Water')	) 	and	asac2.weightfraction = .1 and	(		ac2.inchistring = 'KCl' or		((ac2.inchistring is null or ac2.inchistring = '') and ac2.name = 'Potassium Chloride')	))