U1VHLexd3DTa21MGd27rPsP9fpKdr1UrAVFnycDcnKjKqDXRp70B5odGIbbM9161ga8hgEEdee9vjlNWosyHP7tZ+bubpPAYBg/dP3JSSB8RuQx6ofDai8ZKv01LEl8rTGX8ZXu3/0Xz/gwupamnPur6/t+aTYSV2rY6JXSIWg6MTGuppwSiZJnvseIfniqa6VEKUiWAv+vd25oOSLLtAA5W7SioxhtCD3LnZk8zODdHd69GujGb8VkGq910sCWew1w3ST9NpXjybD44DHDa0yHcTa0St7BU3vypeIFAxXQAqewSnDwEynN39tJMGBq/qaNPaGEwwu1iBbE5LwvE7BDfQ6FZY86eZ458kwTyRR6PbkaMZYOpu7FYm115Mc7UF5d2Nlm+esKc6dt7HvBfe34Z8ZVi1o6vLgt4SZe9h5MHdjx9CkvPhHYWEzMYs2yAyMcI631Q85GQwoqWfsRRFe5D1prbpc9dlnMd8MAVRzebfEDH7SAt/N6TVT7N7gCNByZbhBjwKnFhhDvPuaFVCnc0ECa+8vhy8qKsZkeOh/tISs47182N5lEk18Wx3mkhmkpOASCZp9WagVnKHgI/y7jE4mMmB/4UWMWM6AbBRlPewZji77H41ta0lBoIq6hyU8Vsb/qIKm/X6z68Y4pbH/3MOTcslNj/a11oTRcVLUM066kpTGKJUq03oueTo/ouph3yTw3UPlLeB6z8AKnHoxI9pPA2HurivkEwGrMruqGYb0AWz1aP78ZdV1y6h0ppsgSuO1K0MEFBEddX+4obcoAwy3R7/1gyhqES39QdhdAOqxUFY9kupyAcOO214MDigeoLyqutm74xErIjqiaBwsdam0Zq7rqO6h6pg6bxrUFjtes5cAf7gaonYGT19F6vO3sjmYikLNNzZ2n4hT9u78lfDHPtzT1/d9Dq/j5j0k+MIwKIry4WAU55oMYZlF1TRpp4BRtmiTBiSG/TJdweePWUcVZA4GMuKBVlkkBqSaFBk+SdFnzxZJzUZm6q3J9doq9ADfnf5UX6dg4sM9h1dQe7R0MPOj+pRmapoxSDvTnsZQNMrJDF2bAYQGtU6yQpU5QpaIHCsJd7EKvcfl1W7EDBzCAKX9L4NIk1ycVHzU9kVMi2hlFtn5HhRRTZsqawlgouE2jt1gRy/ouxmpOZAQL58YU7/jksv9vdRVTS0L8GFqsw+O7Jf4V3+a1UBrL1FZDHIb3Bgu/lp3wUwSntZUaYUejx59BT1L/VcS0vYasjfr/jbzHZrX7OBt6+i1+JbzRZzZpbjl7s2PpzQCylhu1tkBLef5p/6PoYk89cn+muYfcsb+FTWnIHy05UjALoj5VFcXLSF+GBjvYveNU5pRZ+EwiDevx+OvrZtYg=
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