sPK9SP74Yp7Y82FiFSqsH1Bs6iR83dS/R3EHnVDqV4kjMJCbTbeeGKyCrZVU5Mvj8b5B4EQjGtyFhpB3EPq6gWafN6IdGQquqmXsjer0Y40uxd68RzCCl4DyZccFA+HzAQVj6+T5yzNZr/rgFt7UwJ57Rz9xpo6DrhMMTKqwJAbZ21Av8hpsR7Oj09IU4oYKT6uwZPMKogsfdhPnpyRMFGBbML/lPzjtTJyEBaWR+/DLVZjdqKdKLBpPS9Qt2pcCGc3iJHsy9sbQoGXsRxeY5E5tONMMln1/WlcAmn5P1/53cHTLGPzQAv5jCQArtkb1qZ0IuMxh4QfTPfQZzwJ+vSDpIuvO1p1mXW2AZos0LmSw+b3EVpyFhfabP7LDjqR4Z6q3JJDbo4XqK7ExJuSz9mvq07Vd6OzBhVRFHZ2SJqhTBGLggadE8IUkEonS1PHCAL0a71IgUSB9gyRhbPyTRK0yI6NLXLYwAt6Lc0X1pPJFKY41Hzb4S6ncF23Ev6YU5m3+CC2x9XD+Kc3SxmRQzEVRoaCz35u9eIAXP05NM3PiXPVv7nzh7Bnir//eLeHtATT2m6oghT0n1IMuA569Oy19TifwXpkyQEsElBYNAkPjNV2VBXPR6X8Ae76XlrlJu3fxGL924EnIAXnacvQ2ftmbYMFSTyXlbIWNxEJJxkfl1j65Lsiwx7tLmPoP6QWxKwb+hhM3pzgNPQlOSW5eC6rS3N+spo4egeEwxKjfieCpX/kS+ScCdOvX8GyCW97WgwtmocNXX6GJMcDVPxR9zwghpImPvIoxYUgi14WJTfHxWgNUUXwO2Msqwd4Mxfips5bxnqrucv61o+oMh7lk0D2YKVGLl1dgqWnkHvnYCKJoSDAJdsUbjXlQeOJfYBI4YoJtWVot+ioziURgkFHyjfHJarBhOnXtljAIbF1ZfrB7HtE7nlUxB9R/ThZOI5aiR61X+PoVMEIrWUnw0qBdf1rOGplciPoH7FZPZcsJOs8xudD+X/kyBx1Iva6dqVKgXmjxkM04twJIVAPDPI8Z5QjJebtvv46VxPugzckZwSTO8JVVHSgSypAv3cVx36FiqDJf8G1PtbMwQ1WTh973Zk88c8c3V/a6RHsBktBSM2IBEsjg2JaIpt/keMgjRPOn+Tpa4TlOv7l6oTyo+Q5B7PMA2ixYQRwmu0XSyuMU4nrXvdPhm3LFazJRL0puff9nh0NxsKYLNHeY4+W2CRwLdPVgofLvuvletM2aGej7NHJflvg4+ABpP+ak7gPUsEdOJfjza6Xng0DfV8w0JU5kX/EFwv2m5adJNjq8jvfVwuHlZD2h3FyDV567bzILJtzYwa2ptxqWtTsUcM6SjCiwbiHor0oeQmpjI2n0ZPo=
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