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 '%0004319%') )

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 ('04350.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: synthetic
	Sample: Na-Ms-AB2
	_database_code_amcsd 0004319
	14.6592 14.0358 16.7148 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 .510 .684 .276 .235 .040
	U1 .23414 .74380 .374763 .01425 .0197 .01137 .01163 -.00003 -.00099 -.00143
	U2 .28636 .76851 .60317 .01568 .0250 .01074 .01126 .00214 -.00102 -.00153
	U3 .25637 .51220 .239215 .01576 .0276 .01094 .00872 .00096 -.00104 .00007
	U4 .25652 .51717 .51109 .01603 .0249 .01192 .01126 -.00124 .00134 .00111
	O1 .1683 .7458 .6126 .032 .031 .015 .049 -.001 -.011 -.002
	O2 .1452 .4616 .2319 .0290 .035 .031 .021 .003 -.004 -.004
	O3 .1225 .7450 .4163 .0202 .017 .021 .022 .000 .005 .005
	O4 .4057 .7845 .5964 .0194 .020 .015 .023 -.004 .000 .003
	O5 .3699 .5601 .2511 .0228 .031 .013 .025 -.003 -.004 .000
	O6 .1407 .5489 .5293 .0266 .027 .027 .026 .000 .003 -.006
	O7 .3449 .7463 .3310 .0261 .020 .031 .027 .001 .002 -.012
	O8 .3721 .4840 .4895 .0293 .022 .041 .026 .005 -.002 .003
	O9 .2524 .9225 .6175 .029 .063 .010 .013 .005 .003 -.001
	OH10 .2053 .3617 .4685 .0187 .037 .007 .012 .003 .007 .002
	OH11 .2966 .6736 .4881 .040 .091 .016 .012 -.008 -.026 .003
	OH12 .2123 .5634 .3726 .0179 .035 .012 .007 .008 .002 .002
	OH13 .3123 .6005 .6387 .0168 .030 .009 .011 -.004 -.001 .001
	OH14 .1869 .6830 .2435 .0169 .022 .016 .012 -.007 -.001 -.001
	OH15 .1880 .8848 .3135 .0180
	Wat16A 0 .751 .25 .380 .040
	Wat16B 0 .6543 .25 .48 .040
	Wat17 .5004 .4164 .1427 .681 .040
	Wat18 -.0234 .6449 .5705 .801 .040
	Wat19 .0294 .5496 .3701 .777 .040
	Wat20 .4959 .6404 .4199 .597 .040
	Wat22 .5 .8089 .25 .51 .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-14-80.crawl.commoncrawl.org'

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