IutoDLoq3E6eqvPecQ5cUKawc/YNXtygybZO7j0+CKSfL3sGImw8po9bgXnYKBtcFcU9qZheYcTmleuDd7NRbShe/NG2/ClkngpT0sW+DliAy639rKbYTs6WJvze3H8QOA32B2Eg4NutHUiWc7kWMwSVQ7cKSbjNK+AVaoG1B2BiPLxCLNGMo3PlaMfcICErGdk1fdBxCQC2tfN63Lm3hXWeN9bcC9wSxEg1iC5LhOX25WtQ9KXLcMwmEZ2t+fOZJwJvAMOiuCXaQtp6Aqtj5BnTdes8nNYc9yVAs5VZ7yLPI9Dy6x45CZmM5UqHKXAKQ/0Nj9QluSWYgauvGrJ8bilxh4RDKqhVclXZqDez5XEvGbZ+rm9fk7VvDd4ZQjc+p5CLzC7FuPIQrMaUVI+lHiTDPeXupLt11jXAiuis/FLPeJQTC5hVdc+4uBfQM1FcWlw9iSaf0K3RVDL9slGr3uBQfsZ/UgJNvNo9Y3WOmL+z8E7wL1WVzmoLrWxJf7a/heK/iwSWq8zrSsxpWyzvcgc7Z+bQAW2BdyJwkOxB+57Ag2Iw1BJWxArPMHc8+jj9LKaRnRGb4ZxmcC+9uylkU+OCvKG1WQdky9FMfGomZ6ZMlzjkKupRk2YIxfcn2aVGKbK7CnZ3FWVY+wilYKbDGwTJP7SyY0HVU/BNknzUfsJUQ+GsnFz1JXSKLQ2QpNQxFt7DXePSVWFdZqUafEDSgEpn17YVpUreieqBADAMqHctOgnqkP99I+fEb3Bop3fNO1vuar+zcq6BU/E9KFUIodam/wVWHGMiNvUvYmxyc2xOCev+0X2Zt8d2r6COH5Qn6GfIBQqCnnP44KtuPPwF0HFvuoKkafU8bNExeTgPKLz6GsGY9Ka+0nNyT/ggasw/QAcm6B91n/gzRgVXCP1KsyVpAD6XlyhdVXoEIuks4caNXrXbzjXleDdKydlpU2OBJJmxVXTQ4b1wAXmQOqDx7xTybFlyybQxeliXSZkqXNqjEUohiy9xfRzBkUEZSa0+5uDczBV0OcuhEuHnmMz8z624LHEOY+Y0K3G2e0I68N8Hnm7hO/3LeH4OuvVxFl3kXXjzQWU0tmU1oVw7E6x+ODZxVCcF89H6aZi3Yfsy0G+YImE9QloRrn6L1O+oxBRmmQEOWRR0MJyucg5no6qoaMR+kSmsQ0pgU0+7a841LSxjFHXY9k+gM79P7XE3TdtMfD1IoPHJ3P592Ir8bb1TajmHZ1mu0zcqSPdr65srrxsb3ELRkGn8sbGCULmylJj8auh0O6+/oB3zdzwjQUdMU/GumoK8WqcIxBA/0Xiw2y8btAAHQIwDrrLqw+SVYsm0n4pVbT+hI/1r7NdqPJDyYx7A1Pawco9n6q4uYL0=
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