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

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 ('18294.amc', '18414.amc', '18415.amc', '19296.amc') order by fileno

	Buttgenbachite
	Fanfani L, Nunzi A, Zanazzi P F, Zanzari A R
	Mineralogical Magazine 39 (1973) 264-270
	The crystal structure of buttgenbachite
	Locality: Likasi, Congo
	_database_code_amcsd 0014460
	15.750 15.750 9.161 90 90 120 P6_3/mmc
	atom x y z occ Biso
	Cu1 .5 0 0 .72
	Cu2 .2012 0 0 .87
	Cu3 .3352 .1676 .75 .82
	Cu4 .3589 .0166 .25 .97
	Cu5 0 0 0 .30 2.36
	Cl1 .2764 .1382 .25 1.14
	Cl2 2/3 1/3 .25 .35 3.69
	N 2/3 1/3 .0557 .65 4.66
	OH1 .4507 .3697 .0880 .88
	OH2 .0743 -.0743 .0961 1.21
	OH3 .6744 .7441 .1094 1.15
	OH4 .4454 .5546 .25 1.88
	Oa .7123 .2877 .0748 .47 2.73
	Ob .6227 .3773 .0335 .18 3.55
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Buttgenbachite
	Hibbs D E, Leverett P, Williams P A
	Mineralogical Magazine 67 (2003) 47-60
	A single crystal X-ray study of a sulphate-bearing buttgenbachite,
	Cu36Cl7.8(NO3)1.3(SO4)0.35(OH)62.2*5.2H2O, and a re-examination
	of the crystal chemistry of the buttgenbachite-connellite series
	Locality: Likasi, Democratic Republic of Congo
	Note: T = 100 K
	_database_code_amcsd 0018302
	15.739 15.739 9.127 90 90 120 P6_3/mmc
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 .5 0 0 .010 .008 .011 .012 .005 -.001 -.002
	Cu2 .2013 0 0 .011 .011 .009 .011 .004 .001 .002
	Cu3 .3360 .1680 .75 .008 .011 .007 .008 .006 0 0
	Cu4 .3590 .0175 .25 .009 .007 .009 .008 .002 0 0
	Cl3 0 0 0 .6 .016 .014 .014 .020 .007 0 0
	Cl1 .2772 .1386 .25 .014 .015 .011 .016 .008 0 0
	OH1 .4505 .3699 .0899 .011 .010 .010 .011 .005 .001 .001
	OH2 .0750 -.0750 .0985 .021 .014 .014 .023 -.001 .005 -.005
	OH3 .6743 .7443 .1094 .010 .012 .010 .010 .006 .001 .001
	OH4 .4444 .5556 .25 .029 .046 .046 .015 .040 0 0
	Wat1 .5070 .2536 .75 .18 .026
	N1 2/3 1/3 .25 .18 .022
	Cl4 2/3 1/3 .25 .30 .022
	O1a .6222 .3778 .25 .18 .017
	O1b .6153 .3847 .25 .18 .017
	S1 2/3 1/3 .3040 .09 .020
	O1c 2/3 1/3 .0320 .09 .020
	N2 2/3 1/3 .0860 .24 .022
	Wat2 2/3 1/3 .0860 .06 .022
	O2 .7113 .2887 .0860 .24 .022
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Buttgenbachite
	Hibbs D E, Leverett P, Williams P A
	Mineralogical Magazine 67 (2003) 47-60
	A single crystal X-ray study of a sulphate-bearing buttgenbachite,
	Cu36Cl7.8(NO3)1.3(SO4)0.35(OH)62.2.5.2H2O, and a re-examination
	of the crystal chemistry of the buttgenbachite-connellite series
	Locality: Likasi, Democratic Republic of Congo
	Note: T = 288 K
	_database_code_amcsd 0018303
	15.739 15.739 9.127 90 90 120 P6_3/mmc
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 .5 0 0 .013 .009 .013 .017 .007 -.001 -.003
	Cu2 .2014 0 0 .013 .012 .012 .016 .006 .001 .003
	Cu3 .3355 .1677 .75 .011 .014 .009 .011 .007 0 0
	Cu4 .3592 .0172 .25 .012 .009 .012 .012 .002 0 0
	Cl3 0 0 0 .60 .020 .024 .024 .014 .012 0 0
	Cl1 .2773 .1387 .25 .021 .021 .014 .030 .010 0 0
	OH1 .4503 .3703 .0918 .013 .008 .014 .015 .004 .003 .004
	OH2 .0749 -.0749 .0993 .024 .021 .021 .024 .004 .004 -.004
	OH3 .6744 .7452 .1101 .011 .014 .011 .011 .009 .002 .003
	OH4 .4437 .5563 .25 .25 .037 .058 .058 .017 .045 0 0
	Wat1 .5080 .2540 .75 .18 .030
	N1 2/3 1/3 .25 .18 .028
	Cl4 2/3 1/3 .25 .30 .028
	O1a .6226 .3774 .25 .18 .032
	O1b .6155 .3845 .25 .18 .032
	S1 2/3 1/3 .3045 .09 .022
	O1c 2/3 1/3 .0320 .09 .022
	N2 2/3 1/3 .100 .24 .028
	Wat2 2/3 1/3 .100 .06 .028
	O2 .7115 .2885 .100 .24 .029
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Buttgenbachite
	Hibbs D E, Leverett P, Williams P A
	Neues Jahrbuch fur Mineralogie, Monatshefte 2002 (2002) 225-240
	Buttgenbachite from Bisbee, Arizona, USA: A single-crystal X-ray study
	Locality: Bisbee, Arizona, USA
	_database_code_amcsd 0014920
	15.739 15.739 9.127 90 90 120 P6_3/mmc
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Cu1 .5 0 0 .011 .010 .014 .012 .007 -.001 -.002
	Cu2 .2014 0 0 .011 .012 .010 .011 .005 .001 .002
	Cu3 .3357 .16785 .75 .010 .013 .009 .009 .007 0 0
	Cu4 .3586 .0165 .25 .010 .008 .011 .008 .002 0 0
	Cl1 .2768 .1384 .25 .014 .016 .011 .016 .008 0 0
	Cl3 0 0 0 .5 .015 .013 .013 .019 .006 0 0
	OH1 .4501 .3699 .0912 .012 .015 .011 .009 .006 .003 .001
	OH2 .0753 -.0753 .0991 .021 .014 .014 .023 -.002 .005 -.005
	OH3 .6737 .7441 .1097 .012 .014 .012 .011 .008 .001 .001
	OH4 .4423 .5577 .25 .009 .021 .021 .000 .021 0 0
	N1 2/3 1/3 .25 .5 .013
	Cl2 2/3 1/3 .25 .5 .013
	O1 .6216 .3784 .25 .011
	Wat .5100 .2552 .8070 .1 .011
	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-86.crawl.commoncrawl.org'

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