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

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

	Allanite-subgroup mineral
	Bonazzi P, Holtstam D, Bindi L, Nysten P, Capitani G
	American Mineralogist 94 (2009) 121-134
	Multi-analytical approach to solve the puzzle of an allanite-subgroup mineral
	from Kesebol, Vastra Gotaland, Sweden
	Locality: Kesebol, Vastra Gotaland, Sweden
	Note: K3-600 sample
	_database_code_amcsd 0004811
	8.908 5.711 10.314 90 115.38 90 P2_1/m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	MnA1 .76168 .75 .15039 .54656 .01684 .02236 .01385 .01801 0 .01216 0
	CaA1 .76168 .75 .15039 .45344 .01684 .02236 .01385 .01801 0 .01216 0
	CaA2 .60820 .75 .42438 .76712 .01802 .01606 .02067 .01387 0 .00314 0
	CeA2 .60820 .75 .42438 .23288 .01802 .01606 .02067 .01387 0 .00314 0
	FeM2 0 0 .5 .18596 .01319 .01057 .01278 .01469 .00179 .00395 -.00105
	AlM2 0 0 .5 .81404 .01319 .01057 .01278 .01469 .00179 .00395 -.00105
	AlM1 0 0 0 .24310 .01213 .00987 .00967 .01381 -.00066 .00219 -.00037
	MnM1 0 0 0 .75690 .01213 .00987 .00967 .01381 -.00066 .00219 -.00037
	MnM3 .30147 .25 .22049 .93882 .01325 .01003 .01042 .01424 0 .00037 0
	AlM3 .30147 .25 .22049 .06118 .01325 .01003 .01042 .01424 0 .00037 0
	Si1 .34442 .75 .04252 .01155 .00955 .00885 .01373 0 .00257 0
	Si2 .68914 .25 .27190 .01318 .01030 .01221 .01611 0 .00480 0
	Si3 .19046 .75 .32413 .01075 .00823 .01016 .01281 0 .00351 0
	O1 .24088 .99254 .03566 .02022 .01709 .01281 .02997 .00002 .00933 .00243
	O2 .31508 .97693 .36053 .01702 .01368 .02035 .01832 -.00286 .00810 -.00023
	O3 .79955 .01496 .33049 .02017 .01659 .01085 .02579 -.00056 .00217 -.00122
	O4 .05838 .25 .13034 .01493 .01261 .01082 .01785 0 .00319 0
	O5 .04673 .75 .15481 .01682 .01324 .01677 .01639 0 .00247 0
	O6 .08076 .75 .41720 .01652 .01433 .01329 .02419 0 .01040 0
	O7 .51862 .75 .17982 .01973 .01525 .01714 .01678 0 -.00268 0
	O8 .53927 .25 .31983 .02807 .02053 .03859 .03382 0 .01996 0
	O9 .61385 .25 .09667 .02805 .03261 .03486 .01896 0 .01323 0
	O10 .09308 .25 .44164 .01654 .01386 .01494 .02306 0 .01005 0
	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-81.crawl.commoncrawl.org'

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