I3T2UbByiIDRLolqcl5QNqQYZcwjQTQwfpMGcxJ9JznvNBFJ21ZSEMMo9fw8rAuQwMwPIF9R/UTaKFcm46DZTxrUKaWfBwIYcG460XIU+/457tR91FiR9lmgMYx7eJmAA2yb4CyKi86PYHY33Ma7mUaghQ0ICfVCDpuknvRdIldiUMmmury9jbCZCs3+LFefc3HF8lHsTHCk7wybxo2HobasAg3oG4CqDAuF70Raf4mtbb6ZCAa5+h35kNGpJYFPmpbaG4wZFOxZsV7X2OOM/sV903B68UfZ+Mf7Jw1AmPysOYw+dZOlbwgMHmehKECy53Nxih8iKJiSoI1wbnNt88X0BfyZ9AUuT6N+b/8ufDx3Q0dtDcNuzzzdcFAbnoJjAklpyQehpizfcrSSwbq2QDNANqH1JIjGIOq6kcYpJVYQkXcd9bKhn9UN9Fab3L9+/zFiDvy5AS2vkCxqMQRA7EYvkaWH7YbNlhrf5H+vYKSru4AnlkTDryARRFjXqcD3gq1y5WXlSoaEO2gYbOog78tFGzIDHOCuvKnqItS5L/gx21H4joOqQwlLnr3AU4ExBrXpK3dG7GBx5cWiGcg+XyOn1jxeyHHTC9lskTsetD6bsr/pM22wQ6FE9OwNmflct/AZzl30V7S1yFnQSwZMAnwZ5qdstT/2sfNM/h3ltyBlLgaNlcQUCRExmO3te8QPVFHp2lY/oRko+q+IBLoWo5cvOh/7SHBbaTWnSZoFRa5k5sy3nrNm6iDcR58c+0ZzsRlJ6EcK+WSDeUSsFuofzQw/Tjb9unCP4fy64C4T0vMFu3uVOa9qDrx32aHBF5jLnCFInTli6/wybDLON4sbDYvsE/JbRFBKgPHU17YkopXqWpJb7tKtaU0UdD4l4uLnNSaXDum36l1hOrW6FYjXSXNvAW+db7VvbK+N9KcXDoQOyMYIPERwTzBgqN2glAmDneHDESoO2k06Ldc4vBnmO0MLxw2v2yDE20xQIU4QmyrH82C2DspB/blMsjxfNX9hFGVMGbJor8kD1vF9GW9S+TM/LB6BnzJsEOuEwwYTcdCq8lYkIaRPJIvUBWjuz2Hx/8WA9kfi6aghe1LYnu/N68ApbWv7lbfAoDQyqR3NoyIWtXNgEBdmduKfpu98Q+XFNPowu1q6VjhEItR13z2HuCDRPj8/IQf0CDCAdl3fd6ijCBEMDJwU6T+0PTANX5WizW2D9vFpDxssITIBiDPtJw64+SyNLt7BKQKCRnCjUSzvWFiX5kxe/QPqBku6PMhc3WL7QLBDZoV3DAszqlLFwEDuiTTnUlpOZ39pjC++bRAjn0bSYqt1edk6lPKviXftG13AuePFkft/fCkczuwRAiX//CypC+O2MyMBhlk=
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