RFIpPXY4gJm95l5tTp5Lc6e/KWA0bN0ZDOnrjp9bAPKRRmsF5Glm09ZyVASU8m/6t4uHVjyfs5/M8yYrZIWeV4Oj4D1Re4HDdhSWxRlnbyRhdsFW1GbXDCkA9J6TSK4VeEtznTMBaHBHrC7uDV3l9GEXU1m0gvZHhjvttYUWfdp3VO5kXvEXRRTu/DTlnMAA/BrgQZJeEhVWEDfmS+MHYLuz8XxCyfYH0DmSU02TgcDRWb/LCl55YW4CDE7cE1PEc6e7DwCnL+sE0pjQpRzt606zHgdVbYkHgs0pOkpqvQ0NJPNqo1K+sc0W1HDWsLO0Z5sPdCxSrDTl+dtuuZTeh55NN6xMoZ/1Jp4Y6boyL8Ty7h8rdD6kDs78MXw9SC1IQVLldBNh1/4PM6puldyKKQJIckE9vfe/mBpXYeuh+CuSW19yWZPgXV/WB8LFpvzctKoHrvk9JfUu+z+xBUTon1ROSUJGTy39DqNow4T5GGJzSQVa79CD6gFwEB/n1ExTb5ppQwpFWC9jaeIw/yqvTDrLHPXKzI8m29MrnaaNebJPQbL5X6YrtLtUD1pjBQzQ/gw+tpQGfV1Rk0ZENPT7EjqplpSYoFLv0Hf22vKMYiEwYy40YPszifDUx/HBvusnGEFE+lSADzO7pqJTvm1CHWLaqWiWS/mH7sRwi203VPHcqAIHJEYO5D6RE/UFwpwpNY1KvTxFopyM6OEJ/Dse2PoZLicHkkDn778ZNmoTIwjdm4JcjGpL6uWW28FzC/9OB+TpoTURRPyyAgDmhhdT1sJMFUTcCBPOn1sDeTOars9wTz4BFuZLQPSp967vB0nPkyGUreEWVzKWQ7eTWKjDkGqbmJHTiaUnpsHg4vQs/ojF9jUwveFEgLS++sCfgAMBbA73Fh9hacIHPD7neG5FNHB9PFhQpNlIKx4hhyy6K2/GCRwmFYblRdjlxHxP92cF0Bmf60Js4y5JAbEhkjlfcEJKrdcH5+PpBQZdN5UBmySTQkp12oT0/zYGgCVW6rbftlfivHNjYehOdu0G1YhubmV7NI07wCYAhXIL6RtbJ0ZRqD0UwvY5vCBTe16YVrVqCi0fvUloG3QM7m4ZwDO0JEmsYkbDcwg9TYsf2CTuU0g5eS3KN+6tDXhpXz4/PhUtNV7sJHGqwv3YpOymA1N4fbbC8ycdzpCeXopxjt//XWRIK5kMIb/C+k/hxmjlm62ed5FMHPKG5YEmy5MPMp5qD5dCYgA9Comak03DXrotS5QcYT0be79O2GKQnyC+rlZjOTX8+xCH6m+P0a/vaq9XEJGygeGMgt3TNTTBUkk7AX40GvUti0GhRFkDUHb/DH+kIS5rBYX8C+cmrztheGOiI8NcK40SqjmOxO5wifQ=
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