UMr1HFj7AhjF7aienHdPMbXvF0fnHlUMmtbF810I4xtPzltwS1gIhsWHcHQPq1Jc53X4c0VxGos9eXV3KprY7W/fwU3lwANXGy4rUy5/5ouJy9+0PHejLY3ocdEh7YEquWiZgjz10keMDs3s8eV2yO28DfP82mflHd2PmbKW1Ss03D3Q6jjK+1Eq67GIfbzWbFA8jGuTTAj3/CSzBF07msim2pzIux/aY2OEfUZRfyscMMTfzVPPYogrHqK052X7UvW94dH7xuWsUUBrlhluvVnZL2dEZ957LXcHojyncvmLVZale8zCOJpfhjD/Iq+VdqYf4VRcbGAnCwQHJktyvQb8JHqRCUo2rR/QaNgtPyL3amGUIkgNzwXv8qwky3W7tvNj18v2Nz56hCYfPrxS0R5B6Q3WDoJuFXplFU01ukOiDKDD925Pp5AmuCvqwM7BR4mRNYA4l3Y3QjGQyYAEdNZynKgARrS+A00BYZV+2G+0lVxOYXVcMcnfby8de69NVuysNZicOh9nNAG/oK+eZcJFH1EiOA+pO3WLnFFShDjYalDm7WzeQtLAemx2KdRNAC1iN06VsdXnE9rlsrZw/Hsb2s8oRcF1Z3uBFCHosRuSBUvEmTv7hm6bTxo5/xRZqtrfcM1NnB57R5NEl/CgPIEzxLbXDzv6303WI3J4oL8mInH7lQkWJjVrpYCBF1w/nnUCGpSD6VUsTQ7F5TomDcPW4sSZ/bXvirqKw016mbHyN4T+n9FM3RJE7qsSkI5iYJ+SEOX09ANR2HENBBACPgCyZniDtC4KIXtGgtXy4OdRpBOxnAAE/tNYCLFZp8GUJZA8rtYZniI9Ybi/flSFjt4PHGqldDlUGD4XleQXv3y8HZRUNXXxJ/xspI0kgQMe5CsXyFPnYOD90xbEkk2M5JiIY6SlC/dmFrOeGeSsYfHPeNO/Dmuqmg7ivHU97wl9ten0L0XOr5ESG/3TaqUs+N3GphiO/OB2J22U5/01cg5gvaA3eJlrvysT6UElWDLk1G8EKT5t98MQnZLnd64JGdoAl+g5QDCGK67/+id5ScTiRmg7igij4Uu0xNnUJTf9UZ4wRKrRFBOziXbg1az8V33xLZDOItcIyAnyNny0+p8RsH/c4RHUsMxRgCSPGjzB35F4xMpXXnDBOb0SFysvIY8jZ0isw8ifmbIfioZvz1tysnb3VivR5nshdX5/9HrGaob0h2XLAJvzsLJCO+7ByiuRDEciVhqn2dyU21p4aMrCG3pdRUGPh8bYxet6DS9wibd0HeXzpqDvkrnHk2GRlmOX3k7iihlSXRu8eglZ7HA1sYn0RjX68bT7evVxu79OKJQNcCvg7ptdpoJSkAiueQu/c5zyrNfIT4ocYCg=
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