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

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

	Chayesite
	Alietti E, Brigatti M F, Capedri S, Poppi L
	Mineralogical Magazine 58 (1994) 655-662
	The roedderite-chayesite series from Spanish lamproites:
	crystal chemical characterization
	Locality: Cancarix, Albacete province, Spain
	_database_code_amcsd 0014512
	10.128 10.128 14.312 90 90 120 P6/mcc
	atom x y z occ Biso B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	KC 0 0 .25 .85 1.76 .005199 .005199 .002526 .002600 0 0
	NaC 0 0 .25 .15 1.76 .005199 .005199 .002526 .002600 0 0
	NaB 1/3 2/3 0 .07 .8
	MgA 1/3 2/3 .25 .84 .89 .002307 .002307 .001513 .001170 0 0
	Fe3+A 1/3 2/3 .25 .16 .89 .002307 .002307 .001513 .001170 0 0
	MgT2 .5 .5 .25 .84 .89 .001722 .004679 .001221 .002340 0 0
	Fe3+T2 .5 .5 .25 .16 .89 .001722 .004679 .001221 .002340 0 0
	SiT1 .23803 .35318 .39069 .78 .002145 .002437 .001208 .001300 .000119 .000159
	O1 .1304 .3947 0 1.63 .006337 .005037 .001697 .002827 0 0
	O2 .2198 .2781 .13350 1.49 .004419 .005459 .002221 .003412 .000000 -.000020
	O3 .1553 .4971 .17254 1.07 .002925 .003087 .001623 .001462 -.000239 -.000478
	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-80.crawl.commoncrawl.org'

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