select psd_codes.id, page_title, psdesc, psd_toplevel.category from psd_codes left join psd_toplevel on (psd_codes.industry_id=psd_toplevel.industry_id and psd_codes.toplevel=psd_toplevel.id) where upper(psd_codes.psdesc) like upper('Probes') and psd_codes.industry_id=1;