WXzRZtEH4Lp7pLQ+Q0qJN6Zlm/bUdQ5+S8sT6v3QXVhy4uWsYOwMq4o8YDgHvtm6sDd9qg4nH402hZvEBhXayKDvooac0NCeCHi8QYmgjSbaTDSPftu0bpVZp+6D5pTCRNPvcQqZ+wYkJHiv36bw+gpTkyeoNTW+VJ0GoQuWJA4wLNd8cJpCgofa0Y6klrxuhrzDYMIBTXh0TO5lG2aAUpseeXk8U3sP8zG5DNFYdO/82lszP5lo1afm4bGt89MujYbXEwFHdzXL+/ICktRqn5aBdQp7MAYja6No+1Nmo7Epu1HT0YbSf54Vu+Np2gn61o1kOuUWlwqtMRZ/Q2LFojiI2nn2nX/RVM9CGfdhJ1tlzHA8FEKuODxIP4B0zDQOOVJC0YDmjv0pv+BAZRPC15SZyUPWx3eeedZ2QVhHJ1rDLqQfoVDDLc2ybE3jSgTZSorHnHSrqVPcGdH9n9N+e4d41Fk5j2WfHkCIGCQ44fXcZl7XmY6HFsrGI5cnSyigjD+ARdCROOba69G1sL/x4KyC6U1Sxaij4YkAJ71r2wsW9YYAd1bSrZer+mvUgU/3IckYzrMzOSP0je1pH5et6m1VIphIwiflN0+tgKhLCZ+kwJ9MKh8g05WfzgJQNzdcQz5cuzfJjJFvA3LuANFYsKN2peWWk191h/lLxbOU4kb7CRuxB7UjH8VPu87JQtOfPHPvbTEL/GNs/2aqQcaoYKRk24dDCE4cHf7tUDbyWjNKoNuf1jlMau9qu4gK8RoBQC3FUuhS7SRnmOSDKZNrAnrGVMuH+rM1qEgpMBDLtdZLpLCgV1F7CljEZkRgZwRtCOTn+9P0MMygDBBHqfLaFfvEmdJ88wycwpLuXuZXFOiCELl3IMN+zdk6Sg8yhcJha9wenMGmB1Gb1WvlnKdPUYt+3XusAIfH9jGpmH8OP/YLbZM9Vb4DpHPKdhQOUj/2Z7YbCdTXaxnZGQXRm2gQTqiVjy6E595tUQ4MlOi/AR2/NhNCSVb/6In6Z9Oz5pTJid9p4hlQKfIxwvqCTN2iWr9qcj43z2YT6KpUlDRsbjhtuZOdVEgGf8b35ZaaYJFLB6e7ZYSkJ2glZ/UHgUPoLall9CFK4DjJG9CwiGsA0uQA3Y2JqNxALpv/viBqC05TujDtaJiwj42F0GTDctLMxZtGvknBrvaOKEcczaULAttOZhpSfZ1onaUolCwfeY7Xa33/h2mrD3o+mn5iceHB9hELLvYl07R9KwbjCNu6C1H/VtzhjlUdfxoHZqJv1+NXUVXJED8esmUgJ5+raPN2QWeEl6fr188Y8YKp/RqxAGY6NKPahDa+StQAR99hrDSAADf1kCgeXrJt6utNg52tueT13sD+CSsnkiCbQEU=
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