qxRiNKjEEWsPEBLa3MOf8oAEAqPiJdSwroebKWqVmCNd4EPVccM2ZypaT3Hrd7gD68gQWwVDVqSffxpApM5zjmeQzpGAtuqaQ2nnISwVPfEsDi0PBlV2/PaykakUauHSVePpEsJGbdZx3V7BQTGNnn/T4BvmcchHscMDqfG1m5EKQ/2eoak6RzW9nmAmqm9X+1Gosh8zSSwj7l2ne3lfUTtVANKrGECgJS/v8CuJxPdWnPLQpSU+9ivwgOg0JCDZxd1W2HzsJP4/dQX/WoBOcxo2UgySRlsYLKqbMwEHYor7W8CJdT4qAUTxetY7y9pd3Z1gqIV/2CabqennUe2bO5Qap0906/YLGZnuX5rsfibl/dNC8WM6dGNK9vVBe8Bfsa/G1WnuJsB27iJ3YnYDc45pgzU5RsPHMR2sC0zIl7tNtXDzNpoO+PupgeNWG5Ovsr8hbO/lRZoV1r/kQD5FNiag1lf2+b8Gq85CKLkZ6BLp67GqExCu1WEJExAMkP0yJsj9qk8IFPoyXeUBYG9CJrEh9U149RtAOeFVgNI3oOMmJNpLZX2TSPF/cokXEthyuH3UeqgN7dlVCzNvQYyJksbGqXl0KeONdnmP+y66nFZ1ujB6OMZQzVEiuqL/EVeg3evX3ytTsmEG2mhJCNMXc8FWGCeDU3dXEUuqRvcr4g1iqBSGaLprGVeqaXNtp4nNCSGCywafCup2Hc7N8R6G96Rg6hKTLIpKpzqMvVfFq1LR4HqNG8NVP+pwEWUs9N1oFLhNtbfZ4F7HfmbWphc90Dy4byljmZhXClIAikgaIUnJw5xCfV8hdTzryLq8uRxdnSKBwLDquLj1INK6M1NcGUtzv9UTGn3IQsZJht0G6J6NjbG8gq3EJCbC0l1CYLgSKAm3qFx/K5BJrqSjKwoCtppVxMa4+rIUfCXfTCArrSz7USCvrhrxbLhIUFLwQCZYsEVGfXGanK4WXAy3eQknF22Q/h9Iho/xVhGC5tzFhSzmdj20JRNraSbIn4wrpyYGe4npaO4YZnas1Z74ge8BriDrj3SMndZVn2lDtGxnh0SccVo3h9VWJtsfjQ97HXDLzz0WL2habORmB1cdzhCpHcNLeXAbTMiFAumFviLXjWGhIftg3PSV1uJYcHqhkgsiNCDV8UdjfDddj8qjmqadOejejbsPycA7lnIvxqmWAmMjRAHp2FtKzVrj/Ek9ugN/QflM45k9zCrEsE3Lw6/PLNLNAg4DPyEki9z655CqWdF6sgfVgV216wowLWbkVLez0wqcXxepyc82HNiPscsLXtfGXaWQ8sEyN8uAv4pxl6eZt7VltOyCwBwDvDj5969WLUa8ff6stsD6NekMtv1GVTO82lqz5hKb2DzvURs=
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