Company Profile New

Loading…

SELECT wpu.user_login, wpu.user_nicename, wpu.address1,wpu.address2, wpu.designation, wpu.zipcode, wpu.website, wpu.city, wpu.state, wpu.country, wpu.telephone, wpc.companyname, wpc.companyprofile, wpc.companylogo, wpu.user_email, wpu.mobile,wpp.* FROM wp_users wpu INNER JOIN company wpc ON wpu.ID = wpc.userId INNER JOIN newposting wpp ON wpu.ID = wpp.userId WHERE wpp.adminstatus='Y' AND wpc.srno = 749