Mysql INNER,LEFT ,RIGHT join的使用

时间:2021-05-18 04:35:32

JOIN 按照功能大致分为如下三类:

  • INNER JOIN(内连接,或等值连接):获取两个表中字段匹配关系的记录。
  • LEFT JOIN(左连接):获取左表所有记录,即使右表没有对应匹配的记录。
  • RIGHT JOIN(右连接): 与 LEFT JOIN 相反,用于获取右表所有记录,即使左表没有对应匹配的记录。

INNER JOIN

首先,这样是寻找两个表之间的一个关联的字段,然后就能够得到两个表的功用数据。

SELECT
a.UserId,
a.UserNo,
b.ty_name
FROM
user a,
type b
WHERE
a.UserId = b.ty_id;

等同于

select a.UserId,a.UserNo FROM user  a

用查出来的a.UserId查询出来的list,做一个循环,将主键带入到另一个表中查询出数据

SELECT
b.ty_name
from
type b
where
b.ty_id = ?

这样也能达到一样的效果。

同样等价于:

SELECT     t1.UserNo,b.ty_name FROM
(select a.UserId,a.UserNo FROM user a) t1
,type b
where
t1.UserId = b.ty_id

表示,将一个表里面查出来的数据作为一张临时的表,然后和另一张表进行外键的链接。

同样等价于这里所谓的INNER JOIN内链接,

SELECT
a.UserId,
a.UserNo,
b.ty_name
FROM
user a
INNER JOIN
type b ON a.UserId = b.ty_id;

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPIAAABHCAIAAACyDY01AAAJrElEQVR4nO2dzY7bthbHz/N0lsUUGr2CH6FALiobBDJPcRfJLa7tYLS5D5CsppvEDhBdtJmsumqQVcbjjbgrbouLJEWaZj7SD6sLUdQhefQxtmVZIv/gwiYpmofnR5qSdWT49/Q/+5aSvVTrw+JS/QRt0+LktH05rJ16KIe1Uw/lsHbqoRzWTj1UNdac8x+vkz4lzvkORrZd2WCjlGmsw7qfssFGKYe1w7qHclg7rHsoh7XDuofqDtYzBl74vcN6Xdlgo9SGWEdfgv/PBUJkEX6+AXzfT3wAAIAvZ21hHTHwwxhZG4e+mnFLxaEPoLVpfMgO5LCuPqYhrH+8Th4N4fNJ3N5q3QjWjKmttox1HPrAot1+/G5FYH1983t54py/eJe8eJe8eBcNwD9+lWRvkxevwoPD8NE7lHPL9PU/4OB+TBR9w2CzlksS5zyz7ukQjiYXyN6LB573YFE1JsVpOfFgOF9OPPCmS5E5H8FGba6TkI1pl3b66TtODWL96L7YUQCwr/P6Qhm78fEhDL6JBgAptSrWeX3IKrSI9WJ6lHVlNMvrC2XUptA8HQKA92AhGbp44EEGk4J13gJqtjms0cd5o2H1ZHs6hKPJdKTaKMxJlc2Qp0M4msxF/nD++/XcOIoYrl1hfXX9qTzVwvpVeJDTbFZOaRYvEPcY62gAaR2R3yjWmXXzALzxAtm7mHre9Dx9AaOZMhS48nLsQTATLyCvKfM/nU88kT8bQdrm9TwA8CZL0eBsBPpHbC0hG/MuoZ58mg2zTN1GgOFcDIWwdzkeiqNQn+cBgGhtNgLlKFnBHK6mjF0H67O3q7O3q7O3zwZwdPxylb1dnb08OTg8eSiKAHDpKQNVB/fis7fx8SEMTvMW/nUnzV+dnTIQTa2It1tNtbBO3YZLZyPNIm+yNByG3y7HHsBwnsOEqGra2TTWub3zgJ5RGou5+ecTuV6b1FKv6eHaR6x1KA340sX46PhlEZf7hrUBFkUeSD8pRWQL6tvF1AMIhiVYq5Oqcaw/nU88b7I8n3hica2D9WLqSSjpxbgAa2K4doX15dVNeeKcP3+zStPDe0cA7L54+2wA8Nm9+Pmb1fMfTu6eppnx3UMYnIrSgchc3b+THiVLZX7WglI/vnsIcHjy8E1ec4uJcy6tez32AIZPxNt5AOCNLy6vbi7Pp+NZmnkx9iCYidJAZN48CdKjZKlWGbcP4E1fa+1f3VzOhln+9hOyUe3S+dTzhoHnjc/JA+cByKKLcVoN9RMNF65JviaHqyljN8I6BVEqI1LNv/NMZP5w8lmWN9Chl5MEleb7lqO799husL68unkSoC9KyRzOD+Y5EzJPh57GOs1B+M7RpzXraflanVo3TwIonk4U1qkJ6fgEQ68u1uRw7Qrrj5fX5Ylz/t0vf/Upcc4rre56KrHxcQBfjBet93C7xupY//bxqjxxzr/76a8+Jc55pdVdT4U2vh5/AcFj8Xb2lXpW99Xj9nu+nrHrYP3t///sU7IW68dBh9ktN1bH+sNvl+WJc/7t//7sU+KcV1rd9WSDjdhYHetfP3wsT5zz//78R58S57zS6q4nG2zExjqsHdZ9SwTW3Mmp+9Kxvs1tnD3R+/fv2+5C47LBRinTWId1P2WDjVIO6ySxw+U22CjlsE4SO1xug41SDuskscPlNtgoVYY1AI24w7qL0mw0wykjhgMc08jiAhnRngAALEoi5odxxPQKu1cF1iTZXcUaeUoLUFVGgayWZ+YeixjhaTITZbfmcNPTmL+KoOGIEaWZTdhK8brtIOBqrE2yu4k18owx6GgUyGoRk4gj/5MoUJlx6GeZqKUdC9lYuhKT3SOxNotKqu1WBNYywg/bqkX+tdLX7Ul/SELBJiSrpqCaH1sXa2UWtbaOFW606rBI1CmfG+1+M9XGGpPdfazVbWShy7NqOtZoDTdWOCJT/bQ2nhGSJLfD+jbI4sPj0N+P54/cAmtJdtexNsEiXZ5Xi0Mfb0KM72m0ySAytfW5dayrmTXRLN2EINJlvbasFCKwloGrmrE4oLWVvm5F5OaWPp3C1dApX0i4uHQ/sterNZ6yxaKwps6C49BnUb0mG1VdrLU47Vb6urmKTtjMi1/FbtE3MFlmKdbUHmbHIrEWvYlYRZdqnjIK1ts/bySwloGrkmkzoLWVvm4mcqcgpF0lKHGLciEEbZ7zKx1EJkK5vS9nAmv1qk4Z2bWwzpZvaepenTJqWJNx2q30dSNF2sN3Cq6E0NWoq9YJ/TVMZ+YNtPblrHqaOEWgzhrysnKs0bHZHK6YKM2KwFrGYwNAUZx2K31tTlb9yliGr15YOh211dkoaHF7TWFdI067lb42J6uwtkEE1nXitFvpa3OyweU22ChFYV0jTruVvjYnG1xug41SBNZ1Alpb6WtzssHlNtgo5bBOEjtcboONUgTWdcJ63zs57bd0rCunglutuygbbJRyWCeJHS63wUYph3WS2OFyG2yUclgniR0ut8FGKYd1ktjhchtslHJYJ4kdLpc2yhAWfDNSaVxLwc20+TH6DWLqLSEt3MpnFdZy9HUfEVjHoa/chFcQOk7eN1R0e5x5+A6FbIxDn0XG8xOUDpOgGswW/3E2bl1gTUTlNDYY9mCtri0qdMYoxKHv+/mN12ToeAo+Y76GB525T5HnaP0l8BX5JcihOVC0yhNYG200OBAE1mv8827HZNzLr41CugipsYxFoeOke9TMvYs8jxj4vgyqZ1GS44kwLV6wa/RfxVpfmCtiNTaXjVhXhOiaj1EoC0asgfWexTKm3RFWlmAtVDQPsz2FEYVvrPoh88NYnS9NjwCB9Rp/UdoNqY7AUveduafy2JgNsN63yHPZqTSKsQTr7PxCO7ekZqy+0RAFInSmary2LpuwzmQ+JA5fJQBzUenXai36wJifYk2tsukKkH1pAWMMGGPkGTONdaJUQg8V2Y3xNmJtjm42CtQjNFLfF4aO18N6nyLPRXfSdVlfrRXlm2JxpmvEJ5ZgjZ9+RX7rFX3qNkRgvcY/73ZA6tl7+SljKkRjSeh4Daz3M/JcRUq8Q5Qr22Y/DLNdhX7Zk0VxyIiHp+ArT8TjUvLDt2qlkDVYlz0wtRJrMlZVX9oRD8ZFg72LPCe2RuaFDg1u5RIJPlOk1nF0STvFmkC4+LL3piKwXuMPpbsuq35lzBBOL08Ysy0OfT+M5N669HckhV3ySkhaJDcyhXUaMzZTrT+HbqYzrckurC2QwzpJ7HC5DTZKEViv8YfSXZcNLrfBRikC6zX+ebfrssHlNtgo5bBOEjtcboONUqaxfwNvyxKZx9zVJgAAAABJRU5ErkJggg==" alt="" />

LEFT JOIN(左链接)

SELECT
a.UserId,
a.UserNo,
b.ty_name
FROM
user a
LEFT JOIN
type b ON a.UserId = b.ty_id;

MySQL LEFT JOIN 会读取左边数据表的全部数据,即便右边表无对应数据

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPIAAABgCAIAAACopLi7AAAMAUlEQVR4nO2dz4/bNhbH39/THIspOP4X5k8okEVtwUDyV+wh2WJtBfFl/4DklF4SK0i8aDM5BL1MgyAYxDNCABFBgGI3CZIsvOnMeNRth3sgRZHUkyyPLckW+QUPNn+Zj+9DmpL9bJjNZn/3/7FpiW2kGp8Wl0ommM1mTdPi5LRmOaydWiiHtVML5bB2aqEc1k4tVCmsKaW/zlmbEqW0hsltVjbYKGUY67BurWywUcph7bBuoRzWDusWymHtsG6htgfrcR/I6GeH9WVlg41SK2I9+RY6fz1SEDkafb0CfD8POwAAAN+Om8J60ofOKFKsjUYdPWNJRaMOgNFn5kVqkMN6cZuKsP51zu724Oth1NxuXQnW/b7ea8NYR6MO9Cf1vny9QrCen/9enCilTz+zp5/Z08+TPehcf8GSp+zpi9GVndHdz0rOkun7v8CVmxFS9EMfVuu5IFFKE+se9mB3eKzYe3yLkFtHi+YkP4VDAr0gHBIgfigyAw9W6vMySbGRD6nWV685VYj13ZviRAHQ/z6tL5SwG13fgb0fJnsAnFod67Q+JBUaxPrI302G4o3T+kIJtRyahz0AILeOJEPHtwgkMGlYpz0o3VaHtfJyxOstXmwPe7A79D3dRmEOV7JCHvZgdxiI/F7w+zzItEKmqy6sz+ZxcSqF9YvRlZTmbGVOs3igcK9iPdkDXkfkV4p1Yl3QBTI4Uuw98gnxp/wBeGNtKtTK4YBAdyweQFpT5sfTIRH5Yw94n/OgC0CGoehw7IH5EmtLio3pkJSRxONekmnaCNALxFQIe8NBT7RSxhx0AURvYw+0VrJCdrqqMvYyWO9/utj/dLH/6fEe7F5/fpE8vdh/fvvKzu07oghALb3XB11XbkT7n6LrO7B3L+3hb1d5/sX+vT6Iri6Qp2tNpbDmblNLx55hERmGGYepT8MBAegFKUwKVVU7G8c6tTfo4ivKYDE1fzqU+3WWWuwxPl2biLUJZQY+vhnvXn+ex+WmYZ0BCyMPpJ+0IrQH/emRTwC6vQKs9UVVOdbxdEjIMJwOidhcy2B95BMJJb4Z52CNTFddWJ+enRcnSumTjxc83bmxC9C/KZ4+3gP46kb05OPFk19uX7vHM6NrO7B3T5TuicyLm1d5K1kq85MetPrRtR2Andt3PqY115gopdK6VwMC0HsgngZdADI4Pj07P536gzHPPB4Q6I5FaVdknj/o8lay1Kis9g9A/FdG/2fnp+Nekr/+pNioD2nqE9LrEjKYog2DLsii4wGvpoxTmS61JvoYna6qjF0Jaw6iVEKknn/1scj85fZXSd6eCb1cJEppem7ZvXajXw/Wp2fnD7rKG6VkTs3vBikTMs+EHsea5yj4BsqrVetp+VhfWucPupC/nDCsuQl8fro9UhZrdLrqwvrkdF6cKKU//efPNiVK6UKrtz0V2Hi/C98Mjhof4XqNNbH+7eSsOFFKf/r3n21KlNKFVm97yrXx1eAb6N4XT8ff6Vd1391vfuSXM/YyWP/44Y82JWuxvt/dYnaLjTWx/vLbaXGilP74rz/alCilC63e9mSDjaqxJtb//XJSnCil/3z3vzYlSulCq7c92WCjaqzD2mHdtoRgTZ2ctl8m1st8jbMlsuFnJGywUcow1mHdWtlgo5TDmjE7XG6DjVIOa8bscLkNNko5rBmzw+U22ChVhDUAOKxbo/XZOHu5//ad9mDjtABrlOwtxnrSB0CiU7VZ4KHiAFrNNDONrZ2ocRFJNpq5CTI8/eXN60fTGWPz6ODw0f7r6EQp+/D20cH7L/k9GVi/mx4+ezOvZtSX1GKss2RvJ9bRqAPQ6fexoGtlFiZ9yWIaoD3pS8SVoHE0fryJoPJS0jx98v6ZAHceHRy+nOocL4k1Y/PoQF8YTQvBWkb4qd/kMiL/mhruysJ/SyDnDTr5LQUN1fQHFrYX63fTw5cf+MN5dHD48sM8OlB23KWxZuzD20fTDTrIlcVaJdsarCd9XtfEWtnDM6cVNHMTpNiobq4ca8ZO3j/bT1iXWJ+8fybBTR9jWKfb/0ZoCawl2ZZgncIcjTrqISQDbDTqZLdoNLNBKTaql3oJ1vy0zfMvgfWGXT4iWMvAVYNpNaC1qeGurLJYK6dp+VxcBY76JY8em3UeSW3UdtYUa3H5OJ1dCuvNOl6XxdqI025quCurFNYm08wozJZtFdY5uzVjyVFk2sbdWgauSqazAa1NDXdlLcR6wdlBuxGSdDTpy3t5aOZGSMc6c7ZO9OXN60f7hwrWomZ6RMk7W28X1micdlPDXUHK7ejMBV06CxPjN3o4mNhda6adTKLizA1Q4Z0QteI8OjiUd0IE5fuHz6Zvi3brzb8TIuOxASAvTrup4VYk6z5lXPONi806WDMc6xJx2k0NtyJZh3X6KeMatB2fMpaJ025quBXJQqzbLQzrEnHaTQ23ItngchtslEKwLhPQ2tRwK5INLrfBRimHNWN2uNwGG6UQrMuE9c6cnDZbJtYLl4LbrbdRNtgo5bBmzA6X22CjlMOaMTtcboONUg5rxuxwuQ02SjmsGbPD5TbYKOWwZswOlxs2Zr81q3/j1vxmGPIFMKNqf8IDQTfhq4s2YY2GlDPG6og8b/57fVnPqvwt+G74BAmdkDapVirxRE3GvNmDNRpSLqRYXUXkufId7sIIhUql2Fi4E6PDQ7HOFhVUq1cI1sv+8+4WKo0e58pZzGuKPNdWUWP7WO6GVYZFpE7x2mj4G+d2Ym0GbuW4fE2R5/qrNRUKtgzWyyCrNo9Gnc0It0ewXvYvSrdOWbBQl68r8tzYnxvHejGzWKxmwSFEIV3WaziO0zqs0cMtfjm1rsjzjd6t1SWbLwxr7Co4GnX6k3JdViq7sM67YMve/Fpn5HnOGaZmoViL0aSBxTkqeckoWG/+uhHBetl/3t0SFYWUG3cJ1h15rqDc3JszgrV+V6eI7FJYJ9u3NHWjLhnbiTUeUi6UzkJFkedpB429OeueRi4Rcn5NVpQVY620TdbwgoVSrRCsl/1D6RbIqk8Zi/A1CwuXo7E7ZwoaPF4jWC/7z7stkFVY2yCHNWN2uNwGG6UQrJf9Q+kWyAaX22CjFIL1sv+82wLZ4HIbbJRyWDNmh8ttsFEKwdpFnju1QCbWC5cCpTRul2azWdNDqFw22CjlsI5jO1xug41SDus4tsPlNtgo5bCOYztcboONUg7rOLbD5TbYKOWwjmM7XC5tDH3iBXEcx4EH/IGaiSn0CSClaZvAQ4IRZIvAI364PkPKyCqs5eybPkKwDn0CoLhDttVdFHhId0hmTvMapdgY+sQLVKizWKOgZpgNfZJjj9q7wDr0idlLZZNhD9b63qJDl8E69AkhRE576MvHaWMOvucRAw88M9O8bmk2yv0XwVfkFyCnrIG8XR7BOtNHhROBYF0mRLeq4dSjwDP2CQNrvgmltTQXGP5A3aNnFjWvT4qNgQeE8H02wS/BU8E0f8MuMX4da3NjVtZ5NbIR6wzVmZ0s8Xi6xSqe1JuXwLqoeX2SNvLhCCsLsBbKW4fJmUKe03N3fd8jfqivl6pnAMG6TCxjpWOqSrojVOnnztRTfPYNxy6LdWHz+qS/I4U+AfCCYqyT6wvj2hJbseZBQxQEHvFDrayedyubsE4UeObFinqXALKbSrt2azEGzyMca2yX5TtA8qYFnueB53noFTOOdaxVkmV1GW8j1tnZTVyOXKyLLS2tvvzZuqh5fVIPIcQPxb5s7taa0kOxuNLVF2hciHV6lyQpy5peeFtxFSFYlwnRrWIo1Uq/ei++ZORSaFQcYq6IElgXNa9Ppo06UuKZQrl2bCa+n5wqzNueXhD6Hj8/5/QvsM6sCTRrPbIGa20rLnHfGtlkjbbm1q7wkLlpgDSvW6aNmaNR9kaHAbd2i0S9UsT2ceWWNscaQTj/tveqQrAuE3lexVAalFWfMiYI89sTmdUW+oT4gTxbF36OpLGL3gnhRfIgk1tn/caaWJcJ0a1mMI3JLqwtkMM6ju1wuQ02SiFYl4k8b3rYa5YNLrfBRikE6zIhuk0Pe82yweU22CjlsI5jO1xug41SCNYu8typBTKxZk5O7ZLD2qmF+j86pp91xN7IwAAAAABJRU5ErkJggg==" alt="" />

RIGHT JOIN 会读取右边数据表的全部数据,即便左边边表无对应数据

SELECT
a.UserId,
a.UserNo,
b.ty_name
FROM
user a
right JOIN
type b ON a.UserId = b.ty_id;

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAO0AAACjCAIAAADpfQ7EAAATzklEQVR4nO2d3W7cxhXH53nqy8IFta+gRwiQoiuCQPwUvUhaVFrBvOkDJFfuTaQVlC3SbAAZvZBrGMbKklYGSBhCCjl2oiSsanm9aiv2gvNx5ovLlUgONTN/jGFqOMuZw/nx7CGXh0R/Gvy5UyXvpIzvFl/KCzJNiJdXDfIce9kgz7GXDfIce9kgz7GXDVrAcZqm/5zlNpU0TdvZswblgo1UhbGeYwvlgo1UnmNr5YKNVJ5ja+WCjVSeY2vlgo1UHeZ4O0JB/HfP8U3lgo1Uy3I8+gj1fn8EmDiKf30L2v6+0UMIIYQ+2jbF8ShCvTgB1iZxj69YUkncQ0jYptRJC/IcKxo1xPE/Z/kXa+jXG4k5f9wIx1HEb9Uwx0ncQ9Go3e7bFeZ49uGqpKRp+u1P+bc/5d/+NFpFvQfPcvJn/u2z+N79+IufQM2S5Y+/Rfc+SxSr/hKh2225pKRpSqzbWUMrG8fA3uPNINg8Kt0hpWW6EaC14XQjQMFgiiuHIbrVNm9SgI3FkFrtveVSJ8dffIaDBISiP7L2WATW5MF9tPqX0SpCBaY8x6w9Ig0Mcnw0WCFDCbdZeyyCaUHJzhpCKNg8otAcbwaI0MNxzLYANtscx6C7IFxbfHTtrKGVjUHI24jNKUQOiZ01tLIxxPVrw6vZUPqUYnc1yfH72bykVOL4WXyP4Ss3LvDFCwB0yPFoFRVtcH2jHBPrhn0UrB8Be48GQTA4LBZQuM3tCth4uh6g/jZeQKwlrZ8fbgS4fjtExTZnwz5CwcYUb3A7RGIXtRVgIxsSGMl8e41UijYitDbEuwLbO11fw58CYx72EcJb2w4R9ynaQN5dTRlbiePx+fX4/Hp8/tUqWnnw9Jr8eT1++vDe/Yef41UIwbWPIsTr3qfJ+Dx5cB+tPmJb+MPHRf31+FGE8KauFX/WWipxXMwTXLsdChYFG1NphuCf0/UAobUhowdg1PTsqjlm9g776kNIgI+Zf7hBPbKMqWpZvbs6wbFIoURb4W5XHjzVgdg1jiWSVKghOjHcKuUW+D+PBgFC/bUSjvmjqHGO54cbQbAxPdwIsPuswvHRIKAUqt2thmPF7mqS48v3H0pKmqbf/HhdlM8/XUEo+gz/+dUqQr/6NPnmx+tv/vHwk0dFZfLJfbT6CK9dxZXXn31cfIqupfVkC1z75JP7CN1/+PmPrGWNJU1Tat2L9QChtS3857CPULB+fPn+w+XhYH27qDxeD1B/G6/t48oPW/3iU3St0BhuH6Fg8ELY/vsPl9trpL7+Amzkh3Q4CIK1fhCsHyo/OOwjuup4vWgGxgl2F2ypXFburqaMXY7jgjwqgiBf//FXuPIfD39F6lZFyulRAdayUGTlk0+jdji+fP9hqw+++yhksL4/ZBDQOpFyNcdFDeB1CHprdmrpMn8sfdjqI/3xo+K4MKHYP/21oCrHyt3VJMfvLmclJU3Tv/38P5tKmqblJltQSmz8so9+s35kfIT1GpvnOfr3u/clJU3Tv73+n00lTdNyky0oWhtfrP8G9b/Ef27/jj8V+92X5kd+M2Mrcfz12//aVJzl+Mv+HYa13Ng8z9HFvy9LSpqmX5/916aSpmm5yRYUF2yExuZ5jv518a6kpGn61+//Y1NJ07TcZAuKCzZCYz3HdhYXbITG5nmOUi+vO648z5Frd51nWWZ6CI3LBRupCmM9xxbKBRupPMfWygUbqTzH1soFG6k8x9bKBRupOI4RUgPtOb6LEmyUUwRHEUzaK9JjNZIyGBFCKBrlo6gXJ6NIbNC+RI6VKN9VjsHUCFmW3Bwrm7FKNkWjSDG1ykpQbWyG5WMVArcg83UUKdYSm6CVeNl0JquCYxnlu8kxmAppL4M5VjYbRZRpMOHKuVdVJnGPVIIttSxgY6mvVQ5PybG8qqRZu8IcF1lr0Dghm830OG8pMZdfE1eQZhyb7LNVOeYOG2OeShs7VYFP0ab8YDD73aPnGKJ89znmQ0HtHJNmIsfAS0s+TFHJ92bi2RV5vhzHyzAKP57EvW48F6OMY4ryXedYJkk5x6xZEvdgXCF99YK4QVEpeGDjHC+GVGaxNK4AaNN2pqzEwhwX2ZeCdTAr09gAby1lgKo+B4LNwHlarJjT0hCj0/4YHqN6qThWnbomcS8aVdtko9JyLGQXmxzjLaQ7y5KvSennQYxJSGUpx6qwpGUpOcajGUULhlTxPA/Dbf5kD3NcZF9SiOWsTMPDvImUX/5Ywrl8yTxwlytAAMyuRygqAbvmvm8VHPPXXspQrsQxcdDUVOPneZBjZXaxoeHdQiPhKTCa6xXqZqqrx7n6m1VdyTZg7PuW51gR5qsif7aunGPwWXLQLjgymhXmuMgiRgjpsotNja8hOfV7Xhmv4srS40/wv9IKgyEy4XhRdrGxATYjpzh2QZjjhdnFpsdZs1yYYxdspCIcL8ouNj3OmuXCHLtgIxXmeGFWpulx1iwX5tgFG6k8x9bKBRupMMcLk1EzL69uK6/ynps2jqkWlTngq1ywkcpzbK1csJHKc2ytXLCRynNsrVywkcpzbK1csJHKc2ytqI00aQPeyVOayaG515R9Rry7ir+9wsCNb3ZzTHe3OCkKjpO4x92ypkl4Vt50o7uZTP54iwI2JnEvGklp/tyAlWRKkOrfWQy3jjlW5KE0tjMs5pj3HjxlEsdJ3Ov12I3IyoTngvQo6gk8qCu7lC8NPKyCV1xfwhiAXufHFRxL22hwR2COq7z09A5Lupld4LhwM3x+ni7hWTkffGXn8qVHEer1aCp4NMoZj4BLvUuuMH6eY9H1LkhWuL2c4HhBnqmc7V+WYFeB447l5xXDwVaWcIylO/BImCDljkt+PY56ccIfIE3vAcxxlZdF3j3xex6Kjx3Z1LBskFtw3LV8aTqoIjOvhGNyjiCcEKoOUTF2wCtwssii/VW7rOaYSH4AGTyXR7LbsMsf4zFEUa/gWOVHi0OefC2hKIpQFEXK01w1xznXCDzsoh3jneBY3p1kjlWPdigmW5vwXI3jLuVL4+EUnlf0x5xYYItPT6WcuxKO4XOXlN9rul7rEOa4yktP75j4c+zy87xCAL+ShOcKHHczX5pnCP8FsOZC314ck0BBvBoZjZI4UjzUA14fUjzGg328Viux7OW47HGbCzlWJlyKzhsAIJ3ady5fWhHtyJcjBJq5Cxnw9E7lqcGl5YJjBbP6y8+3Fea4yst7bZJTv+cRZouLCNLhlcS9Xjyi8XHpDzgcrMrrFcUqGpto2zRi7OL38jbTuzG5xbED8hxbKxdspMIcV3l5r01yYY5dsJEKc1zlpac2yYU5dsFGKs+xtXLBRqrM50t72aG8yn2bc7uUZZnpITQuF2yk8hxbKxdspPIcWysXbKTyHFsrF2yk8hxbKxdspLKP4/Nn41ffcQsK1TfHlbozIo2NwxCFQ+UHxDXTQcC3nA6CYDCdz6eDQL5zAiHy6WGoXIt0/dahjnL8c3Kye3A+n1+c7E92xycnv4B1Z692989+1n5UBOu7g8leciE0Eua46e6MSHusDsNgMFXWo3CooxR/hKCMl5cgU3/81KFOcvzL2R5G5+Jkf/LsgCdpSbDm84uTfR5NYY6b786I9N85EEagYYiCIGQr9JyqUGdNde66BY4X5pk2NgCFvjuYPDsrFi9O9ifPzi5O9oGTWxqs+fzs1e7BOWwE57iF7oxI4hjgixEdhtDPBgEKwjAIAhWG4RDjSY8A6NYruOZW/HGXOIb+rABrPv/lbG9MaKNg/XK2R9FhyyqwmMfFAnPcRndGBDkehgWIohumVdNBEIaL4mPSXutwg8FAFxuLAUr9xuZV8vMa6FoneMJEwCpC2KL+BmBJJ2FgjtvozoiAjQWRynACu8lhGAwGZFHPnyYi0UsXi9et7nHMOTMGFj4JOzi/EVhizMrmuJXujIjZiOlTQ8hiC/LNL0UArAL6b52jnQ4CFgqzrTcbWXSPY42DnM/J1/1BG/643u6MiNoILpcJHPPhBuBYd4pWtB2G4UCIOcRtD0MUhsU/hILBdBg2FVFQY/MqeaaNDUDW+bOxFLAS/Zyc7I4nACzckoUBuoC1jOPGuzMiYiP0oRLHsKKaPy64FGNnYdvTQVBwi+OVJk/x5vN5JzmWLyDAlRcn+xN6AQFzNp7sHbwqc5DLXa+ovzsjkq+7icGqAGwFf0w/oY8rijUsrmC/nLTgjxfmSzc2AJVqPt+vfv24qe6MSOZYgk+NdYk/hptS+mPalB4M4nXlZjxzVjHPtIm+S0R+YKtBy/ye11R3RrT0b+8yxwoYO6qOcty0XLiHxgUbqbKK+dKmx1mzXJhjF2ykyirmmZoeZ81yYY5dsJHKc2ytXLCRKvP50l52qNJ9m+UN7pwyB57t4IKNVJ5ja+WCjVSeY2vlgo1UnmNr5YKNVJ5ja+WCjVT2cZw9H59+zy2oGtU2x5W6MyJqo/BceOElawuEn2Avt9W86oM8sV71BiHWe+3qKMcXr17uHmZ5PkueTHbHL5N3YN3b090nby60HxXB+v5w8vjVTGzEc9x0d0YEbCTM0ZcsJXGvF0XwZR3Cy1QY+3rwdK8eg28BaewFTYI6yfG7N48xOrPkyeT5IU/SkmDl+Sx5wqMpcNx8d0bEc4xFfCX3f55zdfR9jot6KH1tjeaVbg0p6+B7eb8/nDx/WyzOkieT529nyRPg5JYGK8/fnu4ecg4YctxCd0ak88ejCBXvtcF+l77rrirHAF/29jL2xjwYhcDNNOqaO8gx9GcFWHn+7s3jMaGNgvXuzWOKDltWgcU8LhaY4za6MyKlPwZekX+ttsSx0pfi1+dJblj27Lr4uKG3CWbde58pPGEiYBUhbFF/A7CkkzAwx210Z0Rl8bEsrT+WXaoynGCnfc29JK9E3eOYc2YMLHwSdpjdCCwxZmVz3Ep3RqTheCQ5SvI+y4Uc4zZqUKUIRRUhNwZ49zjWOMg8J1/3h23443q7MyKB40j1fkd29Y2/XgFiWcax6vSQbX/Erx5FUSwExE066qx77+XNno+lgJXo4tXL3fEEgIVbsjBAF7CWcdx4d0YkXD8GXpZGxOJbTRPFH9y1Ot7hUnHxSkJejSqe2DnGsXwBAa6cJU8m9AIC5mw8eXx4WuYgl7teUX93RqT4rQdGC/pvef618oqYWqyS3lxd/GUgrujW+6VrPt+vfv24qe6MqJRj/KcCLN5NKzmWANX+HtK2P+7ae3nJD2w1aJnf85rqzohcvL+iaxw3LRfm2AUbqTL/fmlb5YKNVJl/L6+tcsFGKs+xtXLBRqrM50t72aG8c/dtNq/MAV/lgo1UnmNr5YKNVJ5ja+WCjVSeY2vlgo1UnmNr5YKNVPZx7POlsTgbF9yjJgo3H0X6nDrxPgylqmZl31od5djnS99eNXCcl+OqolROiFLctF+/Osmxz5euQ9RGgFYUK9PmJLhUt6ZpM+5U973x+FfKvr6Vsu7lmfp86Xq0lD9eCGnZEym4lJHqrNdvbKc49vnS9UjJseprX/6qZxkkCkkgi95Wc59xo045uyv5eT5felmJHBM0xSQk2buiKI57vTiu8LwgFbUtp/zned5Fjn2+dE0iNhKsQMadNkWfhLUsM7r0IW7qUz3vj4sh+XzpWlQSHxckCwzCtDzQXHPtDQcoKjQN+uMu5Zn6fOl6VHqeN4p0DwBQNVewTALt8utorT2TpYMc+3zpeqTjuHCXhT/WcVjCHwaYPd5CjFlMXq/w+dIW50uzc7wk7okgqWEuuX6sBF/3lOS2/XHX8kx9vvTt5eL9FV3juGm5MMcu2EiV+XxpW+WCjVSZzzO1VS7YSOU5tlYu2EiV+XxpLzuUV7lv8/Iqt6lkWWZ8DN7Geo31HNtZXLARGus5trO4YCM01nNsZ3HBRmis59jO4oKN0FjLOM6ejk9PuQW12W12Z6QAG0d9cKNOf4f7E6He+lT4bLK+goLNRLHZnQiFI1izFaL+TieM7SLHPyQvdw+yy6vZ8f5kd/zyOANrX5/u7r/5QftZEazTg8leMtPPcRvdmZpasjzqr8QvuLWjPoq2rvLLq2R9Jdq6yrfCRfepFfgSjpXtDQLdSY6zN3sYndnx/uTpAU/SkmBdXs2O93k0BY6b787U1JJlwjGh8MVmj7hbzHHVzTJ/jLdJ/DE9MIwZm1fJM21zTKcHk6evi+XZ8f7k6evZ8T5wckuDlV++Pt094Bww5LiF7kxNLV6exgHvOIPNhAUbJE54sanNdS6gX+yzRa/fqrFd4xj6swKs/DJ7szcmtFGwsjd7FB22rAKLeVxpjlvpztTU1r9ZKT7uSMkq5ue1OCZ4wkTAKkLYov4GYEknYWCO2+jO1NTS5YW+tmKbrsfHHeKYc2YMLHwSdpDdCCwxZmVz3Ep3pqaWLoOAOL/cidTLVQrguL9Dwu5p3N9MXmz2PMewqB3k5RX5uj9owx/X252pqaXLVX2tRgxQ3Cbqh9z1u6AjHC/MM21xTNnTsRSwkrU/JC93xxMAFm7JwgBdwFrGcePdmZpaulzJH2t8M71CvBWyMzn5srHnWCzSBQS4dna8P6EXEDBn48newWmZg1zuekX93ZmaWrpcmz8mpaPx8cJ86VaHVfP5fvXrx011Z6Ro/TEsy/jj8spO+OOFeaYtD4v8wFbDppb5Pa+p7owUF++v6BrHLZhtfAzexnqNzavkSxsfaO1mGx+Dt7FeY/MqeabGB1q72cbH4G2s11jPsZ3FBRuhsbnPl/ayQIvv2/TyuhPyHHvZIM+xlw36P/aiza+xSXdEAAAAAElFTkSuQmCC" alt="" />