aqW/TE41iK5bdDOiN+Adb13B1G1SZlXnHA1Uu+MLKEOhozwnu5kZQFIHjONUJLi9YIy5hu/S56iSFCOrY+r7awzi++M7ZHrPdcQ3fsfxaDvyQXkU6ce0MY8Io77B27B6N1TKe2bh8EbwSgkvHbZFzvEHY1k03B8IWJRo73G/uFcyq9GYflJtaU3arkJNscBkgXnY4wXm24tT9pYG8XCg1bAip4Ow+Hg6f//kPFEXbCxaj9xWkxIOh1672oKvTUYjt/WshVOLYJ5icflDaIHMUL0/6CVqOZOiVyeMp9G3lUf3ZPZFYLB5gMZfxEcyf8anzRFIhezm4Z2dGtR3nv+aFwnX8P5h1U3vqAoTP2WM6xrZCzqx9FrV/q8Z8RuHneXT5RJvgjVRo+oBeg4057QjR+kFPgtRIKAZK09HbDvLOMNMxr+s7k1OGfqkAdnbcyCUue5HxWYAd+Jldi/HCWj+yMgDesxpkymNFDcVGb+GNzshobXue4JxSHqiJqg1Q2QnFFsd9ApJEENMt9aZskSkb0F1Bvi8g4bBdml26dIPGckMZxTcD0kDGS8WAxo29DphpY1uDac43MYrNETp7vabnlNwtvR6/OUdnJ6Ag1EKK9n3IL0NLsqfNuGAWhZrRkSw65u1MZFgWenmx4hJf8n9hUPloOWO2HxXK8BW0K7xr2PjgQXKygEVWgrCwmY3fkIBeMSr0HGmfZ95Wsqj26ONznJ6XhJnp5q7kns7l/HSYi9aYZa1lZHRDeZ/hkT46zwQiik+DpCRvcUpmfBKzllBRr+Cfrx11Pz1QSbNFeqczDlW23+trCfETy9/ZM4kEI8Uq1whOI9zAfAzRUySgFKMLmOd6aCQHWtFKAbZSVc//pblcE43W7SQBuX8NurDb5zaXfHt
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'
GROUP BY et.id
LIMIT 100