select contact.uid,id_campaign,message,first_name,last_name,auto_link,campagne.id_event from db_campaign campagne,lnk_campagne2personnes lnk_c2p,db_contacts contact left join db_auto_connexion auto_connexion on auto_connexion.uid=contact.uid where campagne.etat='suspended' and campagne.type!='sms' and campagne.id=lnk_c2p.id_campaign and contact.linkedin_id like 'ACo%' and contact.uid=lnk_c2p.uid and campagne.id_unipile_account=4 and type='message' and message!='' and message_date='0000-00-00' and (lnk_c2p.inscrit_event=0 or campagne.objective is null or campagne.objective!='event') and lnk_c2p.uid in (select uid from db_connexion_linkedin connexion where distance=1 and id_unipile_account=4) and lnk_c2p.uid not in (select attendees_uid from db_message tmessage where tmessage.id_campaign!=0 and tmessage.unipile_account_id=4 and tmessage.id_campaign=lnk_c2p.id_campaign) limit 1