Bb/QJg+o6dli6YmgzdGHsUd5hi53GYVXbkI7KbYmvskiQJByNLx2wCf3+7HZzt/83t+ztZq/Sk51PJt0nLoQlFE7HfrzkI1Bn2B+U+sdzjMIV5eaixjZLrUvxM0kkT9snXzaMcoQldlBsTDTFyr2Cf42tKElhTysR82Dv1xNan+GXpq6GRqPUC9wMsEvhoyCeqXuyDCxVxnHHZTQCnpWVEQ5Vns7aB9nGvE5Ox+plIs7ywqcSnJ9MPYlG8evbGy2WRWOMxjLWpMLIoRSJ5fB03JRFA4+fvWcznRTWuAZWgkzICgexkEFFKOwB2fGkWJTwQ7N36eF3WEf2uGVSV6UCs00GUVB39CaTjiKU+fslUOxYts+fUk96qg31//sbcxrAU8WJadQHVHZyUzsElG0nkNMBHd1wK841vU1Vzdc5D9RZh4m9XswoWg/h9iH+KMw4vZp+K/r6LU0kVM8saaUN2A08UERXPK3lBHS3cR1WoWjKGfE77XooQNRZV9dxTpdZCQI+azO3jx8q2nF8sjxwAQcNJGeHY3zJEW4xCe2VIp5+jZCZZ6llSsmEbNT6Qzdu1ENMZIXiVhGDSAxhIpnBtqJWFcE2SQsM9XwTXaqj8RVF9g+cQgGvLT801pM06UTSP2dVHW3Of4TL8Wde/F9vzLs8A6tJ2SotLmsX2DGjJSwmAbGbkAEhEy5o2BKBlG6JtPkOwWSSwG/Ym2fXckGGyQLodXQByAg8l0wdDZiUnZvlPg12aCFTtrlH8Qyy74qtTJxm4BvFOlk7GQWcz0GO3tk63haq5KUK059u0+dUaQMjciqQ+Vsls8C+pbDXglTW7Or+iB04xLHPE7ahDl8O8GPB9X2qvxbET0LvQLmla/t7wRf4cxtOrjHnoI7c4neYOoC0s7UoaWfiV8Bn6S9I2wo/H3quiagZAdnRTIIZqOqxdeKRZAs6idPMNeZoQq3wxtsTa53JBHIXjyHiOlY6LqMjXrKCm9DDH7MhUeTgB1whKYbVxNDuw+mWapkNUoQ4+y0qLaYpoykfPcKkeJNvdMSGmnf6NFBJiJxugnVxnllNVHynGJfHAXMOvoyVbqgPVPU2wluQtC336nAld34bNIe7JZrjShUhfIZBZLUgUhd05OsBtKXosEkx00CWVI8dj2UXXF1PTyrIljK2QNJxnl8skAFrbjbsnUEXsiAjBaACv27o3a7gaHPsSTHxFjqiWoXKjvcg32HvSSfe+KWwTfxgcT3pnN2pA4OedsivMxnzLE6lYJ6EFTZ1/6wqL0eXNYqQJzDjbtCN3z8px5yRR+qNJbvMMvBQ1haN1rU9WEX2n3kTs7cG54e79+n36LRn8NxQ2tcm+zcRBAgkrg+m1R44U7+NcBGCpo0+Uw=
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