SNRcmXp9B809rRMbV1c+zJZelFqUOy4Ne9/GG3+FvhE+DKxgrwXLsvCBOlGnmwcqqQS3k9hAmUrbUahfoCWWuCNkEr0wHLQQg4FS3SHGqtPggRXKcNFDd3MkSSt1QXM0sXADHldeWzbus3C/yV8LktNBb4kFLTUwGVRNGSQlyr5YIRrcn0iIY/5VHGOuDQzbbGFnDZSxZCm4t/2BfJtEbPQd8yj8f2vjG1bvxMV07Yk5NNXSeSdVlgagi42xlpS6b4l3qLu8vTNKU6DoM/3qJ7aDbYegXi0e2RKfKM7Vf4B1WtJk2GnDWu0auG3tuuH5MHITT9YS/JHwfYZsIPA644vo1C7a8eUUFJk/X2mjANbMi4xfJeYjrJt5gZV/uspPX53oUHKDSn1wEPd3R0AF4W6rnkZGD1DS9M/YeiUXi7qJzdM9stS81aw3fTfUNmiVpB7Jp4I5ij51qTmUjtj0nMFo0YuZrCa5l9E2sEXWl2BECJu1DTWVRxZQM+k7wwmSszEWbrdB2LggIGbyvhtbrP7HOvltoZO2Lxq7xu1GVZys9H1RrXV0lPWZYGKJELapxrzGHK0tvNDR6iiRYzz84rvIMtERTh36bCYXr/KW9PG3fC4zBwO8u91CGy8Jy841oXEBloUc8fCZZiSC9KSmGPKUDKwVVZvQd61nizV3k92g57wAkRGmzOYaKwljhnUlh4T4XDeoXqZ+FeN01a5d1u7aaws+zX/57xs5HprypyYwW9Lbvmm3tLTLazCMl2bE/6P2XyKBqzfYLLoww3RaRSmwCIWHJkc+VSryFBWQTL7tmSg1FivXFMuThq3oXIQ+GVDD3vrCRD97FLWmSDEhrfn1m39PWCjBRAYdASsQxzfkMeug5JOWOMCyDfAlC2+z+tPdHAjop+z8H//z6C9b2h2v8AXN6kcX5C+4a8fxCl4ugWUE0PfZcST0e5dsFSXXcPY3j8fmd2Dgx4VzAfDzQkjtGJu3JX+hYga9zQOXMyKF0B5+2jX2zOKT6ZKtAUqlyGpQIoW2E+4DOunVpNhEXrYdiz1U4p5Ur1vfgqS95zvQO0xb24GttTHPhitQZ6JmdEQ39BIs13grgu5bX70u3ZSyBPLFMXDSJsVsKQwnFDYFr+ezkUYqr9R3Y3N4hnGcN0XWhW2qiqm/h9/NMB1i2rp1J9M8zBOpy5j+W1ys7EGLLsp7scaE2bB5mjmMEEAAtXXgipW7CsxdIFEpwtIJjbqxl+s7eV9iVZKEF9KK0/sVSHSaWCXQzWr7BN4GX4WH229DPR3foOmd45037jHGAUDtyQtM3f/mTHVhfkNz9wgV8OxzTI24JNMr6yp8aaifmHFEJ64WLsbOiLgdakQayIrfDYLNM6A9MdpicLI=
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