minfind.com

β-Roselite 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 '%,3451,%' and (mpa_name='β-Roselite' or (1 and (msa_id = 'β-Roselite' or msa_locality_en like '%β-Roselite%' or msa_collection like '%β-Roselite%' or msa_name_en like '%β-Roselite%' or msa_reference like '%β-Roselite%') ) ) order by (mpa_expiry>now()) desc, (msa_dateadd>='2021-10-11') desc, rand()