zeNF7/G9zfjukZ0U2GVMgFe94TMPqaTqGpiBO3nPc3o5EuWRHLLGfkHc0hDzuLEBTu1Y0PUjNAw8J89PaLV2DmfixqbLajS6wnfca6bMvrSez2h37IGVfhHiAuQ0a3NC/M6RynaYKm9iEkI/BjLdwqzJnWtSX9gDDZKNsvtZzND49YjT7YHzApH5Pmzt5ihLPqafcohuY3XYBFqNQwA+X3p54R5oBvMT/zffNG03hVBZFdCUxtmk1RdbYxCzCmoe8k2VEDRWh0BPs9f7lji0kDkyQgY5gAgnWgCfXeJfY0z5DpotmBFGsiugPbByneMcHwLSBlOCgHylrVdCkS4voTVqbcCerDlzovzd8CQWTZYnfiKQ1cJDksQ0K0rIBUAeyPWU7DxiqToMIMvbSBFRMzoqc3MUPoQc4r4R6qoPHY+PDYKGAL6OYZ2Bapk7PT6z+7ZTL9MkmvCRugzxvyB3r2mfP/hxzI/jgbKUk03VTNcY0CnG9ymKxOCqstpVpQB0EDbaGOebede4vXiKQLNDgxme5F62TIuSiKqPTMTqhK37tTdGmMS3gTEjqhyAD+a+ANLxdMvP68EmTf/3O0WtC47w/FsoABhhUrwPi6RUkiPMRzPVvWluoExwsFcJgnMviJnuKeEWkYYQsYGeEGLCKqMhUAr6qyq5jhPp+E/9ovpdQD4lLqLE4USPRHxQgcVA49EoLM0qRTPR8+Sf090Nm8FwKnCdjFVV0tJfRZpdK+73Zll/yltRKCGIPGJ2KhsVZFCmnRgSJNa8naFByaa7z1EC77VKQSejvVnc3CokTQK3E9JSJKJ/DDjFW0fKPML5+cQfUrfjqAomZDtc9UZ0/c4ot1gxmmeT3HMwxJbaDdGN0OpSGBIJT8+ZFiIXzkSGROoOLHH7YiiCyXavGCfsBSR5El+p/6WNk86Ye3a10Sxp2A9vWSTfqtTcqtAK1LkASz9oBEgMB4HqYlE0BZnmCqS5Ifb6jg4RDTjNC+kILXe92ARI8Z//ocL+y2/XqtSw2WW3GPFlQ0VQfeqS2q9u9P/UqWNd2f/gOW1JUsuK6xQuidtSba5k3XXrPAVa+kAcWrABN7pf4ClnVNSOfeFxPjWUItLjJz5TNumzfbYwGww9UfzcG94Aba1bZscrrP+RZrXSi5E/KgcRk4Bnx0ogg0y1RlYUSMRQvxBvGYy1GU/m5r/gv38W/qEAwndVm7BUQbz4Jj3TLAxU3fK7a6LK//auQuUQ8UECVTWh9NDCiUcs64lDr458KZfs7sZxT7zgbVOy4WnSowYS+yU46npHH/dmFISVVW2fnMrWbWJIxV2DcHXchS3kgLyccNdTu0+W3MkQttS3WaQnTbjdcs/JqA5ViT6g5Fi2IrV+A24=
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