UQoAFxy6hZFTzOVV44TrtoL3lBaxX/52u2cwS4/rn4AHX/KTMfHhk1Ti975uD7WgSboZ6U712+4bLDfje97m+kyFCNLBTiI6JufKXxEdkL3Ds5rkEOym+8YY3VEssSNpbTbtajsNAsJ/ZWHOP3Xx1GGSEWgboQ1Q7LyzgBZyW4Cz8GCPBFbF8biTyZF7bvqk4+AP7wmfw7ygkgL8ohWuvpSYN6sgxk4HkpWhjcxQGQIubA9oGCWZBhAKSXY33s6WxBJhhL1hyfSYNmXzcNFh7+6TDDq14VxMiGJOubjHj7xs2MofdXgzSRhFU6eoaLI6M5ak6gjp/Cqzs2n4x6IVQA/UQYsaPl5BUWxBajCOoJ1fcjtsn1Zcv5nbMm4jIrf2tRoEb7o+R4+odbST7mbKs7nQ70X+xH33M1s6UdGV8nTD0mLCs3dDRV0PqQovaspnj+mVmRUKgEufYLgbJbmksZD/KmeMXeIxobyOz4B1b9DqAeTgHJQZYAyxeso3vSS3A7yEnteo50XBsjO8OcUp7YBc/zFkKs4nbvZeu7A8aktw/dvetXnODE5Urm9xuntlyvUOWvDRDwQY50HtCjhJJGCb5ZKC5mM+G0/W/DhqYiNKrkrPv2T8539OyeMe3K1KbmTFgQFBAk8rvJD2sF66Sv+yWMWD+285uSSPdpcRNWHniJWJGRyszcLTO2bsMbOU2rEBA6aET7ZEwSe46qgktYTYfzYDEOYKnbKn0/E8US0Hw6jsccvFlsJFlUanj2WyJXBedRbJWkzLe9tHSDcBQUR1J2HUMkJIzOtAl6xlUwAYz12xQi4+uJiB75Ooh5aG//jlsVG3d/Zc6jyV6LOGVO4ORIUKTNY2XUI3NQO24R0Lj2fv+2FF0x3glfXlmJUpY3m3gqiQwDT5cz3bYXIi6icySpLLgC7WM4nWBw9GIREBadtJDjtfWuTH/OaRkAvw/I+v4Cm6IkUd2mG2WTbD850cJ0t65A9sA3EVRa+7uCQu2YbJlW6q/3qumh50UYvC9x+5Rb7qI6lXTMmXXiMvIDc7Z8G72x8FS7WhZh66oi+c7qzhhnbZPdTnowyRtXX+eaw443CoLuMvxnjQLcYpidKnIWbx7UOr1s+ZnM0h9g/cHZRqw6CYXEbvWI/E1Lx4jSMs4yeS6cfAx1VPKNI/bxoO45rO4nOKUo+/2G0yZLfNTr3sCwK1mz3Sebh1rLBKWxiGyNPzjGtstoZuEG3mSDBbjhqR9fqBs8WrihnRw4JM5lFyO8uARHi3Rjqc5vf607o7lhmfLPmzTP3OCp7PZDNxzAICsnczmJmGIFiTkJ8CBan0qrG4NRkYQvrXOZi2PCvnM8jtROgFubpxcuKLP1cOVtq38sS7laoYIxM=
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