X+pPeN8pr2p2Gd+FBjR5kP4bx4Aqe1G4G7Cijx3zgrxEQVRb8o/KyzPVyapEXUSKgi+Gh4oJU6hY7XpWkjV6s3IpeVsEdsuvYtQSFH8gzK+ukgcwYE2t6m3KAStq+1fNkA4giEV4dFMjcaiUR+hCG7klI/c2Ag4Y51p5wAYlcpuMt5JRgLZaAiCq37ilYomp1OicF1u8l0hnXIzCnywXlp23gH/QDYFlhOraM6Tn87NVEfXPCq0pO2HPCiiNhyRclLjNBHJai8uqRbYBLCInA4FsLzxX3dtKiYf9k2KapHCnf8qFrnNVuMBP+tlQcE5Xh9w7sQIIrOaKg9XAmqjycBIVNLBt4u7XLgejkAAY592NfoDEwVEYVWuUiBDJqkxd6K6x6dudPRLM0wsJ2w+PA5Wgx0TxvGVEpWNDfDNalNZcDtZ0sbAckjzOSE6zerO3jI1MKoI+tI2Yqu638AF9526VfqAtrnMyT9AQ9hYlwh3o8XrKemSm7ZOfuZ8ZlDZr46lDyxq0RWYAnAqN+UVqMQaei/kd66ANkeyfWIUmUW23kY+9U4OfOttsuyGvAlOXIe1SY96EFZZqlvBbm7MEq5JbVBvA0pdFR2EeyzpYJ4Y1JNTnU4vqVwTbM+MkSnlq6W7o/tUk49LHLyvlqf4xDshz95IZ5XGAfwAW8nK4AQ0MTXeYGb990Ugtsi+HrHVy8un52rLcE200c6YH5kmmLqGynIYDhTdrext5AnSkqU0Yycor1BAwzAs20wZ2fRl3yq6yX932S/Iip7eiGRD2cqKkuNBPLpPI+4PyPDbICEpZx5Y3RRzbOoGzizzt+pFt/t9kZKVGfqw3pMJ47EohGULuiQiO9ylqqgDobzrqGdMDMvO/QWyONzHxFmXOQ31LFJ6+3cp5J2qigtwl93/8rrqrPIT4WwuUNc6gSGTH453gUD9HNUu2rMTz+ExlGqcQ13+hBTIG6XZgcHbyzcAF4b0x5Bujh+T6+FKtmSRfeANxXHYPQvcwPUcvapV/8Qa2XnuNNjKYcGf+F2/KoizwJhoMOpCBHxYHietB2bgV5woSoK1t7K9rVk9opttUo5hngIy60BySiJnlSf9d3r0zhAuU6sswk6VMGmPbhGZ4N6FPE5QeJMQkIwF4YPb1qHLY7BHRGgBBbxR4Y4nwGuluRXze/9e1hZS2xUvQhFVqHECO8tgw3X+UwWurFimdmIkVNH/Fp25NOytm+/dnhE1B+QrlNPdk30B/JUSmpI/bhG/4GtSFFKv0TQAoni/3l9gjyGaI1jTcskbycyyDRA2pY4+YJQBr0cAjck/UBemncXe9LWGg2enp7JplZKW4W6AKszYSgaZYvJhNDCGWDiVOO/v/JZ5Xsq7EcVlVavA=
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