HQJQhyK2800b4FG5Pg7Yk0U4i7A+uLUZsLk06TVwvhQg7+LPpzLWBJMFQkAqgdOSMHCWJrmo1HvxriK+MDUOky6wH4wUwurOdZ/Dm8c/LaL4d67ewRwVGVgENjRGjb3MG8U/IwQ6IBH6zmQvz4Xxp55dGKlff/UhckueexVXMRiRar47PkJxzmGkOT/XyMqJ54gHAmxl/5mlkIqEDE2Y+5uy1UnSOQaULFXSI9Ko3LHzVr5QyXkuLb/YTVigGuIIEzOvZxrCHcThOmjYT2mrWpiWoIacIT6T4foaoVheRuYgQ4HwpOfwPZZKS4dlFuZQ8KuHxUiZPpEoXOAKsLov6nOF0xetEvttzThxlefGlgMyk9fL3arpDEuINMreR5dw0IcugKuIqcTKTcfiOk1JVIrKb0xbhkMR0tC5oErJcuPgtl5KKVFlPr7UtZ9Fyt0LwE6HTUqFUd1e+7/TimZdXa86b9H5OAA+XlOUURUJiiU+vgw5bLPuvqO1Tsoq7F6VG3neLskGmxNTG7IfSip3fStADkmUsm141cnTlGU2wGqFBIaiGRW9bxQ30d7j5BfawMwMl6LnoTulJlYi4d7/pnL7icr0HyCMNgeY/F1gmoKduF7qXXP0MRxyv/GmgaQEKQgB1owUB+8MaRufbAf3pZ0aSu5d/5l9zA11eCTdnuUZs0G29IJhXAdW0FOsc7Q44pdsIM2sxOYpAj0Gqu7XTzDlo1H/x34uf79KGzpKeIZhnjY92RA5DD4LSJ3jvdZ+mQdSd/7xehAtrTdvEtYoxxAT66syeumzdeYK7dDJDLOzYjUNT7gKq47YA4z4I6h58Mk+Vb2rT82nVZfEyTOxEwtfLsN1uYJmhSneZN1QnBkvZzOwzqp5iz8fyhv64gVzYVWh6oXkFCW1qPBCBCAer0QTtqiLWM8gjMSgP8zSLvzdaIp0VgizQvfgnqDDkKbQLRA8gsfKZa2PpIepxjOieMTJYZoHn9T/2M1qbOswH0rWMQ8QX6yxKuC/jV6Hg3ZGn45c6wkGQhg8BbVm548wGxWtHZDltf8IrKSjqYTbyucjgmUQxSXiRW8kPh6M8p1MKYglV4eL1RLKfkVFeXnGxfVUcDI+XdwoaStmwPP8vu/PtLjZ05kDljuv0gGp6H4Mkcrshfkk2eyju5k3ZsH/wtCD2sTVJZm0lBA74Ct2u30m6m16rNHVFCwNxLgEw/PzXmUQDGLn1Id/iygttYpek6gB
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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'
GROUP BY et.id
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100