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 ( Mineral LIKE 'Schreyerite%')

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

	Schreyerite
	Dobelin N, Reznitsky L Z, Sklyarov E V, Armbruster T, Medenbach O
	American Mineralogist 91 (2006) 196-202
	Schreyerite, V2Ti3O9: New occurrence and crystal structure
	Locality: Sludyanka complex at the southern shore of Lake Baikal, Russia
	_database_code_amcsd 0004005
	17.102 5.0253 7.0579 90 106.636 90 C2/c
	atom x y z occ Biso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	V3 -.07555 -.5010 .10036 .893 .612 .0101 .0068 .0053 -.0011 .0005 .0003
	Cr3 -.07555 -.5010 .10036 .079 .612 .0101 .0068 .0053 -.0011 .0005 .0003
	Fe3 -.07555 -.5010 .10036 .018 .612 .0101 .0068 .0053 -.0011 .0005 .0003
	Ti1 0 0 0 .845 .233 .0035 .0021 .0032 .0003 .0009 .0000
	V1 0 0 0 .156 .233 .0035 .0021 .0032 .0003 .0009 .0000
	Ti2 -.21608 .0067 -.07227 .845 .560 .0072 .0058 .0074 .0007 .0007 -.0011
	V2 -.21608 .0067 -.07227 .156 .560 .0072 .0058 .0074 .0007 .0007 -.0011
	O1 -.1085 .1585 -.0203 .47 .0040 .0049 .0089 -.0005 .0017 -.0008
	O2 -.1742 -.3316 .0731 .50 .0055 .0051 .0091 .0005 .0034 .0004
	O3 -.0474 -.3463 -.1300 .40 .0061 .0041 .0051 -.0004 .0016 -.0006
	O4 -.2262 -.1679 -.3190 .52 .0081 .0063 .0058 -.0016 .0025 -.0005
	O5 0 .1965 -.25 .37 .007 .003 .0039 0 .0018 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-80.crawl.commoncrawl.org'

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