3dA58UBrw1JPZ0MiVUQzCG68SGwdOwMuFI63CmJ5H1gLAbK5jJJUBiZ8Rvq3XKq8Dy2jz4OpmPasFjmfQrCIE5q5zz6seozwbP87DEM4bW+RXTAAXAaG7Z8cTGVCmBs/Wi2U8Tw56IHOZa1mTxAXRwOj+XMVjgmN/MIkbKqqzqzpwiuejzrgm4SEqN319DYqEzye8SP8O4+Z3MET7TOCXHQudVJg3tVB2XIv+mEXV7n+yFEf69essMauQNYVQqPpEpA7U+uaX4UTwgefUU+WfhGj4yftscGPV6w7i/GsGi82IYvAk3GZ/HvLvsvgod5S1XDn5PMDH0CC6ju8XEHF3AQ1KUbrbEgwJlr/TYHTgOmnQ2wM1cCkq0G3pSwshqN3IHaej2T72/ydxUtLn9d3ekyQUklmKWoXXv4cvPOEkcHQKYxVlwHtatLfVLpAEWwe6WA2N7J1Y1KnSwMpZFnJ39/gLQzPGHD4aQ7HFTF4dwB0l6rjf9t1YkIRW4QJKRourh8+4LcvdKnOmuowz7ridWXXlfNwQ17b+O43U3N+AIzMv3Qh9K26z51J0Fu8VGml0Y4jQf+1rWI420Vt7hFi9uylrGQpm830bBkjAcPYhuT/EpCIS7NSYxzudoaQcYSpEyM3tXOj+h9pD8nVX5/Ph9rHzbUYTx00KgLzTexR9nVlnKWM7pL4BHSNOgp88+4pHMmyb8pxjpZcQqO2n+7mfRWx2qAmjVIn+36R2grKXU1g7T0WOb0bQysIAMj1eDtLk89JDPG+2L1EtO9u53wavd3hE933cBWXj4mwNmwNvfbzLlr8NgXvycOwXGbnenz2zVcfMzEnSTsMamMB59wQ0ZY2LYX41RHrgdpu/Jg+Id1z1oKzz/5HJsxUI/ILNfz7Fq+rM0j0B0rRoNlIVkCUPEnv56NlXUGur+A61M/R6Yp4pN17zeKIBlq2aX6C5HBkaP1eEThO3YmkPX8JqJ2if/q8XM00/FWUMvzDJi94br6jKTrDkS0O8IosCKqL4odqr09dsGUGONWMB4N98kRpmYX4af5HeQS9q4B9PkxFp+F5oVfvJQA9ypNI2jmNybolIwWEg2Pm2vc9rELBetbKdS3Mt3HiTo92BQsT2NYcZzuqJlPkQ2XgTNvyHAkJ/Yr2EvPiIWqcrxhKN5SbCLWlfFv+hJ8m1w++IASlnMSQhMWAI79/pXjtuXlqXd8zqVJA1djcorBdWKLLWblWrZJIdyNBlKGcnC4gIQa9oo0cf6jaoVr1rfYoAGn2t2311mp0xYxCFY5k4OvWbe2UO4pzFbY55iUXlqwHmCoSMxX02+dWlI1BTZPs3o8FR7Qp7/u64UbbNt/TqARlz5eFenO0c7PnG3KJGwXVNC+MUVs=
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