h1YAUGsUVF4obuKNMaOcJtBtX7A/Xb16uGGkXsrLkpojpvhxBOct0OSCWZpmtVEPxCLA/Gjd6MIWvakaZDFK9wLTTgInrkK37A2hOU0SQ19r9sIiCSYlD0vVQYGerks8uBJj3ghU/ka0dcrbFEkrskayNj+o4Rtc0wbCYtbq+PAJVEpKMZM64W52tu2tzamCyeS+cdeQNSThUxg/pWprcZjc2SBSyvZAKqxIOlMK+YtnVsRuB9Prmj/5f6h0tcFn2IRTxqIBwFWQyBgxnJPEcbEKpKUpC9Gf3uY13BMSUOsiV6UkxHzAZOXSYCfm8QeD8LlzYjFRh6PF9QnJwFiKiL6kdn6BAdqHfqN0LokFTSnXZTbW38dzE3v5u1dy3XkP6bEioLshBHW7p7rwA6xrRep9C1Ttma6XArq3Uk/fqIIEOM6stbDmfwPl/pDkp1yCcPAOwyIQ6MYyodxA+ywcuH4lAFjziC7oACEpcyNGlRowLrA+xWeYauI8DfRUTMTRM75JwgFDM87euVHkiiw08NroGtH8uJxD6K088WURMAYsDpO2kmPw89H4eCqYmC6APb2cAJXj4XV2FXy5MFf9ZaXWifw4DJvlw6v8dlDG5gqcLPj/sucxmYG7rd12SRsJI6F6nG9vdzIrllWzosMY+YKDNH3I8Q/mPQDBtigxsfJF8kLZyo8UolO/BM0ZKzPyWrctTbQzoMoIOdnenYJroStsl28gJsCxbOiO3jXp9G4qGUXGJZCMWhTLk8O4hHmAwsJ1ucbtuoZICS//ObU/bW5I+LeFTiqtk4917s2hbY/pmsJXowlOVm56RuHu1gYqu7ZXMNZMpWcUs1GTGUGOa1OVC9QW4Iz/vmnJNd/gX5rdayFx5Bj3fageKJDsFP90dXVF9y4zXzYUy9xZNhxYR4DYAHTNt2XCrEYTYF+N9b2PChaiCyIrDxDfkaTO7rz5OTYCMfFMO8GcuBCxQDmk9RN3dABi3i3tp+fPtqnA16usJ18rGpqEQgYwylWg4z/9sPCm72ghPM3mk7dsrHTHelazurxwGi3GImKq267BaxMXCUK6ldz+LmNNguZEiaBa5F6Olj94V71892ohLQseyov7bZ5mBLZrtXvtTUokFwGA7sWDPYbpErZbk690ctsqYJwnx6tL8Pee/aR8EIRIPiJ2nqVJBGtxR8bxxVB3bN/WKfrY8pun/dZd5no62jcjc3OwAxGj19Ci3oiUHp3Doiwizz6PGcb5kDLJ9umRx6X0NsUwTn/nRriGzBxUuIkh8y1u176EEDl51OLrTj4WBxh1FTbTiHTqUsCdoeaNP4jwnF5rLqqHS/iLORFuztShIQxiUrkU55NyFUavCTw5MARRKUe92x1jwcVBXqw=
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