rB9ltA2g1GqC64Eiy8WhvUdG9E4W2a5qBsWo2YqKB0t6m8uk2O541rd0wH4ksr3leGvYXMIdpWgMhmtkEogTHjwD1DbtDgKcaYeAHPMI/SxExnePS/xgPowLlzraD9NmtFWqb16xhhR1bh5usZMlFhfLUsmvXzEk0RPusWxooEuuf3a6NQohEG/ifHVKUSGXr0RTHEwyW56I2Zd0KYoTzVQbtDDniTHCyuqfsU7VUF15y6taWullIr7Nm9stAIXU6NKI+pej4lCWJLhuXTkBSSN7WJea3EyyDwCcMui9sZguDpOz94vyLXxRKXD9Kq1DsLKsFxeAFqoqgT3cikRG4irfFfmkvXN3BKRO/cL3YNBiTPwZA6Ux2KQDb0kNIf6Cpu/m/hRZXg5MTov27kTR9yn4+hQ3Yue9O2atwgfzRIVKc5Tv3EQOZ5pvTvnJhF0nmz/f/qVx5gm7P7J/zi3q8453GhFWunjrOFgX9DawQPVwG9to5QYn6GkZO3hnBnV98chlNs7dhoPXHezcHeWsobrXwoiWoeard4YOpTNvDBqzatBayBxtxeH4zW2uy9t+dLaCvmpK3YpZO1aTDCez0sRTWuuxAF/0XsB9R0rt/R+8rghmqdAppkwA4jEwYBLQFQmvrwkZme0kfpqBFOdh2EGMNPxvfnEMsaaAkUGk0eoWAx1vUtzclIZB0rT8m+pAnbHbGkAOz6rwDCaXyofHaPKZyFOWbr+8zimd7Dpk+6ok/cZpe3uU9llkI3f8osI+BFS9yxOlq4UlpiCSamWQtvoZ56BY62H2jO2AkwWY2NxKLc3kDUsbILMS7wty/5DxcpUA/GUzZDvUXfn4qlUCw0fU+EGaBUFAMCZUuZjTffHRTEbPGZfaOPZephr1DR9MYXPQl4iVfBrpS0KdSfaTdHmXXE6mK21krpKSpVgXJdEPfiETs8E4Ssd7iSjJp2HFITJXNAjTqBRY0wJT0jr2cEopWMh3jROPHgCgUc57PdvaNuHTej7I3LqQ7LQ3b2gJQ70knbUCTp+Q5aaaQYqcXjcaJLtXeIkJ7ssFAK4YVdR/tFfQPtzJKiLn6G+pCdvL1WMFkRT/XC3ONKgBERu4cJYXA27xUsmvALjE7tZOSDIsvqfqErl8DA56n7/xKXZQnL6MIiHc0f+/cgJcnugNNWUR0+lTjy2eF/1ga1ZxziXOhXY2OsQPSY47xZmjfVNyUWVzDE1Hi5DM6fYB2DlpzzJ8maly21jH1M9q35SVHOAEqWLX+er1ZBNPBvGrTQgsmlF+v0mwG+zOnR47e3f+ixkYPkTSjDL2tw+et8oMv71ntZfr1PVuCwBupDrKizhI4wi2CMxlF2+RqLVTw05jfyhxqAIXk/7PE8ageMo=
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