EIXg7dW9J44owYl7uvefG+JJ68KSX3v4404sPxzBTIhfOvRBlwRNK5f8arwJnllMeWL+1peQV49l6PyhYAN7sJppKumpNwq51zFU9PC1i9R2EOZgv9rCXPJHBkH39ffej1ooag/h8yOWISy3JyhsCATsT3E7qnrbHhEjasuAgGacnDT1nU/4/qmv2myDVIcUea+yCXGgEEoFjkYwWiFg54RJ9g8rRN0EwJ1e6RAo2mfzhYuutd5daZBaba81OfooIgxeCYF4wavlXOQeM36kU+N/GNaBJ3uzUaQKaiM4BzuGAvAcduOQGPXlsz7ATxuGMuGvrt/JTQsiGV3w4iodzsdOp2Se2pHq2Tvc07kkOzSiKtOHuzuMgBeTu5zFA98BESZNYh0O7sX9Ks2Bt4mr931AFOCU6wu+Iki2HloRFv9PXyec9j2DHDVisGCBwE0fgHBCbM3wNd3PinXwegtB/jzL0QzuhSOnMot5Wljo1W4ccaOdSZHnrQMAOFRQFJvxGGuXD7Ty2PbXzsE/rgU2897ZDQ082wDtPWbcnajXmgkGL1OEPeWOoL4jFCnyIHlPUH56EjAc4Euh86MMCNEx4dADI9GlgtmOE50yFXjEGktmKKY1svgFL8o+V2HPIGIF5kVNvunVRE6KdyXFN1d7IEmVd9EzgVNdDvpgOVcVBFWRRKPQohEIs1l20JcsUcBo2TXtiZnecDvLHkNGBOdKFnsRWtHP71tvC6KLNOLgvnra1HfxNNGCKqoOr8IgbOqmpIvOJwtK6V/qtOXwdfB53HHA38R76nWtQP61EHpwcCT/J0GEb7a90F0fIMdsUxuPIR+R5xOjZHeWMv5b5t6Ssi83TpBjFjnHQmpdKMPFUJSSXLlfhOSp5AHYuFOvje/lvGAT
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