Gd1GZAcFdAoyRCfZnvYTUwSgbC0OYUZIwhqi4X0dUGo/GJ+WWJZJdqiXYR4bvBx044+WP0iUCigvdTjQqm+oOyXhDlbMLzV4neA74j9Vp4YsLfkfcCqSLaES1TMVHF+jUXSbcHAlWywyMLg/1GrRmESSEFXG1wDz6wmKfvBMYQTY1nOOtynmHNilMQk2y9p5serI9uLtF1sWDmseW3h1ewOs/2Wokh4Y4731/Jy5iannk9Zo30gsVq3QJJvJ5KtDBknPVng/mXk8cb+prbp88qzs6NJDhR5gnBAAm3UcEEqos0zo1ah9zqsf+QwZtV7ukTxx49LCt6ZTJa/zuYF9lq7+Yv8dvEn80G0LkG+3HY29IdT3E5PQCKYxBDF8iBotaKGOnv1sf9bjFd5LvuAFrZqIBAF4o2O3qu9VamDAMoaeXJAzTCHXO67fZdBI7rRlABgZ/BpDLM4X10IN/+raEz0w07duZ+3kOC3Jfb2JKUdxsckaRDNVsbdTtHxQ+Xvng//1/EqZ5vzdea9su5MVxp87TnxnN2yto8jJ+ZpZ/OQ5Dvc0vHI83pUSfbvD2IG0ZlxUq0LiBvibk+UozGLLDySWFZck4JWg1soxhfrkzljhTPEwDmAoBILWH7tmJ71xkSDgW6t4mjrmxfk7ffRci2nTzxKW9WP7rWRsTBZcGyRBJ344DMhvKGhFQj5/MyooBXDeSGfbITWWfnQ6VmFB47hxv60iDKgljEf7+isyyTlymE7A1gH+VJr68r0zNK0d7lhAxJBZ4UUokZWsqsyB1bjANyRG5tbY18rPReJD799dWaz4owtrsA96j0Zuzddc41BlQFNOqz2BWGxMBXgXKHS0hnBFUogW5ClmF/+dxuEtcem291Jx1mkb62k/wflEBCEEzwEmYj7kMPeoKJLR5zmqLttsgTgh2tnsGUxoplXRcRmda+W2GR21GjZhEo1yno5iEjW2oxy2nPH948eIecoQFAH9djhYkh6+NVqd80BAelvG+K6TDvImSeizXXRuQ1MyUGa+UScmOANEBJSjvmCeHAG9LfxwYbj68aX3/8orupRWYjpnMVh0r00GLA98BT5Gl3GDninTNZdH1IfbCJ2RGasmj78P+yLD0ysaAulw3k5REWuOJH50tFlmRDSMGmlFUfhQ3cGf0l5Rf+RvwtUz7/sP9gqoCcjpX4F5mp1OoSsp0OeEZcxQZi+7yjZbiebTn7tdFwENTibf2TmsujkChAQlR1JY9QoAB5rLUZTAjm/Wwt3EfJnh6B+394oOMxwsVVEcIv/1Ps3NQV8Pp/2tmwgZgCoRs5vd3Uz/aYyV9Af7bH2v4I0jwZTGAe2rmruBLxxNAMCCf1OGiMGSs7ryMV0XWuUKkuWRaOk=
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