Professional Affiliation: Environmental Microbiology Consultant
Mentorship Offered: Problem formulation
Professional Affiliation: Sam Higginbottom University of Agriculture, Technology and Sciences (SHUATS), Prayagraj-211007, Uttar Pradesh, India
Mentorship Offered: Manuscript drafting
SELECT DISTINCT p.ID
FROM wp_posts p
LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id
WHERE p.post_type = 'research_mentor_cpt' AND
p.post_status = 'publish'
AND (
p.post_title LIKE '%Soil Microbiology%' OR
(pm.meta_key IN ('professional_affiliation', 'research_area', 'choice_of_mentorship_in_research_cycle')
AND pm.meta_value LIKE '%Soil Microbiology%')
)
ORDER BY p.post_date DESC