SELECT storekuaidi.createdatetime,storekuaidi.kuaidisn,storekuaidi.phone,

provider.username,shop.shopname,shop.address

FROM storekuaidi

LEFT JOIN provider ON storekuaidi.kuaidiid=provider.kuaidiid

LEFT JOIN shop ON storekuaidi.shopid=shop.uid

where storekuaidi.state=1 and provider.kuaidicomid=33 ORDER BY storekuaidi.createdatetime desc limit 0,5

找到快递公司为 EMS 快递，已取件的快件，

字段：存件日期，单号，收件手机号，快递员，商家，商家地址