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 ( ( contents LIKE '%_database_code_amcsd%') AND ( contents LIKE '%0004315%') )

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 ('04346.amc') order by fileno

	Metaschoepite
	Klingensmith A L, Deely K M, Kinman W S, Kelly V, Burns P C
	American Mineralogist 92 (2007) 662-669
	Neptunium incorporation in sodium-substituted metaschoepite
	Locality: Katanga, Congo
	Sample: Natural
	_database_code_amcsd 0004315
	14.6801 14.0287 16.7196 90 90 90 Pbcn
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Na21 .503 .672 .295 .24 .040
	U1 .23381 .74397 .37478 .01545 .0264 .00816 .0118 -.00032 .0002 -.00215
	U2 .28634 .76845 .60325 .01605 .0315 .00797 .00865 .0026 -.0018 -.00103
	U3 .25577 .51214 .23933 .01607 .0328 .0084 .00695 .0007 -.0014 .00036
	U4 .25591 .51731 .51083 .01707 .0316 .00946 .0101 -.0007 .0015 .00165
	O1 .1748 .7406 .6145 .035
	O2 .1475 .4622 .2320 .032
	O3 .1206 .7443 .4156 .026
	O4 .4098 .7847 .5967 .019
	O5 .3678 .5610 .2511 .024
	O6 .1391 .5483 .5295 .021
	O7 .3420 .7440 .3315 .028
	O8 .3699 .4841 .4895 .026
	O9 .2517 .9229 .6173 .0184
	OH10 .2082 .3619 .4680 .020
	OH11 .2928 .6751 .4885 .028
	OH12 .2144 .5628 .3722 .0140
	OH13 .3117 .6015 .6385 .017
	OH14 .1883 .6854 .2439 .0148
	OH15 .1894 .8851 .3128 .016
	Wat16A 0 .7528 .25 .59 .040
	Wat16B 0 .659 .25 .47 .040
	Wat17 .4994 .4181 .1441 .78 .040
	Wat18 -.0195 .6443 .5691 .94 .040
	Wat19 .0268 .5492 .3679 .81 .040
	Wat20 .4972 .6469 .4223 .63 .040
	Wat22 .5 .794 .25 .53 .040
	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='18-97-9-168.crawl.commoncrawl.org'

Line 943: Update statistic set count=count + '1' where hostname='18-97-9-168.crawl.commoncrawl.org'