zOSrpPQ0xEXSM1Fj1JPiiiJVw1IA04LKzLFt1GIv6H93Kvc4idws3+6qm7cGey13zeMT/FWkfJHcAhsH0NsJp+eE6PMCa1q0Nl6B+5uezp9ZpIudX/3IBxDcqc7CIkMmZ6wjNxMX7AC2Ak1fHFgA140sJ6aP7h+b04I1FiUP2p5r7AfFso0Cx3/Rmfk7whXhoIGKIrhGqD+ZAMmL1S/G3f/wOUyQGmxktp4OOcmyancQ/xl151Jgub0zj5NTnnCdOSSeu1NnWLfoe8h0XME90H7/dUrNo+1/EgWAMpEWA0TVYXZTVh+PfceSF/i7zhgF09nB8rmK62tkfXAvZy1gD53Q3vTZPNGHrOgc4Kx2qoeD6Nji4FwAtQlqcooG7JXezh+UP/Nn5DEKG7bYJVcscnqUTl0OpV8U6gKqw86OEZ5CcMF+7rWnR4F57vkd3dDZZ5MYJSzgfvQmZRd20lLiPAIdwzu23agBML/yVubUpGTXtamU0TyJyzdCilgDSAp1hUiWNyN2sXY86ldSYQJNbnoqDllyzFwkGKoA2XMMrx7q1qOrpoQ9p/aKGryS6agWsKx3ThXI+MTjXsOKbOetW3I7QWP1IyZ5P+l3GvDvYxW/ruS2+5vXPWYAnrz3lfjV2kFlNk1FKU0yEthTSSgenOkVXqoVlM2j4q8QHwNE1w6fyHhRLx+CfrDvFGL4Lox9XEmTO/uImnhda6Rgjy+5pEUMC5o3a9RTVRsH8OVgQRZECylArPVD80ijroSGuAtG82zJKZAk0rqapbXFqTnEMXlTaQf//j3vz5rEUgrHl5u5AdaOQP2Nr+YqIUee6XTs1+E8XGIOJ5gkJeihJKyonP7zo9LxQkdwUeBgB3+Xi/RWqsaOdovqS4KFoWN2GCS3gdcNJaeme5ZUi6UhNgspUzC7wjng3NVxKG+6vpfXyiLzYToZYHtUjsxb+wlyozfOfQzitQDf+siLizQ88rlEPDUihJeGXF4qKIMDICuI+1t0b+Xz3KcCpnC/BGs/+2NCHjaVeiUW76NSt2qVs6ZNB7gsnnkishj8n304Wca4PJI36vrnA+bgsH3Fl7T7LZ+Jl0h6RaweGYV6fNktjnxvRDFtD8GDCec70ifIpy095RL7tZ4szGFoiy+vmCecTcF//Rke5wDNnFpZeXHhIN2Ibra1mnwcQNbQs9YvEBybAic+YKj1CrNmqRMMQMHcZPba0eukhFPxdKK1w6Ut+WrWyFVnWIayyS/FN4yuRrvMegX1c3FYVMKws0pTLdkocgERsFfXXRn3qow6OjrnxSN4w5bnmgASyc42A3iaHK5yTV8qw9i3/KpL14rCrnzdUCTIYs7yWHBDMDSOTapkG7WacyOWhYLs2Jw3k9bQ0qc=
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