minfind.com

Mineral Specimens from

Jan 22nd 2020

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='2020-01-22' and msa_mpa_id='65' and ( msa_locality_en like '%Madagascar' or localities.txt like '%Madagascar') order by (mpa_expiry>now()) desc, (msa_dateadd>='2024-04-16') desc, rand()