Mineral Specimens from Le Comptoir Géologique
Mar 16th 2019
We are a French company create in 2009 by the geologist and gemmologist Rémi Bornet. We want to offer you some uncommon, hard to find and beautiful specimens. You will discover many French and from worldwide mineralogical pieces and gemstones. We hope you will enjoy items of our website and you could enrich your collections!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='2019-03-16' and msa_mpa_id='27' and ( msa_locality_en like '%Australia' or localities.txt like '%Australia') and (mpa_name='Le Comptoir Géologique' or (1 and (msa_id = 'Le' or msa_locality_en like '%Le%' or msa_collection like '%Le%' or msa_name_en like '%Le%' or msa_reference like '%Le%' or msa_minid='Le') and (msa_id = 'Comptoir' or msa_locality_en like '%Comptoir%' or msa_collection like '%Comptoir%' or msa_name_en like '%Comptoir%' or msa_reference like '%Comptoir%' or msa_minid='Comptoir') and (msa_id = 'Géologique' or msa_locality_en like '%Géologique%' or msa_collection like '%Géologique%' or msa_name_en like '%Géologique%' or msa_reference like '%Géologique%' or msa_minid='Géologique') ) ) order by (mpa_expiry>now()) desc, (msa_dateadd>='2024-04-12') desc, rand()