From surenkid, 9 Months ago, written in MySQL.
Embed
  1. SELECT v.id
  2. ,a.time
  3. ,ad.`name`
  4. ,ad.mobile
  5. ,ad.address
  6. ,v.nickname
  7. ,v.city
  8. ,v.province
  9. ,v.headimgurl
  10. ,CONCAT('https://truly.vinistyle.cn/',u.savepath,u.savename) qrcodeurl
  11. FROM `wfx_apply_record` a
  12. LEFT JOIN wfx_vip_address ad ON a.contact_id = ad.id
  13. LEFT JOIN wfx_vip v ON a.user_id = v.id
  14. LEFT JOIN wfx_upload_img u ON a.note = u.id
  15. WHERE a.id>=44