minfind.com

Uranophane-α specimens


MYSQL ERROR:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
select distinct mv_sales.*,mv_partners.* from mv_sales,mv_partners where mpa_id=msa_mpa_id and msa_status='Available' and msa_min_ids like '%,4107,%' and (mpa_name='Uranophane-α' or (1 and (msa_id = 'Uranophane-α' or msa_locality_en like '%Uranophane-α%' or msa_collection like '%Uranophane-α%' or msa_name_en like '%Uranophane-α%' or msa_reference like '%Uranophane-α%') ) ) order by (mpa_expiry>now()) desc, (msa_dateadd>='2021-10-09') desc, rand()