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

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

	Vicanite-(Ce)
	Ballirano P, Callegari A, Caucia F, Maras A, Mazzi F, Ungaretti L
	American Mineralogist 87 (2002) 1139-1143
	The crystal structure of vicanite - (Ce), a borosilicate showing an unusual
	(Si3B3O18) polyanion
	_database_code_amcsd 0002883
	10.8112 10.8112 27.3296 90 90 120 R3m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	CeM1 -.13188 .13188 -.31881 .751 .0096 .0092 .0092 .0087 .0033 .0007 -.0007
	CaM1 -.13188 .13188 -.31881 .249 .0096 .0092 .0092 .0087 .0033 .0007 -.0007
	LaM2 -.13794 .13794 .09655 .738 .0121 .0135 .0135 .0097 .0069 -.0008 .0008
	CaM2 -.13794 .13794 .09655 .262 .0121 .0135 .0135 .0097 .0069 -.0008 .0008
	CaM3 .11490 -.11490 -.09790 .992 .0149 .0158 .0158 .0156 .0097 .0018 -.0018
	CeM3 .11490 -.11490 -.09790 .008 .0149 .0158 .0158 .0156 .0097 .0018 -.0018
	CaM4 .13025 -.13025 .46683 .983 .0151 .0132 .0132 .0111 .0008 .0020 -.0020
	CeM4 .13025 -.13025 .46683 .017 .0151 .0132 .0132 .0111 .0008 .0020 -.0020
	ThM5 .14125 -.14125 .21736 .816 .0088 .0082 .0082 .0088 .0033 -.0002 .0002
	CaM5 .14125 -.14125 .21736 .184 .0088 .0082 .0082 .0088 .0033 -.0002 .0002
	Fe 0 0 0 .823 .0064 .0070 .0070 .0051 .0035 0 0
	Al 0 0 0 .177 .0064 .0070 .0070 .0051 .0035 0 0
	Si1 .1692 -.1692 .0431 .0087 .0091 .0091 .0091 .0055 -.0001 .0001
	Si2 -.1701 .1701 -.0404 .0084 .0083 .0083 .0089 .0043 .0001 -.0001
	B1 -.0780 .0780 .2926 .0098 .0111 .0111 .0076 .0058 -.0006 .0006
	B2 0 0 .1467 .0156 .0143 .0143 .0182 .0072 0 0
	As1 0 0 -.2107 .773 .0088 .0092 .0092 .0078 .0046 0 0
	P1 0 0 -.2107 .227 .0088 .0092 .0092 .0078 .0046 0 0
	As2 0 0 -.4576 .417 .0074 .0078 .0078 .0067 .0039 0 0
	Na 0 0 -.4264 .583 .0238 .0311 .0311 .0091 .0156 0 0
	O1 .0821 -.0821 .0452 .0111 .0116 .0116 .0135 .0082 .0002 -.0002
	O2 .1867 -.1867 -.0149 .0120 .0164 .0164 .0089 .0124 .0013 -.0013
	O3 .3233 -.0680 .0694 .0132 .0122 .0137 .0132 .0060 -.0033 -.0017
	O4 -.0837 .0837 -.0490 .0120 .0110 .0110 .0157 .0069 -.0001 .0001
	O5 -.1926 .1926 .0170 .0124 .0144 .0144 .0095 .0080 -.0003 .0003
	O6 -.3277 .0783 -.0643 .0151 .0108 .0145 .0142 .0020 -.0033 -.0010
	O7 .0761 -.0761 .3045 .0089 .0081 .0081 .0114 .0049 -.0003 .0003
	O8 -.0951 .0951 .2389 .0096 .0122 .0122 .0078 .0087 -.0009 .0009
	O9 .0728 -.0728 .1443 .0135 .0152 .0152 .0133 .0099 -.0005 .0005
	O10 0 0 -.1491 .0161 .0153 .0153 .0175 .0077 0 0
	O11 .1605 .0460 -.2332 .5 .0191 .0125 .0289 .0147 .0094 -.0006 -.0008
	O12 -.0812 .0812 -.4922 .417 .0185 .0156 .0156 .0239 .0074 .0001 -.0001
	F12 -.0812 .0812 -.4922 .583 .0185 .0156 .0156 .0239 .0074 .0001 -.0001
	F13 0 0 -.3366 .0258 .0174 .0174 .0425 .0087 0 0
	F14 .0212 .3058 -.1612 .0200 .0165 .0197 .0235 .0088 -.0072 -.0017
	Wat 0 0 .435 .21 .0200
	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-85.crawl.commoncrawl.org'

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