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

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

	Na2(Mn5.26Na0.74)Ge6O20
	Redhammer G J, Roth G, Topa D, Amthauer G
	Acta Crystallographica C64 (2008) i21-i26
	Synthetic aenigmatite analog Na2(Mn5.26Na0.74)Ge6O20: structure and
	crystal chemical considerations
	Locality: synthetic
	T = 295 K
	_database_code_amcsd 0010341
	10.5578 11.1532 9.1833 106.707 95.809 124.367 P-1
	atom x y z occ U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Na2 -.2913 .6300 .3830 .0121 .0151 .0181 .0066 .0062 .0087
	Na3 .1629 .6118 .3735 .0147 .0229 .0167 .0101 .0052 .0111
	Mn1 .5 1 .5 .0094 .0107 .0071 .0031 .0030 .0064
	Mn2 .5 .5 1 .0103 .0095 .0096 .0031 .0037 .0065
	Mn3 .80868 .84635 .17711 .0099 .0105 .0112 .0041 .0042 .0071
	Mn4 .09944 .94628 .06221 .0120 .0123 .0124 .0058 .0045 .0078
	Mn5 .27496 .82376 .15887 .0111 .0127 .0112 .0062 .0049 .0082
	Mn6 .5914 .9367 .0598 .26 .0070 .0117 .0124 .0073 .0033 .0041
	Na1 .5914 .9367 .0598 .74 .0070 .0117 .0124 .0073 .0033 .0041
	Mn7 .48962 .72991 .26696 .0104 .0094 .0081 .0043 .0044 .0075
	Ge1 -.28732 .65515 .75805 .0088 .0103 .0094 .0040 .0033 .0057
	Ge2 .02820 .76641 .66405 .0119 .0126 .0109 .0045 .0038 .0079
	Ge3 .22611 .65845 .77842 .0121 .0113 .0136 .0042 .0042 .0073
	Ge4 .52220 .76621 .65123 .0096 .0103 .0092 .0040 .0025 .0058
	Ge5 .14459 .94746 .44097 .0113 .0088 .0077 .0032 .0046 .0066
	Ge6 .13837 .43761 .95231 .0123 .0081 .0101 .0043 .0059 .0072
	O1 -.1603 .8260 .9343 .014 .012 .010 .001 .001 .009
	O2 -.4430 .4863 .7740 .011 .016 .019 .009 .007 .008
	O3 -.1672 .6197 .6601 .010 .009 .017 .004 .007 .008
	O4 -.3812 .6809 .6131 .017 .018 .013 .004 .005 .016
	O5 .1456 .9424 .8332 .009 .013 .010 .003 .000 .006
	O6 .1127 .6663 .6312 .017 .017 .016 .011 .006 .014
	O7 -.0049 .7949 .4918 .006 .006 .013 .004 .005 .001
	O8 .3359 .8265 .9539 .014 .012 .016 .003 .001 .005
	O9 .0851 .4857 .7990 .012 .009 .017 .005 .005 .006
	O10 .3482 .6272 .6897 .011 .012 .017 .006 .007 .005
	O11 .6506 .9432 .8198 .017 .007 .015 .002 -.001 .005
	O12 .4491 .7753 .4796 .016 .012 .014 .010 .007 .011
	O13 .2601 1.1278 .6108 .010 .011 .019 .006 .005 .005
	O14 .2624 .8848 .3878 .018 .016 .012 .005 .007 .011
	O15 .0458 .9541 .2858 .023 .015 .010 .006 .005 .014
	O16 .2449 .6064 1.1332 .022 .017 .016 .006 .005 .012
	O17 -.0447 .2791 .9562 .024 .011 .023 .007 .012 .012
	O18 .2631 .3879 .8904 .015 .013 .006 .003 .003 .009
	O19 .4982 .9240 .2855 .015 .017 .009 .004 .001 .006
	O20 .5601 .7103 .0796 .026 .016 .015 .003 .000 .013
	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-170.crawl.commoncrawl.org'

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