Cacher is the code snippet organizer for pro developers

mysql -hhosts --user=sss -pssss shops  -B -e "SELECT users.name,v.company,v.shortForm, d.id, r.name,r.shopname,r.id,r.mobile,p.name,va.mobile,va.ref_code, va.amount, va.amount*va.discount_commission/100 as comm, va.status, va.prevStatus, va.cause , va.timestamp ,va.vendor_refid, va.api_flag, vax.processing_time, MAX(vm.timestamp) as updated_time, group_concat(vm.response) as causes from vendors_activations va USE INDEX (idx_date) left join vendors_transactions as vax ON (vax.ref_id = va.ref_code AND vax.vendor_id = va.vendor_id) left join vendors_messages as vm ON (vm.shop_tran_id=va.ref_code AND va.vendor_id = vm.service_vendor_id) join retailers r on(va.retailer_id=r.id) join products p on(p.id=va.product_id) join vendors v on(v.id=va.vendor_id) left join users ON (users.id=va.complaintNo) left join distributors d on (r.parent_id = d.id) where va.date between '2017-02-21' and '2017-02-21' group by va.ref_code order by va.id desc limit 10" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > /root/trc.csv