+cQ8S5ikQZp+QXxY+tk3O2VHQ+Kk45fM5aBCVNUa1x0qAn4XBE18QlJPMoFCBsIpYzCog9OiGXo9uFV3cURszdrC4GsPst11QqeCzdCheYYqynVUhSEsCE7PVbYRXS/Q6Clb0lQlY+UD7kwsWKiFfTRA2bMUd/HSMUUesitB9mQWPN/Oryu5zYKOUvRAbw6SnKWyCBj45Nl+c7xCscbCNxfIOU+ZNpEdmTA0oZUJ8VtE6JjPv7YVVbq2oLVDWY3QxrnFgvv/wNHNs+9ptMFHmqI6PxF82PLCt13ICRLWVrUp9q4AA5g6J82n3gd77RsBw2FkDIZUCur4KpRZ1ZprR8iZyxMdmTtQE4xQuzPtfzi5caOV5Q5827Yi/6pGdU1IGp0NpjdaoKk1nKw0ofPplRqX5iIhIqSMHfITjJpR9aXP8DUICqwE9kgcwkWSon9VEQml3UhXRpvteagkL5l5d1ovlkmRl0DpRSBQLIDvfIEHS4cygl6AcO2xW/6PhzOhrRwrvPoI2x/gcFbcBDGK024nickgUUIW2hUyPn9olbin5dCocn1zf9ZQcun6tx5wyFJStXmOmpgt1lh02IWCUigaEFGYZ5o9p6Hio3HIPHRIyUxMa70Xi+u85rwh+kIxx2Jjyekqd9jVG2x6clqAT93IhupeG2klFmFfqUWhH8sOQU6cbFv00ck+bEahh2LFIuAsy7pvpLSo/Yd+6X5Kv4C8TDqngQ+Sn5xO0L+CX2qC+eGG1bO9kg/DPd5Ct5rZxOb9rm26WojjVZK4a6M5t5j2zYk+/a9tQkAMyyrYT4S1wcJuNKgKO33gZcrYnwewds8SnRJ/k2Iw6yVpArMH230T2VTpoMxTwShmQLyRvPEYfZ/sxJgKKu6LZz674uWsfLVgdN7JOJ2ATh5xbOrqrGXwjJMp8bYgtwH61nYuGSW8DQzZq7JyLVxZJ3+GNPgzOQ+ZqfwER3CpFndhYAH75aiByYCT59GjZQiQLArALtYjheMqw1LJvIBn9ui4qy7+14s0ewBroZAnjkace3/EZ8VpZwgCmBGSAA+Bdo/ZHWLdQzsWvtb6RTsgy2/wDHNCRSMY3D9azJmngFty+c772DXtIK1OnTYUbEgmLm+CL37rgr7Zy5aHtGYdjppcLKXT8UqHNKENuDZYbS16YTlDxufB/iaulcotshP41q8pm8iuMkYHRTLch+kWL26flKXGImXYb3lcVTci5j7tnMM7Zf4vJndH2aD1QI25phVwscnGNQZFxH30IXH9zJQnb+VtNlO14h8W6n6jFpkCDIIQRdJTN61Z6xf5WRov3xr+XUHVgJvx6HLTkUehRAYOWwXUGJZsotZ0KrVjDVlmYNsZVV4MLvx7IYg3PyTobPM=
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