|
select
ms.* , m2.m2_code1 , m2.m2_code2 , m2.m2_name1 , m2.m2_name2 , a.a_name, m.imagehosting, m.owner_logo_img, m.homesitename, m.chatColor, m.cName, m.ceoName, m.name, m.tel1, m.tel2, m.tel3, m.cNumber, m.address, m.address_doro, m.address1, m.email, m.id, m.mail_order_sales, m.homepage, m.account_bank, m.account_deposit, m.account_name, m.memgrade, m.oname, m.opost, m.odept, m.mincome, m.motive, m.course, m.oaddress, m.oaddress1, m.ozip1 , m.myoffice_img
from odtMobileShop as ms
left join odtMobileJob as m2 on (m2.m2_code1=substring_index(ms.ms_jcode , ',' , 1) and m2.m2_code2=substring_index(ms.ms_jcode , ',' , -1))
left join odtMobileArea as a on (a.a_nuid=ms.ms_anuid and a.a_view = 'Y')
left join odtMember as m on (m.serialnum = ms.ms_serialnum and m.userType = 'C')
where ms.ms_randcode ='58951376'
|