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

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

	(Na.98Mg.02)(Mg.51Si.49)Si2O6
	Yang H, Konzett J, Frost D J, Downs R T
	American Mineralogist 94 (2009) 942-949
	X-ray diffraction and Raman spectroscopic study of clinopyroxenes with six-coordinated
	Si in the Na(Mg0.5Si0.5)Si2O6 - NaAlSi2O6 system
	Note: Sample J1
	_database_code_amcsd 0004950
	9.4051 8.6436 5.2679 90 108.142 90 P2/n
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	NaM2 .75 .05151 .25 .96 .01059 .01223 .00892 .00861 0 .00034 0
	MgM2 .75 .05151 .25 .04 .01059 .01223 .00892 .00861 0 .00034 0
	NaM21 .75 .45644 .75 .01549 .02062 .00885 .01238 0 -.00158 0
	MgM1 .75 .65466 .25 .00688 .00701 .00636 .00695 0 .00170 0
	SiM11 .75 .84705 .75 .98 .00518 .00512 .00464 .00572 0 .00158 0
	SiM1 .75 .84705 .75 .98 .00518 .00512 .00464 .00572 0 .00158 0
	Si1 .04470 .84848 .22631 .00592 .00581 .00573 .00601 -.00043 .00155 -.00017
	Si2 .03724 .66527 .73569 .00596 .00566 .00589 .00625 .00031 .00177 .00045
	O1 .86221 .84423 .10170 .00747 .00594 .00877 .00694 -.00063 .00089 -.00056
	O2 .85625 .69303 .65646 .00731 .00551 .00827 .00832 .00058 .00238 -.00034
	O3 .12357 .01500 .30692 .00848 .00990 .00644 .00931 -.00196 .00331 -.00028
	O4 .09819 .49496 .79057 .01087 .01193 .00868 .01200 .00181 .00371 .00040
	O5 .11251 .76685 .01196 .00858 .00757 .01000 .00807 -.00009 .00230 -.00205
	O6 .09258 .75262 .50666 .00841 .00836 .00957 .00743 -.00124 .00267 .00180
	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'