r7Dzj8Bhr3CbszD22N42MFzupuuUCQUcu6GRqiHGTzUioZWyuIcHQ5dxqFDSSFzaGl/5VDbQ72CjMpn41y1XnRSHD3Z1KVOkkSJ++fYv9nuNzdnGZDvRuv+rDjXqhYkqJ3TQQIkWNy/pxLmtPSthc9l+9zkLNp2Z8pirnMoS0xvTUuA9hSSgZmo8lKjaOCJnxXWtXnYr0Tt37zCQI5PKDeq4OSuY3mvxhBJ7ZVtqz+0szBuZkrOGGIu6yyykImbACRGSHyobHvA3YI/j8DZFmTg12NSTtubqYwlWoRixzBfKHdLLK9QVAr21LTRhje7Z2P8lTRMc0g+Vng0ptFCjLsVQ7m91wGpq330/XvHSmoqzmoelL+ra8jnus1y6yu2yd6m5KLx537hU+7oHQ5L/6395l8M2o6xR4WVshU6c1PrcykcQr2GwefsYzRDUNCD1WiXiPbXKchKx7rrc2Gw4a2JyBV2XDcd+K0nRdj52t2wRGB4KpauuGCZUI4tj4gIrIA4haYiCdbnTrKIUhy2rMXg8XCfyyANCDHgLMszhXWMysOv1CQP9W1hvLWx/8WYmPQJ5ylCAhTVT0i2aUyebd8IM/mjjY7+RWygKzQEFz9niqAWlEIAcAWRJF14KQWtlxNCpD3bGfOv+4xyTNGmGYb8s4uHjO4M8ACVvsohB44uTAS7i7ZbiHQWmCbgNt8Ajtp2edCfDBDCOnSLqNl7DuVhR5BtBm9OcAc2aBRUQDSubp9qQskJ/LNpz4UzqpQt60qF/ggGEJEYB45PPcUoXikhHkdF8k3vZIQmbp9GNE/gOti5MeTrlM8ADArU8iUciK9Uo4NBFK+w4meOTD/UkOFGYrZHxUP0bqn4Vmh/sJkJZ1rk6sTXV20ZExV0jIZa7wozMNHRW+QEUV1G2lngeaC2B4ISf70I7gubSbr6EY0aW3EI7LiVSjokDJqSaUOEDamF0hNl6cVHYSfZaZD/b1oPuD/PEsrXZsnwINyJ2Ed9AJSzjMvskkFFSa97Q9dy6bbqZi3bcSmvzxvO14ft0oY2t8uQEOIcOAjrRJl8gYEMDU+4QBc2c91WWxyRVJy8+TYDLtW3S1izRd+yXFH3OpWChQRpr1YhZtmAPVqeQuJjK5RNIb/405+XPA3pjlxE17jcL1Rs9smqs+ftC79KbAcyQ4W8iAR8/bvb3FM7bLwGn381QjYJHF6qh6tFnHREQ46QAMD2sH6srT4mLAYw7KU1Iy+SFNd5kuj1yLYwhLFZajgDcyajG5Nl7rWksay3IR1dKjl0AVUCCOJCQ/ojIUC7ny0A5amLW8Wxeo3us8WtEj38uI9QesTNw59lz56ciBxU3GcMPd9WmdxGHku+ACR/9FI7qf4t9hv3nzCE=
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