gP+RQUuWZX+Ny/FSffwMnirG6U4TVKS/39jA7VUggcaH9SYgZRnnJvX40Cpkay39VLUMaYGX0909bUN5xwUI3Vk433ezyd/6LmTYl48xQhosrlPtEqxfp8TFGmh1Hw1ASGzcG1a6zaL+Cgf+n9yakBxip0RrZw6H9rAsJyjhP+/Wi6uzo6NLILbvJugkxgFIALVs9HXBkhTVF65Xbjem8sS6xQP5g+opUKP28DV6WMvxo9b4z+Q13/gMPfw8F0a8R2/2unoDqw90luNx7zjA6BNKOtvpubUwTByBwzPPLmn1EG/Mf2Uq505eQjgZCKPSd39l9ktRxxOOKnqU79LZD9iT8Gbk8d/a6aI0b6tCeKXjx16ANe1yQoVWAyhaEsDMtn2k0FjK3zBkze6CuinsE53nwdvN1Eta1R5gyC9GO56XVRJ+4nXf0SgalkIXtl+ueurWRXUYhzuejhHNNjjFbzyb0ZUDRTET8hYzgs0cQfNa3BFQmemTA7ifhzZKZ5yOEbMWMsx8IOM2zx9SnJEaCS61hUsKUo8J+n10ehBu58bMHVbeimAbNsnJ7NwldGRIBznw6wEi9AUBbDB04fAs67Jo5wv6uJRB7FF7ZDoguYCBfIdkJA66gm8kSOxItNaFux5FKIqVJYNqA0JuugPimP/UqaOTUDK3WU4vtSofMzrIv9DIBHzPEWlQ84kTfW1UftSl5zZLNIlcvtSefnxLaZHRuki7ZcKnRcRNBxx2oVTSF06mxz91bjKKLvUoBPeCFQlay1P2qmeppWmQ7oxCSOqGxqGZm8trj0wJAtzJOfk5Xf+sEn0cclY44PTjacorUyzaV9PKpQWK6j90VmNeqxU+CxOlQWG39PwellhrNXPSsv4wMhj1R/N1tf5+oxfO3kMehHih0XixvVUyBXZi1KfXaxgYazTT+NQp96xd11Fcy+wk8RSyZvyvlyq5j947y1gTsYbT5f6OwtgayvVGKHvuEJ0DORhvaeUcDzlT25+p36+RCmGvIHvFuKg2Ks+qCISaaoUk0ICXMatL0RWDt+IHfTVU+BPcO4m+Ps9o8KxQNu5yHMYQ09yXjiLTlcrL6vyBmBdiwjXEmcVL0X6Ifs+ERwHCGZz/Zs7H5WftjadpYE9jj9XfV6Q2pDSBwneYB5RgxFA6jq5ByyPVeErrVs4ialNGSSoPddiJbHN7Ea1OcOtlW3LHmAoxxW328UL57zti94bz/U28l1OJtu4CtMgqOd3RpPombKH6u3/jxYaD9/jftxam9gG7N+v1dyrEp+o1h917uNlxmDTX1KH33dE4ucka6vU0cPE7w0DuPFI/awkDXEUsWidBKSLKevu83cDzx9YjWNU8+VZrJ8GWU12YNanGbHVwlbm6CBA=
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