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

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

	Lyonsite
	Hughes J M, Starkey S J, Malinconico M L, Malinconico L L
	American Mineralogist 72 (1987) 1000-1005
	Lyonsite, Cu3Fe4(VO4)6, a new fumarolic sublimate from Izalco
	volcano, El Salvador: Descriptive mineralogy and crystal structure
	_database_code_amcsd 0001127
	10.296 17.207 4.910 90 90 90 Pmcn
	atom x y z occ B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Cu1 .75 .7497 .9080 .59 .0017 .00064 .071 0 0 .0026
	Cu2 .25 .82189 .2113 .00219 .00151 .0131 0 0 -.0039
	Fe .42409 .97289 .2476 .00136 .00034 .0044 .00007 -.0002 -.0002
	V1 .25 .05727 -.2293 .0026 .00082 .0083 0 0 .0006
	V2 .4716 .84431 .7208 .00191 .00067 .0073 .00039 -.0002 -.0001
	O1 .6129 .7959 .6585 .0033 .0007 .013 .0003 .001 .0006
	O2 .3859 .8739 .4245 .0026 .0009 .009 -.0005 -.002 -.0018
	O3 .25 .9940 .053 .0044 .0013 .011 0 0 -.001
	O4 .3849 .0358 .5747 .0051 .0010 .011 -.0009 .004 -.0017
	O5 .5054 .9272 .9130 .0025 .0009 .011 .0003 .001 .0013
	O6 .75 .6531 .656 .0033 .0015 .012 0 0 .001
	O7 .3766 .7917 -.0738 .0034 .0010 .012 .0011 .002 -.0010
	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-81.crawl.commoncrawl.org'

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