echo "select tbldura.mac,durabyh as dura,tblfreq.freq, tbldura.timebyweek,tbldura.sender,tbldura.netid from z_weekdurabyh as tbldura INNER JOIN z_weekfreq as tblfreq on tbldura.mac=tblfreq.mac and tbldura.sender=tblfreq.sender and tbldura.netid=tblfreq.netid where tbldura.mac='00:73:e0:67:42:e2';" | mysql -uroot -p0ffs4t? wlsp > weekmac-dura-freq-3.txt
echo "select tbldura.mac,durabyh as dura,tblfreq.freq, tbldura.timebyweek,tbldura.sender,tbldura.netid from z_weekdurabyh as tbldura INNER JOIN z_weekfreq as tblfreq on tbldura.mac=tblfreq.mac and tbldura.sender=tblfreq.sender and tbldura.netid=tblfreq.netid where tbldura.mac='00:73:e0:67:42:e2';" | mysql -uroot -p0ffs4t? wlsp > weekmac-dura-freq-3.txt