AW1kNLjTxUkVyZVj9FcejF+HGa+xSAworg6vA0rVmfUtC/XcNRYMYvi6DIku6MbKY/ILEL3ynArI5sHxaplandROTg5QTdbGhpqRiAuKOs5hiPDkxfMpjxDuRngNtR+KbkGpqU6VYcmB6esQ0PhoL1Oc05tTL7Sw1v62Hp79lqHZJ5un46w32bIlqZmkoD6BMl6VysLUqOF8cPHtNF6O+5LtoysZJJk1lpb6VJV3n8ni12sMHyIno01uE+U5dFkk2eomoMsw+L/ALFNVJ/aw7iFxqI3XuzS0XapLuFaaEvLv6sl8JBl2iyLQRQNPl3HweC/vR7+ZhtBNVvHNJGaHMX28IrKQFaW1zFrJXQDC/tgUVCLgJYP4wFfp0ZKose+K44RhPnTdkS4WtAQ1WvalOF0gk8HcHmfPq2Lj5UnonljWPRh6/i/U2W72QQJoZ5Vvai0+GNg2Ot7AkrsGpIZQ1UT5K4Fmqyoi1kTKtTASe31a5rjnUT7Nb5JpTfL/E4ca4SD1+VXe3BqkLXxqO5ruftUymvCvsJCQivr0dd9Zmk3nl/YxfXgNFMMswqLYCFPzS6Hl9eFPGVs6cZtiZ6nueblprsaLyWO2uQexpXUOnRKqRPioYMcR80xbcCsxIiKv5GPs6xwXC9nyMHJH97YiM+qrckhyxZgOmwxb0lZiVEAdopQ6FUP7kq0acHLAm9Ogxjw0UJqlmI9ZunaogG/dIWlCyMz+6v6fejVmt76JEJ9g3Z1UakPHDA7ukXo3IEfADiiektGc1YoqVrqRnOYZIuiGZ7IkzOlZP8NI2M2x+begqeF8+Gr37rcwAoybWctgks9q9jW2TIQLiYDWtLBGztnNjDlX+9J6bh5mey6ucR0NogaYtpqfvbRgTlCs/u3V8fDjsmkW0Z3ajXjNAs8uZLt+Eud2P8ehYkGI07iUa8CPv2LNVY1v2+X2jOzDXJRzje0Y+CyBBb1EuFYQgi2651joUIHNDEuJ67m6Apnf6P2ndunafd7AmHlp61ZFmqeqBh7OEcY1UQICULLbQHNlZ421wqN/z8Gq52qZZGuxoIByr2L/omwy5c+nz5/2Z7uCJIDJKegQkSIKa2vmsmgIZoooB7qtiXFepSaz6zWafeezY/5tXPF+L+R0R6d06K6nWiOHl4vuZOrDddDcKGZuL1g1FATpNyR3su52KANLKTXL2r5W+jsRA84PjnIJ168Qjl56HS63iH8T43CD/jLQdDcEFPleZ38oP7DwB3kIaX4yzUAP343cBsEhl3x8OyKJCNjnTxMJOpyRMAsVcBkUoVgCJZErFITlbRcG4qhQ7GIIbEvlx4dbs9oCai8IK5VO0v6fuqZY8vSbIsFTbUrtXZaxMlbs4H1k/HeAzHw=
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