yNJ1e0LbCfMkT8XAgvAr2cBl/TjCFLWLBZ5XcUlTkdahDP1151cZdsYa2gCgqPJqZdnSw7ixPhIwu9pAS6fQ8ymqPth7W7AjCxSiN9H8cTKri719wBRj/2WTFHeeMVeFmj5Pjqc42U/6jSogNK4px6QkCTprr0cLm55pY3Glx1Zb7Rnn81R4kp+ftYTQjQF0mHe7Wg4wXXsPB0E8/06PYdbIRX6ucheck5bdm87wsTl3e7rCenxrY/NmvQ9v3Uos3HKvnxOWUVOGBixDdwIMT0BCK27WOi8mMySKrCu+ae+ET465q4yCS6UCohBts1BMI4wst7kEQvH/4guq3ip71u5EuJufmI7LqTisq7ooKDgbhWGeGos1eIpJepttbOjyQcr+sGiisAayWdWXvgg+RhY2pP3kbwXyBQdZel+DxeNN36tBlAJioLi8+1u5HGkGrepOtMi++fTqG8PmfhQcYa0oDuuFCl5mBRKrypm+aYlzAOVtpko7MMNPggArU0ECk9urH6/ngdG+mP1p8okvUE6aLHeAD1lvELjj5wPHXm3wSG15uoOEV/8ke7PokWuVz1Ql91BtQCyKZPB3xhaiVOsYSndZW93ye6UoQ/JndVSjU62Pmp7uRxsvfNL21c1UjI1/MX9NB5QtZXGhD5g+r8JCo1l6EaK+CWFm4U2XQJKoe2w5KKP29MFPIQydDoSHsti/0xv+KpLibjZd6c+1d5g4vVV3O1oGZOKF4xDnkpah66FbEYJJwCzgEfccr8zFF9BVr89yGLWZPMn/NrY0SI7eOwsPUx23d6VAmXVn8K2kWmTX/32ltK0LWFXLRTjkJAIolB2EpbhR26tBpugK2xep/jl8RT2QpXIelS235Vq9UBaLx6ExrLht/xlWlVqWN1jIDPl9C+840xI39Rxb4z2tXbJRYo6Nh3kzCGkBopfMuxUf4quxD18gZBRzuTQ+zOJTigs0/xH5KqnczUxM7ng8hpPCaJ4bktdVCHS44RDtv+zjCh+ErEuf99SwmTNuSdHFMcMKCaOvE8kk+hp6i3hqRT0W4Y/WmTdawHbWIikFYwim86I7eYgHFL+0UK6FagfOgBc/f30bLBZU7iJOUYQUKf//TMqMSEyCchugdDRsibo99od8hzMELo0Du8t1WleqXTYNjfhVixp+yG8dl95ZnjBpns5ZGRB87tlwqKSZmTPw5Tz5YR1U/SeubqII4vAYX8FdalvSvjK+GVWkl/6Fj+zOInjheZMl+w2nEgW6+qT/soZFpnozEcC11JkJ+dc02AUPrJL/44izhnMJIm1anFeLNggRw6slIJa8OcHP55EfuguwetHcwGT27VPCY1dKdnJMscabKlt3/uHS8TlfJazKuw2f1zSk5hk=
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