khIWzoY+KozmSm89IvI4iZnhCrEXKBK3Cr/oM0cSvzANv2icu7X70W425++eyqq56QKEtMcTv6yciZ1vzpcNiqthFpOY5GyXq4wTIhOAlQqAbuAEA7ptHPfS3+lVWAZDPlF8IdFYgR3fPNOzOkazzID5qov8FRpKR5q8gVKBtq53gpf418XvCPU1d7eOIuHamNGrJ6o55L0m8bwDcvj4kr7PJHC0mxFbsipDK2JBGFbAkcaeaWDkRBtl/DPpdsgtD7LSAOiE2PM5S4m5T1xwm8GCABLAw/HbxDjqn448AVb2crjwgo0O2a6Ez5TleJc4iEWGGpPIL5/mo79KEUWE7nsUK3/c0vGLfmhStRvtq0PXB9GIm9C70xBeLaVLO5wvX5209teCmR5wLZUdhaqTK5zBVhnpYxVMQKH/gnweaQrTy/6xNxH95BaQGRWzU3047+qzmsbyPye6YRolk3YK26v+ZKtyRmm6CP1dKpi0/qv5BaQB+/B8h80qSC213qgdO3ZnyBlzpk8K7huliijf6w3kYVb7kVGk+HA+PNh3yG75pgSGSgmmzFdVfi9I2ZZxg2zguokhCYg6IYoLrzsL+Yi9YOQd+HJTo6UfqNYBBhBdGpZWbiPftOMhYLWlPJVqzZrNgv+xjPggod2Lt8nxYTOiFmNT37HqwOYXQDLCUhVhor/D66gVg6JJrtzaASItyxE/84eEYgwdC19UaLb/SttKsAzI9Ljx/hJ21DU2SeBzREL+YgCz4JUKO/NK0Dg2E/vMzHy76XCME3LVXiFvVvk2N2AFTBkUrv/6HHVZt7o5ARa2FVWwRNfY6yUDCVRcBKG+4GsiwPCZtSWLCGYBuGx4ax4o53hHnP197oZWJfuTjCmFep0OI43ZSr6nnDNEhmuxfhMvsiaqX8cv+225r5o3HEnybO7ic56+yf/d02mda0LkcSiqBtaNx2rtMee8So5GhJX7n887gD9Id4PXzw57ZpmTDgYqioegDKy5nTnSzS0qgyg18s9fbUjryPWD+WF10cwCLLfRkC0wM7xYvh0v53K2oQuwKJj0GXXW6N0y7Zpk+UEBabKzrQUYrJiIjIFFIsAvEDIVQJznC56unSd/akfJvHCsc1OuxvKOWR2eJSSyotWjpoSGR8rQoDgjATcY3RWSSJ8n0FHQqzf0inmkJecmPaB3Z1RGRWSTtpeQhST0ua59DXPin5s76VMIjq9NnKT/k+Xn08tD8a8NKj0hvcMYUs3ds6+7WnXuPSKYecb7C15nTFZ8h13gLQTxIG+XWZdCh1CF6MDBoMn/l+s+C/SgEJFR3QRSaIFAh+bT/8DqMfnG/i6C7Vyb7CaxcAzUXo1Ss4qmm9BPJmvdv36sam21vu6EbXbskzA=
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