bUx2ENbn44UBbOhwXoTn36VLLZt+Q/XLEmRElOyqwBknrf86LNf9srlLIP3ykaeGtzFGM+Kce/Z7W/IiqgB5Hag7N1/1y8sbSUK5aVcnPtt9b0HUsgqxGJcJA/dA3BdGaZXcbzNjyLRskusbGOyVPxXnH1j4YoTJZEjXcBzV69qkIVlekyUkpj/SLAk11SQjoo9Lg+b2vDY8GHj3jvOQpYyoY5NpvMUOMJOeuA9HesKhahiKruxEnFWCvs4IHNhDH3pYMJ9rpq0fYdVlyTovzC8esPY/SPAJTDcEv1pzGqFoju1BhCxSauYa+HNRqNxqoxVW6jnQarFxnYEEc2PdxIrDR9eCqixlKhiuZbUMVh8QSZ1z3jghd9u9/Bt5jndnlGfcOG1Hvm+xqiUCgFqESPE9mO+iR9SO71t0wDVpm1THCHcKVttKzvMvC8h9KimhqXZWR/bQgXc/aK2FklOOhXnvdPIdH4MzwXdkEIPHMCH2fkijYB4DSo4HYUdCyGGP6ZhgIT1kwQmpFMy6C2oSzF5Lz7W2dLOx1mWopiD58VNUV7DlhATJMZgsDhU0/mNkEoienYmScovvKW1zjFyTRQ2R4x5gL9ntPOxVEGA/IOg+6mAWgznzKeJTerd80fKetSt8qJe7xogrz22lIMSO7FOih4ulp42HFquLMGs8v6bAIyK8GPkZGb73/mlQPa5yB48bgBKKOuXfonzuJdH2HQFlTbaUPWR9WAoR4dosxC8QIb1QHtm5HtLCHtF9GME6n/xqU80heSiZdEGP4x2x2AZf2xjqdxR1vn6N9L0+hD82UoJ6PFpxIs5nRcDY6KN9VWtjAR5Br9+R53gqMEIQx62aAh3Vi1x8DBrc+esdBtJDL8822S99Kqy93oHQ98kW7DYW
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'
GROUP BY et.id
LIMIT 100