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

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

	Olenite
	Hughes J M, Ertl A, Dyar M D, Grew E S, Wieden-beck M, Brandstatter F
	American Mineralogist 89 (2004) 447-454
	Structural and chemical response to varying B content in zoned Fe-bearing olenite
	from Koralpe, Austria
	Sample: T4
	Locality: Koralpe, Austria
	_database_code_amcsd 0003448
	15.8472 15.8472 7.0988 90 90 120 R3m
	atom x y z occ Uiso
	NaX 0 0 .25 .545 .0178
	CaX 0 0 .25 .245 .0178
	AlY .12142 .06071 -.33189 .597 .0098
	Fe2Y .12142 .06071 -.33189 .223 .0098
	LiY .12142 .06071 -.33189 .075 .0098
	MgY .12142 .06071 -.33189 .013 .0098
	Mn2Y .12142 .06071 -.33189 .007 .0098
	TiY .12142 .06071 -.33189 .004 .0098
	AlZ .29709 .26061 -.36039 .0087
	SiT .19179 .18986 .03137 .892 .0074
	AlT .19179 .18986 .03137 .045 .0074
	BeT .19179 .18986 .03137 .004 .0074
	BT .19179 .18986 .03137 .059 .0074
	B .10938 .21876 .48285 .0090
	O1 0 0 -.1930 .75 .0257
	OH1 0 0 -.1930 .25 .0257
	O2 .06044 .12088 .5170 .0184
	O3 .2634 .13169 -.4615 .0145
	O4 .09357 .18715 .1045 .0135
	O5 .1862 .09310 .1264 .0142
	O6 .19538 .18497 -.1950 .0108
	O7 .28663 .28622 .1084 .0101
	O8 .20935 .27011 .4685 .0106
	H3 .262 .131 .416 .05
	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'