MhiJSs339GCiZcj5HZRFUq0Ata7hjuwOTPceBqsFpyvYs9IOGOLvokI5v8wjYNaBibjbJodAO7VcOfmgggljV1lpikbN/2g1S7VXZWgHWp0bi9k6jfn4CtgWiZ0Ehmmvs8O6lt42rZZJu7RL0364rOYafsQ8ubBtzMJylS1qH4wkMbZG8F26WzJBlRLzYrnVT1zbTX6kicnN0Ex7PibsYSzDNyfTsftyeyyG9yXSb/+gPg0+JKrSCLetP2MWYY62W1Gd2QPuUjMCqXWv7VdwCMVFp03yX54FoY2LR2T++uenXk0j2U+4E7I+jZRU6TO6mL3MHILBbOM1suZmjBEKUN+K7X67X801dkY0cIsP7ZLKezmZbFfImaH6eanDjq3gvjvysVWDO5ECqBE+XhiX52WaNSramMwiTdVqUPh1ahT8W5JCTRLh/otgeIjcppwE0KpfAuOxOWaroNkyyrVFV0adK29stn4BPrYFb3Fp+FZMaYJkQyfB6KRzZeb0fXVqDT+SHzc2twB3APo7DtohFdv8Odk+6fADQnhwFHxJFEKrv+4D8wr0zs/qXxF6lpjmkctlWigB0oaLbjtMZtwjnMu5nV5SqO7oSOzZ3eLtefb+gDeGfREg7QLLoTAMuEXaZwB1QWhix0SbnbYzUylOMGYDz3S9LH13fgaMiEmvfFC7oap8PL2I074Gpqq0NOeWp5508BYjf8Ub/pbntuhYuSRnD9plLgdJLcnQAwAc+9a//mgz/E9vl0DQmepbI9uABECrl7ew+GEVHPeIvzA6xKc4h1N0V0HEwD/OUE3E1cbaLpOMDojbIl71UXWJ3amDcYVsvBksgfRxgOCKkNJUcBwPh20Rfmc5yrv4omE01A79NrSmlbdPswXF0uuX5hA9FyVjn4/gL5e8KkXwmxo+T/wKnTQWTveC/8+fiv2QyEtgybuUbLSQHCsRplYGkUiyWDvL+qXGYtGv7dR5Bh8dB3uHwV47ZeGk25uYApEhtw9e6tAYQAjyiH/MReb/IztLMSE3FWY9kD/Zk+UDwbjtEjED6zmgFnI175+8U+yfoJDEP0tGEk2ZK0PFsgu000mdaOcTgBnFZC+VkdKyGBzWhWyS9h8WlQO0N2NgWp5rxd+H44awCPBIYXgX2bBMKVYtrmFtQmHtqpNGyWuXgh1wnYnY+k4nmfz8LO7whON2AKbIGcy0iB1kXDNLeHijkWRTfGJrUlBf8e81BHqLDTY2kh7kf4Bgb788/RALtHi0V18+sp7pYfQ8NM1hV3YUVrzseAOJ0OrnhythrrGBkDE7udmh5qFiyUTxjSnfAf0xQt6NT1wkgXpeaw/ajZ3bNp2E+N16z3CYwpiLS3JsrROrBliEvFRmoNMhpYatPp4=
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