SurCluakD01jGLiCmAgXvqHNzZQqLBdi+IIrEZS++QB8lxgiaP0lschlltMgcnTXeuOStXu/TvjJbxEzsnbWrJmHG9sUPGXDfUVx53IVYyY4Ya6cErYopElKU2FyTiNtHIjazsrlZvwzHTdrtx/UNz4NZ7Wq/6XBtSPeRGB96jR2k6Al7a+ZgagrsEiYbaMAB3uZMB270CmO4sbBx5CsKLJCFw3z64a+kYzN6V07npY1BKKD2lMWEav0pNZBAAloQyFbTlwQa8a3Hv8HUx+xeqrcbBtCIpOLJAK4iyeypaH4/KikdLS20BRfEw9zWC6Y+d/NrJRt4rkJdZpHoVZYS6jgVGTTevyc7xX9F8sXSKSw1eFCpF7780kq2WjO4Ys2NmoYSiToeHRvCZIHJPa+dzBhmTHWjXv4o7C3bwjHyknmgTpJYT7zWOdOMfS02yUP82F7SlEzTM96ecZfgDLSwNKS38wyIryT97rYKvoOByJdyZE1dlwPcXaQFr4ACw6BEz2AFHaM0bRULIQZJ2eVnalhSC8Ifww8vY+hqBMEZtiUm74Nkd4SPdLed4I6DHIZYaZw17uRAvmZpfYthD63plr0Lpu0DPfdBXZ6eXWW/qfbDR3ciDn7fq6MLdjPXg93rKDD6EMWeLruwF2eudz8gkUXZtY93tV8JaUT0cbPHvdiLhuFuqOu8nDvf4REhGN4vdH6GrJzTxMdBMO6ThV7y58QsWWayWDRM1Efneu4yUw5ARX64VB2vkTqkpseQL4Q59Y+MkSMoPXe0lo8ZJItFiK4/oLAlwqJneF/7pujRdnpUWHs69Wxwxljt3zICGcbzTQVciFduRdPMDCTuEUGa9nsnA3cDElOCdL9Sdih1jYHXH+LXe8yI61xO+mFkuTzhZ7rVV4xZeCbF2toc41kpIia85z2YFH7OrREoCebwipL3vqpluZaS6TyzQcAchHQ6ynD4cF3W7OUw5gPL9LjiVmPVPTYd9lK20SRWfSatiorBEr4f9/qRSOlaMwUOj/FzuM6EiLscrA01rpYiWoT5OPnnnO1ePr/cQJqaN8Bqphbx3+HrpkAW+BgmO0kowZfVp27laWs+3XUFGiQqB9fzLjEQqVGU+BxG++1npGqdHqr7QkpubsCzmOwk7+pGQqwIq7UekgkD6cMSd/NjCfPouFezvkb/su8OhUeYQ5eLFvsB6dUw4CYaiFZcxiSzYkP7NgfcRZKse6u0XTmLOt9WlU3KS68+LCjBWo/XIGEuDM8fP3ku5ssRZaGblPd+lSlhZvW3YCw65OoXEC9uy4DG+/LO+HG39s0O1IlaXyhJ4bGPZyQm2ZzMazemsyYpEbbs5pdONruysKCPDQYXj1U+UiDPkYkgrDN7FMXdrw=
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