bEMCAxU4SLscqihLumijVb1NfMuEfa94zh7YYSvWDPTFkjIa9itxHMhYJ4rbPoBXYzTotsoOp6mT3fwVIKa1XJ7e5eal3DVcKhx+QMuolm7yDl4MhT43Zzem72QzOxy2LqIlfjoXO7v1LOGk/SNbTdOtZS+/Op47y55gVxRFQKEuJg1xLDi8HhYZtJTS84dv0Apx2lhAY9iegrhTmTXTcYz+4QXa287aZZ0tez8Ag3EcRNix12IsJMfYtmn+dmgGvUMD61o4DQ495syEwyu0cJSa5QPQeDq/VGSvs4TZjg4M5nf+8N0RXfz54YKA2CJQoVouv1fqn8hdjYDMo1CZ2JSg3SNaPxa44438D1c0q+XUkaD8NLmB5I7s+qiOWFUo9Rb/EZK6pWTDLwZ+VKgdOD+n1iWu1S6HDjbQBJ/MUoKmy8FQ2Hsvt1l2W41um2hVP5h8ixYArl1Xs0Ou8svO0PapShmEokBIAMZ2wHVm+aScplMhz7DT4oELCINCiqYFhOMbD6FANfF5WSz5WO8cXYOH8ol6bzfwEPpuHzyOw7EdUKMBqOyepRbOmkTPzmUPq9jznjdS0oo+Uq5P2BVUTIKUBq1O0kjOntWJ3R9oUbaiVhdfDshPJzdAe9kjE/rUI4IX8khak/+DtXcrPajT2uKeBhH70NlRMTgCAgEQkG3aMXrUa38VXbtEZvmxGZ2SpqJvLEYKRRzEmuXTHA9teZWQoWIakKzH4tVP9pFCIMJ5lQDD8+tZ8WelCbw+SQuKhHPlilnHkWV6bY+5wgWy97MLfn4c7OuuaC2CK7LE2VYDpUJZsTElJFrPbROljk6WwA47sWTbyj9FtXiCWmQapKq72mG+9i/5nWAr+BunSZDADAVEcPm5twpRhvK/LSdHkC7DvsGtGO89KzKSUNBHfDKkMMUR5//5Fd4YZPmhR8/Kz9WuDdC2/cyqyzInVb4Se4s8a3ObjAdb0Bv80qxyd+TGfOJdsVyyA5EscLdpDfUj6IcKQQqzcaRGKTrn/fRw+XlzYKGnhBlE7KrKGbOOZhhSQQAnH9MBGtpX0gf7ZaJGLL2k+t6yfj6jTh3AXLlblTAd69yjuBFKJnQ6NuR1WjOj1yMV9MkySL6fLAnm3jJhngQPtSQnzF98+MToEHcnkFwcFp6zYofnhrHc3BbQWQYFFPuHZ4cpUJDUQdg45/okdjAOtRP1opqjiGJUmaR1DYYQ9eWkaPOcfLnoqNKDQr27VDC++bKteM2lbXKp/BPYglnWyu0EuSVuOxhJdM16SncKADcWnWY76mm0plBHgRbe7iaMpGJCWPVnwQ29UEXv5kZBMXuQDgVK+m222y0NrxwcCNGYWvm4NPoSlUsouioYU7BPoWjaANvuuTE=
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