qxd+UIJoHthycxvlfD5P1HTKLOU9BfHecE2mB6QY3EpwPp6G77sZQ//+RiKsMZmdHfTYorp39w42pbHVxx33a0ZuCTqiml9HptSjn8FQRSvd8dGoH3b2DQJNvNs+I0N+b8UibPlyqeWJMCQcUi2/jSr9/E3FLsPgVVL7zE9BMxL7r4i8iNI3VAeXmoOQbT2YBAObUNNMUECnLzU1kVPeppXlsDzpLOBm5b6OMTa3xmB8FEXzHDI8oVF/a0xjXg/SqjGo9NmpbwbGa0stuGofygtDm2xYktoho/8J0jEqrmitKa6XwwSBkdLGI0uzbDKVf9cYVneJkc6woujtqkFDW7iTi+7IWLvctpbBYCHhTJ73inaNG3kqMsbdIcqPtyKiU9nMdUmdgzSlfTS7OrzhmtfXsYJepUHK3/m1z7wF/Hrc8UuBinsNF+aAld5nu1x5E+xjmBoVJPTFhoaFqsfjrLPZ/d/pTiSAv82M72XDrCit0auSCgOeuW0ydDrZHeuHpI1zswe+wvG06iJGSTIf2WFi8Ufwb1mah+2OW+vOqvpqWqCyQZDIKrAAnQGdKbM1wYLJwh93MzhSohVi1kedkBEQF24opcSeKzRU/rUaPXNKL01E6El/hU+Cwa66GOGpdyzqLtrml/s37jCyvcA90JftV9f1wSscLatyKGu55JYkVZ/s8h2yvey3qaSPik5P3sjk9AO1LwizPiTHFXLUWI3V1aj4/QEpRZPZnvjCyCBTIWTETpwrTmwAqy9r2e59YvRZiJOcy/WQAS0Gh6UxqNiNE+EZtpIJ91MlszyzoxUD4OguC+xib45DgJc9eMLKOb95VKVbbhiidNvyz9O6twlYy2kJ0HiJQMxOZMPtTdbHHWYAmIxWM8hPZ0q4H4ptCypBQT04KwrpqoSpRp8iPLZvj0uXgmC4IgObcIxmIj0LNA/6SbHZE62SX2sm8oF/yMo15xkb8fjgmBS0PavR8BtlCAPirVMxP6FVKlhTk61dd4hQX0ySgaWpzwhEwTQ96AudKW+zsQ9g0mp/bBaj+K7kjf5GQRObByYo92QoWFUr8FA13GR3yCebdFhLUPGAAivT8C3Ed1Dn/+HYqwYBGv1DDMNe9dBuOCodlToS3ltDXirxJJSvM6aLnSUoSs3mvZGAX+H9rpAMoBF7haN1vhXAH6rAxNATVYJglXcMiTGqa2FfwclIYmJ+m5cF4igLBY6ulqrjwBU0Rzc3UV2gr32YNajgyytwm3/jC345T/ZT5Ys93G3T7/BoaD88tc/ChScbgFP0qb+GKM5tgpBgx857VQINKMVjODGYHOGR0kVALQvpRgCoCrrl9mOZHQdWHLDEm+Paj186H1tFuJ06gHuWiPGqQOZ+1a4o0CM=
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