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

the size of the result array is 4

the size of the diff result array is 0

The total results from the merged set is 4

The total number of rows in result set is 4

The paginate value is 1

entering paginate loop

The total number to display on this page is 4 4 matching records for this search.

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('00106.amc', '10986.amc', '12629.amc', '15060.amc') order by fileno

	Valentinite
	Buerger M J
	American Mineralogist 21 (1936) 206-207
	The crystal structure of valentinite
	_database_code_amcsd 0000015
	4.92 12.46 5.42 90 90 90 Pccn
	atom x y z
	Sb .1215 .207 .175
	O1 .25 .25 -.075
	O2 -.110 .156 .175
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Valentinite
	Svensson C
	Acta Crystallographica B30 (1974) 458-461
	The crystal structure of orthorhombic antimony trioxide, Sb2O3
	Locality: synthetic
	_database_code_amcsd 0009500
	4.911 12.464 5.412 90 90 90 Pccn
	atom x y z B(1,1) B(2,2) B(3,3) B(1,2) B(1,3) B(2,3)
	Sb .04149 .12745 .17845 .01221 .00174 .00620 .00097 .00074 .00051
	O1 .25 .25 .0229 .0250 .0015 .0040 -.0005 0 0
	O2 .1520 .0591 -.1446 .0121 .0017 .0073 -.0017 -.0042 .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)
	Valentinite
	Buerger M J, Hendricks S B
	Zeitschrift fur Kristallographie 98 (1938) 1-30
	The crystal structure of valentinite
	_database_code_amcsd 0010568
	4.92 12.46 5.42 90 90 90 Pccn
	atom x y z
	Sb .0444 .1283 .179
	O1 .25 .25 -.075
	O2 .147 .058 -.139
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Valentinite
	Whitten A E, Dittrich B, Spackman M A, Turner P, Brown T C
	Dalton Transactions 2004 (2004) 23-29
	Charge density analysis of two polymorphs of antimony(III) oxide
	_database_code_amcsd 0012431
	4.8996 12.4490 5.4103 90 90 90 Pccn
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Sb .040642 .127526 .177835 .00479 .00502 .00545 .00390 .00117 .00046 .00064
	O1 .2500 .2500 .0209 .00781 .0121 .0066 .0047 -.0026 0 0
	O2 .15086 .05868 -.14535 .00629 .0074 .0066 .0049 -.00145 .00144 -.00092
	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.171'

Line 943: Update statistic set count=count + '4' where hostname='216.73.216.171'