The query is now

select distinct Amc_Table.fileno from Amc_Table LEFT JOIN Amc_Author ON Amc_Table.fileno=Amc_Author.fileno LEFT JOIN atomic_data ON Amc_Table.fileno = atomic_data.fileno WHERE ( Mineral LIKE 'Brandtite%')

the size of the result array is 2

the size of the diff result array is 0

The total results from the merged set is 2

The total number of rows in result set is 2

The paginate value is 1

entering paginate loop

The total number to display on this page is 2 2 matching records for this search.

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('06947.amc', '14401.amc') order by fileno

	Brandtite
	Herwig S, Hawthorne F C
	The Canadian Mineralogist 44 (2006) 1181-1196
	The topology of hydrogen bonding in brandtite, collinsite and fairfieldite
	Locality: Harstig mine, Harstigen, Sweden
	_database_code_amcsd 0006117
	5.877 12.957 5.675 90 108.00 90 P2_1/c
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	CaX .56763 .11965 .24347 .95 .0095 .0095 .0091 .0101 -.0011 .0034 -.0012
	PbX .56763 .11965 .24347 .05 .0095 .0095 .0091 .0101 -.0011 .0034 -.0012
	MnM 0 0 0 .88 .0094 .0096 .0089 .0093 -.0009 .0023 -.0041
	MgM 0 0 0 .10 .0094 .0096 .0089 .0093 -.0009 .0023 -.0041
	FeM 0 0 0 .01 .0094 .0096 .0089 .0093 -.0009 .0023 -.0041
	AsT .22243 .12174 .57383 .00639 .00747 .00533 .00581 .00010 .00123 .00021
	O1 .2445 .03619 .3558 .0119 .0128 .0120 .0111 -.0019 .0040 -.0061
	O2 .2883 .05599 .8451 .0094 .0096 .0090 .0077 -.0000 .0000 .0034
	O3 .9499 .17265 .5022 .0110 .0084 .0092 .0139 .0034 .0013 .0005
	O4 .4404 .20712 .5795 .0099 .0098 .0084 .0112 -.0038 .0028 -.0010
	OW .8087 .14270 .9719 .0099 .0132 .0089 .0067 -.0020 .0018 .0005
	H1 .685 .150 .811 .037
	H2 .907 .205 .987 .028
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Brandtite
	Dahlman B
	Arkiv for Mineralogi och Geologi 1 (1952) 339-366
	The crystal structures of krohnkite, CuNa2(SO4)2*2H2O and brandtite, MnCa2(AsO4)2*2H2O
	Locality: Harstigen mine, Sweden
	_database_code_amcsd 0012042
	5.65 12.80 5.65 90 80.5 90 P2_1/c
	atom x y z
	Mn 0 0 0
	Ca .428 .120 .253
	As .777 .122 .566
	O1 .048 .165 .522
	O2 .694 .055 .816
	O3 .756 .030 .336
	O4 .559 .208 .566
	Wat .208 .136 .935
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)

Download in: Amc Format Cif Format Diffraction data

Multiple datasets can be concatenated into a single downloadable file by selecting the datasets and then clicking

Multiple datasets can be downloaded as individual files inside a ZIP archive by selecting the datasets and then clicking

Line 935: Select count from statistic where hostname='216.73.216.218'

Line 943: Update statistic set count=count + '2' where hostname='216.73.216.218'