minfind.com

Mineral Specimens from Mineral Classics

Apr 1st 2019


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-04-01' and msa_mpa_id='23' and ( msa_locality_en like '%Pakistan' or localities.txt like '%Pakistan') and (mpa_name='Mineral Classics' or (1 and (msa_id = 'Mineral' or msa_locality_en like '%Mineral%' or msa_collection like '%Mineral%' or msa_name_en like '%Mineral%' or msa_reference like '%Mineral%' or msa_minid='Mineral') and (msa_id = 'Classics' or msa_locality_en like '%Classics%' or msa_collection like '%Classics%' or msa_name_en like '%Classics%' or msa_reference like '%Classics%' or msa_minid='Classics') ) ) order by (mpa_expiry>now()) desc, (msa_dateadd>='2024-03-21') desc, rand()