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

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

	Wadalite
	Tsukimura K, Kanazawa Y, Aoki M, Bunno M
	Acta Crystallographica C49 (1993) 205-207
	Structure of wadalite Ca6Al5Si2O16Cl3
	Note: the values for the anisoU's are from ICSD
	_database_code_amcsd 0010280
	12.001 12.001 12.001 90 90 90 I-43d
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Ca .1043 0 .25 .96 .0086 .0082 .0092 .0084 0 0 .0110
	Mg .1043 0 .250 .04 .0086 .0082 .0092 .0084 0 0 .0110
	AlT1 -.0169 -.0169 -.0169 .60 .0065 .0065 .0065 .0065 .0005 .0005 .0005
	SiT1 -.0169 -.0169 -.0169 .28 .0065 .0065 .0065 .0065 .0005 .0005 .0005
	FeT1 -.0169 -.0169 -.0169 .12 .0065 .0065 .0065 .0065 .0005 .0005 .0005
	AlT2 .375 0 .25 .68 .0066 .0016 .0090 .0090 0 0 0
	SiT2 .375 0 .25 .32 .0066 .0016 .0090 .0090 0 0 0
	O1 .0628 .0628 .0628 .0178 .0178 .0178 .0178 .0096 .0096 .0096
	O2 .0308 .0500 .6488 .0120 .0088 .0122 .0151 .0020 .0014 -.0005
	Cl .125 .5 .25 .92 .0189 .0078 .0244 .0244 0 0 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-9-175.crawl.commoncrawl.org'

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