AuK9KMvgtkHEIjosIEAddMamQjDgQEzielNQGFGGQAHdf2ezZiPeM9GnMh6ID3ut824wcCgtoRTc2ztZDh0BbM59jurtWmSFtAetrEX8adjcpv1X9eqCYw9aMKd582gkYF/3ya8DMHpb7Ekzh6ut0f4M4Qrsm3yS08OSe2flbdHI6dtZnk3lJ4klzfIwqucsS/lwmvsTYToS9U3L3WCP0QoOUn7FT6PLMakhubOGvQNZcc3uWUahLxnTFIQqa714e0v0/mFfhky3gsoh3Mdzq0mmqt4n8lWujUVfgU8QCmUFkLtrvKUBHIwkAWWNiSas5gy9nOabigAAOfDhmQ7QIMXcNsEfdI0P6WTiZk3Qev4NfLpBlXV1AAbHKfuztxqc/SP8BZXVSN/ecRx6Y4Exjh1CaQTnZ3A1ybx7knwyRpDFKCxiogWblTN5UXJ5JjSjwl5adix3ZqvT+LlpuruR0i3iq2a8H1Zfs36G7wAU4ZC7Ok27CgJjqbgrPCRLHc/F8XQgyGX4lDMtyJIsBQM0yOVTaW1hmJCqjahmoUycnXo9Lyc3PuzHiTy2cTddk9jIqOlPbGsODz+j8YvR2mxBUtw+m19xms4Q+JSBEn5pQF0+vnHkk6Y2D9qFUafHesceb77bWEKyVMVSmw1JR4nXNlwTfBLC5lqyPqaAZSeDQNxB4CfH2NUAkBI3dxT+DyRCMlOvzo/M9P/7g/Q7wK9lBJem44T7PelGFe0Jm+qhEg93/VuILB1r5NBDAbcQ7I9MJTIby3sseiaySD3qte66DjP1EwZpmTJmr+HJU73XqE9dRsfRNVhokclt2N/raR23kmdtFMp6NDJ/NRgR1npOljIcwiEWMsuhrW7tOqpPLOPN8UjpjsoizOwRLLXnqcf127eeqcdnK+3OytbqV2i47bTK+XWET5ydD+nBrwEQ9Zn2RePsXS6ymBfGAiKHI+zx+SC+zlnhyG4fwzzPjdtEe5TKA873KaqF0bgZrfSmc4wf6DgEARy14PK53fmDfGoFfV8xaXQoyFGPTx0ZKMn+dQqxOOK9cCUxV3x0tub6RFYe7fvEHEywXlCdiFV1Skl+YEIblMLLEPhK7HOypfdZyfUDHWGnPONbDux042wS7Q1FwcOpDoi3+VZn/CdMvCDjWGjUI+ILtz7OVau8fuNIAHtqNxelCqGrZ/bCqXbkvzBbQ0IddT2jlDqK/xFgPooXRtShCDpRWN0RBT1s9dc7SQyBLFExXo7MHn895UgPcJ+rCw6CWiEXtOn9l1ncWTdnqeuEnb9IVKa4OmsMFGEtni/iINeBnu3hvfTlKdOGl+pHsUzhTPao0tg6js0nO6BU7f7yjcFARFmA58t2AisBR1+vwT7tMK09VyvdJu8=
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