HhMcXh5JYYpQjBZkIbaJ7WYg1uZNdVw1q2a+atmqF1vwMLZTWjDIL8Sre+pEaqGwMzeM1bFGqKMg1SxrObIAwq2E/T0Vsp3JrFcZbH4XAkVAioHDKBxWE4CJN9ao69jJUgOXxqGi8DoVnCBTRyiqenbNCtHjU+Z53bCkDTVlxqI+vcxQ4BDImwDpdyNWycVce5qp0FHdd+JvWruP4ajlAgjhpRsUSxrRb0DLYlJD/CL9nfqSrFg8/3+CMESRh8uVOA9Ql5E1w5OXijxJNHpXOtNS51zchIViykT1tqzhK4jmX4JpuquPsVcUOSUOcS4o3mCRftiE99IxKjQR+g4kY5l4yBuFvkrBHSu3HKBhPJmqhH9UUzW9YxzbYCy7x+xB67pmeU6f2KPfm/znlXh7oUZ2ntQMWQuU0OrRkiEFQ+Oj5pwTYY7wOAwnNr/JsSjMbdYT8MB0sJQS5d/C1WDPtFuN+QRIClGP10qkchWDvhKmG1Xwa6kGHkwTPNWT7+Tm1ISLWAd7vB1svMQ0i36H35F6kLR9MSYlkkAJHYynQEQhSrjaDTCBoc68bWJFUv3d205eRo4IlmYrPR1glcMpbVsJVM2Lz/p3RH0VPatEqdTbqVLVUssGhWq6POWKEoDM/ehq7HTDyRfFAvQ2/fX2bR8cPBDKBPmtq/anayoODaT/FJO79uSbTWXVXN91ntDkgjvTXj8im+garJFuSIDDsl8n2JPtOXgAXmd9HQ5biAW2v9P5LccU5CjW2+nofp8ytRb9NvuI+OF/hZUZnzoUalSH627cNgpstCiBTNYolKyLp0xbdim0ZnUINjcXS64VNwBSyhkh1SbEsKbCKL9/5TS6pAWwPBymD8K77g/PxigmzspijkKJCHRpVn0Hhx/8WPAisGLD56+M6RsufUo33DEnNky9mpyIUVI7YpUI2bLNeByM4m+fCJpei/+u6o+OYrPcUpBILf90CvCcxrgPSgUNMjMqepe048SfqQ0UQuR3WTCadAN5+OeTv77MRI8xa8e3zj8b/AHyB3AKPmA1P7syK1DM3sBaOPbvJM7PAnO2pF7btXZ/CtBh7vq1lRi3VHcW0sAXaSwg+/X6JPq3FW08g9uJcWI26ocHOlm4tu58G0AYGWq4Bq/s0sj3DIjTV6a5zjORm6qvZGh4VgT1bPHnRDx0iPpluWFaVsN1hSH69SXSPrvKucjNcoK8kW453Ri1314vP/mIqyTLVD/anG+7I++VRlbEhL7C22GNpWysoeMkkaT+EcrCYupyino/x4u6GkvcXi5T4GTQaWC6KdMvEmkQdk/v2iL+jsfrFHDJrkpRiarWL2EgIBtG2LjbkH7hjk7OqeAtzzryuo/HX1dgmk/6DBw3T5AGF/A=
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