<!-- GetJobQuery:  SELECT  v_id,v_category, v_position,v_organisation,v_city,v_date_publish,v_category_name, v_category_parent_name, v_branche_name, v_education_name, v_employment_name, v_appointment_name, v_abstract, v_highlight, v_special, 1 as v_order  FROM [mbb_nl_cache].[dbo].tbl_vacancy as j         WHERE 1 = 1  	  AND (v_category IN (SELECT afc_category FROM tbl_affiliate_category WHERE afc_affiliate = 11) 	  OR v_id IN (SELECT vc_vacancy FROM [mbb_nl_cache].[dbo].[tbl_vacancy_category] JOIN tbl_category ON vc_category = c_id JOIN tbl_affiliate_category ON c_id = afc_category WHERE afc_affiliate = 11) ) 	   AND (v_organisation LIKE '%lievegoed%' or v_recruiter_name LIKE '%lievegoed%' ) 
     ORDER BY 14 DESC, v_date_publish DESC, v_id  DESC  || mode=search&o=lievegoed//-->

<!-- Render Time : 484ms / Query Time : 156ms / Test : 0ms //-->