• Go to mindat.org
• Latest Additions
• Mineral List
• Minerals by Dealer
• Home Page

Australian DollarCanadian DollarChinese Yuan RenminbiEuroHong Kong DollarJapanese YenPolish złotySwiss FrancUK Pound SterlingUS Dollar

Upload a list

Mineral Specimens from Weinrich Minerals

Apr 29th 2017

---

MYSQL ERROR:
Unknown column 'msa_locality_id' in 'on clause'
select distinct mv_sales.*,mv_partners.* from mv_sales,mv_partners left join localities on localities.id=msa_locality_id where mpa_id=msa_mpa_id and msa_status='Available' and msa_dateadd='2017-04-29' and msa_mpa_id='14' and ( msa_locality_en like '%China' or localities.txt like '%China') and (mpa_name='Weinrich Minerals' or (1 and (msa_id = 'Weinrich' or msa_locality_en like '%Weinrich%' or msa_collection like '%Weinrich%' or msa_name_en like '%Weinrich%' or msa_reference like '%Weinrich%' or msa_minid='Weinrich') and (msa_id = 'Minerals' or msa_locality_en like '%Minerals%' or msa_collection like '%Minerals%' or msa_name_en like '%Minerals%' or msa_reference like '%Minerals%' or msa_minid='Minerals') ) ) order by (mpa_expiry>now()) desc, (msa_dateadd>='2024-04-12') desc, rand()