HQL查询中取个别几个字段

时间:2023-03-09 18:37:32
HQL查询中取个别几个字段

数据表:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqMAAAELCAIAAABiWhghAAAgAElEQVR4nO19TW9jvZEuf+z9F7Oa3axmN7tZNLLLLgsjaBiOAcPjNixbtiVLkOOeGwQJAgzmAnnrTbTXXZxuguZHsVgkzyGpelAweHiKxapikY++LCkogS9fvnz58qWIqXkgDguIkMy3gzHWYowoBH1BAcDDt685AkbtZpqaR3p3+Pj4LyLzSHelMrCMsRZjRCHSl/xg+tX9ZY6YtZtpah7p3eF/rv9VZB7prlQGljHWYowoRPqSH0z/+HCVI2bt6k6llKuplPL2zyxeh1sWy+F/vvybyDxCLJUWqnp4qbptZ1vB2ocP74xt5GQWqSQ/mH69us4Rs3Z1p1LKqxzqn1O8DrcslsP/2P67yDxCLJUWqnp4qbptZ1tBRhTqMyhReNVwO1LDA8sPpn9+uskRs3ajykqpzOnyxetwC44RHf7H7j/YopSabdQA0l2pDCxJ50yzwo6CUnU5OlLVA8sPpn9d3+aIWbtRZaVU5nT54nW4BceIDv96+E+2KKVmGzWAdFcqA0vSOdOssKOgVF2OjlT1wPKD6Tcvdzli1u7UM706ZKnpV40yp8uXkMPaPdNP5cANamaHf/3jb37942+0P9Ol7rHuugpFRp2JREvFrYFlS2VgsdbCu1s3vs3r7URWMGSnyAp6owhVixWXe5fYaVn2RirFObD8YPrt632OmLWrO5VSpo6+tPoXEZ7DlMY8DsP33yql4PtvUxtWmz3qjIRQKlbP1Db/tlb/nYq7FlaSQwkPbW2ks95mD0URnYtyopbSERlMfjD9brvKEbN2dadSytTRl1b/IsJz2NvQmNNh+NPvlFLwp9+ZonuQhjvQDIE+6oyEUCpWz9Q2/85ZKgOLuxZWkr159ibcXQjG9i8bRXQKyolaSkdkMPnB9PvdU46Ytas7lVKmjr60+hcRisNTj9nphjBbLJbD8OffK6Xgz79PbVht95I46oyEXCpW2/zbSNn3LknnDNLjvRU9r0otpRsFcS7KiVpKR2Qw+cH0h/1zjpi1O/Xoh9WmmvlwO3PG4g4jPkcVZojIcviXv/7hl7/+YZp3ars92jGkP6RJGXUmQikV99L6O2epDCyhtbDUzDwTDyJELWSzYBT02b1xuZ1u1YXshBIiMpj8YPr3wyZHzNrNNDWPEB1WSiGXCzr8y9/+S2Qe6a62B5Yx1sKNYsGDReRM5AfTf7y/5YhZu5mm5pGow9PDW7fH6lzK4b//z0pkHumutgeWMdbCimLZg0XkTOQH03//2OeIWbuZpuaR3h3++/9uROaR7kplYBljLcaIQqQv+cH0+dC12wvEYQERkvl2MMZajBGFoC+oLwKBQCAQCMaFKmXo1BUuLi6WdiEN3Tk8DCTz7WCMtRgjCkFfKPbq/el0OvaDabMt7UUCunO4Eko9MCXiKJlvCWOsRaUopk/25evM4EZr4PncV6QKAB6+fc2R1pjezb67JOZms27pT8MiPd5ZqmKMMy4fX2Z8g9NienZhEI9gd0jSKOu/pYvPFRqI65fdONa2Tc1qKR16xryw9jJeUalVZzZwHctOqH4oSaYMYeQwWj9z+uydyx0V8jl/lSkZQ6AAYHV/qeX/EGDqr+4vm2L6aH1PsI5vV/lo7AevKXbGeZgc9pb1WYHH9Eop3dBIYnp2YSCHgqmDF2HqKAS8uZCBoVE1No65baM+U+Zi6DBybiH0eIVSY0RPEJuUucxb0arAJ/XaoeSQUj9L+RzqxC3T15S+7nQoAHh8uNJCYXpT//HhqimmP9KSEnpOz95atZF0xkXv9gsG00871sv6xZkeaeNgs2+lufCDL+l0Zvvpwl0LHBTNVJ32mZ63OpRRRJsUUsz0lmcTsRD1mcf03n2E6NRl+vXqWsvE5aF39ae7pv56dd0+07uP8oTpO8VSTK8dQM7lUNs6zS24o7xzRUe5d0MInXTIQGsvhLZVdJZjXmWaTJ8aaXEddiDWXo5WlHvLit1aem9+vMUTqkw8zJBlpIdix+qh1M+cPnvniva4a+HGwutJhQKA56cbLRSmN/Wfn24aZ3pvigdj+lC1ITqdIpXplVIWqevMRMe6TE88fcy2d71ceM+maDZ4xekeZ26pe/XNRjSuGhvHfA+LYi01h3SdIlFYphjVFWozbBLXy+Ww0C3cTnRUqWyU8pkyyptVig6jJxUKAF7Xt1ooTG/qv65vG2d6b3skpqfsK+LJ2D6SmF75nr57OylMH0opo+0CMU4fxZuL0m/iSIurKtMTrVVi+sxN5H7mhsJA7mWNdvRuks+MOonWWGq9VfXZalDoo1RPKhQAbF7utFCY3tTfvNwJ088AynP66O61dHpEKtObyGF6+mnIKxheaRWcizJpzglO9A1HC0yfv4Po7weVrboiBx1ySWdNyqhS0S3rc1tMv32910JhelN/+3rfFNN7Oc9luKR/nSLarAp5Tj8h87P3OUxvYnKmVKmEzOIDi8yle1w1opPIqOIbB9+2uMOldIirQ4kCMY7MhWS1lA7SE/W5iGX1k96KWy7r87I9SVAAsNuutFCY3tTfbVdNMT0R3f17Ov5fdm4/UijsWmkB7E/kqZ9v2JuXdKZfOm7B8TjKWowRhaAvKADY7560UJje1N/vnoTpZ0B3DlfCgt+cI1gcY6zFGFEI+oICgMP+WQuF6U39w/5ZmH4GdOdwJQjTnzPGWIsxohD0BQUA74eNFso355j674eNMP0M6M7hShCmP2eMsRZjRCHoCwoAPt7ftFCY3tT/eH8Tpp8B3TlcCcL054wx1mKMKAR9QQHA9499jgjTz4DuHK6Eej9b58VRMt8SxliLMaIQ9AX51do+0J3Dw0Ay3w7GWIsxohD0BVXq2c+FQCAQCASC9lCM6UMf128TFxcXS7uQhu4cHgaS+XYwxlqMEYWgL5R89b4jdLfZvA4rpbzKKgxkCvyuZZbueVmUemBKf/zaXakMjDHWolIUlI05w+Zd9nzggedzX5EqAHj49jVHWmN6K/tefrI2m3nLVfbS28xr7J4OkwNeNyznQ20rLtcU/VHCbPgy72fvT0bm2YVBeYzFKDCiP96B0dnpA5M8dI0kwdwFjEhL6WTuiMzDB8+q2cB13O3v3ey8OvSq4aMolk+BdM3gs3cud1TI5/xVpmQMgQKA1f2lFsp/2Zn6q/vLppgeyYXZHzoy3LX3VkNOxnnATwdLOXQ3FEvITsjmgogyvfr8Nbd6e1iXivZtuKefmWcXRjS9vAIj+uMdSCkP+sCyceEwH3XhsxPnYujQMxZCzuFD9ASxSZnL654XxJJg5JBSP0v5HOqkHLC8Vc6vOgUAjw9XWihMb+o/Plw1xfQn2pJkMn1olnqwHLbuugUXgjtEh+lVQyZdBDjTT857WV+xfsvulMj0SDsE3tics4DneWib5Fumw10LHKn5p+jkx1Kb6XmrQxlFtJl0gNSopRo+U4KiZJW3yvlVpwBgvbrWMnF5SHu6a+qvV9ddM72VR97WmgH6jAsRM35keNsWr3sbIdSLFEfSc3pv221QmF4jNcknZ2mQZFIWKzSEXpyh4cgo7zahDEn1DYfJ9JQ6pMzF1mEHQj98vJfeGjA7vflxiyd0iUxtalL8SbJj9VDqZ06fvXNFe9y1cGPh9aRCAcDz040WCtOb+s9PN+0zvdtjPTlIWoaQzapI/UQevY0nITrXzEh99d5L+RNwO16mT0rsKbzDTeQUGG9s6HiNemg2qsYVgvV4N2otNYd0nSJRWKYY1RVqM2wS18vlsNAt3E50VKlslPKZMsqbVYoOoycVCgBe17daKExv6r+ub7tmehOnlBTnbHUGhOknMJheOe/cI48JEKYPHR+Mdqqd6MCksRRPrP7oNsGtldo4oXdSQqDMxdDJ3Av0wwefukY7ejfJZ0adRGsstd6q+mw1KPRRqicVCgA2L3daKExv6m9e7vpleleBnuLM3Z4K9xPgLkzfknSsiHTgOGaK/DMYn8gLKbi3EKbHiyq1nWoHH5Uz1lv50YH14sLRAtPnVz7v8ME9yW8T1wu5DJ0kxLZ7/hSJblmf6/WkQgHA9vVeC4XpTf3t631TTO/lITc17odizDWzLFB6akOe009gv0+fz/QmJmdKlQpjFNEf+lyuGj7QO5d7WXbj4P/xiDtcSsebeV4UiHFkLiSrpXSQnqjPRSyrn/RW3HJZn5ftSYICgN12pYXC9Kb+brtqiumJ6O4rOLzvFrsNF6Fb1l6ySopuZ2ZQPnuvfP9TN3Val3SmF7SAMdZijCgEfUEBwH73pIXC9Kb+fvckTD8DvK/4mX9DCNE2wu79Mn1ZCNO3hjHWYowoBH1BAcBh/6yFwvSm/mH/LEw/A7yvIbtwB1IYWn1+Ucu9m/OqUVkI058zxliLMaIQ9AUFAO+HjRbKN+eY+u+HjTD9DOjO4UoQpj9njLEWY0Qh6AsKAD7e37RQmN7U/3h/E6afAd05XAnC9OeMMdZijCgEfUEBwPePfY4I08+A7hyuhHo/W+fFSTLfEsZYizGiEPQF+dXaPtCdw8NAMt8OxliLMaIQ9AVV6tnPhUAgEAgEgvZQjOmXfsiShoveHlZ35/AwkMy3gzHWYowoBH2h5Kv3x34wbbalvUhAdw5XQqkHpkQcJfMtYYy1qBTF9K+w+TozuNEaeD73FakCgIdvX3OkNaa3sq//HdzstDabedfV91qYeY3HOOPy8WXez94fjcyzCyN6IvAKjOiPdyCxE9epFBcCcxewI83XIeY5hMzDB8+q2cB1LDvqM7zueUEcwshhtH7m9Nk7lzsq5HP+KlMyhkABwOr+Ugvlv+xM/dX9ZVNMj6yf2Q4dGa6+10JOxnm4+PnNOZZjoULPLItmkcr0Og/WpaJ9G+7xc+YnJBUGcii4/fQCI/rjHRg6npDpXJ1KceEwH3XhsxPnygkcnx1BzuFD9ASxSZnLvJVah15TjBxS6mcpn0OduGX6mrJ3NwIFAI8PV1ooTG/qPz5cNcX0R1pxZzL9kZtuNkJM7zYWdHIGJDG98v3ajdsoyPRIOwTe2JyzIHqoRXWSTuck33C4a4EjNf8UnfaZnrc6lFFEmxRSzPSWZxOxEPWZx/TefYTo1GX69epay8TloXf1p7um/np13TLTH3/uJavTenIwKtOPB/ar95lMrx1ASiXUtk5zFxQ70SH04vQeT5QhbqUho2psHGsXRE1R5mLrsAOhHz7eS28NmJ3e/LjFE7pEpjY1Kf4k2bF6UvdFbZ+9c0V73LVwY6H0IKERoQDg+elGC4XpTf3np5uWmT7Utp4cJC2D254BONN7q21O92YDg+mnbFiXKvHV+2l24uljtr2lZSKnwHhjvZrIEO82qRpXCHoXUNwmzsXTKRKFZYpRXaE2wyZxvVwOC93C7URHlcpGKZ8po7xZpehEe7xxJUEBwOv6VguF6U391/Vt10xvwqtfI+kM4J8L8w6Z2cN5sOBz+tDxwWin2okOTBrrsoJbVJZ+dJtEZyH6hiP0TkoIlLkYOpk7i3744FPXaEfvJvnMqJNojaXWW1WfrYY7tlQP4gwRCgA2L3daKExv6m9e7vplevcWMenH7LynIvSKH+7JzE7OgKWYnn4aljqhUjksk/+SCO+cmT5/T/EOH9yT/DZxvSiPPKJ1QhlVKrplfa7Rw4MCgO3rvRYK05v629f7ppjefOwW6jn6PhRjrlnUgtdmVdCZvuyp1BoW/ESeicmZUqXCGEX0hzJXyAF8YMhOZlw4kl7ZqqTjzTwvCsQ4MheS1VI6SE/U5yKW1c9Trrjlsj7P1qM+45gOBQC77UoLhelN/d121RTTE9Hdv6cjn+IJlQivIBrHUv9lt3TcguNxlLUYIwpBX1AAsN89aaEwvam/3z0J08+A7hyuhAW/OUewOMZYizGiEPQFBQCH/bMWCtOb+of9szD9DOjO4UoQpj9njLEWY0Qh6AsKAN4PGy2Ub84x9d8PG2H6GdCdw5UgTH/OGGMtxohC0BcUAHy8v2mhML2p//H+Jkw/A7pzuBKE6c8ZY6zFGFEI+oICgO8f+xwRpp8B3TlcCfV+ts6Lo2S+JYyxFmNEIegL8qu1faA7h4eBZL4djLEWY0Qh6Auq1LOfC4FAIBAIBO2hGNOHPq7fJi4uLpZ2IQ3dOTwMJPPtYIy1GCMKQV8o+ep9R+hus3XncCWUemBKf/wqmW8HY6xFpSim74PK15nBjdbA87mvSBUAPHz7miOtMb2Vff2daGantdnMu66+18LMaxw9HbweWlFU8WxefJn3s/cnI/PswoieCLwCI/rjHegOSR14qhYXAnMXMBwupUNMVwiZhw+eVbOB61h2QpXAq0OvGj6KYvlEq94aPnvnckeFfM5fZUrGECgAWN1faqH8l52pv7q/bIrpkfUz26Ejw9X3WsjJOA8I31iORRs5INaft9CLOBBleuV8za3y/WStq4YzPbswovnnFRjRH+9AoiZxYNm4cJi7AJ+dOBdDh5c9EzmHD9ETxCZlLq97XhBLgpFDSv0s5XOoE7dMX1P27kagAODx4UoLhelN/ceHq6aY/kQr7kymP3HTzUaIb0LO1HCPmJziJ6MJnOmnqaM9occE+UzPiJc3NucsSD1ndQ9yLOKWS9WAuxY4UvNP0cmPpTbT81aHXglRmxRSzPSWZxOxEPWZx/T4yTw3069X11omLg9pT3dN/fXqugumt+jHenIgTE9B/rlTm+m9/F2E6d0Q6PFap7kLip3oEHqeQ5ajQ6y58FE1asDcBVGfiXOxddiB0A8f76W3BsxOb37chQ5dIlObmhR/kuxYPZT6mdNn71zRHnct3FgoPUhoRCgAeH660UJhelP/+emmZaY/GVk2+y3iTFoG7yy1gTC9W4KhHstmqEyjzqTuRm+bhyJMPwG342V6RrzeXJnIyRVvbOoo7zapGlcIehdEZ6fPxdMpEoVlKmc3UaoObxPXy7IcOpGidqKjSmWjlM+UUd6sUnSiPd64kqAA4HV9q4XC9Kb+6/q2cab39ptHhsZprqQzkP+cHq9+b8OLgjuQgQWf04cSmBk7O1dEf6IDKf3RbYJbK1UD+C7AfSiok1nG9MMHn7pGO3o3yWdGnURrLLXeqvpsNdyxpXoQZ4hQALB5udNCYXpTf/Ny1zLTh9JEf0m2xoHFQD2mN3vM/eBFwXOHh6WYnn4aljqh8Fwlnc5FZjQV6sWFowWmz69h3uGDe5LfJq4X5QSI1gllVKnolvW5Rg8PCgC2r/daKExv6m9f75tiepervNTlfijGXDOvBbynNuZ8Th9CPbajY0GmN6HDKVIqjFFEf9hzedc6Opd7ycgGAvw/HnGHS+l4M8+LAjGOzIVktZQO0hP1uYhl9ZPeilsu6/NsPeozTulQALDbrrRQmN7U321XTTE9Ed19BQflv7q9ZREapTvdnlAleauNV8dsUD57r3z/VmddKtb79IJlMcZajBGFoC8oANjvnrRQmN7U3++ehOlnQHcOV8KC35wjWBxjrMUYUQj6ggKAw/5ZC4XpTf3D/lmYfgZ053AlCNOfM8ZYizGiEPQFBQDvh40WyjfnmPrvh40w/QzozuFKEKY/Z4yxFmNEIegLCgA+3t+0UJje1P94fxOmnwHdOVwJwvTnjDHWYowoBH1BAcD3j32OCNPPgO4croR6P1vnxUky3xLGWIsxohD0BfnV2j7QncPDQDLfDsZYizGiEPQFVerZz4VAIBAIBIL2UIzpl37IkoaL3h5Wd+fwMJDMt4Mx1mKMKAR9oeSr98d+MG22pb1IQHcOV0KpB6ZEHCXzLWGMtagUxfR9UPk6M7jRGng+9xWpAoCHb19zpCmm19+AhvQcnc2G63stzLzGC55xTRX0l3k/e380Ms8ujGgCeQXGLktvCESecB2o4WEI5i5gOFxKh5iuEDIPHzyrZgPXseyEKoFRh94hjBxG62dOn71zuaNCPuevMiVjCBQArO4vtVD+y87UX91ftsP07sqF1jJ0ZBAt5GSchwvj29eP2aueipmDRZDK9DpR1qWifRvu0ci89iGpMJBDwe2nFxi7LCkHXNLAsnHhMB914bMT58rMGC+WnMOH6AlikzKXeYtXh7gdSg4p9bOUz6FO3DJ9TenrTocCgMeHKy0Upjf1Hx+uzpDpj9x0s5F0xkXvpgIp6BrTIUhievX5C/BDjYJMj7RD4I2tMWNIR/fw2J3hYQjuWuBIzQZFp32m560OvRKiNimkmOktzyZiIeozj+nxo3Jupl+vrrVMXB56V3+6a+qvV9ftML0GsnkmWMTZF9PjO3OCMH1ZpncjpZ9E1mnugmKHMsS99CJkOTrEih0fVWPjmEwf9Zk4F1uHHQj98PFeemvA7PTmx13o0GW0okKWkR6KHauHUj9z+uydK9rjroUbC6UHCY0IBQDPTzdaKExv6j8/3bTG9JQSsZ4cJC2D254BONOHqi2kg+wQb493oFnEXms1wGP6yTezrRJfvdfhm5mhtL2lZSKnwFyd1FGUGb3bpGpcIVjvYUWt8XJI0SkShWWKUV2hNsMmcb0sy17N6OyIwSR/5vSZMsqbVYpOtMcbVxIUALyub7VQmN7Uf13fNsX0oTW22uaRYbLUPElnwH0ekLSvEOWkhvfS21MJvPfpocRzemJppRYMu8C8CjnchvRHtwlurdTGCb2TEkJONhCdzGqnHz741DXa0btJPjPqJFpjqfVW1Wer4Y4t1YM4Q4QCgM3LnRYK05v6m5e7dpieXrL0l2RrHFgM5DO9WevIqKiOe+ntqQT2Z+9Vuffp3ZB55ylPn26NMjappHNO8CQPQ2iB6fNLnXf44J7kt4nrhVzSTyTKqFLRLetzjR4eFABsX++1UJje1N++3jfF9F5KMy8nuB+KQfQpPbWBfCKPcv4iR0ZSY3GwX73HOylMTyktXqkwRtFLnTeXt2Cic7mXZTcO/h+PuMOldLyZ50WBGEfmQrJaSgfpifpcxLL6SW/FLZf1ebYe9RnHdCgA2G1XWihMb+rvtqt2mJ6O7r6Cw+Kbo8PreGW7Pfh+8FZYpdCSwH713ry0OilMv3TcguNxlLUYIwpBX1AAsN89aaEwvam/3z0J08+A4g43wtypWPCbcwSLY4y1GCMKQV9QAHDYP2uhML2pf9g/C9PPgLION/U0PQnC9OeMMdZijCgEfUEBwPtho4XyzTmm/vthI0w/A7pzuBKE6c8ZY6zFGFEI+oICgI/3Ny0Upjf1P97fhOlnQHcOV4Iw/TljjLUYIwpBX1AA8P1jnyPC9DOgO4crod7P1nlxlMy3hDHWYowoBH1BfrW2D3Tn8DCQzLeDMdZijCgEfUGVevZzIRAIBAKBoD0UY/rQx/XbxMXFxdIupKE7h4eBZL4djLEWY0Qh6AslX73vCN1ttu4croRSD0zpj18l8+1gjLWoFMX0f7P5OjO40Rp4PvcVqQKAh29fc6Qpptf/KW51WmrWZjMVXAtEm1WBnw5sZ/oq1tPp9GXez96fjMyzCyOaZF6BscvSHeI1RRxYw8MQzF3AcLiUDjFdIWQePnhWzQauY9lRn+F1zwviEEYOo/Uzp8/eudxRIZ/zV5mSMQQKAFb3l1oo/2Vn6q/uL9theu/KebMTOjJcC3SbVXHh+/Z117EkIPXaLFKZ3kyXe0lnenZhRJPMKzB2WSI60RlDk5b1EIH5qAufnTgXQyd/3+UcPkRPEJuUubzueUEsCUYOKfWzlM+hTtwyfU3p606HAoDHhystFKY39R8frhpn+pMvNZlM77VZFUlnHBEzh1AE7Of0ivVbdqdEpkfaIfDGlpox1IkffEmnM8PDENy1wMHOBqLTPtPzVocyimiTUmCZ3vJsIhaiPvOY3ruPEJ26TL9eXWuZuDykPd019der63aYXiN6bFnE2R3TF5n9fJhecX/L7hR+rZV+ElmnuQuKHcoQ99KLpIPYCiQUF26wBtPjs9PnqpQxBPTDx3vprQGz05sft3hCl9GKCllGeih2rJ7UfVHbZ+9c0R53LdxYeD2pUADw/HSjhcL0pv7z001rTO9dZqvHenKQtAwhm1URfbfYvaSoITohO8uiCNNPiI5ymZ5SDEg+vRHlFBil1PNHebdJ1bhCMN/DoljjZYOiUyQKyxSjukJthk3ielmWvZrR2RGDSf7M6TNllDerFB1GTyoUALyub7VQmN7Uf13fNsX03iy4naG3vdkboDbw5/TuJV7roVHexsyR4mAwvfpM6or7nB7JOeP0YevjCjV4i7JN8FlKbZzQOykh8LIR1cncEfTDB5+6Rjt6N8lnRp1Eayy13qr6jByVtXtSoQBg83KnhcL0pv7m5a4dpqcUwQT6S7I1DiwGQnzj7fRuXbPW8VELhhnFUkxPPw1LnVA8DuNxG3GVc07w1Lm8aIHp83cE7/DBPclvE9cLuaSzJmVUqeiW9bktpt++3muhML2pv329b4rpXUpzGe7k+1AMok/pqY18pqePQsp3cSzI9JTS4pUKYxS91KNznWgFQ5nLvSy7cfD3sHCHS+l4M8+LAjGOzIVktZQO0hP1uYhl9fPkKW65rM/L9iRBAcBuu9JCYXpTf7ddtcP0dHT3FRwW35i3okWMq7nFZLVzyqs4MpnejDo6UL45pzWMsRZjRCHoCwoA9rsnLRSmN/X3uydh+hnQncOVsOA35wgWxxhrMUYUgr6gAOCwf9ZCYXpT/7B/FqafAd05XAnC9OeMMdZijCgEfUEBwPtho4XyzTmm/vthI0w/A7pzuBKE6c8ZY6zFGFEI+oICgI/3Ny0Upjf1P97fhOlnQHcOV4Iw/TljjLUYIwpBX1AA8P1jnyPC9DOgO4crod7P1nlxksy3hDHWYowoBH1BfrW2D3Tn8DCQzLeDMdZijCgEfUGVevZzIagJJVgOSy++QCAQZKEY0y/9kCUNF709rF6a7M4aSy++4Ae627ZejBGFoC+UfPX+L3/7ey8ybbbF3aDLRDn/97//nyluj+4PwSf4DmkAACAASURBVKuPW/OaxTXrSakHpkRopl+8AET+0uG2nTOKqVbzdWZwozXh+dxXpOr4+C/50g7TaypCev7ibDZc32th5jV2+XW69JKu2Ym0Ldr2PpJogd0tpi/y2JT4+NVkenZhRE8EXoGxy9Id4jVFHFjDw5CY25bhcCkdYrooUfwl/fDBs2o2cB3LjrXZ6fkhDmHkMFo/c/rsncsdFfI5f5UpGcNC/uf6X02h/JedNeSf639thOndlQutZejIIFrIyTg7NEXg7ySmDzW8gt9th+mV8y33E6xLRfs23EnzdDqxCwM5FEIlRykwdlkiOtEZQ5OW9RARvW2js+dnIxp4NGPRKCzjlBojeoLYpMxFzw+xJBg5pNTPUj5H0+61TF9T+rrTRf3z5d9MITH95yH/fPm3c2N6drpzQlPok2/rMoQQ04fU+mL6yXkv6yvnh20U4RduJoN0pmcUCW9sqRlDnfjBl3Q6F9w4Fz9//YG+a4rr5MdSm+l5q0MZRbRJKbBMb3k2c3xO3TWhrPJWOb/q1D+2/27KxOWhd/Wnu9aQf2z/vRGmR3Jh9VhPDpI2W066cyIyadglZpOhVd6r92YjhDaZPsTu+Uzvrjv9JJqMuOuoQbFDGUIsS68OPlD5tonlCWIQcThJTKbHZ8/MRn7GolGEsuo17i0Gt8c0iOu4drzV5Q0zZBnpodixelL3RW2fvXNFe9y1cGOh9CChEUX9Y/cfppCY/vOQf+z+oymm9y6z1WM9OUhahsyMs4NSKZ/Io7eRBmWulpk+RPkTcDtepieePtaq4QWTU2CUUs8f5d0mVeMKid620dlzslEqz9EoQunNbzNsEtfL5bDQLdxOdFSpbJTymTLKm1WKDm8tkkT9evhPUyhMbw359fCf7TA9cU+aR4bGbEnnxaWE6VlMrzJ+n35Ku/XeMF4MqQXDLjCvQg3eomyTgnEh4r56H/WckY2oTubepx8++NQ12tG7ST4z6iRaY6n1VtVnq+GOLdWDOEMU9esff2MKiek/D/n1j79phOnpR1jo46/EpOfnnRGa8r1ub8Jk5SQdL9MjRixTLTO9ChO/ewthery0UtupdiilTi9L+jYJqdWLC5cWmD7HfzMKSlbLVh3eJq4XcukGkuSJ1SgV3bI+1+jhiYLvvzWFwvTWEPj+23aY3oS3ZxL3QzHmmlnKlJ55QpPn9Oz36fOZ3i2kUqXCGEX0hzLXX2jcT5nLvSy7ccx3uF3LlKzm63gzz4simlXiKhfXiVZLvh3csvp8ehe0XNbn2XrUZzCqTsGffmcKiek/D4E//a4RpqdLd1/BMS1wEjdTHg2Y1YMPQaZoh+l1LNal7rQu6Uy/eAGI/KXDbTtwFCJ9iYI//94UEtN/HgJ//r0wffV18pGx+TeJ6XF275fpy0KYvjXpbtsOHIVIX6J++esfTKEwvTXkl7/+QZi++jrRwGNo87UBVx8xLkwvMqd0t20HjkKkL1G//O2/TKF8c4415Je//ZcwffV1aoZrhelFlpLutu3AUYj0Jerv/7MyhcL01pC//89KmL76OgnTC9OfvXS3bQeOQqQvUX//302+CNNXXydh+p9MPyeE6ZuS7rbtwFGI9CXyq7V9CPF9ekEN9FUqA0t323bgKET6ElXq2c+FoCaWJruzxtKLLxAIBFkoxvShj+u3iYuLi6VdSEN3Dg8DyXw7GGMtxohC0BdKvnrfEbrbbN05XAmlHpjSH79K5tvBGGtRKYrp9ad8nRncaA08n/uKVAHAw7evOdIU0+tXXJGek7PZcH2vhZnXGD8d2M70Vayn0+nLvJ+9PxmZZxdGNMm8AmOXpTvEa4o4sIaHIZi7gOFwKR1iukLIPHzwrJoNXMeyoz7D654XxCGMHEbrZ06fvXO5o0I+568yJWMIFACs7i+1UP7LztRf3V+2w/TuyoXWMnRkEC3kZJyHC9/vX7mOJQGp12aRyvRmutxLOtOzCyOaZF6BscsS0YnOGJq0rIcIzEdd+OzEuRg6+fsu5/AheoLYpMzldc8LYkkwckipn6V8DnXilulrSl93OhQAPD5caaEwvan/+HDVMtOH7mYyvdd+VSSdcUTMHEIRsJ/TK+eHbRThF25OiUyPtEPgjS01Y6gTP/iSTmeGhyG4a4GDnQ1Ep32m560OZRTRJqXAMr3l2UQsRH3mMT1OQzxe5zP9enWtZeLykPZ019Rfr67bYXoNdwGsHos4u2P6IrOfD9Mr3w/cJTG9BlIqobZ1mrug2KEMcS+9SDqIrUBCceEGazA9Pjt9rkoZQ0A/fLyX3howO735cYsndBmtqJBlpIdix+pJ3Re1ffbOFe1x18KNhdLjjSIJCgCen260UJje1H9+ummN6UO5MPutJwdJy4DPUgnRd4vdS4oaohOysyyKMP2E6CiX6SnFgOTTG1FOgbk6NUZ5t0nVuEIw38OiWONlg6JTJArLFKO6Qm2GTeJ6WZa9mtHZEYNJ/szpM2WUN6sUnWiPN5wkKAB4Xd9qoTC9qf+6vm2K6ZEsmLdCb3uzN0Bt4M/p3Uu81kOjvI2ZI8XBYHr1mdQV9zk9knPG6cPWxxVq8BZlm+CzlNo4oXdSQuBlI6qTuSPohw8+dY129G6Sz4w6idZYar1V9Rk5Ksv2hCKlQwHA5uVOC4XpTf3Ny107TE8vWfpLsjUOLAZCfOPt9ObBrHV81IJhRrEU09NLq9QJxeMwHrcRVznnBE+dy4sWmD5/R/AOH9yT/DZxvZBLOmtSRpWKblmf5+F+ChQAbF/vtVCY3tTfvt43xfQupbkMd/J9KAbRp/TURj7T00ch5bs4FmR6SmnxSoUxil7q0blOtIKhzOVelt04+HtYuMOldLyZ50WBGEfmQrJaSgfpifpcxLL6efIUt1zW52V7kqAAYLddaaEwvam/267aYXo6uvsKDotvzFvRIsbV3GKy2jnlVRyZTG9GHR0o35zTGsZYizGiEPQFBQD73ZMWCtOb+vvdkzD9DOjO4UpY8JtzBItjjLUYIwpBX1AAcNg/a6Ewval/2D8L08+A7hyuBGH6c8YYazFGFIK+oADg/bDRQvnmHFP//bARpp8B3TlcCcL054wx1mKMKAR9QQHAx/ubFgrTm/of72/C9DOgO4crQZj+nDHGWowRhaAvKAD4/rHPEWH6GdCdw5VQ72frvDhJ5lvCGGsxRhSCviC/WtsHunN4GEjm28EYazFGFIK+oEo9+7kQCAQCgUDQHoox/dIPWdJw0dvD6u4cHgaS+XYwxlqMEYWgL5R89f7YD6bNtrQXCejO4Uoo9cCUiKNkviWMsRaVopi+DypfZwY3WgPP574iVQDw8O1rjjTF9Pob0Nx+89LabOZd14LX5sxrPMYZl48v8372/mhknl0Y0ROBV2DssnSHhHYNZWAND0MwdwHD4VI6xHSFkHn44Fk1G7iOZUd9htc9L4hDGDmM1s+cPnvnckeFfM5fZUrGECgAWN1faqH8l52pv7q/bIfpQyvnJih0ZLgWvDZzMs7Dxc9vw7UcCxV6Zlk0i1Sm13mwLhXt23CPnzM/IakwkEPB7acXGLssEZ3ojKFJy3qIwHzUFfU5MxshnVCbjpzDh+gJYpMyl3mLV4e4HUoOKfWzlM+hTtwyfU3p606HAoDHhystFKY39R8frs6Q6Y/cdLMRYnq3saCTMyCJ6dXnb7wPNQoyPdIOgTe21IyhTvzgSzqdGR6G4K4FDnY2EJ32mZ63OpRRRJuUAsv0lmcTsRD1mcf03n2E6FDOcD7Tr1fXWiYuD72rP9019der63aYXiOacevJwahMPx7Yr95nMr12ACmVUNs6zV1Q7FCGuJdeJB3EViChuHCDNZgen50+V6WMIaAfPt5Lbw2Ynd78uMUTuoxWVMgy0kOxY/Wk7ovaPnvniva4a+HGQunxRpEEBQDPTzdaKExv6j8/3bTG9N40WQmynhwkLYPXYG3gTO+ttjndmw0Mpp+yYV2qxFfvp9mJp4/ZDlVgkp0QvCda8VHebVI1rhD0LojOTp+rXp5DoB8+7DbDJnG9XA4L3cLtREeVykYpnymjvFml6ER7vOEkQQHA6/pWC4XpTf3X9W1TTO+usQndbx4Z5l32BqgN/HNh3iEzezgPFnxOHzo+GO1UO9GB9FFenShfRrcJPkupjRN6JwXxPGqToZO5s+iHDz51jXb0bpLPjDqJ1lhqvVX12WpQ6IPXE4qUDgUAm5c7LRSmN/U3L3ftMD2SAusW/SXZGgcWA6FX/HBPZnZyBizF9PTTsNQJxeMwHrcR6yTnBE+dy4sWmD5/T/EOH9yT/DZxvSiPPKJ1QhlVKrplfZ6H+ylQALB9vddCYXpTf/t63xTTWw/frH7d434oxlyz6HC3pzboTF/2VGoNC34izy2tUqXCGEX0hzLXkcb9lLncy7IbJ+mVrUo63szzokCMI3MhWS2lg/REfS5iWf085YpbLuvzsj1JUACw2660UJje1N9tV+0wPR3d/Xs68imeUEGwa6JlLPVfdkvHLTgeR1mLMaIQ9AUFAPvdkxYK05v6+92TMP0M6M7hSljwm3MEi2OMtRgjCkFfUABw2D9roTC9qX/YPwvTz4DuHK4EYfpzxhhrMUYUgr6gAOD9sNFC+eYcU//9sBGmnwHdOVwJwvTnjDHWYowoBH1BAcDH+5sWCtOb+h/vb8L0M6A7hytBmP6cMcZajBGFoC8oAPj+sc8RYfoZ0J3DlVDvZ+u8OErmW8IYazFGFIK+IL9a2we6c3gYSObbwRhrMUYUgr6gSj37uRAIBAKBQNAeijF96OP6beLi4mJpF9LQncPDQDLfDsZYizGiEPSFkq/ed4TuNlt3DldCqQem9Mevkvl2MMZaVIpi+j6ofJ0Z3GgNPJ/7ilQBwMO3rznSFNPrb0CzLq1VsTabectVdnusITMgejp4PbSiqOLZvPgy72fvT0bm2YURPRF4BcYuS2+dEHnCHVjDwxDMXcBwuJQOMV0hZB4+eFbNBq5j2VGf4XXPC+IQRg6j9TOnz9653FEhn/NXmZIxBAoAVveXWij/ZWfqr+4v22F6d+VCeQkdGbgFa1cU85sAhG8sx6KNHBDrz1voRRyIMr1yvuZW+X6y1lXDmZ5dGNH88wqMXZaITnTG0KRlPURg7gJ8duJcDJ1Qm46cw4foCWKTMpfXPS+IJcHIIaV+lvI51Ilbpq8pfd3pUADw+HClhcL0pv7jw9UZMj1iuRJCfBNypoZ7xOQUPxlN4Ew/TR3tCT0myGd6Rry8saVmDHXiB1/S6czwMAR3LXCws4HotM/0vNWhjCLapBRYprc8m4iFqM88psdPZh6v85l+vbrWMnF5SHu6a+qvV9ftML2GxToW95ycJwfC9BTknzu1md7L30WY3g2BHq91mrug2KEMcS+9SDqIrUBCceEGS9WAuQvw2elzVcoYAvrh47301oDZ6c2PWzyhy2hFhSwjPRQ7Vk/qvqjts3euaI+7Fm4slB5vFElQAPD8dKOFwvSm/vPTTWtMTykRiziTlsFtzwCE6d0SDPVYNkNlGnUmdTd62zwUYfoJuB0v0zPi9ebKRE6uvGtafJR3m1SNKwS9C6Kz0+eql+cQ6IcPu82wSVwvy3LoRIraiY4qlY1SPlNGebNK0Yn2eMNJggKA1/WtFgrTm/qv69ummB7JgnnLPDI0TilJzyetJOQ/p8er39vwouAOZGDB5/ShBGbGzs6VV6EGb1G2CT5LqRrAdwHuQ0GdzDKmHz741DXa0btJPjPqJFpjqfVW1Wer4Y4t1ROKlA4FAJuXOy0Upjf1Ny937TA9vWTpL8nWOLAYqMf0Zo+5H7woeO7wsBTT00ur1AmF54pijT6WuC45J3jqXF60wPT5Ncw7fHBP8tvE9aKcANE6oYwqFd2yPs/D/RQoANi+3muhML2pv329b4rpXbryspf7oRhEn9JTG3M+pw+h7LnDw4JMTyktXqkwRtFLPTrXiVw/0bncy7IbB/+PR9zhUjrezPOiQIwjcyFZLaWD9ER9LmJZ/aS34pbL+rxsTxIUAOy2Ky0Upjf1d9tVO0xPR3dfwUH5r263jpHK1p1uT6iY1GdE/SGaTQLls/fK92911qVivU8vWBZjrMUYUQj6ggKA/e5JC4XpTf397kmYfgZ053AlLPjNOYLFMcZajBGFoC8oADjsn7VQmN7UP+yfhelnQHcOV4Iw/TljjLUYIwpBX1AA8H7YaKF8c46p/37YCNPPgO4crgRh+nPGGGsxRhSCvqAA4OP9TQuF6U39j/c3YfoZ0J3DlSBMf84YYy3GiELQFxQAfP/Y54gw/QzozuFKqPezdV6cJPMtYYy1GCMKQV+QX63tA905PAwk8+1gjLUYIwpBX1Clnv1cCAQCgUAgaA/FmH7phyxpuOjtYXV3Dg8DyXw7GGMtxohC0BdKvnp/7AfTZlvaiwR053AllHpgSsRRMt8SxliLSlFM3weVrzODG62B53NfkSoAePj2NUeaYnr9DWhup9ljbTbzrmshZLOw6ygWPOOaKugv8372/mhknl0Y0QTyCoxdlt7dQeQJd2AND0MwdwHD4VI6xHSFkHn44Fk1G7iOZUd9htc9L4hDGDmM1s+cPnvnckeFfM5fZUrGECgAWN1faqH8l52pv7q/bIfpvSvnXZXQkeFaCNlkZ5yHC+Pb14/Zq56KmYNFkMr0OlHWpaJ9G+7RyLz2IakwkEPB7acXGLssEZ3ojPj+KuUhAvNRV9TnzGyEdEJtOnIOH6IniE3KXOYtXh3idig5pNTPUj6HOnHL9DWlrzsdCgAeH660UJje1H98uGqZ6UNJyWR6xHIlJJ1x0bupQAq6xnQIkpheff4C/FCjINMj7RB4Y0vNGOrED76k05nhYQjuWuBgZwPRaZ/peatDGUW0SSmwTG95NhELUZ95TI8flTxe5zP9enWtZeLy0Lv6011Tf726bofpNdyHUVZ2LOLsi+nxnTlBmL4s07uR0k8i6zR3QbFDGeJeepF0EFuBhOLCDZbaOCbT47PT56qUMQT0w8d76a0Bs9ObH7d4QpfRigpZRnoodqye1H1R22fvXNEedy3cWCg93iiSoADg+elGC4XpTf3np5vWmD6UGrPfenKQtAxuewbgTB+qNiQVocr29ngHmkXstVYDPKaffDPbKvHVex2+mRlK21taJnIKzNWpMcq7TarGFYL1HlbUGi8bFJ0iUVimGNUVajNsEtfLsuzVjM6OGEzyZ06fKaO8WaXoRHu84SRBAcDr+lYLhelN/df1bVNMH1pjq20eGSZLsTdAbbjPA5L2FaKc1PBeensqgfc+PZR4Tk8srdSCYReYV6EGb1G2CT5LqY0TeicF8Txqk6GTWe30wwefukY7ejfJZ0adRGsstd6q+mw13LGlekKR0qEAYPNyp4XC9Kb+5uWuHaanlyz9JdkaBxYD+Uxv1joyKqrjXnp7KoH92XtV7n16N2TeecrTp1ujjyUuX84JnjqXFy0wfX6p8w4f3JP8NnG9kEv6iUQZVSq6ZX2eh/spUACwfb3XQmF6U3/7et8U03spzbyc4H4oBtGn9NQG8ok8yvmLHBlJjcXBfvUe76QwPaW0eKXCGEUv9ehcRxr3U+ZyL8tuHPw/HnGHS+l4M8+LAjGOzIVktZQO0hP1uYhl9ZPeilsu6/OyPUlQALDbrrRQmN7U321X7TA9Hd19BYfFN0eH1/HKdnvw/eCqsSusLNiv3puXVieF6ZeOW3A8jrIWY0Qh6AsKAPa7Jy0Upjf197snYfoZUNzhRpg7FQt+c45gcYyxFmNEIegLCgAO+2ctFKY39Q/7Z2H6GVDW4aaepidBmP6cMcZajBGFoC8oAHg/bLRQvjnH1H8/bITpZ0B3DleCMP05Y4y1GCMKQV9QAPDx/qaFwvSm/sf7mzD9DOjO4UoQpj9njLEWY0Qh6AsKAL5/7HNEmH4GdOdwJdT72TovjpL5ljDGWowRhaAvyK/W9oHuHB4Gkvl2MMZajBGFoC+oUs9+LgQCgUAgELSHYkwf+rh+m7i4uFjahTR05/AwkMy3gzHWYowoBH2h5Kv3HaG7zdadw5VQ6oEp/fGrZL4djLEWlaKY/m82X2cGN1oDz+e+IlUA8PDta440xfT6P8XdHrPT2mxefaTHGjIDFjzjmiroL/N+9v5kZJ5dGNEE8gqMXZbuEK8p4sAaHoZg7gKGw6V0iOkKIfPwwbNqNnAdy476DK97XhCHMHIYrZ85ffbO5Y4K+Zy/ypSMIVAAsLq/1EL5LztTf3V/2Q7T4ytn9oSODNeC12ZOxnm4ML4N95S96qmYOVgEqUyvE2VdKtq34Z6MzGsfkgoDORTcfnqBscsS0YnOGJq0rIcIzEdd+OzEuRg6+CFDQc7hQ/QEsUmZy+ueF8SSYOSQUj9L+RzqxC3T15S+7nQoAHh8uNJCYXpT//Hhqgumty4zmd41WBtJZ1z0birwZBafDkES0yv0h20U4RduTolMj7RD4I0tNWOoEz/4kk5nhochuGuBg50NRKd9puetDmUU0SalwDK95dlELER95jE9flTyeJ3P9OvVtZaJy0Pa011Tf726bofpNaLZsYizL6bHd6ZWKzi7ML0bKf0ksk5zFxQ7lCHupRdJB7EVSCgu3GCpjWMyPT47fa5KGUNAP3y8l94aMDu9+XGLJ3QZraiQZaSHYsfqSd0XtX32zhXtcdfCjYXS440iCQoAnp9utFCY3tR/frppjem9y2z1WE8OkpYhZLMqcKYPVVtIB9kh3h7vQLOIvdZqgMf0k29mWyW+eq/DT217S8tEToFRSj1/lHebVI0rBOs9rKg1XjYoOkWisEwxqivUZtgkrpdl2asZnR0xmOTPnD5TRnmzStGJ9njDSYICgNf1rRYK05v6r+vbppjemwW30zwyTJZib4DacJ8HJO0rRDmp4b309lQC7316KPGcHkkC4/Rh6+MKNXiLsk3wWUptnNA7KSHwshHVyax2+uGDT12jHb2b5DOjTqI1llpvVX22Gu7YUj2hSOlQALB5udNCYXpTf/Ny1w7TU4pgAv0l2RoHFgP5TG/WOjIqquNeensqgf3Ze1XufXo3ZN55ytOnW6OPJS5fzgmeOpcXLTB9fqnzDh/ck/w2cb2QS/qJRBlVKrplfZ6H+ylQALB9vddCYXpTf/t63xTTu5R2ijG9S2/u8GhPbSCfyKOcv8iRkdRYHOxX7/FOCtO7pVWqVBijiP5Q5jrRuJ8yl3tZduPg//GIO1xKx5t5XhSIcWQuJKuldJCeqM9FLKuf9Fbcclmfl+1JggKA3XalhcL0pv5uu2qH6eno7is4LL45ObyOV7bbg+8HV41dYWXBfvXevLQ6KUwvaAFjrMUYUQj6ggKA/e5JC4XpTf397kmYfgYUd7gR5k7Fgt+cI1gcY6zFGFEI+oICgMP+WQuF6U39w/5ZmH4GlHW4qafpSRCmP2eMsRZjRCHoCwoA3g8bLZRvzjH13w8bYfoZ0J3DlSBMf84YYy3GiELQFxQAfLy/aaEwvan/8f4mTD8DunO4EoTpzxljrMUYUQj6ggKA7x/7HBGmnwHdOVwJ9X62zouTZL4ljLEWY0Qh6Avyq7V9oDuHh4Fkvh2MsRZjRCHoC6rUs58LgUAgEAgE7aEY0y/9kCUNF709rO7O4WEgmW8HY6zFGFEI+kLJV++P/WDabEt7kYDuHK6EUg9MiThK5lvCGGtRKYrp/2bzdWZwozXwfO4rUgUAD9++5khTTK//UxzpOTqbDdf3Wph5jRc845oq6C/zfvb+aGSeXRjRBPIKjF2W7hCvKeLAGh6GYO4ChsOldIjpCiHz8MGzajZwHcuO+gyve14QhzByGK2fOX32zuWOCvmcv8qUjCFQALC6v9RC+S87U391f9kO07srF1rL0JFBtJCTcR4ujG/DPWaveipmDhZBKtPrRFmXivZtuEcj89qHpMJADgW3n15g7LJEdKIzhiYt6yEC81FX1OfMbIR0Qm06cg4foieITcpc5i1eHeJ2KDmk1M9SPoc6ccv0NaWvOx0KAB4frrRQmN7Uf3y4OkOmP3LTzUbSGRe9mwqkoGtMhyCJ6RX6wzaK8As3x0SmR9oh8MaWmjHUiR98Saczw8MQ3LXAwc4GotM+0/NWhzKKaJNSYJne8mwiFqI+85gePyrnZvr16lrLxOWhd/Wnu6b+enXdDtNrWHlxH+VZxNkX0+M7c4IwfVmmdyOln0TWae6CYocyxL30IukgtgIJxYUbLLVxTKbHZ6fPVSljCOiHj/fSWwNmpzc/bvGELqMVFbKM9FDsWD2p+6K2z965oj3uWrix8HpSoQDg+elGC4XpTf3np5vWmJ5SItaTg6RlcNszAGf6ULWFdJAd4u3xDjSL2GutBnhMP/lmtlXiq/c6fDMzlLa3tEzkFJirU2OUd5tUjSsE6z2sqDVeNig6RaKwTDGqK9Rm2CSul2XZqxmdHTGY5M+cPlNGebNK0WH0pEIBwOv6VguF6U391/VtU0wfWmOrbR4ZJkuxN0BtuM8DkvYVopzU8F56eyqB9z49lHhOTyyt1IJhF5hXoQZvUbYJPkupjRN6JwXxPGqToZNZ7fTDB5+6Rjt6N8lnRp1Eayy13qr6bDXcsfV6UqEAYPNyp4XC9Kb+5uWuHaanlyz9JdkaBxYD+Uxv1joyKqrjXnp7KoH92XtV7n16N2TeecrTp1ujjyUuX84JnjqXFy0wfX6p8w4f3JP8NnG9kEv6iUQZVSq6ZX1ui+m3r/daKExv6m9f75tiei+lmZcT3A/FIPqUntpAPpFHOX+RIyOpsTjYr97jnRSmp5QWr1QYo+ilHp3rSON+ylzuZdmNg//HI+5wKR1v5nlRIMaRuZCsltJBeqI+F7GsftJbcctlfV62JwkKAHbblRYK05v6u+2qHaano7uv4LD45ujwOl7Zbg++H1w1doWVBfvVe/PS6qQw/dJxC47HTRfyzwAAA1NJREFUUdZijCgEfUEBwH73pIXC9Kb+fvckTD8DijvcCHOnYsFvzhEsjjHWYowoBH1BAcBh/6yFwvSm/mH/LEw/A8o63NTT9CQI058zxliLMaIQ9AUFAO+HjRbKN+eY+u+HjTD9DOjO4UoQpj9njLEWY0Qh6AsKAD7e37RQmN7U/3h/E6afAd05XAnC9OeMMdZijCgEfUEBwPePfY4I08+A7hyuhHo/W+fFUTLfEsZYizGiEPQF+dXaPtCdw8NAMt8OxliLMaIQ9AVV6tnPhUAgEAgEgvZQjOlDH9dPhVKqlCnE4MXFxSLzsuE6LJgH3ZXKwBhjLcaIQtAXSr56X8CbOgXqmrU222zzsiGnw4RSD0zpj1+7K5WBMcZajBGFoC8oAHj49jVHajD99N/eJ+dbSM27VqfZHzKrEdpstedlQ06HCV/m/ez9qcNSGRhjrMUYUQj6ggKA1f1ljpRieqs0zRKPNkJGQv3mZptzXjbkdJiQyvQ6UvfS7CcyfRelMjDGWIsxohD0BQUAjw9XOVKP6TWHWQq1mb7evGzI6TAhiekV+sM2OM0Tmb7BUhkYY6zFGFEI+oICgPXqOiRKKeTuJML09HnZ6M7hSijF9FGaF6ZvEGOsxRhRCPqCAoDnpxtXlFLW35DUY/qTUfqnokUffYpcaV425HSYUITpKTRPZPpTe6UyMMZYizGiEPQFBQCv61uvqJ8IKUwiTE+fl43uHK6E1p7Tn84m8y1gjLUYIwpBX1AAsHm584pm+pDCJKWY/vS5NCm17urjFjSQj7JXnZcNOR0mLPs+/amHUhkYY6zFGFEI+oICgO3rvStKKetvSGowvX6QcXLq2NVBYJnVwD/KXm9eNuR0mNAO0zdbKgNjjLUYIwpBX1AAsNuuQqKUQu5OUpDpTxUK1Guwuy+ikdNhwrL/ZTeh8VIZGGOsxRhRCPqCAoD97ilHyjL9POjuy2XldJiw+DfnCBbEGGsxRhSCvqAA4LB/zhFh+hnQncOVIEx/zhhjLcaIQtAXFAC8HzY5Ikw/A7pzuBKE6c8ZY6zFGFEI+oICgI/3txwRpp8B3TlcCcL054wx1mKMKAR9QQHA9499jgjTz4DuHK6Eej9b58VJMt8SxliLMaIQ9IX/D5C40MJh8+NLAAAAAElFTkSuQmCC" alt="" />

要求:查询type为4001,以content分组,本计算不重复的pcInfoId

MySQL语句:

SELECT COUNT(DISTINCT pcInfoId) AS COUNT,content,TIME FROM vrv_paw_reportlog WHERE TYPE='' GROUP BY content

对应的HQL语句:

 SELECT  new map(COUNT(distinct this.pcInfo.id) AS count,this.content as content,this.time as time)
From com.vrv.paw.domain.ReportLog this
Where this.type=4001
Group by this.content

注:

使用关键字as给“被选择了的表达式”指派别名:

select max(bodyWeight) as max, min(bodyWeight) as min, count(*) as n
from Cat cat

这种做法在与子句select new map一起使用时最有用:

select new map( max(bodyWeight) as max, min(bodyWeight) as min, count(*) as n )
from Cat cat

该查询返回了一个Map的对象,内容是别名与被选择的值组成的名-值映射

这样可以方便产生JSON字符

我犯的一个错误:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAzEAAABiCAIAAADvBsoTAAAWWElEQVR4nO2dy68k113He501O/4MGqVVkhFixtmBnFiRkEjf8SKUZJOIDYkdCYlL24PEhpTXM8ligI4dNgjN1AaE8BWPu5lIsMqdYoEXGV9CnPheTEymH5VFvc67TlVX9+nH56Of7OnqU+f8zq/Orfr275yqGuUAAAAAEJpRaAcAAAAAAE0GAAAAsAegyQAAAADCM7q+zjHsuO18FN4HDMMwDHMbmgw7fkOTYRiGYftvaDLs+A1NhmEYhu2/ocmw4zejJvtkOsrHycehfTtGyz4dj/JpGtoNDMOwAzM0GXb8ZtBkl8lihG7Yln0yHeWj0Wfz8J5gGIYdkLVostl4VDKNp+Pk+jq/nEUjhXFyfZ1fz2NhUzyvarCWv86vr/P5tNl4OYumc1P5UTS7DB+p3dhsLHVWj4++XdkynmVNDMdJsX08y6RjMU4846z4U1k6lY9j4UDRyoY2VD2iaZos+3Q8ykfRp4aulVbEZ2pXFdvwszUyEn6CUtzL0Z3Njos+HtLPRloa8jIZy2PGaWnjuLaXfl46dNvD8YYdkAUfP4c+Pgfwv9v5zWouTXY5i2ov59PmzChuV/yYTw2XcFv5+bS5rtRDqi48n5YjzCILjtHmsXihNcbHsL2JpxiodCpsH48rlVzF3yvOsj+ypZtcC2fjRrVvw5T6VU2mJcmM/ogieH9M+mtqtYFOEx6mjodPpgbVWw+2Tv4rZxXbeSmgdR3PBzTeBunvtus5tTiEGj8cL7d1Pr+ZzFeTmbYbrspOTSaXv0zGzh/6G3avFDHTOnsnHIzLZKz9BC9/eVculdkF2+m+qGEcTYuayxxh1YSQMqwDOBuPRqNoNqu/MialhC7b4qNdZetAOTTZbFapK/vuukn+yHGbzpv665SbPlqafMY4KtsVgy8nb4z1uI6jnC8sNaWpflWTzeNmZs3pz3RWf2tI/Xr112Lu8WDol/rX1B4fNa8m+NP4OWo/SVn7axkPhiDbR29r09N5fj2PlS53/UVri6ceB/XHj5xjNsTZPn7MFmi89YxDp/6azquDxe3afF49uTiEGj+dztvu66MpPls/7rvxf4jfwN5zl0JL4hSYNtbNmsxQXj7P6ra55LycReKfliCPGiebPJOmgYx9UY5xccEoWml+pszT+u9BlDWzsXJclcthOhW3WOJjuCBVJV2a7LL6toMmk/25TqeNbjDMXeqOOfIZjt8rxnqMx1HLI4rnVlee7ONZpMgF2+/Ouk5371r7azTbeHD0q1N8ympNE39NmXnsmWfS2m0ZD4UmW6hjWNyr3arjogo+43nJZrZ42uIg5RuEP0NHnIfKc2x1vPWIQ6f+ms+rA8bNcl49uTgEGj9uPw1nHsv10RafbR/3nfjf7fxmNN81/srYGiBPthNNZji3anq5/jspDthsXBzdtrm5+mpXTfA1zclNiJpM7JGaalZU2tCarHTYX5O5/dHqMWUvhCVBsgDtqslM10jXARpKkxmvzT36a3HSOB5aBp53fMyHqfNvD1u7rQ2ZNZmWfHWYMHVuG6Ue53RLPO1xcGgyW5yHn3safrwNFgez//bz6mBxs5xXTy4Ogc5Xbj+tvwaV66M9Pls+7jvyv8P5zWL+9102WRPH3IF4fq+HiLl8W5ZvW5rMfs2bT6PZZTot1q/MW6ZW7ZpMUsqiD/oklEuT2eLjOXcprdsTTi6zXWoyweR8TFhNpk+rDXSOs/bX4qRxPByVJtNvvfQ/Z/nd06Bkc00FjlaTSdHemTa1+G8dtwPFzXpePbE4hBo/LX76aprOC5GHOu478n+rmkzOwglD1pF39dFkdXn5Tod0Kk+lb02T2e+wmMfTaTyeZdfzeDxuWy/p0NH1Mavzn9XRcuoS9epii49tjf/lLJK2NzkG1xxTl7lLea1SmyaTNId8u0DzVZUZdtTjdxyl8aPU77HG3+BP13Oco7/VTzr1F5VxPLj/LjbVZKoWVE4xBj8t7baMB+Ma/y65fX2+sprHtJyXbGaLpy0OTU8vk7GwysR5TbWM52IliuZhkPHWIw6d+ms7r/aJm26u86ojDsOMh2Bx2Kfx4z5e3pqm4x2Owx33nfi/3bnLVP6Z2vxoUFN3Rd+kZ2E0aUZr+TJGhpykvEvPGyXqSqop4dFIXXGvNXGZjMtutkW2TmBO06LycfUECrnL0XTaLBmejcuPijPCiFHlkTE+16ZnYdi2i8/IKEeYtjbfFmfVH/EQT+NK3injZCTMBZsPulxVvd1cj/9xtLgaz03PJ1MVg+aPvd1e/TVrMut4MPbLmDdyxGc2NpSXRq8eN4Of1v5axkO5l+FZGNf5p7//6l/++tnHf/tP19mN6++38bD+e6w/ms9LbjOPE1scxNZn0l+3Mc6W8VwfMpOHIcZbpzj066/uUr96jGY/rzrisOl4CBuHfRs/vudt5/Wx6yEb8Lhv3f8drPHHBrT2h3r4if3d2b7509f285mxR/yQF9szY//ld35lMZkU9vOvvv6zB+/9z79eBfd2eyYtG8ewjsb4OSzb+rMwsAHN806xfbtO75s//WwP363U6c7BQzPLu5Uuk9/8tT//xW/dqWVZYb+4c/f2W7Of/vXjluTZwZnh3moM8zbGz2HZDp4Zi2HHYa3vIP/fP77/3/95G9zPU7DbP0sUTSbaz3/3K7fv/MVP/uFpcD8xDMN2b2gy7PitVZMtXnrps9+795N/exbc1aO3H//7jxyaTEyeffqH3/zZg/d+/B/Pg/uMYRi2G0OTYcdvrZrs/7/yWiEFPnn4fnBvj97+76tv+Miywm6/NQvuMIZh2G5slAOcPMuvfa0WAcs338xvb0N7dMysHj/21WSzWWhnAQB2B5oMQNJki8lk8cUvrn/wg9BOHTMvXnkFQQYAoIAmA9A02WSymExWDx+G9utoWT582KrJVo8fh3YTAGCnoMkA8uVbbxllwfKNN5jH3AbrH3mt9EeWAcBJgSYDyFff/a5VGbz88vriIrSDR8jizTeRZQAAIi5NlhjeipTuzDPwII1Ho1GUbKnqKMk22l9kO0729Ucdxy5NViiDd9/t12yWRO6/m03jfLCsnj71XOmPLAOAE6ElT5ZEwtUkkz7BfpDGweWOhSyJarWxY+VhG6lpbPaiVZMtJpPFvXv5Rx/1aJe/GxteK/2RZQBwMnhpMvHimlf5syjJsjKT1lxxhNRanOZVliCK4mJLmatov0I1SY0oERvfvP665ijJxA+2fjnKWyJWOC10INPaFrYqISyLuGVW1oQhTiVN1i0+Jn/E6vWNcRxL9TuRho0oTAT/65664qb3S9iojsNMTe+Kjto02T9PftVHGfz0N+6snzyx9tbSbpZEcVJ/27hjjLPa3yiK9lVzb87y/fc9NRmyDABOgVZNZrpC5tXlvLhapHFxnUkioVgal99mSdSom1Lhua/nVcF677LWoeqXtEIaKxdtvV+u8iak2aosiRoNlIp6otyquWvTDYKLYvpJkjXd4mP0p0IR4mJNxm91xDJi/YpUk2WZIW7mfgkBUI5X3jFPlkSjb/7Re17K4O5d99oyW56sHsPGqDq2pPEeTPtujfXNTRPb2Wz1+PGLO+rbMJFlAHA69MmT5bnp4mbTFlkSVZfMOpHhVDWWybjB6s9FYaX2zCyI7OVNKPqm8UdOpSgCorhwt89FKh7W3e8RH4s/QsWqVmjKtClHpXpZhSk02ssQN7dmtbjRQZNlSRSna4+1Tf/46h+03oPZPnepeWBSt+LatyOf9ly8804hyIqP66sr94QmsgwAjpgu68lEDluTVWX0pJflGm8tb0K5yFb+SEuqRCfTOEqyNI6SNI6StD2LOJAms/ojVLypJivLiJlPu+g0x21rmkys30eT3fuTv3f319Zud00meXzEebI8z9c//KHybNj1zc3iG99AlgHACTKcJlOvqdWlt7tmkteDN9fzXvWnsTnZkMbySjVHv1zlTfVXGa/6Y+VWvVGcBczzPI3jOC7Wq0WRpkD0NVHSruLcZZf4OPzJ6/38NZkhDmIN0hSuZb2/OW62fpndqPetNkty0KTJ8jyJor/5u3ZN9lf3/lRvyKfdrppM2uD3M+D4WD544DgW66ur0A4CAAyP57Mw5IuibQ21PhdWb4nTau1T1vp0ALnpDeu3aTJJJbT0y1zeWn8SRXFsiJ3gfllAmEMsSulyxeS/NLUVN0vKOsbH4o8aB72muoh2/4ImhkfyKn5p6ZgaaVvcLHOszuPVfGkrLnyXJfc+97kXn/+8W5P9153f1o6+ZThIddviZo6zLTgnyOrpU9vyshd37yLLAOD44Jmxw+Oz5gx0wsZt8dJLramy9QcfBPPvJFk/f/5iOkWWAcCJgCYbGCH3dMzLgAYneNwWX/7y8u2310+e5B99tLx/36gDlvfvB/HtxFnMZsgyADgF0GQAGre3i3v3DDrg5Zd5/WUQbI/JQJYBwDGBJgMw8fz54gtfMExf2p4ZC1tmfXVlnMdElgHA0YAmAzCzvrgwTF++9VZov04X22MykGUAcBygyQCsrL7zHV0B5M+fh/brpFl+73vIMgA4StBkAC6WX/+6+szS738/tFOnjvExGcgyADh00GQATm5vF6++Kl3+790L7RPk65sbfXnZi7t31zc3oV0DAOgJmgygjWfPFlEkTV+Sj9kPlt/+tirLzs6QZQBwoKDJANpZP3kiTV+++25oj6BEf0wGsgwADhSbJhPejCO+BiZOfd6MtEta/bG9XfFwSGOth83bhvy2FwfwwOMQGOlBsl/6Umh3oEF/TAayDAAOEXueTHtZcv3qm9aXiG8PY8s78Cdcj/MkGsWJ3H4a1w+7V19IbtpevqnT+np18EN+kCzvWdor1jc3yuP+kWUAcHDYNVmldOr3Y9e6IEuiODElZDLpreX15mJr/fbrZhdLeas/xjc22/2p99C1iPAmnyhyN21rN6u7JX1KouJ/9QumhcZN/dWql/Ypk3yy6pTElfCVbbtpN+iF8CBZ3rO0hyiPyUCWAcBh4dRkUZLnaRxFcfkPUUY0WqS+0ovvkM6SSJJZ1eRZ8e9CLbjKW7DlyYz+CP2wbkljrxcsmvNkssqpy0izqWWSqtjerb/Nrm5N1uTGzNuN3kI/mgfJ8p6lvWR9dSUuL0OWAcAB4Vjjn8ZRUlzIkyhKMkmTifNlcqbImMkyCQJ3eQvtc5daQ7omE9bHeTVqa1faLrTbqDDRPUt/HXky0Us5eYYmC0n9IFnes7SfrG9uFq+/jiwDgIPDdd9lEsVxPIrTPEuiKI4jIfVj0kCNaDNgEATO8naXhtBkkhf982RCc2IBpcHKvT79VaqoXZYmaBtZaN6uuAqbUzxIlvcs7TPiYzKQZQBwELg1WRQVF3ZxdtCugVx3OJoEQY87Ihu5k8biyq5OmkzaIAmZvEpOqQrM2G71VZyqk5jKcrqyfP87QBWBlSWxEHNRh5m3V5vQZINRPUiW9yztM6sPPqjnMV+cnYV2BwCgBZcmE+VHvdK/nmuL02Z2TZy20+YilSk4SSuYyjtpKpOX2hv8UdsdNeu6HI2aNZnerjlMZf1RHIur+WW51qm/6lNJtHrkOozb1UD0TteByLNniyjiPUt7jvSYjLffDu0OAIALnhm7MfaHhsBxs37yZPnaa6G9gBakx2QMIcsWk4nto/KVz+5bYjetHBaOmBAu2BPQZP0x3ikgPGWDdBTAvrB6/HgoWbZVTaa8Ksph7goHExkX54vJ2erDYSobEM/gKLu46/FvYvj+AOR5jiYDgBNhfXX14pVXNpdlyoV5cE3m6YN7ry1osovlZLI4v3AUXU4my0cfih+d5V2tylW10CNoPgKrk7YDGAQ0GQCcCs1jMjaQZaIa88mj9Mh4ddVtaLLexdBksFegyQDgtFg+eNBblrnVz1DryXpny4afa+swd9lNSA1YVdfpYM990WSwe9BkAHBylI/J6C7L9Ev7ljSZfxKuYysfrs4mi8n5ytH8xbncYpMna3SSWObs0brIijV2vpLKF/++WJ2VBRS9tX501ux7fq5V1R6utiJSsc0TnD7NAfQATQYAp8j6+fMX02knWVZcjOv/+isnvRKfhvxd6lJDmya7OF9MJssL8aOmyT58tBTKrM6L2gxzl6Ima6qVc2/rR2fCx4tlpfAcebLW4BsPQde5S4DdgyYDgBOlfExGx2zZhlfx1t171D/cerIPV2fyIjCjJjNPaLZoMr+vjFW5MCYsHSVbE42ego+EGWwDNBkAgBf69dh9ne53de+hAwZTD3ICLM9debLF2aO1tHMvTaa3aCjvopMm6ypeUV2wY9BkAAAdUPST41v3vpu37qizZ0OemkxdAVZOSfbRZMpUqWHfFjw1mY/wtdUMsDNaNJn4BNSw70tMY+X1QgNTvKPJ8baj/m+rBIAjYn802fBiwluT1Tusziw3AewkT+Y+FvV2fdbSJ2hMWcLuaXnfpfje8a1KIh8GfGeR/E7vksy4dS8ZytPD6THAvtA13WLc0VagVQe0ionNFIMmhlo0mSiqAqwn89FknoX944Ymg+1h12RZElneDlQkz6Ikq97/3VzXhXdsS+8IF99GXgirJBqNRlGSxE0irk1vJVGUpHULVfmsdkf65OqX/Eru2vssieKk/rbpVL2H7qKQR4xs4RJJhe6KEtMat1h797ndf+mrypk+9QCAHTHp4n9pHyqb5a7HQ5+13He5Ohe/Le6XVDXZ+tFZndlaPzqry6/OxUVmnprMeN+lUpUZd2c7Bcq4xbNdgAGxazL3VGUlr4p/F5fzJBJUSxqLsqC53gvVSrOFWRK1qYJSxmVaedlVn9yPLU8majul++4tadz+gss0VhRRubcjbqJEa+2jWCRLot71AICDTlkrx0bHdnfrti1+Tbc/n2x1XifnzleONf6liTdg1k8pMz6fzKzJcvvqtKqqbnHwKYAmg/3ER5MJ79qur+C6YtNm/uoiDk0m7tE6dego3/zTb9Vb+9ylVo+uySxvIbeRxkbR1j1uZv+1vJeowzrUAwBOeiwV95mU9GnUobo2b+KAcC8d03ttXE/WNUqOQwAwFM65S4tW0D60lLdrMqkOD01mL19V6ykyBtJkAkJ+y1piq5rMVj+aDGBrbD4jOWB6ZsBs3D4zyJxvvwN3ZJGEPcS1xl8RIS2aTC3fSIRGzch3ChQfhN095i7r8tpcZxLFqfetoY2rwoRiV00mbUhj2Z0ihaZukncYVXO+1rjZtZTBf9udoV3rAQAAgN3jfBaGMh3WXPo91pibt5eL+qucVhTH4qp0l5wqnoUhlDdOJHqrilRd8177GKfNt1GS6f2tdzFGR25A9UfcxR03uz9m//X6i6/61QMAAAA7JuQzYwd8tkWe+64kAwAAANhDgmky8Wm0G1bVaaU9AAAAwB7Cu5UAAAAAwoMmAwAAAAgPmgwAAAAgPGgyAAAAgPCgyQAAAADCgyYDAAAACA+aDAAAACA8aDIAAACA8KDJAAAAAMKDJgMAAAAID5oMAAAAIDxoMgAAAIDwoMkAAAAAwoMmAwAAAAgPmgwAAAAgPGgyAAAAgPCgyQAAAADCgyYDAAAACA+aDAAAACA8aDIAAACA8KDJAAAAAMKDJgMAAAAID5oMAAAAIDxoMgAAAIDwoMkAAAAAwvNL3qy9qGXr0roAAAAASUVORK5CYII=" alt="" />