240HUkRl5gu/yrfCTDFInGAvE8iNIIe4+TYXh5VGMSWOpa0XHlRo3yB3DU08JeDaWleuLrcjqg3XNOKuOkbMLO7Rw4Tmir+O+CS05mHLmfE/Vso8IkAylmLWgvEAxp6Ip72LhSatD7f8FrxObx2WmLUxG54+LeRt9IHogmNyXBrXhbleBW3qY7qaV57bGjq7+uMVfgEIl9rjERgeNmlyREmsQC5zRNtZEYbEDTvUbmt92qf2GCufsZ2VCre7pd0TsHLSiA83C3aqYeeGTaUKFgE0PBFmgkMgPI0ghTPzMKrU/3GgSAdMkzagNa5E3TNo95JOZfzhFap1pC4G1TPJyuYIyIZnRj15+Nwdg/XCg09r6j9Kw952QgYb60HFGCJxBiEZxU7TCOV3KRRvr1V5rc86fPZeNwrXEPuGE5r3YLbHpl88FfONnQyZNO0TZFFcXljAGjHKwpg2Gj0DC21zbq1emU2Y1u9uDKiPP+eG6iEjdzdlRHADXHdNYHjm+hlOGEzv9kRsxpY4WoN/Mt3Usa8MWcc6obGiTRXW1wqi/NZjia0adbOnnWg8KttLA6Wx0hShEaI3GUd2KWwJTY0gluwCDrrVeFdkyuySBN9hrD44h2dIMP6EjZBsMGr9TWzRV1Ba1qlz9m8vKOtFm0I2Id4xKJCKy7HysM6C/jtTLOKu5J61umUVk1U9H9bhti/cE9asO2C8lDlxj5Oelf50vKt3xHYyZZG8hpMLPEYF0N2UO/mGidot7N0o4riAZCvIN1rB2Rhic4p6uOhEDPtBjQ0FkkG+zdSeJSAG/4+7upLkgHIqjR7gaZK9KcyD+OeyztZ7vsCbRBCrnj1gyeo6ZztEoySwv95fsvc+dTbpKxBi+LB4mD1PA8Z6c5oqAzQaAXn9C0cZMGpwITve9DqDb5HcR2inQUFqjdE1TfTUUrWVLvxU3XgYGPAr+IOnJmkLdbGoNyltOVCMsQp74aVk2HcomChERRVHqrUsj6s50P5Nn5lFrnSLCUBvUcp0a8LJH/qy5Bszwuk7P2eRJ8vVetYzhPqOb1w1PdOtyDyzOqfgPnEtoB9uXZDbL3d3+XUaHiAGoL0xrAgMGClxWd1/uzXYHLYpCxia+pzYn3pS9CoAIXaddScmE9oxF8GrMeiNfWkQxMe+/sBw3wAnJUphKtDOeidCog4eyBtCa+s6u0hUJIvHY+suy5P7hV4Pa1BdRaXssIRVRv5nkJL4f3T5KicLq2oQ13wS3DvfSduJ8nrT7KlNLffB0nRrnigKZUWZZnwQGJ4GtgxgFBESgz5O82TJFfRwSwVo9kWuuu2t5yB/z99tZLf5/FXQVRwSnroHYJrO/Riu+21zvdzjsLa6SP5R5pJumPwLpL8f3QU=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100