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 'Ferri-pedrizite%')

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

	Ferri-pedrizite
	Caballero J M, Oberti R, Ottolini L
	American Mineralogist 87 (2002) 976-982
	Ferripedrizite, a new monoclinic Li amphibole end-member from the
	Eastern Pedriza Massif, Sierra de Guadarrama, Spain, and a restatement
	of the nomenclature of Mg-Fe-Mn-Li amphiboles
	Locality: Eastern Pedriza Massif, Sierra de Guadarrama, Spain
	_database_code_amcsd 0002869
	9.499 17.864 5.296 90 102.15 90 C2/m
	atom x y z occ Biso B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	O1 .1121 .0911 .2045 .61 .0014 .0005 .0064 -.0001 .0006 0
	O2 .1217 .1736 .7311 .68 .0016 .0007 .0059 .0001 .0007 .0001
	O3 .1145 0 .7011 .65 .94 .0024 .0007 .0096 0 .0002 0
	F3 .1145 0 .7011 .35 .94 .0024 .0007 .0096 0 .0002 0
	O4 .3747 .2503 .7826 .84 .0028 .0005 .0077 -.0004 .0004 .0001
	O5 .3545 .1295 .0639 .82 .0017 .0010 .0064 0 .0008 .0009
	O6 .3467 .1205 .5626 .90 .0020 .0011 .0057 .0001 .0003 -.0010
	O7 .3395 0 .2803 .90 .0024 .0004 .0125 0 .0008 0
	SiT1 .2856 .0864 .2779 .44 .0013 .0003 .0040 0 .0003 -.0001
	SiT2 .2967 .1713 .7867 .46 .0014 .0004 .0040 -.0001 .0003 0
	MgM1 0 .0878 .5 .74 .62 .0020 .0005 .0051 0 .0011 0
	FeM1 0 .0878 .5 .26 .62 .0020 .0005 .0051 0 .0011 0
	FeM2 0 .1810 0 .85 .53 .0014 .0004 .0048 0 .0004 0
	AlM2 0 .1810 0 .10 .53 .0014 .0004 .0048 0 .0004 0
	TiM2 0 .1810 0 .04 .53 .0014 .0004 .0048 0 .0004 0
	ZnM2 0 .1810 0 .01 .53 .0014 .0004 .0048 0 .0004 0
	LiM3 0 0 0 .64 .69 .0023 .0004 .0063 0 .0003 0
	FeM3 0 0 0 .29 .69 .0023 .0004 .0063 0 .0003 0
	MnM3 0 0 0 .07 .69 .0023 .0004 .0063 0 .0003 0
	NaM4 0 .2636 .5 .12 1.93 .0033 .0031 .0072 0 .0026 0
	CaM4 0 .2636 .5 .02 1.93 .0033 .0031 .0072 0 .0026 0
	LiM4' 0 .2454 .5 .85 1.05
	NaAm .0720 .5 .1453 .26 2.68 .0114 .0120 .0325 0 .0149 0
	KAm .0720 .5 .1453 .02 2.68 .0114 .0120 .0325 0 .0149 0
	H .1877 0 .7657 .65 .91
	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='216.73.216.159'

Line 943: Update statistic set count=count + '1' where hostname='216.73.216.159'