8NWxPPpE5z8LC1bHcrY/WMrlzMVD8JZYbPl0VZ6nDfYNKM10EoI1++IQw6Ig9V+iksSLkP1AV2yltxeDhQWq/HxuyH7qt3juIrInj7RIRb+WK3k7r96ptmhOiXAyhJlLVqTQVWbTmtD7SQHFsX4MekRLOGpqGmQi8wAxd68ylt5G6nxzQBvHPOh5BYGNL3H+ZmP+umg6J0TTsPLsub7WonBv3tEEke721uau7ae1Pokjs/h+i72cWt7TA8LNrHRx2HQuQU6SNFxyGPofKSQGM33Hb1Mh9hRdFZkY39++TNlrpG5NsnnTV8sj1547Bm9nqefDH/Ts29bDWaF+20JlG2ccaX5qOUAmuI2GwMjJ3hidTUTesiVwZxsGF4RgCEp0NSvj9PIWxNIooV0hjJQzDkNdfe/Xq0zKqyUczjPXJaFnUDhyk+YLA277dtvwzhz8s13+3/xTS68kI53zYDWeDeN9WXpRLbyLvIZigqyCCxmKLsJ8JhjmlpUmR0c0r2PUvhI71w1g+jLg9Sqn4Kya9Q9NVOimA9YerG1QooL+cHI6stzsXcYBM/JyBKeg05vi9yzSuziCzdEmlpj1yEWf0gqIaiIQuPV9/I0nwK1t3bNUDlF68uhDTBrltR5IIXcXEdeGMq1RRIYBy12cZ/gwaWCwporzetHuGYjiv4o3Sbob9vYUQXQacWfe1atIQab2xVNHaRPuELEYzB4Gma4YXIIklZe97qdQv+QC/UOkmDwh7jm/qSZGepLjViGv+WYtNvAvnvG73e5MMgldsjKOOrZ3atGEBdbW6jZkKIOlDJ1Oi3RbHQILC4iv9I7jh173IpSt/KHhzzUhGKdxy43GzwW4cWeavwj20d76ijBlcotukgCMZJl3etX5fCtdy8qGTrqJ0A/XXdawnxFsxN7D6Nbe4x3SbdOBhqfBzycwTQ8oeD+q7c9bDb8kMdgh+PM5ugb8JUrzqBW2lYu6+Fo+hzqOEETGB0FfMivVueKfJv6aI43M8C+v2Iqv2vXe5yPWb4v84WWZ3Me8PPn861Bh1c3wCp4ivmOg1gDEI9wvIUyD/vroKK0ktArKWZmNqeLbEQLwJJq3iUMFNJr1GokKPFX/SB18qheYp3LN7mnYTfqD4w8u7OpFSO5cid4+nUfnVszaZgOEDaNJifmUyjOgzORgdtuLPnz5NtU6AKw1+5ASbdQGhKgx1ofDOfmYIjSeIjOob0sDZ+/ZzjHzcgUad6ow1t7Hw+tzFfCjjqHHOhOEIIohmixCE8XfiQvwAjxKpw6+KkifU1S6iAhZ2z0gx6FcC8rjq52Ox59C3takzw1a3VbDk5ohzFuEbUgAEseoMmx3Qkza8bv/wPhIxEQoPwbCk4pLn95ia2H9xes=
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