zsn9h+Cpiw8RAiCpH2Tj3kuY14PyBnYtFItYLfqETbykfCGy68nJc4v9Ljj+a+INKkdd7L0LPV7Gd4eUmtDqPhfZe4EcP1e6zEED/9I3bMtVBjMA/ZBEbd0j2a/EOeu/VVwZi8RFPH2nsjzkse4k2beDWN7RjMQEpsagfX6RNnBzuJkjH6Sf2paIB1ZkEmopavU7a5BEqfrm343WkYRRF4eCrdU7qICvFkXo5elbxh0b8YOMj98GUA9LeFHcPf3dNrZUcJLrwO8e4BETXe4ACQW3UPe1qi0Kx9YtIiAXesmaY389wEAu3D321lStZMaFqsXzUdgGXcbFfnK66+jt1Mmn8//JOatE9M8ytUPw3jzocv0OVXHfGlnf6fFO2uHBkxTQbVBN0SzvgJAahIlc/DrBvgpeBSk5quA967+szOTqDfnVDHilkkyeWaxdWJI/L2Wl5hK9vYL1ztkJj2cj3ZeXKsZ8WNb8vX52jHNVNVCDfFxa9R2h6DyzPIai2Ir1by7qwY5LWWS4Hk4icO4+zt26F4Fw0yWVNKK8yrI8ZaOlO87q47pYNWHrbW+mmSfVTfMNRmWoS7/ISH9oh0zXgjOjDiyU/Qf9jpIwdifRsSEYdPPGsu3dwLBywqVMBv9Ng35Ji/OIruOUg2BYYi0YausJCrO/zseXrLuLd5icICrrlNFMDILPvfyfs1gYiacRmoAI9TfRI2lt8GH/YDz5vdjb+UtgKaY2/lm6BsfFYGTxsoFSjK2P9xJaCm1U9JzYSVQ1EgacebAs6fZcxh+DzaST8PVvJa6pL9ad1WEPjbu2g7Maqwm8MsvvNW1YEAXnyIqq/3drQs61hWbUNh0OBxQ3ZuclqHj7YvdggtZnijXTJMMxnB2hOfjOTYeE9qBUrt6/OhhbtWfNRzq9Xm7lLjZZPOFdAqPO4z8j3V41/VTB/Tu9OiV5WWKLG0SKCFf8gvyLmdnaS1XhNTPEQQazS+CJXc5tWcbLQJTWmIx6XvTpOn/K20Lso01GyHfJLWyexFocf0fDmYQN+LavzTMMkxD0cxHfRcWvuGs9sirdhOdaRuuE+FwvineTGc58a9S3Iax7zd53E0LbqIc5bPVT8mkyUe2beMGZEnISinVLH1W27gaAF0ow5o/i45WK7HufkG+8vwMHsN7fq20dXEYcgje9oSwop//StipuD7l719IpNJ650MG9nqg6r4xdpc57VPsbevOYxqIlSM5Gw+KuMmp0N1BtyQ+6f1RtUYvqjcv46lIEOJH9L+oICvYmR9e3uk32W9sXH20RRRRjgBIUxsisBzqSd5ZDsKPPmQRhenhXX93R34yug/69aDHETa9erjV0SpkcczBuaJIgETwgt+yMl3o76Cy3hhhl3+M=
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