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

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

	Phosphuranylite
	Piret P, Piret-Meunier J
	European Journal of Mineralogy 3 (1991) 69-77
	Composition chimique et structure cristalline
	de la phosphuranylite Ca(UO2)[(UO2)3(OH)2(PO4)2]2.12H2O
	_database_code_amcsd 0006412
	15.835 17.324 13.724 90 90 90 Bmmb
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	U1 .2095 1/4 .1158 .011 .0154 .0096 .0088 0 .0023 0
	U2 .2439 .1399 .3726 .010 .0153 .0067 .0072 .0014 -.0030 .0004
	P3 .1876 .0609 .1229 .003
	O4 .325 1/4 .137 .031
	O5 .095 1/4 .103 .013
	O6 .349 .143 .320 .036
	O7 .139 .130 .415 .029
	O8 .209 .117 .035 .023
	O9 .198 .113 .215 .026
	O10 .246 .005 .374 .020
	O11 .098 .028 .110 .036
	OH12 .198 1/4 .294 .041
	OH13 .267 1/4 .453 .000
	Wat14 1/2 1/4 .227 .044
	Wat15 1/2 1/4 .420 .049
	Wat16 1/2 1/4 .800 .144
	U17 1/2 0 1/2 .018 .0165 .0137 .0221 0 0 .0020
	Ca18 1/2 .082 -.031 .5 .021
	O19 1/2 .095 .457 .023
	Wat20 1/2 .078 -.215 .5 .03
	Wat21 1/2 -.072 .220 .5 .03
	Wat22 .411 .029 .098 .5 .03
	Wat23 .412 -.040 -.073 .5 .03
	Wat24 1/2 .214 -.001 .5 .055
	Wat25 1/2 -.084 -.232 .5 .03
	Wat26 1/2 .080 .255 .5 .03
	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'