SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
135480
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '14' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '75' AND p.permit_type_code != '' AND ( 1 )  
1436
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '3' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-22 23:59:59' AND tap.permit_type_id = '3' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '1' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-22 23:59:59' AND tap.permit_type_id = '1' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '45' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-22 23:59:59' AND tap.permit_type_id = '45' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '6' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '27' AND p.permit_type_code != '' AND ( 1 )  
1312
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '71' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '9' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '5' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.start_date != '0000-00-00' AND tap.start_date >= '2018-01-01' AND tap.start_date <= '2018-01-22 23:59:59' AND tap.permit_type_id = '5' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '15' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_midlothian_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.start_date != '0000-00-00' AND p.start_date >= '2018-01-01' AND p.start_date <= '2018-01-22 23:59:59' AND pt.type_id = '12' AND p.permit_type_code != '' AND ( 1 )  
0
%PDF-1.3 % 4 0 obj << /Type /Info /Producer (null) >> endobj 5 0 obj << /Length 3169 /Filter /FlateDecode >> stream x[o8+``277qR;8 m3f`^,*qtC%qHӡih;>GkJ+Ujdշ_G? :WBJ0_NV_Xu689sw[V]%nfv_/zõ?__>w_cj"+B+Xв1T*:_VW}mf6cUө-o \m7?-vW˞ea[`jl`N?f<=_ß8+itt64dV#o>==<~>*9oVTը:.9@g5:V\xǧѺ>sLT?>5JUäxϿ߻[km8W1JgUc76VzUkշO?nϫp, HS1 ;:#18OXeFF. z`Vx~zFXr7_[S.`C*nNR2gC>n``D#lWmlk[@I 6g /T %Ѝm㥃Ƅ0N ֢5_D}t+=ĎH{43ft-$k&~P3S+'pB#~L͸n: 2P?:N(JNRI{]^Nj~S8z~zڭ6n{AVrղF) (wYml6 dp iRj#BQ 0+2纈@@-bHw* ڥg3l!, LZC>]f!\.øK>еͅ߻,SUFW\5>EXlȔѾ$)Ǹz)e[l./!u2*N\4ϰe.36ʬv:ڌ6Bn6!lY2ֹu>#p qGEpЦ%wfr?1`!ˌ@y1tE6`m7=4Z(>`(ZyPc04 g zL_7vYQ5F|( /zP̆ x?HjU: 5͌~2gζ0>C&E>hVK PPO6'B hhI>DW3h$bDK-5ܭ-ZeU:HߋjOhM zJm/wjgXR$+ Vt)JCLV"BG)JCV A4u4%ٕF"`cTBS!x)D Er̘ " dM"J95e m44GK]]\?x&b0_J:7EqE9CRGQFC21B4vo;8YGnQ!nQhϐ3ȐbĐD)Ve__d5MjJ_ZYtHMjb!,nWVJD"ZfRIrr t9Ms`G9Q(!un9!iS]N,'7ʩ7)4M'KCR -BNFW\iS%]IJjIIҭNf}j=8ɢph4*JS) vKs-)ROQܞ!B=bgTz=U=ɞ"KH6~cv* Vĥ}iq˥3++SE4*/ g6 :K|(BjG.7iT$Il4ϵt;)R4Mn*ADnfF5 3 レI"Z,N4yUIN$<%3mN5d;M㣜J⣜,I|LR|z:Z(i&>iѹxc- ?n'6y5%Rޠ}|EA$&8PJPGh!sn7'PyVB]eܜiV!lԘ&6'l`^`60F u9% n,7W6BGȓ}NWMP.2> 6ld`2 44,uݛ,nNp q8yƏ@ޛlH^d1XS~t4Y!d:G@$=6QPd2 R% o:|i\χYj~7p."*9vcoI;*Ϋ*2uT:tT5"`RܪԤUU;*.9.LguW` 5t ު6oU-Uma  buLIB+n?w COۻ0@N^splŅҦVukX-O~ 5-m-`:1pm8[P#8y]L^n_d=εc]\ytgxlm~7tNvHYWk@vwݝm-Z0tLƶLY>w=G'g;.wŶ{#a6~TBj,o=߼onekaX])2JQx/{ATv<5i)>uqw_H/uN endstream endobj 6 0 obj <> stream JFIF xᑠރZ Rz^'ȼ͘K |0?n?i_7-Oڪw$Z\/N3hދB|SmVhi}q:꿱?g ?X}x~ EΟ ";/YӦ-k:auu 2y F ğ 1eq6ZbTcS C0tpa^3//'L9aRf{E][w{;5cu~*ǟ]/_?0m%Pz-ZڬV!3sU~>.Y/xW׀t]WY%Б=f,ƭe]]2IxKO]I-VEi#?D >[x>UڍaJX)UPG ?_ ſ4c~ 𮧦}o ͹Ѯ/級[{x淖)Y37K|uLc1j69X\21(`(ʽJ4ҕQ 'aFJ0 +]P,jW,2Ut8sˑ)tm'.1dcpI#3szt p7 &_xö!xkqXCq,WP^:4ѥeKna)w.|X%G^&1XLSbp~6/OԧS*8IB>R((ϑ݉p:v#<A8Lv=}opAo ?>!ZNMvR4XzɨZʼn [OkÔw71Yu<<#HK ;蠜*b(bi+ҭERөI8;N2%$u.M,,5ɱs|0 q93++B5(X\Mu}NQGBpqw4IpLxO{ϯx@dW6X»m6FM]{&]Xd/海@Q单^{w៉> /5(u=) 6a 6r2<\26ujΖ7)aN)WuS uaɷ u9iԕJv;q1M V+5-T08F?*`2x(R[*ZYGJ3cL {`0;L)z`t}o_4|cS>yE^3 }{ K3ʓȷYm}B9œ%Rs8A9Ju'tYmF1E Uz8\b*† SVaNgZII҄;g 3}4#0y d9xW?hJu2m4&Aa?fu 5Y.lRO@n "?|s>#'<=ڼo<-Eh]ܺv7-9GXэz2:j)F9U'e'/e-Rܲz#KU >yUl¶KK4i<2tV I`eV8R^tL$s#>du}O<:w gKRB|[åi:W7lWw5̩-l|i/xGW/xZ_<6[߉4Kҵ&?2"Rky ^,2M!N5gATF,jJ'ffЉY,qW-1X6kS ^n'B[ C(,5lU*mTVUjsb}:=Oǜ1<=#_~(rrO8p0yֵ8׿bG?Oq4v>:~qN8? crq${hT?oώz1jԟ5 ~$kZtH  mCL;G4}.2B[ĠVO_ {^)դWŸ6|U B|>2=C(όmAG^խ])fc:5|U_E4k.&RjW7 !Hn x*6Av#;gϭо#xW<|ff6L-ZXzZ}&*q8|Kte),EzXb)Քks~.wwZ=nM4_Q٣ GZⴹ}fKkO0;[,Ir:Ntzͮt/Z:Nqh,௞+O O ڭ5gMw jgD.gKkU#縖%o'owէ~|zV⯊#4]R RVM|-.-nrٿI>5|:kno.'ex/Ohimbx SXO"m7|~70mq3a8{|N.xZ KeNPux  []>1eb&?k_} v4Ĝ˨Mn& W?߳ƅ[ҵ;IĶnmixV+e{l6 %?4y~5v|K S"տiŚ\~+>;+k^':YS+ Im2-!-W? |q8w+o-4k~&][_xcsi .X-cW _l1 f9 }8ʍYFxlzŨAޅjG4z.ms~;[<7xxV Ke 85OS̲c2j7y_u)Y"𓭷$&&ftoi:ޫib#tK {V/c by#Uo"|9O y|w OF7:n#L\.y. hW1~=J3ÿxg^(#7ό<#_iߎ|2t -gz^ˬxdi%}I_=ƿwf WGQ⨴[y/:|ao<,-0\Ƴhrkck7x gp29VYSUUrL[5V ?G*RX94kˆ|s ʼ(;(`ÚC=s[>Qy613 jXx0] y=9? EW*_*A 28 Fx#x_zg~+P*sMhմ/kϤj6fu}yS:{9-ʰU`SF+F5X;GxI<=e>b6 pX̟ V[`3.\IY+C%^j{ m|>jMw\~ڝ2VmKO[[;}BX񝗇 ZOoDZ.q5v:̷VJT(ۃ;/ |#D9Ե.Di:a/iqj^]mJY]A 20&x <6no_Π a5ii+1ن][qF9Wy˽|<cF#J)F3(&s!p p?dm?V?g҆2پ%ݲBeͳqF?*g>+[ ʇÞ#xǾ.uyak^U犴>miYjQhK8|ncoW~J0ʕh6|m8RRhFH(>Ryu̳>\<e_I/&Uڙ6g8./ pyfT,p8LMXR1Xt%\*G%[>jޚ;; hog_ƚ66se[XךQ`c=if[^asGͅ^Y e8\Sɸr ,,.<5YEl6>?VujOh__(ό> ֿh^K-CO/~ xn|=w^TO·Uڝ<) AjplZ.i~a/eN -13oDp <n'"᧐g\A`18f7 ]JSU/o qIMK:ǯ~KEa.mtȪaNJdU%Mdɻڿ ͖ZÛm>o5;WqE/~kW*-<@m /dG-YmtKW?(\|Ou Od^>#]qǤCiqEs 2DH7?Wыƌ 2&3FpfUG. 5IӅYp0,WRԧ *5էQ$ܡb%FIi&vW%}Mf{ 7MSN#>+K[<y\xJى5OZVb fZh~< x>[gľ"8alK[W%Ŷivzu"Agm4~Z|dd!G _Z_xO>q6o>%,,5}FMy/E ,Dz]}=K?⌾1)4/|4+˨ -:bcE&3o5/j>tL&V _7x|.cפ[UO +Z  S\<T\Nct0QF4]')jmI;~sM\~>1[Sı?~"I49F+t+FAIiz6ZZO>^74QMDRDuUetp]\ AsCgo7K{x+\+:6:2+f^-t]I/뚜ieOu{2D 9fos;ŏ#xNOxĺ֦Qsx._~I54K;E歭7ҟO d2 sZ4\]X1XxRl5:|UhET}yJxDRW&i0XFѓ9]i[]Y#_Bp::k+C06e\, x`8O:玣zGec#׾+lO6{%K[oE.Q_~3aigKOxN:u֩ٵ1#6K~^i# }FT@ Vm_웭xq|kxDŽeOtC_/w?G?4?G񮿩_}}qwkov❮{߅5xFn-Z}TT[?6_?W|UE5?^E_OZ|mqs?5{tyLpz>oX[Cj +Zֵn~տ>5;O7_ gnH$ڗckc7!/ b)c#Bx;z|e>=xT͍oڋB<;gPLk 3HC*=W~ S/= '޻ x_@sXޙ]Gv^*ռ#Z77Vwv`NM%!_vq+ Uz>.Cែς?>\^[[ַuO<Ѿ$[~5{N\}Ӿݗa_NO]ZW~ub5;RX5O~JKYmu7WI0t'6:]|nu<xw~%Kq|7o |Sn<[;sݦsiaMCQu%:W_x>+xҼk|Oɼ|Xi_Y|u1oxZ'|{hmѢR׵]_:mOxt-Ml5SCe ϧEGt7׾=?> P־fO'~5Wiym{k1xY]Mo5mAT5~ƺK/v#^4|R?㥧-\cB|TŮm ڽԈ; Y&h%ix{;O /}S-_U¯r~; cRuorI_^Mz,+mֵ%#w G/؏4*Fx?GEx?*[1|)Se_F/amhm4O)+ñ?~xc1ox[Yjӵ:iY?Ə~*h^ OOľ}o@߆|I[%|%ŭ{wKfZZ=Y) ψiacE)|9|Z.u| q$M_>OL. Wrـm'ԟe]9|i{nbVѴPqnNJ+s߈>̱k)b"'Y݊JR E()+yN:QPӂF)E/xPNN}Ǡ<=}13Q\e9<}~lsq;Ƕ1`@}r_cq㧱P  g=q:cԎǧj(;<\g??^u?O_֊(#0N> endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F3 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj 10 0 obj << /Type /Font /Subtype /Type1 /Name /F4 /BaseFont /Helvetica-BoldOblique /Encoding /WinAnsiEncoding >> endobj 11 0 obj << /Type /Font /Subtype /Type1 /Name /F5 /BaseFont /Times-Roman /Encoding /WinAnsiEncoding >> endobj 1 0 obj << /Type /Pages /Count 1 /Kids [7 0 R ] >> endobj 2 0 obj << /Type /Catalog /Pages 1 0 R >> endobj 3 0 obj << /Font << /F1 8 0 R /F3 9 0 R /F4 10 0 R /F5 11 0 R >> /ProcSet [ /PDF /ImageC /Text ] /XObject <> >> endobj xref 0 12 0000000000 65535 f 0000014824 00000 n 0000014882 00000 n 0000014932 00000 n 0000000015 00000 n 0000000065 00000 n 0000003308 00000 n 0000014269 00000 n 0000014375 00000 n 0000014482 00000 n 0000014594 00000 n 0000014714 00000 n trailer << /Size 12 /Root 2 0 R /Info 4 0 R >> startxref 15069 %%EOF