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 'Jahnsite-(NaMnMg)%')

the size of the result array is 1

the size of the diff result array is 0

The total results from the merged set is 1

The total number of rows in result set is 1

The paginate value is 1

entering paginate loop

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

the file_query is

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

	Jahnsite-(NaMnMg)
	Kampf A R, Elliott P, Nash B P, Chiappino L, Varvello S
	The Canadian Mineralogist 56 (2018) 871-882
	Jahnsite-(NaMnMg), a new jahnsite-group mineral from the Sapucaia mine, Brazil
	and the White Rock No. 2 quarry, Australia
	Locality: Sapucaia mine, Brazil
	_database_code_amcsd 0020883
	15.1045 7.1629 9.8949 90 110.640 90 P2/a
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	NaX .25 .97021 0 .569 .0264 .0260 .0173 .0278 0 -.0005 0
	CaX .25 .97021 0 .277 .0264 .0260 .0173 .0278 0 -.0005 0
	MnX .25 .97021 0 .154 .0264 .0260 .0173 .0278 0 -.0005 0
	MnM1 .25 .47232 0 .601 .01254 .0114 .0130 .0140 0 .0055 0
	FeM1 .25 .47232 0 .375 .01254 .0114 .0130 .0140 0 .0055 0
	MgM1 .25 .47232 0 .024 .01254 .0114 .0130 .0140 0 .0055 0
	MgM2a .5 0 .5 .712 .0174 .0179 .0147 .0168 .0000 .0027 -.0042
	MnM2a .5 0 .5 .151 .0174 .0179 .0147 .0168 .0000 .0027 -.0042
	FeM2a .5 0 .5 .137 .0174 .0179 .0147 .0168 .0000 .0027 -.0042
	MgM2b .25 .50365 .5 .809 .0140 .0142 .0147 .0133 0 .0050 0
	FeM2b .25 .50365 .5 .106 .0140 .0142 .0147 .0133 0 .0050 0
	MnM2b .25 .50365 .5 .055 .0140 .0142 .0147 .0133 0 .0050 0
	FeM3a 0 0 0 .896 .01090 .0108 .0080 .0133 -.00013 .0036 -.00082
	AlM3a 0 0 0 .104 .01090 .0108 .0080 .0133 -.00013 .0036 -.00082
	FeM3b 0 .5 0 .940 .01133 .0108 .0092 .0149 -.00015 .0057 -.00010
	AlM3b 0 .5 0 .060 .01133 .0108 .0092 .0149 -.00015 .0057 -.00010
	P1 .18573 .26411 .18734 .01379 .0117 .0151 .0134 .0008 .0030 -.0021
	P2 .08097 .74458 .79732 .01281 .0123 .0136 .0129 .0014 .0049 .0008
	O1 .27677 .2399 .1503 .0296 .0188 .0477 .0225 .0134 .0074 .0049
	O2 .20817 .3055 .3443 .0243 .0320 .0239 .0159 .0004 .0070 -.0031
	O3 .12452 .0910 .1425 .0272 .0252 .0172 .0272 -.0017 -.0057 .0013
	O4 .13985 .4343 .08528 .0174 .0116 .0162 .0233 .0004 .0047 -.0010
	O5 .18557 .6787 .8580 .0241 .0148 .0329 .0232 .0071 .0050 .0017
	O6 .05501 .7822 .6377 .0214 .0274 .0193 .0159 .0012 .0056 .0027
	O7 .07671 .9239 .87932 .0218 .0281 .0168 .0269 -.0024 .0177 -.0022
	O8 .01684 .5929 .82168 .0201 .0230 .0182 .0219 -.0020 .0114 .0003
	Oh .02733 .7508 .0972 .0174 .0204 .0125 .0204 .0006 .0086 -.0007
	H .000 .752 .151 .026
	OW1 .22565 .7237 .3433 .0307 .0380 .0306 .0286 .0091 .0182 .0068
	H1A .258 .726 .292 .037
	H1B .1705 .746 .271 .037
	OW2 .44911 .2141 .3462 .0349 .0364 .0302 .0249 -.0055 -.0057 .0034
	H2A .473 .232 .284 .042
	H2B .3926 .214 .283 .042
	OW3 .62887 .9899 .4598 .0350 .0332 .0315 .0440 -.0026 .0183 -.0124
	H3A .655 1.007 .541 .042
	H3B .643 .914 .420 .042
	OW4 .39097 .5131 .5159 .0265 .0199 .0268 .0327 -.0012 .0093 .0094
	H4A .405 .591 .478 .032
	H4B .425 .477 .587 .032
	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.159'

Line 943: Update statistic set count=count + '1' where hostname='216.73.216.159'