h0Cb2vFqqE7iXO7bf5qcU5GD+RDDk+UwwpsW6g2y8IdQ6rfvV98kzu1J+8fOqH0QKtZCNNiEzCsfXEyJfUOb7fJYGZOL+7Xv4ISN6c7b2c9YPWzsq9xIeiVPyE5FTNzagE1cTeMauqy6p20ysNu/qCWPmo2ZnJfhmdGAAEr3RckcpyVAsyW/LneJrDKwp9b2YAgOvwvfZcVdvd7IrDKMr1Z+LlW0kLfTcRThIMBIrkjxTWpC23NOIG5C0HqNerc+R2HMzxTSUxBFR2+QgfGHXJRAhlkSzK38KHd/VUJ1xMi60DeMmt+zWfgO66K+ERDzM5fzY1oLaLscvHUignz4rNb2O9cQFRJavjAqZuXJLHWkv4fXXUfvzHB6Yx3ChXK6Ig/ZnWuXhLBuiRI34Fa1rRTOaE9my6qGN4BD09+8CgM3QEU6OSSKs7/YTTz32hd4MDbab0A5ERiXyEblngdwGdsLPQHWDBE2pylDxN41Zwm2SVWt9vo91eZf6tRVmW5ARsZHq5X72IcmRuNttUnMLaOf0Cam13Yu6o3ONnkjm4M6vcP2tv1HKmWpKbXiHId06REoltf70J+luDA7bCxO495OhmZrGes9WPH/Ze2X0m2Xm6JqM2skzKuns9g7furBkSlCX7HJ7DJ5lMgfQORN1mfX8CR/4zHHSQKv+wTPNikBA5SBRENetue4IpqADCrGkVERMKY9siAVDdOJS26XRMHEeqAwVF1hT3T1pll1v/evBAq/PXPPqAR4z5FUMpGEINHBayNywr2TRg6kVrL4UQi0uIlmfEqKGW3npbVU2Zt58D9SCUdVgm/tQStDGWFmzKYfjLywHnC81Z8rOWWSZoMuyHsq5kBgggLGmKMqqZmFnr2RCK7peLeTVdX08yjSrQCOF4Ja7fDCY/n6VKGhcKXmhINpwQ/lJ3+5q33TqmDGQ7gg0ymo2NwShPyg6QhM3AqMW/95d8vPtNC79Q3JGPGkvFkzWozCF0JpQ+tf1WdgFcZmETmqy3QLhFnZ/Xlp8Jtp2qsek31ZaVy4xiLIFtIJQCsrnmCNSwRSiBzhrbs7F5qU+FH+7nMjaif3Y5tP+jj2Nq6aNndGbmtWyzvNDopk3h7Lr6mYv0oxz5mcbW16D/89Vfg/h3FkU5qEcdr/adUVbGTtg0wfn5zdMXeI58FpZzz0pDJHQy8TA7ocYZ9f3+eQWOXL3Fae+kqnEs62i4ZyZsznEb2DLjAYP67smAtwAuCpuWW7yxgtd5aoJslT3bnL7FiJmkET72OvHqzggZ4JLuPMqffctOPac+8b4JOtY/nAWm+aWkJriPGeMSriWBwupiJJxFYChGPr+VfE67NeMhJGuFLrVKKBs6vo7/vKhddKzMms8wVxT3s=
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