b2duRSPI73MonmNVFrk4togEyrjyky0ZKm4ceJFwWLTolVK5e0G+uwuffriCbwlpeFBbYTErgHAsva+57+QtTAIqVOnJcKeooZWkUypCC1+LEywjsl5PdSKTw0amOKkq/fz1g7E9gOAsawHK05u7279eOYIldzcfcPKiDvEOt1zlxc0y8DuSmnShu/xlDUB51Y/e06eC5jIX4twTtUnKhgQityw//FT7iSHDMIfQrmPrNJtReaKxW9/2QMFegwGnfXxsyyhmzz8wBTd+3UHLMGN7SfzSox+5c9yZ6kB5jYvdAuzpq/1PPx+JYOldj06VMWs32voZC4VAU+WWZbEoWM1KXvZH/fez5KOKR7bfD7xlUBgctAwuSaJVg3y4LCabujdPP9pBc3kb/kSjYDwscwUdMEMixIbwlGg/jO97lbj0jrjuEMcdYjodGPagAroZsPsLSX4QakCM6i+wIrF0AAdZ3KP/J9ediesT/Tt67I78V7OnmE2chG6LPC4puzDxd7gA54fqWUg5y3/VFLrJKZ74rt+fgvttGk6/CtXAYUX7Me+OrO2SFL5ODNJz97LkfBbVdp68azwqeCm1MmpMHV796dDiakbxOJtLUiweYlgdR1PSGIgr4uFAh9lf72Kq1UhCTjNDTy+J2y4iDuKV4WKqE6EAMiQqJjGX0W+czOr8dKgyPQU4Kn+M/RG9q8QB8p1uNxhB5sHDFkBkYHD51DXlHX9livjJhbiIKVfzx+VXRQql5kwrGnjrCj5OMq3u+wLN3eYnWkOe2EGA3oRDZ9f86Fs5HjDfZq0UohZk90aJSZxYdxUnnHQ0gBCiCtG00ZjzJGZq3aj/T69bhisPEmDW3dwXX+jk0wwfZ0PAEDhT+Pp+GZ0PZnzNBMJU7Ww8wKDNHuappNAgjhNeqBYfhXv3ATpzLcbRGMm+4xz0bXjbqnmVMcWwE1h6h+89nKv6DK0b01JsPxxn5tc5kj7zo3BZdiVMFRItPnUoyLvNMx3IsrwJ4Dgma0++NHnGl+RZMVenax4cL27IRcHbYW436eLMPosfESwTHI2fGCuhXzrs3A7jn6bY8FpDWqaGTCltWccz0nyo75/FULI4PeawsVzENDOt30PH5s0AAA1Zge4NMNUwHm3skw6ao7T2Go/FGcM8HwO0YAISsiu7ARRMUOriKjX7f9Dp6oUftH0FOf52XWM+jotMbM93jJBFenSrbBYJbgabE6Z8dba530pTdykXWeoyOPcgBNvQw/V2tk5SxP5uj5ngeQ9nscw5FdnPKn1/GnqutLHQlodD1oobyzFWMOvuN6pWYMACIElVEo7AHBOKcVGQlT7jx35hgyE2Ue+e+XC0TznSWk8o9B2b0+E4QZi2K6YWOVS8XZw=
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