OiSEE7s3EpawiR5qY3ePhdjByr7rdqz55EwMCk2kY6tAALFn0eN/zo3zEU84C6mHiEmGRDbQO6lQjkpgx2mv2Qb6jDfpoJtrC6VsqSwPRFCdZ0QDmjEnFGNSsytHMaVaTDKQl6w6drIAFveKe9VTKdtuqX3T512AxWZDHH4NBwRorLYiNO+Fj+jPyQN8e+SbI3eU3ZxouYsiXJcsXX13EJCLrtkD7B+SyapgaOYJfsqeikGy3EqWDnye+QWjakpVxNONCqHBYY1kyoYx1oSlI3rqxA75lsK/Prn8UEka38QOYOR2H991iA8vYC0gvQqGocoss8J3yV6dH78KmdP00l1TOLCwcDDJRaM3Wv6e+uu/7tCViXtCiwzgrLmYeh066nxhbA5nCZCSIhfwgvyat//XpiRn0lvBAwAjV+YdoZ63GPInniAmM79NyvN1LYhvCj4WuDIz5WXxOtIRMsIAwNot1JL+VTqkgYdhwND2sYPXqNF9p32L1qf5ONegSzDXTD/8qsYMH2Ckbs7MnONsgjhIwg80ITi95FtRbqbuW6irSvVgD5fnmH7LOWChfo4dA/DX07XTeDhtfLz7pnUxgskJ2BNlnHAf3G9seDr7UFUKfJFUZoRJTuZOWZgFeZwnjgHDnlwPkga8hbBufo3W2TupAyynv2SnVxzggVIvjb+lIJoxMFtb7VVHf+uOswwhk2mHLsvy8lUriLUy+zkrvl04Nr1gRU+J+7ysuVJduVyr0LwGDjoy91vmYlR6Gxf3m6um13mZcklTOq6hXnbaa9RBRxIhi9MUUTA+QQRkpCz7pJi5esepXZxqhRjuq2Ak+NcFD+6khBOy8IKEChOL5yiWyL4Mhh3GXG5A561VFMw9w3NI9mta4rLdoK/2UsG/qMYjlHl/eQbJFTQixZRt6qX0Ko+W3G74lGXmmsvPD+KYa8KZ6efueSDD1vYz4Fg7W7tLlkcPqGR4u0WHfKK83raaUV1iAw+kv7uPRhDxigKIdHiV6GfmUeTf1KfS9VY2/ERHBdW11L/rRHn/ih5N/rzLCQPFuawAEmj2YJpLQGcPy/VdcYMQVgOUV5MtvI30E/XLmgBqfKcptgqa90+i2yq6GPdQHbyi0nJ+Z5rL4+OddhRq9W8mRPwP+dNw1zsDsa2qfLhbYeiHni1/fsqfXYwsNOpp3ycRxmjKmabcHAymi4ekRS6Bn1VN9VXUYDWTBCF6YXsL5sL4HE+g6uw8LCjFPufXjtNLWT4oB0OUqc2AwvdBrUKTwySI9eqCbTXmuyGK2N0ggc4H5Fx84u8FUA235lp3wT/+TkARzKyJ8OEFiJ0tOGB/z966/aIycxyt/o2DtnwnqQGZK2dikmXLIKnzLXyHUzYbFMS3Q8E=
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