xkBFO2v5ZQ/ixT16NcZIx1V0qVoAm04+6bt7ULQoivEJEV9SKVdwefYX5OkXtgcFlCsXw5fSCs/KXgrAx8sQTS0qlWZ+DR5z+DmZfhaSXLQWE3nT3IljVfdre3UXSQSJZNMmBjpid7gYzqshBRzB649d3FraYnrZorqBqU2yu/kIgusPPpY54Rp+BQqX3gnUwkp/MVyv09TDBGYw1BnLpHedL/RjEGg44NHd8c3RXxAO++FJYSlZprI33YAwURDj4+n8XmPwE7Ejv6SWc0PSsgX+i2aLJpTgCvc0G1ZMGY1Kq2GPOza0Js4W6EkZHCe9wyvfE5JvMLg7BxKOaF13DkdBlOvhsjj89NFATFGC4pntszX9Ol2ty5sRHj+V/bamIir1XzWHq+fPJ3QbxQLBN5MgPkF5keIQcdDXREyretohnRk9Xo+vbDv7w0LCq1UX05F9BAhSeiaNVGGgv1UD7tNGu13Tr6ZA2HNWmWRd95b0t+CRYEw2MJAOZdSRc2vc9CK6G5fg1h6jgbfgerKjeXdZXUvsmzheQ0AIaTKI8ti/ZfrHlQ4P7UCuMhzWT/bUxCmfJm590/DLqGKChmMg2Y1Lrc7aWxanNJ6aI4TfHXd8V7z9KhacR2B6RNLaTq5W6f49ilFyLN7l7ckM+nFm9mODeyK1DhyXptTDkNyt1TPJdCmEP8cka3oeMPrkPTZiTQLxfT80mNTcC1co4W64ltIffXjbXDtZLvuYDVHvg+UQEGGCnO6+6tyJZ6BZ5WpdvpHt5I2ePLqO6KOsu9H4EnEPBJZxjfaCAuliVPe+mZ4uNnNsF4GKxhtn1okBeKwtPSDUJCpADjMlpBycmFVlzmUZwrE0Fjbmpw/7WZ7qoA2d8vvfixgb/2OxI1JiBr6tFyVJVL7fu2PTL3jJTHPan7tB2NqlkD4RR3PdKMu6kUQfjyeCLDLOzrDreCOm/Idh6ULibMTTNJnB38senQ8/ua2CPHGDRlGYg8zwf1H9e0BqZB2DhCP5NOm4hfFB4rZlsSS/n0UD/SyK0QS+vZK/Yf2eQcJjeJ1v0vEJBn2ezLzZpWSK9F035mQL7fPXsTpDNSO0dpZGPe7rFkjK2TVvQLz+/fHneqLFDwzra1yNOZjXB/clLwb9/UigHpGcypIE8MBO+kWWXM0q4xBzX7/EVcN+p5bejPSTUJOFXlahUD00HEjDV4rjN7Fh9+opAv4QPAhoiPM/7N3HGgO6TVFDHNsXHZqYXb1FYQmR97iCfhBt9j+OS60lGV2NL55V1sRJafoZF1QQ5sXGXq8BbS57fFDjjK6ul/n66WnkfXeTbnN47sGhINPrMdNkRk8fUQ1Ydtb6ZwkuhWzWGwEi6yVBtDfCIh7WXrQy9BjUUfo=
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