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

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

	Poyarkovite
	Vasil'ev V I, Pervukhina N V, Romanenko G V, Magarill S A, Borisov S V
	The Canadian Mineralogist 37 (1999) 119-126
	New data on the mercury oxide-chloride mineral poyarkovite: The second
	find, and crystal-structure determination
	_database_code_amcsd 0005596
	19.009 9.018 16.848 90 110.82 90 C2/c
	atom x y z Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Hg1 .6637 .1301 .8657 .016 .015 .008 .021 .001 .003 -.001
	Hg2 .6635 -.1476 .8439 .022 .033 .010 .022 -.001 .010 -.001
	Hg3 .8349 .1199 .9722 .014 .016 .021 .007 -.005 .007 .002
	Hg4 .8275 .1254 .8198 .017 .024 .022 .008 .000 .009 -.002
	Hg5 .9038 .4620 .9640 .019 .008 .021 .024 -.007 .001 -.005
	Hg6 .7667 .5162 .8913 .033 .013 .051 .025 .022 -.005 -.011
	Hg7 .0152 .1381 .0116 .025 .022 .009 .041 .001 .008 -.002
	Hg8 .9320 .0144 .2021 .032 .005 .057 .032 -.008 .004 -.014
	Hg9 .0111 .3740 .1792 .015 .015 .024 .008 -.004 .005 -.002
	Cl1 .8501 .8127 .0185 .036 .040 .039 .036 -.001 .024 .002
	Cl2 .9693 .3066 .8472 .013 .021 .005 .011 -.008 .006 -.004
	Cl3 .6673 .2863 .7133 .023 .035 .006 .029 -.008 .012 .001
	O1 .0098 .3625 .0550 .013 .009 .021 .007 -.005 .001 -.004
	O2 .6664 .3333 .9064 .030 .033 .033 .019 -.004 .003 -.004
	O3 .6677 .6060 .8105 .018 .013 .015 .027 -.009 .010 -.005
	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.165'

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