W0bk+Wcbm2GFV/bmARD/BjQ+/h00sXTgWAbfxj/30+4eo+dpuublYJoFybUii2lCwwJjx2vNtQniLPLta71iId4HvKyp7g91HiMJjS8/S9cJTgDlUPtLOvAkP3AZ0gEKq5oTA9qhNPJXrhzEcBDgg2eQ6B0MrhpbQokM6LbgUP1M/lfRA8hlBA08/Om1BQI5boVUhggbzNkH/O0k3yd8onUYOYNLvpnAjsLEOMM9vBEWYGnR18ecIvwNBZQXCCAhirQBzJS6S0wUXSVs5B0tDBiL5ZjupkWNUC/fiGpKViY56fW3iAUE7Icb/2u6tOpWRcwifdNb2zeJCe0/ayg7eQ5fyPUK6hcXBWLx5PfHf91rbkpfg9GR6YnJ7TWNLEuGSeB48ynib63CqL6aMkNDZ5kd4mseC9PADxTvY3TXny9ZsCbTtDkT+7ZoOm2+QzNTxTa/OIWjVZF+Ab3bXjqQrOkMbHaLEJJU3rqSXbTcuAjreVIph14DRBKsAvBpAhO8b9e2paVzu/fjk2Vi0IDprQEiRtsTHfLoq/wO+RAeJ4OBm41wA/IRaMsHlCvnxCc0LUvEXzK4XbA0bbwfGWzfRWDlgIlDz8PoJgs+2aWth0NWRKVasyMkuz2zyKYNRt/9YWVYnr+henmpO+XbEIJ3qJEeN0y3Ngnvdl9uTK+u7E/B8hdBxyo/1E/2kWk1lqk4Dx8bpxojV7wyz/EBjY1IU7vuZHORN/xl5k1YLVS6OPcvhLpGQmiIHorL4xYCGF6F6gtNYOPF3ePtwnZ67Rlf4AtvKG2FfUbe98pf41ro2l/Cv6C0O/kUaX7LraPke8X/qwjwDfosxmgw/7MuNlQZmXtWqBuchghwZCgO7p3kijz4QWbeufQiPukiSCCmsWNtlMPeg8FePcUE0dLLay5OaZD2Eb+Nlf0NZoOHzJfIdbp4XHDyUdHHs4o33/JJLYYHagRhUS+2RLYEWRkWiJ5kxDWHuaPg2SXIkkVP4JLseL+nmZuwgjrqM02hC+9FchTm5UhYg/cNd7t/arVOdQpsetHAokm8C9ATxVbRyZG3hVZyZ4h00wcyhXGXpFlGohbjlzV4IvJEtlZh07WmNJ+aq2crOwd2pK4K1uKnVF8ICkXFQhhaHNEqSpgA3ZDz5pgCG01WioLgMATxHP6XD2djbWVBxCuBKpxPACemz0u/KyUIcr7D/Z4LRlEBnn3BMjkL8eHfwirnW+IQgUtelvoWBh2pZWBOfzNla+QHTWCSQ6JkfkI+ADK310OvidZ5EdTJeYr870/n6AG3ibHVYQUUPDoOEmePfo2Zu4Qo+Hf1IE5kyEIMg6fOxhdP8n3czVuu7WkJn6pD2eJk0ZKHYJXNYel3sMrz72eaciLdHNE=
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