BEGIN
declare last_inserted_number VARCHAR(100) DEFAULT '0800100200';
declare last_inserted_message VARCHAR(100) DEFAULT 'Lorem Ipsum';
declare le_keyword VARCHAR(100) DEFAULT 'loan';

set last_inserted_number = NEW.dest_msisdn;
set last_inserted_message = NEW.text_message;
set le_keyword = 'loan';

if ( not exists(select id from transactions where tel = last_inserted_number) && last_inserted_message = le_keyword)  then