#!/bin/sh

(echo "SET @cid=570; SET @cid2='service@';" ; cat /root/bin/mgbc.sql) |mysql -uusername -pservetword  > /root/bin/result_mgbc.txt 

SELECT  table1.id, table1.a_id, table2.email
FROM table1
INNER JOIN table2 ON table1.a_id=table2.id
AND table1.campaign_id = @cid
AND table2.email LIKE CONCAT('%', @cid2 ,'%')
; 

#!/bin/sh

(echo "SET @cid=570; SET @cid2='service@';" ; cat /root/bin/mgbc.sql) | /usr/bin/mysql -uusername -pservetword  > /root/bin/result_mgbc.txt 

campaign_recipient.id campaign_recipient.account_id account.marketing_contact_email
0

#!/bin/sh
(echo "SET @cid=570; SET @cid2='service@';" ; cat /root/bin/mgbc.sql) > /tmp/tmp.txt

SET @cid=570; SET @cid2='service@';

+ содержимое /root/bin/mgbc.sql

#!/bin/sh

(echo "SET @cid=570; SET @cid2='service@';" ; cat /root/bin/mgbc.sql) |/full-path-to/mysql -uusername -pservetword  > /root/bin/result_mgbc.txt

table1.id, table1.a_id, table2.email
1245       4578    service@somedomain.com
и еще 500+ таких строк  

table1.id, table1.a_id, table2.email
и больше ничего!! 
списот полей таблицы, но нет данных

15 8 * * * /root/bin/mgbc.sh 570 'service@'
15 9 * * * /root/bin/mgbc.sh 571 'service@'
15 10 * * * /root/bin/mgbc.sh 572 'service@'
15 11 * * * /root/bin/mgbc.sh 573 'service@'

mysh.sh 570

(echo "SET @cid = $1..... и так далее"

set -x

#body of my sh script
(echo "SET @cid = 570.....

set +x

(echo "SET @cid = $1..... и так далее"

SELECT  table1.id, table1.a_id, table2.email
FROM table1
INNER JOIN table2 ON table1.a_id=table2.id
AND table1.campaign_id = @cid
; 

#!/bin/sh

(/bin/echo "SET @cid=570; SET @cid2='something@';" ; cat /root/bin/mgbc.sql) | /usr/bin/mysql -uusername -pservetword  > /root/bin/result_mgbc.txt 

SET @percent := '%' ;

SELECT  table1.id, table1.a_id, table2.email
FROM table1
INNER JOIN table2 ON table1.a_id=table2.id
AND table1.campaign_id = @cid
AND table2.email LIKE CONCAT(@percent, @cid2 , @percent)
; 

15 8 * * * /root/bin/mgbc.sh 570

15 8 * * * /root/bin/mgbc.sh 570 'something@'

15 8 * * * /root/bin/mgbc.sh 570 'something'

SELECT  ......
......
AND table2.email LIKE CONCAT(@percent, @cid2 , @percent)
;

SET @paramener2 := @cid2 ;
SELECT  ......
......
AND table2.email LIKE CONCAT(@percent, @paramener2 , @percent)
;

#!/bin/bash

### Usage scriptname.sh 570 "'something@'" 
###
(/bin/echo "SET @cid := $1; SET @cid2 := $2; " ; cat /root/bin/m01.sql) | /usr/bin/mysql -uusername -ppassword database_name > /root/bin/result_mgbc.txt

(/bin/echo "SET @cid := $1; SET @cid2 := $2; " ; cat /root/bin/m01.sql)  > /root/bin/result_mgbc_1.txt

#SET @percent := '%';

SELECT @cid2 ;

SELECT count(table01.id) AS initial_contacts_cid2
FROM table01
INNER JOIN table02 ON table01.account_id=account.id
AND table01.campaign_id = @cid
--  remove percentage sign  AND table02.contact_email LIKE CONCAT ('%', @cid2, '%')
;

/root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
15685

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
--  remove percentage sign  AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

30 16 10 * * /root/bin/m01.sh 575 "'admin@'"

#SET @percent := '%';

SELECT @cid2 ;

SELECT count(table01.id) AS initial_contacts_cid2
FROM table01
INNER JOIN table02 ON table01.account_id=account.id
AND table01.campaign_id = @cid
AND table02.contact_email LIKE CONCAT ('%', @cid2, '%')
;

/root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
15685

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

45 16 10 * * /root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
0

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT (@percent, @cid2, @percent)
;

50 16 10 * * /root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
15685

SET @cid := 575; SET @cid2 := 'admin@';
SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT (@percent, @cid2, @percent)
;

#!/bin/bash

### Usage scriptname.sh 570 "'something@'" 
###
(/bin/echo "SET @cid := $1; SET @cid2 := $2; " ; cat /root/bin/m01.sql) | /usr/bin/mysql -uusername -ppassword database_name > /root/bin/result_mgbc.txt

(/bin/echo "SET @cid := $1; SET @cid2 := $2; " ; cat /root/bin/m01.sql)  > /root/bin/result_mgbc_1.txt

#SET @percent := '%';

SELECT @cid2 ;

SELECT count(table01.id) AS initial_contacts_cid2
FROM table01
INNER JOIN table02 ON table01.account_id=account.id
AND table01.campaign_id = @cid
--  remove percentage sign  AND table02.contact_email LIKE CONCAT ('%', @cid2, '%')
;

/root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
15685

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
--  remove percentage sign  AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

30 16 10 * * /root/bin/m01.sh 575 "'admin@'"

#SET @percent := '%';

SELECT @cid2 ;

SELECT count(table01.id) AS initial_contacts_cid2
FROM table01
INNER JOIN table02 ON table01.account_id=account.id
AND table01.campaign_id = @cid
AND table02.contact_email LIKE CONCAT ('%', @cid2, '%')
;

/root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
19

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

45 16 10 * * /root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
0

SET @cid := 575; SET @cid2 := 'admin@';
#SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT ('%', @cid2, '%')
;

SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT (@percent, @cid2, @percent)
;

50 16 10 * * /root/bin/m01.sh 575 "'admin@'"

@cid2
admin@
initial_contacts_cid2
19

SET @cid := 575; SET @cid2 := 'admin@';
SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT (@percent, @cid2, @percent)
;

SELECT CONCAT ('%', @cid2, '%');

@cid2
admin@
initial_marketing_contacts_cid2
19
the percentage sign
the percentage sign
CONCAT ('%', @cid2, '%')
%admin@%
the percentage sign as parameter
the percentage sign as parameter
CONCAT (@percent, @cid2, @percent)
%admin@%

SET @cid := 575; SET @cid2 := 'admin@';
SET @percent := '%';

SELECT @cid2 ;

SELECT count(campaign_recipient.id) AS initial_marketing_contacts_cid2
FROM campaign_recipient
INNER JOIN account ON campaign_recipient.account_id=account.id
AND campaign_recipient.campaign_id = @cid
AND account.marketing_contact_email LIKE CONCAT (@percent, @cid2, @percent)
;

SELECT 'the percentage sign' ;

SELECT CONCAT ('%', @cid2, '%') ;

SELECT 'the percentage sign as parameter' ;

SELECT CONCAT (@percent, @cid2, @percent) ;