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

the size of the result array is 3

the size of the diff result array is 0

The total results from the merged set is 3

The total number of rows in result set is 3

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('00558.amc', '00696.amc', '12995.amc') order by fileno

	Margarite-2M1
	Guggenheim S, Bailey S W
	American Mineralogist 60 (1975) 1023-1029
	Refinement of the margarite structure in subgroup symmetry
	_database_code_amcsd 0000477
	5.1038 8.8287 19.148 90 95.46 90 Cc
	atom x y z occ Biso
	Ca 0 .0932 .25 1.02
	Si1 .4647 .9285 .1416 .5 .99
	Si2 .5364 .0752 .8549 .5 .58
	Si3 .4567 .2572 .1444 .5 .61
	Si4 .5500 .7437 .8573 .5 .97
	Al1 .4647 .9285 .1416 .5 .99
	Al2 .5364 .0752 .8549 .5 .58
	Al3 .4567 .2572 .1444 .5 .61
	Al4 .5500 .7437 .8573 .5 .97
	Al5 .7469 .9187 .9997 .73
	Al6 .2510 .0863 .9998 .55
	H1 .3970 .6370 .0830 .78
	H2 .6030 .3630 .9170 .78
	O1 .9600 .4436 .0512 1.00
	O2 .0460 .5585 .9390 .50
	O3 .3950 .2540 .0568 .90
	O4 .6190 .7489 .9447 .70
	O5 .3670 .0974 .1775 1.10
	O6 .6410 .9167 .8226 .60
	O7 .2660 .7784 .1665 .50
	O8 .7110 .2140 .8304 1.10
	O9 .2870 .3926 .1785 .40
	O10 .7370 .6080 .8211 1.40
	O11 .4480 .5693 .0488 .40
	O12 .5430 .4417 .9468 1.00
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Margarite
	Guggenheim S, Bailey S W
	American Mineralogist 63 (1978) 186-187
	Refinement of the margarite structure in subgroup symmetry: correction,
	further refinement, and comments
	_database_code_amcsd 0000615
	5.104 8.829 19.148 90 95.5 90 Cc
	atom x y z occ Biso
	Ca 0 .0933 .25 .80
	Al1 .7449 .9177 .9996 .53
	Al2 .2488 .0858 -.0003 .44
	Si1 .4623 .9264 .1422 .5 .46
	Al1 .4623 .9264 .1422 .5 .46
	Si2 .4544 .2567 .1445 .5 .22
	Al2 .4544 .2567 .1445 .5 .22
	Si11 .5336 .0739 .8551 .5 .59
	Al11 .5336 .0739 .8551 .5 .59
	Si22 .5467 .7440 .8576 .5 .89
	Al22 .5467 .7440 .8576 .5 .89
	O1 .962 .4445 .0527 .50
	O2 .395 .2544 .0590 .50
	OH1 .449 .5696 .0507 .40
	O3 .366 .0974 .1781 .80
	O4 .267 .7782 .1682 .60
	O5 .289 .3924 .1788 .60
	O11 .045 .5614 .9401 .60
	O22 .618 .7502 .9468 .50
	OH11 .543 .4396 .9482 .80
	O33 .639 .9172 .8236 .50
	O44 .712 .2149 .8323 .60
	O55 .737 .6062 .8217 .70
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Margarite
	Joswig W, Takeuchi Y, Fuess H
	Zeitschrift fur Kristallographie 165 (1983) 295-303
	Neutron-diffraction study on the orientation of hydroxyl groups in margarite
	Locality: Greiner, Zillertal, Autria
	_database_code_amcsd 0019603
	5.108 8.844 19.156 90 95.48 90 Cc
	atom x y z occ U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Ca 0 .0929 .25 .725 .0090 .0112 .0112 -.0005 .0021 .0012
	Na 0 .0929 .25 .210 .0090 .0112 .0112 -.0005 .0021 .0012
	LiM1 .258 .242 .501 .105 .023 .023 .021 .005 .005 .001
	MgM1 .258 .242 .501 .105 .023 .023 .021 .005 .005 .001
	AlM2 .7480 .9169 .9998 .0025 .0047 .0058 .0001 .0007 .0000
	AlM3 .2522 .0851 .0003 .0052 .0042 .0054 .0018 .0003 -.0009
	AlT11 .4636 .9279 .1425 .0076 .0048 .0053 .0001 .0017 -.0005
	SiT12 .5350 .0747 .8553 .0023 .0044 .0062 -.0003 .0002 .0004
	SiT21 .4546 .2565 .14486 .0064 .0061 .0057 -.0002 .0003 -.0001
	AlT22 .5468 .7438 .8579 .0038 .0029 .0061 .0009 .0005 -.0004
	O11 .9611 .4455 .05259 .0065 .0067 .0069 -.0004 .0026 .0006
	O12 .0451 .5618 .94059 .0051 .0072 .0061 .0019 .0014 .0020
	O21 .3953 .2545 .06003 .0086 .0055 .0059 .0001 -.0023 -.0006
	O22 .6200 .7497 .94772 .0079 .0041 .0067 -.0012 .0006 -.0003
	O31 .3636 .0978 .17757 .0082 .0050 .0084 .0009 .0038 .0001
	O32 .6376 .9181 .82274 .0094 .0050 .0089 .0003 .0032 .0003
	O41 .2674 .7786 .16830 .0055 .0076 .0095 .0009 .0001 -.0018
	O42 .7122 .2156 .83231 .0053 .0070 .0109 .0029 .0007 -.0014
	O51 .2882 .3906 .17847 .0053 .0090 .0081 -.0018 -.0005 .0027
	O52 .7352 .6036 .82142 .0059 .0085 .0080 -.0013 .0000 .0019
	O61 .4547 .5670 .05169 .0065 .0090 .0069 -.0027 .0014 -.0016
	O62 .5489 .4361 .94891 .0073 .0087 .0100 -.0022 .0029 -.0033
	H11 .3663 .6550 .0620 .77 .016 .022 .061 -.018 .009 .004
	H12 .6325 .3452 .9396 .79 .033 .018 .056 -.011 .020 .002
	H21 .439 .591 .098 .21 .025 .053 .030 -.018 .016 -.001
	H22 .561 .399 .905 .21 .051 .044 .022 -.025 .019 -.035
	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 + '3' where hostname='18-97-9-168.crawl.commoncrawl.org'