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('Belt_Conveyor_Misalignment_Detect_') and psd_codes.industry_id=1;