nYQeyrRGc/XJ8qvqPxvUpcHyETAAOAokO7j55NlTDB0WJIdhOWVexpWEiYjEoGOEBmCofj/xnAXvpqxE1Q2gKQk6yny7u7UwFHJDSe8xOUQmcptgU0AvQyRWrq17G5TAtfmYLniEm4515wlyvrgiOXIAAiy47X9qFfd5cUJiQasZ7j1IvLhPCDskffTg9dB0pLqbST8c9Wyj71SwjhDQovfcms3KUtOBIDu9gr/SiyestlAdup1rAlkEFwE7LDDZvpa0zmU+QMCc3XPZRYipLOvT30vw19xSf8qXqctKvUir+UaD03xvUFJaIz8aTNC+FQqYnXC3CFihMus3WkgLV7LZCaWLq1idhpfJiaGj2Z9LRsTMFvyac4kQcR1U0Do5+Qh3fa0AKwqV4gT65HNbTpozSKRicp5PQeJQ/IvLw1bE2wCIc+oPeU79vMXB8R2G3fbgl8/YcUAFBoDsB7BVb4oWMLnNvaMNhNH4GWcLHIy6AsHHQSYsE6lQPgcKBTkTiRLiCvdl9gNq0lWH4HJk7mn+xJCMX/8A6fEjuv6t7uM0hkpnWOSBK8IDmEvumYxotz3j3FjageNs4pssolBfPFMhV/75FUDXisc2hAHLTN9AE6mMWZZphul6G30cUIu+rHwPv8BCM/FzxKJwXSByxZEnqSnWS/7QXIZzBIlzYAJv/3oQ8lYOZRXKlB2mtQ8m5ZF0yM6WKWg2O6k4vHinuesOo1NBCKY5dikxRNIYhtm93bG1J/IGxwimBA77/maKVjdy2WtT5xF0x3L4inhtcln0o0m/x645b2+yVLyjGMOYaNaJgWquwuzqy3/Oz2ZRHhcM7lc6A4TStPQuiZfQG2HkA5eE3m/QhzGPb8SNNPyOTG9gP6p05descij4ox4iZYqFez2iqR8dYjaDyz6/X/WoQxqWoZRe4tFq/qupp5kttfiP4DOpauDS1+motNgreeF4ip2tuPJ8SkfTNCMRREN56CTePv4xv/r8fuCqB2A2+oqnookMhYSs/kxdIB5zUAaK78nzvedKO/dCY6lxEg4dQ79J3b+d6dUOMF4lngP9uDmA/2/SWGg0K7nzOmmn5RZa693SzwZSJr7DEBSJMrqUBrO+CQreNi0kSv0PfADy1RM5NSBztS5exCIKMMFz67PCxKBVZRLcCLQ5W30iPB8GLBZk16mvWruvd7b4MxCmLM3M5BIGfp71PK+BCC2GXQHGLHQKN9/hIOxz0pQ1osQTKcrGmLRJiRHb8ShOyBmhbEGdQrnF+kjZ5/oEz+rNtgbtZhAPhsmw7bEiTJeoebR3D/Y5UYeQ1cSqeIXsAZ4Gezf84ZNrEBcwYUE5jopvtr7xsz45u9Uhd9+7J7e0tXa/FgEGln8PebqCE4A=
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