gQWUKmaX9dZPFnogDFrvN+lc3lb3cNgTbteDte3Vqxv2P1y4z+DdiQfuekfH/5FuI5/zFLa0Exr+GhgDIcPc+46KLcEkXtv/kfGXJnOb7ZfEgTCpfjpbY4B/7MBD6OBsTm1V+hb13Q525ci0jGfYnmTC2nfDLz3hcGMOt2AWB7EQGhRbhZzVs1LoMVuX8yrTiYRbt1I8srrKEJP4Xuo51a5wEe2LJRMBqerRJbcCe/3EojasWgyoIyqDXwJvmM/UXyqLhNPVFOOsPSn1xy5T0jYl/XsviofMB03QpSlYjrbwjKaJ75rNxHjP19CZHqCDbuNoGN/grN8eLSxKtdPkHDXsKuVaOyq9uVyKzeC6FFRdxBUGVqWcH8rc9AlkRwo8sIujRS04SimDKp9/4OpqLxKKVXpBfLCvI58xK+5PNCQYG+b5h8BGRLLnU62vPFFTk7iWQkQaeYzw2q2THI2WDMrgORoBZsuIHI4NdGdYGSWpfSXvp1XK+/w4eu7lXPCAIFKz9Z+akZDsbZtob5t0TEgXEDZiS+6uBbt4034sMMLy5kBN6u8PLTmiQa3xBjrul7V4sMr+NCJM6rCwS8MZvitLtImByTiZRxD/089uMO6tVNPLeN9yeGEqTgPM+Woh3CvxVkkFKCw813zyiYJf1ZmvATITQCcnl5hW57nDWCovJki+D8i+2EfgYqVEcl2i/rfKSq8ojKwoy89+/fJK1FpHrXkmDi0DIFrK+Y8DkCh7xjwTxT0r09Rcy4tmeSDCSVHrbSWXG2/cM5CkdgtrEhGDfzf4KgoBhlCthaP5v4RneuObCVSEybdSGJQksbU/kxdtQNx/fW0Fe2MWJKOwe/5SktByARb3vm7Fii4yYK4XDwfQD7qoD7WwcCSCCEERwRCJGcDmExC5ASs2TAOQknn69UKxviatJ5Pk8pad/ANzNpxhm2Bbcepa9jD26F7vyCU8drhSlD4P4C4pLElEBirUQWJyzC47DXp+oaO3I+ZAS69l80gKid2S/9Siqz3X/Oj47AQekH1Oqk3MMmPCzu0FlQzBazOWRpNy4AjTMN0bWifVSEzQ3LuCumtZa/A/I7d0NIweLqkrioezWS+ThA2otp8q1/QHaFKLlhcuMFpYiPikzWyGV7rfNmFjnd8z89xwSrD0Uy4+bs/KUPsIf0TTrpRl2y3SZeCHZwTe5wtD0q/kICSSf26dscLQXlXwJUXuCbr6x87tH5oT/WcN+3uvk2kk1PTiVimO9HIKRBHmLdY1DVN0tMA+VYZNgME1wwYkpJ0LGOAhUH5OyC1FgJYiFHCzfAtSgqtHFKAAYVoXqHQLzjLjnJP0OKSctqPkBhtltipKeyzgIh9RGdcxxK2Xl4FQRmUJBn34zuw=
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