j7lIVHwVgSceAlVtJM9GuJ2U3zbiP4GQDE99vWwMNah0Q3D6WRFD5v+X9g0I6s+eWYRLkfSqc6atZ/RBfsueLseas20ZF1nj7BfxUJsy2InjiV6GxqE8C1ImKOxzbhq09Rnlk42QBtmFB3pnjfiT59DgjBWZMFNgGjCg0Y5DTWqu40AsJajPq8Zs7AjH6s2xKhEq27Vvi2GXjYKM/+ThpjMqe9DkrtZVZDVkeLbD6UJBIWC3yCuCq5MyQxR9vyHkz4cXlohKhnPZoqP1YoRU7vNUurW7X5qVtpkwGaqlq7F1QAtKeKLpdOhLrL8oSnjAoo+lpy5O9fg1YiTXygAG1XcljXuxQNsZlDUWICm1G9aaZLYj3BOAlfJHTU5mLRt1qBWQWhRwlGx1160+B8pAZ1UEUE1t1LmQZvEO2PChEWHmMeseNPTbAjnZsohAQl6qsrfbisu5IWW9sAh/bw7Xf+phvb+iJPULLaVZZmj+J+hJCzIbsWdyIY0F7d93x8vsUQxwc3jbs6HUrSakAATNouWrpxs2rs6V6dya6gDdOxM3wsdehjW/Kg+dMBbJd1cvmVP09iGg+sZOCGFevmBwI9+WqcjApbeu+Z9a1DtkTOpohRHMUVUKMwB0vepneEBUpbwT/ZWbaf9IqQaXpKRgZ9h0MDER8aNAeh+90v4Z06AqT5yABbW+IdYbBSdrWcVvXHL+uygoTNa9TVSzAftga4PQr9HKrzFz9Py7CJA06HEETCyDYbGXJIw1ZB2UIRGEtf7HgwLCS6TKEiO5YarevARscymmY7ex1coA04b3wLEzKz0E/Iqg0GQO10QCqK+fR145DTV+TOsxi5N4g7ZpdFNpWDCCTi9cK9GQ7B8K5UhNMofjfmNi/t7pqQestleuIzvC/39dAYLzi6ua1CHsibaUbsUXYJden2yY30UFJICZKJ4ybuO45Wt+qkYghk12FDAP+nk/T14dHRf+lNdaG1gp9HOOYFoVePKF5miuI0UFXSpDnerT+vIvhQr7fnjZHMrB9mqBP0InqPxOITKLeo2wnjVxmqemALs5oi9vfmE6uDU6DnTreBLo5pIXZYNliUIfBDlb2b+cuUqL2msWUQhpB2rp+LCrzCvEkK6z5cmCSn4+1QFDzyFVGtXYgw0ttYZIFxmnKE6D94jzCUOAu01LXt12JPgEtaPnQh2Jw+rOE98rMpYvkb5cd9rtwZRmnWhkpqHWfytl9MiC3sxKUrr2apa/QqbaQzTcgsCa+7t/M+mexzELZQ3u6XkhTykLZvaHq34mgEykPFH8zemVDlWx6dVQNpLMaVFD+vJz946P1qyF4WqDXL/nT70Vct+nYR1g2YRnFTzQP9RyplQCu7FM6LYboBAdbScObAc=
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