7oPv2mUnr9gtJfuIjDwvuZvIhXEhIHBmEjzUE+B7ENVrFxErbmTj0Q2o9ngP5D5Ujy/RDE4zQ/JSsyDa9xPJtv81Inumtt4hPEFoNKVNJf4c4nW8vR0ear4CTzugM+pYdQacrqqvThGJu8yM9gk84nzkMEqOAp4bYlk+/vNrBKU4kAPtoz00jj7yRuYlgRMG+JtwKnLSDRc4QPW9tx/RZsj5nJyXuQkQltNRNTm+rDGwQk+t92RokYVd1cxZ8hA+sz2wAZpJdn/DVFv3u91vycCV0S3nc4cZ9eAZ0hvnAEXhM5VnnM8vWwllcTSR5Q6iHLSfBUCDx6V6SoLfq/9L0R3x0U5/e0QRylLJALqCqTgLlgJ42PFbxNNCcxGeJI4SfosJcILHIt+GAF8dD/E3D2Tf4aTlXig62qFMkzBw0L60hppowx9kQG8/9dLqFGMRd/re1L8E9sUc3x9BuhejJe1ca0Btd1fINm23hp1idyFto2gaGjfIwk5QNdb4G4ApqfVnTq654PsVozatQVDm9U80OZrdJIjxe76TdbQJIAuMZHwvw27eKuuaUW6vKZvFWfUokzGG7Fu1Ycz2JCaVd0vI4QM+jVrfaP4GZBCVLkvKeOQ3rtRaL2fBvh+ZnwM9K/uIl8dtAhlgIVbmTY5r7UMPbon0TF5pGFOGss9yesR+08dkJn1gmf4j3vjYWVZDpCP43BKoepvnzPYnlX2Mu9piu1dtq9wDCDX+1y9VjY8sCIjGhMKvH0GqmYiKKB8ZJuqhx+n4BelPb361mJscMGlHTyzAIoRtYjp82cv6hkorPochUKehAqDydUx4Z9D1iDty1EIl3cdTnNxIgE48fQYL4CLmJwA0ovmeMIUnY+LJrNaROC07Al9zXhqgDyedx89vBDuMinzhFN1kWlv0szlVvsYrgMdihaSuxG44TMxCV2Q8XyXlVjkJEIzLsGhE/R58avmB8RJ44T/PANnOjHwz+O8DBo5sMh+mMQ1FTKVsix0rZytGM66IEELlZ+FQlfr9IoijzLmhORCtjMoiP3J3IzbSTPi0MZ7Gf41rkPeyXESbz6o9xOULOaBY+viEvQtLhlTXFmArc5rlJnGTWM2IWA0BJq3VZCuOT30QM+Ym975S43auscqUZY1ISgbzwwzoshOzlhBjopEJpqd7H7m/eI1fREFbOQHPYLque1O+YL2+roxtvdcfD7s3pTBJwE91pWRJBsy0zGZUmZtefCHvExfZOoPNgnzr4OqADSb7lnrq5MAZA5tJzfRish7kySA/p+46l6dCSsyzLku6+/7IeqhRYBIx5WBqGuWNEXL9pY7Fq40eVCTC1Y8T33XX8lek187QJU2HmxL0kzDRS7M4Mvrz3QHzEPF+1+M=
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