<!-- 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_branche IN (10) 
     ORDER BY 14 DESC, v_date_publish DESC, v_id  DESC  || mode=search&model=4&page=12&branche=10//-->

<!-- Render Time : 407ms / Query Time : 157ms / Test : 0ms //-->