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

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

	Anorthite
	Wenk H R, Joswig W, Tagai T, Korekawa M, Smith B K
	American Mineralogist 65 (1980) 81-95
	The average structure of An 62-66 labradorite
	Note: studied with X-rays
	Locality: Surtsey, Iceland
	_database_code_amcsd 0019662
	8.1736 12.8736 7.1022 93.462 116.054 90.475 C-1
	atom x y z occ B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Ca1 .2665 .9862 .1649 .325 .0047 .0095 .0156 -.0023 0.0048 -.0074
	Na1 .2665 .9862 .1649 .160 .0047 .0095 .0156 -.0023 0.0048 -.0074
	Ca2 .2723 .0306 .0952 .325 .0034 .00276 .0087 0.00127 0.0011 -.00157
	Na2 .2723 .0306 .0952 .160 .0034 .00276 .0087 0.00127 0.0011 -.00157
	Si1 .00632 .16304 .21518 .595 .0033 .0012 .0042 -.00043 0.00153 0.00022
	Al1 .00632 .16304 .21518 .405 .0033 .0012 .0042 -.00043 0.00153 0.00022
	Si2 .00264 .81626 .23099 .595 .00342 .00126 .00389 0.00090 0.00145 0.00020
	Al2 .00264 .81626 .23099 .405 .00342 .00126 .00389 0.00090 0.00145 0.00020
	Si3 .68589 .10882 .31775 .595 .0030 .00091 .0062 0.00024 0.00144 0.00013
	Al3 .68589 .10882 .31775 .405 .0030 .00091 .0062 0.00024 0.00144 0.00013
	Si4 .68100 .87870 .35715 .595 .0025 .0007 .0049 0.00017 0.00128 0.00043
	Al4 .68100 .87870 .35715 .405 .0025 .0007 .0049 0.00017 0.00128 0.00043
	Oa1 .0042 .1290 .9811 .0114 .00287 .0080 0.00101 0.0058 0.00086
	Oa2 .5798 .9914 .2789 .0043 .00146 .0099 0.00017 0.0026 0.00079
	Obo .8131 .1037 .1886 .0082 .00192 .0147 -.00041 0.0067 -.00031
	Obm .8156 .8532 .2435 .0082 .00269 .0212 0.00081 0.0079 -.00070
	Oco .0139 .2895 .2818 .0072 .00242 .0122 -.00056 0.0045 0.00048
	Ocm .0125 .6869 .2133 .0074 .00244 .0097 0.00181 0.0021 -.00020
	Odo .1979 .1073 .3822 .0070 .00226 .0086 0.00060 0.0015 0.00050
	Odm .1900 .8661 .4292 .0075 .00263 .0118 0.00085 -.0001 -.00062
	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-173.crawl.commoncrawl.org'

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