srM5E01Looe5PH00nKI8QUBHbACpap382lBCrtjuXLHY3WYCwd+hamJpB2LiBPvhLZM2oofd46MzWatHiXw0UrbDdbzALam82CBWcfnoqQ3Akw1YskiVO3oP5J0BV7OC4GjXnevZnRZ2lD5yL7hKXea/9R6K4fMe/okghB96SJIDn0QXs49luuJIcF3Nao5dL7KxKDedlsz/sr+JUMIIvNUsUD6Asx9DKtySNzflr177WfoaBjoRDiGFI4XdJPX2hh9fjrUjxeC1c4Kau7cvjQuZq28/aNR1aMN8761mMdaWEbxNk1KfY7pjOc1XDW0pDtirakRXLnlMpsrGcth/4FPzZKBmdzmxf7kF6MSoMv6axgCEEqlweSi6z0oWv7zpmrZFIFV7w0sQEeVLl567VdbFU+MK65btrHZhITOC40/2VM7gq1fo7KRqH62Wm8yQvGAB7s6Ph3glR8XTQ7mqcOD2Mp4I16Hf2HL/jSW/UQoiweyXdvYUJCZmUqwjAFVmHZAAw9Uf4UWouEfB6vWIV5CmYo56wID+NfLa7LoMz1u8iTHeSVn22ytxJ03GimOtDzqM4n4+LhRn3tRwceoyzFFUa8quEyk0Cc/BbLTSfo31p2OSDoQ2wQtht1mgloUSd9IPr2Pjt5UPD6zDZWGP5Wt1qjPdqjcKtSC9grW6FDYirjKode4gNxhWzXJZHaQVWH/tM09H1hNs9AjyJg05BfkceHxLUiqp+wGwtuBwykpNcCI7z6BmZ7T/DUEorr3Nbeh5WrvPXiiwTMEJf+bfQO+bwb9zIKg2Yg8NEeKD7w0dsbxyqn4xw0HFdyBP1McfUmZvZmfYCgqenVj805iQgpEl74upyQQL2FlGVfHcEMjzs36DKdkhZfssc4uhvGr/ipe+ZDXL6adVhOlwaZe7DAcNShPI0IeDdAqIX42b83VZ+ozJsgzKW+XVjFfHL0Y5Gy++FgniI7xZ9G6KFVIAIy5YiUxjdUIedi7Bu27ZFDpKkjSid/Wn6R/iST24Sa22IMKwUjJtc7A+JwkBqxGfsFUifajyt0HipMT2/+SZTLu8RScqUmK9jF+fZYMHVZuGgi6u6oC6j8qslRBS/SfAADbVkJYyHN12jSXkL46recUddwgwe48tPPNiqP42m/2dSSJruQpOUg2nd36Q0lKCMzMi4zX5YkDJkvi/nSx6jwCUqE1mc2QZG+mHmu3RtCn2jUHjPbmoKKkM+zmbIbbrrlwe
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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'
GROUP BY et.id
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100