udqSIGladpW9Ko08zkYF4efoJRlsqDMnJ6ib2Puq3RbkCDWazHrySfayBiP+RfcMJMHyperx0C3izPK/ZPEFJxFj9KRzN6ivTor4BNo5zGa6h1T7IEBAZ81/uupu0X62pX9OuVK1bzsKCEX9qknNya56hfuM2opIR3dGyQRalZ19v9ev1FifjVSHX41MrMrX/jjMXytDCrvBSBC+OXtKK0UXkUaTlTGTz2pcKsrrNvDEtnXpG+kHbrHBCGSI8oGW9kaBb90Pvvloinaq4o8OsGwA5ZD3awE3JlZoJ5ZMUcbI20PnxEtkupKmvwphPN8QLZAnQIf0WFO4efj6HuPlbGw+CFqqh97HVCQyWvDLzogHSJnt+bOPaLTfXYfg7xAwKzWS37E3YobjsDqKZlJUd9f41N2uAgUj/r9AcHied5uixJPiWahwpUiZ1Z0F9gfLpVAqtPnvq7sPRyNtz7nCs1mVNLLWEpTRDY/KhBcY6Ms0GuS+8yCJ6rZgz1tXAKBJdGKsWcIaN/2TDYpoUiq7+Z3wqPUqCU01nFb/0nAcihyIXkwsdpFfmXotxHgFJn70l/FAqaYQlA8TCG0kWqc26LV+cwRohsLbCPQaQN+oR+elCdZx1lFZfih0Mz2yaSymiuNePvwXBdO8eYmdk6gkLuouyWG9rRprgvaBoAPvvPKWWUCxmjxXy/qIADXQGgYc5632rbeusk9feuD8WDRxcViK92PVtyAZ5Xj376q2S9CXR8f0M/OK+AduSdsfK436QJ1Aj2ALh+krqPmxjYvMFEmVSSnqjwPxjw+wFHMkiKvWcVxq5+4cC/8nKlN0ZCAx7bxT2z+sE7ow5/HV6GSUgAFSrn18Pc6lJ10kQ7ecmv2MMvRybvThgydClZacVLBNTKwoDOIy2dvfyF6JRcHz0+SwqN867VfWBzf3dVwv5m0lGx4R6+ItSc+925Ty313fKm0xUVtJQfbJIkNA8T8ghfzPOTCN1JPjKgrVG8q1U0ZhtTSZ+dKr1pjYg0+QxQc5NcKbbjH1ANnYSLEjLZUJoRElu5miZGEQ69hZdpd7GTYds1394LWu1T7jpBXOsbR1GZcrxQqlA2AipqtlHvwz6CUUfnotOk6J2qBOf8YWyBbvqOTi8jP1REFM9oYCj7wKgZGqlJ+kjOedKkPV7N7g58i6/1x7ZK3GtfCC5Mc/rMncXgOo/ZSg7qVcIMCEgAOPC0+l0ZALWg2THNX001v9TrgrOv3bLjvtvU47o2mFEM8JV9IEjk5fKkOj8rdJgjUJ3xbmtcPx+ODwIlFs2DNJyxbS9XtSOW7ZLJd77DxWfvcGflvwwHWeMstF/CX1OpEw1780Gp9jGhu0GhHp1qdUAAltCdwKyWDwryYZa1U=
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