Standard Jet DBnb` Ugr@?~1y0̝cßFNl7nӜ( !`g{6߱DcC83y["|*D|؂f_Љ$g'DeFx -bT4.0dv YS  Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYuSY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId Y!S!Y  Y Y Y  Y  Y Y  Y  AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y 8 Y H  Y accolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @@ EB  X*%`B  `@R$@(MX U@@.^YkmYbU6@:@+-MMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^QkJomWdik^YkmYbU666:^YkmYbU6868^YkmYbU6>68^YkmYbU6>6:^YkmYbU6>6<^YkmYbU6>6>^YkmYbU6>6@^YkmYbU6>6B^YkmYbU6>6D^YkmYbU6>6F^YkmYbU6>6H^YkmYbU6>86^YkmYbU6>88^YkmYbU6>8: ^YkmYbU6>8<!^YkmYbU6>8>"^YkmYbU6>8@#^YkmYbU6>8B$^YkmYbU6>8D%^YkmYbU6>8F&^YkmYbU6>8H'^YkmYbU6>:6(^YkmYbU6>:8)^YkmYbU6>::*^YkmYbU6>:<+^YkmYbU6>:>,^YkmYbU6>:@-^YkmYbU6>:B.^YkmYbU6>:D/^YkmYbU6>:F^YkmYbU6>:H^YkmYbU6><6^YkmYbU6><8^YkmYbU6><:^YkmYbU6><<^YkmYbU6><>^YkmYbU6><@^YkmYbU6>>6 ^YkmYbU6>>8 ^YkmYbU6>>:^YkmYbU6>><^YkmYbU6>>>^YkmYbU6>>@^YkmYbU6>>B^YkmYbU6@68^YkmYbU6@6:^YkmYbU6@6<^YkmYbU6@6>^YkmYbU6@6@^YkmYbU6@6B^YkmYbU6@6D^YkmYbU6@6F^YkmYbU6@6H^YkmYbU6@86^YkmYbU6@88^YkmYbU6@8:^YkmYbU6@8<^YkmYbU6@8> ^YkmYbU6@8@!^YkmYbU6@8B"^YkmYbU6@8D#^YkmYbU6@8F$^YkmYbU6@8H%^YkmYbU6@:6&^YkmYbU6@:8'^YkmYbU6@::(^YkmYbU6@:<)^YkmYbU6@:>*^YkmYbU6@:@+^YkmYbU6@:B,^YkmYbU6@:D-^YkmYbU6@:F.^YkmYbU6@:H/^YkmYbU6@<6^YkmYbU6@<8^YkmYbU6@<:^YkmYbU6@<<^YkmYbU6B68J^YkmYbU6B68L^YkmYbU6B68M^YkmYbU6B6:J^YkmYbU6B6:L^YkmYbU6B6:M ^YkmYbU6B6J ^YkmYbU6B6>L^YkmYbU6B6>M^YkmYbU6B6@J^YkmYbU6B6@L^YkmYbU6B6@M^YkmYbU6B6BJ^YkmYbU6B6BL^YkmYbU6B6BM^YkmYbU6B6DJ^YkmYbU6B6DL^YkmYbU6B6DM^YkmYbU6B6FJ^YkmYbU6B6FL^YkmYbU6B6FM^YkmYbU6B6FO^YkmYbU6B6H^YkmYbU6B86^YkmYbU6B88^YkmYbU6B8: ^YkmYbU6B8<!^YkmYbU6B8>"^YkmYbU6B8@#^YkmYbU6B8BJ$^YkmYbU6B8BL%^YkmYbU6B8D&^YkmYbU6B8F'^YkmYbU6B8H(^YkmYbU6B:6)^YkmYbU6B:8*^YkmYbU6B::+^YkmYbU6D68,^YkmYbU6D6:-^YkmYbU6D6'^YkmYbU6D6@'^YkmYbU6D6B'^YkmYbU6D6D'^YkmYbU6D6F'^YkmYbU6D6H'^YkmYbU6D86'^YkmYbU6D88'^YkmYbU6D8:' ^YkmYbU6D8<' ^YkmYbU6D8>' ^YkmYbU6D8@' ^YkmYbU6D8B' ^YkmYbU6D8D'^YkmYbU6D8F'^YkmYbU6D8H'^YkmYbU6D:6'^YkmYbU6D:8'^YkmYbU6D::'^YkmYbU6D:<'`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&'( )!*"+#,$-%.&/'()*+,-./0 1 2 3 4 56789:;<=>?@ABCDEFG H!I"J#K$L%M&N'O(P)Q*R+S,T-U.V/WXYZ[\]^_` a b c d efghijklmnopqrstuvw x!y"z#{$|%}&~'()*+,-.'''''''''' ' ' ' ' ''''''''''''''''''' '!'"'#'$'%'&'''(')'*'+','-'.44444444444484?4 D4 H4 K4 O4 T4Y4 Kraaaaaaaa a a a aaaaaaaaaaaaa$a% a2 a3 a4 a8 a9 a: a; a< a= a> a? a@ aA aB aCaDaEaFaGaHaIaJaKaLaMaNaOaPffffffffff f f f f fffffffffffffffffff f!f"f#f$f%f&f'f( f) f* f+!f,!f-!f."f/"f0"f1#f2#f3#f4$f5$f6$f7%f8%f9%f:&f;&f<&f='f>'f?'f@(fA(fB(fC)fD)fE)fF*fG*fH*fI+fJ+m+m,m,m,m-m-m-m.m.m .m /m /m /m 0m0m0m1m1m1m2m2m2m3m3m3m4m4m4m5m5m5m6m 6m!6m"7m#7m$7m%8m&8m'8m(9m)9m*9m+:m,:m-:m.;m/;m0;m1<m2<m3<m4=m5=m6=m7>m8>m9>m:?m;?m<?m=@m>@m?@m@AmAAmBAmCBmDBmEBmFCmGCmHCmIDmJDrDrErErErFrFrFrGrGr Gr Hr Hr Hr IrIrIrJrJrJrKrKrKrLrLrLrMrMrMrNrNrNrOr Or!Or"Pr#Pr$Pr%Qr&Qr'Qr(Rr)Rr*Rr+Sr,Sr-Sr.Tr/Tr0Tr1Ur2Ur3Ur4Vr5Vr6Vr7Wr8Wr9Wr:Xr;Xr<Xr=Yr>Yr?Yr@ZrAZrBZrC[rD[rE[rF\rG\rH\rI]rJ]y]y^y^y^y_y_y_y`y`y `y ay ay ay bybybycycycydydydyeyeyeyfyfyfygygygyhy hy!hy"iy#iy$iy%jy&jy'jy(ky)ky*ky+ly,ly-ly.my/my0my1ny2ny3ny4oy5oy6oy7py8py9py:qy;qy<qy=ry>ry?ry@syAsyBsyCtyDtyEtyFuyGuyHuyIvyJvvwwwxxxyy y z z z {{{|||}}}~~~ !"#$%&'()*+,-./0123456789:;<=>?@ABCDEa&a'a(a)a*a+a,a-a.a/a0a1a5a6a7aaaa aa aaaa!a"a#? 6 @ 95JE\ p!1"(&*@),/0;1          "#$%&'!(*+),./0-13452689:;7<>?@AB C=DFGHIJ KELNOPQR S TMUWXYZ  V           ! "#%&'()$*,-./+023451 6 8 9 : ; 7!!?!@!A!B!="C"E"F"G"H"I"D#J#L#M#N#O#P#Q#K$R$T$U$$$$$S%%%%% % %& & &&&&& '''''''((((((() )")!K JomWdikmYm^Q+JomWdik^foL^YkWQikmYm^Qk^mYm^QkidvJ^mYQk^mYm^QkmYm^Q+JomWdik^  idvJ^mYQk^mYm^Q+JomWdik^mYm^Q+JomWdik^mYm^Qk^ @JomWdik^foL^YkWQik^mYm^Qk^mYm^Qk^&0d _ Z g  ~K g  4 0IVGx F-SOEuD*BLrnA&z]t@z]t&۩WC@J@listing04270 @j`@iPDD88888886 @%-WC@!%J@listing04260 @j`@iPDD88888886 @4#NVC@C%J@listing04240 @j`@iPDD88888886 @"UC@.J@listing04230 @j`@iPDD88888886 @!UC@J@listing04220 @j`@iPDD88888886 @4zJ@listing04110 @h`@gPDD88888886 @RC@î.F@ D AJC@AJC@MSysRelationships1DDDDDDDDDDB AJC@AJC@MSysQueries188888888886 AJC@AJC@MSysACEs122222222220 AJC@AJC@MSysObjects188888888886 AJC@>or@MSysDb0 $@c:::......., @AJC@AJC@Relationships1<<<<<<<<<<: AJC@AJC@Databases144444444442 AJC@AJC@Tables1..........,  %YN Y  Y  Y  Y  Y `( Y @ Y  Y  au_idau_fnameau_lname phoneaddresscity statezipYTY.rB0Index_90B322E8_9ABB_40D3v11 k W M A07FL34236PaddyO'Furniture941-925-07521442 Main StSarasotavfN6 A06CA94305HarveyKellsey650-836-7128390 Serra MallPalo AltovdH0"A05NY10014ChristianKells212-771-4680114 Horatio StNew YorkvfJ2(A04CA94123KleeHull415-549-42783800 Waldo Ave, #14FSan Franciscof>&A03CA94123HallieHull415-549-42783800 Waldo Ave, #14FSan FranciscojB*"A02CO80303WendyHeydemark303-986-70202922 Baseline RdBoulderxjJ2 A01NY10468SarahBuchman718-496-722375 West 205 StBronxlbF.  @@J68J6:J6<J6>J6@J6BJ6D[d0`, v X , c E ' o ?  s ' p ' pR4o?X' W'Z&[=[*_+city# g au_lname' g au_fname' gauthors   G dcity% / state$ 'state$ gcity# g au_lname' g au_fname' gauthors   G d au_fname) /state$ gcity# g au_lname' g au_fname' gauthors   G  au_lname' 'state$ gcity# g au_lname' g au_fname' gauthors   Gstate$ gcity# gauthors  G  Gstate$ gcity# gauthors   Gstate$ gauthors  G  Gstate$ gauthors   G"Postal code"zip<++ ostate$ g"City"city/ o"Last name" au_lname='' o"First name" au_fname?)) oauthors   G country& gstate$ gcity# gpublishers%%%   Gauthors  G  G state$ g city# g  au_lname' g  au_fname' g authors     G city# g authors     G  au_lname' '  au_lname' g  au_fname' g authors     G  au_lname' g  au_fname' g authors     GVuW9q@" w H * J  y [ =   d , n B  mO1gI+Y;t5i8S\(iK-$pub_id% g$publishers%%% $ $ G#l@ '#state$ g#city# g# au_lname' g# au_fname' g#authors # # G"`@ '"state$ g" au_lname' g" au_fname' g"authors " " G!type='biography' And price<20< '!price$ g!type# g! title_name) g!titles ! ! G price*sales>10000002 ' "Revenue" price*sales<## o  title_name) g titles     Gpubdate>=#1/1/2001#2 ' pubdate& g title_name) gtitles   G contract=0) ' contract' g title_name) gtitles   Gau_lname<>'Hull'/ ' au_lname' g au_fname' gau_id$ gauthors   G D price*sales, /"Revenue" price*sales<## otitles.sales+ gtitles.price+ gtitles.title_id. gtitles  G G  G "First name"+ '  "Last name"* ' state$ 'state$ g"Last name" au_lname='' o"First name" au_fname?)) oauthors   G zip" 'state$ gcity# gauthors   G state$ ' country& gstate$ gpub_id% gpublishers%%%   G d2! / 4 'state$ gLVAL4t * " X  v V TTx\r0Switch([sales] Is Null,'Unknown',[sales]<=1000,'Not more than 1,000',[sales]<=10000,'Between 1,001 and 10,000',[sales]<=100000,'Between 10,001 and 100,000',[sales]<=1000000,'Between 100,001 and 1,000,000',[sales]>1000000,'Over 1,000,000')SELECT DISTINCT price FROM titlesSELECT DISTINCT price FROM titlesSELECT DISTINCT price FROM titlesSELECT DISTINCT au_id FROM title_authorsSELECT DISTINCT price FROM titlessales > (SELECT AVG(sales) FROM titles)pubdate Between #1/1/2000# And #12/31/2000#Switch(state Is Not Null,state,state Is Null,'N/A')Switch([sales] Is Null,'Unknown',[sales]<=1000,'Not more than 1,000',[sales]<=10000,'Between 1,001 and 10,000',[sales]<=100000,'Between 10,001 and 100,000',[sales]<=1000000,'Between 100,001 and 1,000,000',[sales]>1000000,'Over 1,000,000')Switch(type Is Null,Null,type='history',price*1.1,type='psychology',price*1.2,type In ('biography','children','computer'),price)sales Is Not Null And type In ('history','biography')CStr(sales)+Space(8-Len(CStr(sales)))+' copies sold of '+Left(title_name,20)pubdate Between NOW()-90 And NOW()+90 Or pubdate Is NullDATEPART("yyyy",pubdate) Between 2001 And 2002 And DATEPART("m",pubdate) Between 1 And 6InStr(1,title_name,'u') Between 1 And 10au_fname+' '+au_lname='Klee Hull'type='biography' And pubdate Is Not Null'Title '+title_id+' published on '+Format(pubdate,"yyyy-mm-dd")type='biography' And sales Is Not NullFormat(sales)+' copies sold of title '+title_idtype='biography' And pubdate Is Not Nullpubdate IN (#1/1/2000#,#1/1/2001#,#1/1/2002#)pubdate Between #1/1/2000# And #12/31/2000#zip NOT BETWEEN '20000' AND '89999'phone Not Like '212-___-____' And phone Not Like '415-___-%' And phone Not Like '303-%'(type='history' Or type='biography') And price<20type='history' Or type='biography' And price<20(state='NY') Or (state='CO') Or (city='San Francisco')au_lname>='H' And au_lname<='Zz' And state<>'CA'4WhO | F  z \ 2 s U 7 x N 0  ~ >  n-]-sU)fH*iK^@"M/V81titles 1 1 G0V@ '0 pubdate& g0 title_id' g0titles 0 0 G/price BETWEEN 10 AND 19.959 '/price$ g/ title_id' g/titles / / G.F@ '.zip" g. au_lname' g. au_fname' g.authors . . G-title_name LIKE '%[%]%'6 '- title_name) g-titles - - G,@ ',phone$ g, au_lname' g, au_fname' g,authors , , G+zip LIKE '94___'/ '+zip" g+state$ g+city# g+ au_lname' g+ au_fname' g+authors + + G*au_lname LIKE '__ll%'4 '* au_lname' g* au_fname' g*authors * * G)au_lname LIKE 'Kel%'3 ') au_lname' g) au_fname' g)authors ) ) G(b@ '(price$ g(type# g( title_id' g(titles ( ( G'^@ ''price$ g'type# g' title_id' g'titles ' ' G&"Not (price<20) And (sales>15000)? '&price$ g&sales$ g& title_name) g&titles & & G%Not (state='CA')/ '%state$ g% au_lname' g% au_fname' g%authors % % G$(state='CA') Or (state<>'CA')< '$ country& g$state$ g$ pub_name' g0O"ND j fM  L A Jc I >:H`FE7]YDC4AV|VPmC@J@listing05190 @s`@tPDD88888886 @%4JfC@fC@listing05170 {@s`@ qPDD88888886 @IW@fC@8m.J@listing05160 @s`@ qPDD88888886 @HeC@x+J@listing05150 @s`@qPDD88888886 @$4FdC@hw*J@listing05130 @s`@qPDD88888886 @E=OdC@K)J@listing05120 @s`@qPDD88888886 @DcC@],n(J@listing05110 @p`@qPDD88888886 @#4BibC@"J@listing05090 @p`@qPDD88888886 @A#^bC@āB J@listing05080 @p`@qPDD88888886 @@aC@aC@listing05070 {@p`@qPDD88888886 @"4>O`C@ k)J@listing05050 @p`@ oPDD88888886 @=m`C@ciWJ@listing05040 @p`@oPDD88888886 @<_C@$jJ@listing05030 @p`@oPDD88888886 @!4:5^C@X6_C@listing05010 {@n`@oPDD88888886 @9^C@G4J@listing04460 @n`@oPDD88888886 @8=^C@ljJ@listing04450 @n`@oPDD88888886 @ 46>E]C@ qJ@listing04430 @n`@oPDD88888886 @5]C@QJ@listing04420 @n`@oPDD88888886 @4Ԋ\C@J@listing04410 @n`@ lPDD88888886 @42j[C@ J@listing04390 @n`@lPDD88888886 @1#T[C@UJ@listing04380 @ k`@lPDD88888886 @0[C@J@listing04370 @k`@lPDD88888886 @4.[ZC@p J@listing04350 @k`@lPDD88888886 @-PYC@+ J@listing04340 @k`@lPDD88888886 @,,YC@] J@listing04330 @k`@lPDD88888886 @4*XC@(J J@listing04310 @k`@lPDD88888886 @)XC@μJ@listing04300 @k`@ iPDD88888886 @(Y,XC@J@listing04290 @k`@ iPDD88888886 @4 @ @ @ @ @ @ @ @ @ @ @ @ @ @                        "#$%&'!(*+),./0-13452689:;7<>?@AB C=DFGHIJ KELNOPQR S TMUWXYZ  V           ! "#%&'()$*,-./+023451 6 8 9 : ; 7!!?!@!A!B!="C"E"F"G"H"I"D#J#L#M#N#O#P#Q#K$R$T$U$$$$$S%%%%% % %& & &&&&& '''''''((((((() )")!K @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @     ! "#%&'()$*,-./+023451 6 8 9 : ; 7!!?!@!A!B!="C"E"F"G"H"I"D#J#L#M#N#O#P#Q#K$R$T$U$$$$$S%%%%% % %& & &&&&& '''''''((((((() )")#)$)%)!*&*(*)***+*'+,+.+/+0+1+2+3+4+-,5,7,8,9,:,;,6-<->-?-@-=.A.C.D.E.F.G.B/H/J/K/L/M/I0N0P0Q0R0S0O1T1V1111U222222 23 3 3 333 4444445555555666 6!6"6#6$67%7'7(7)7*7+7,7&8-8/80818283848.95VS5R  i 6 X % [ + Y ' ] ? ! \)R"vX:yO1|KQSs?>type='biography'/ '>"Revenue" price*sales<## o> title_id' g>titles > > G="Advance" -advance9## o= title_id' g=royalties### = = G<"New price"price*(1-0.1)B'' o<"Discount"0.16%% o<price$ g< title_id' g<titles < < G;2+3" g;au_id$ g;authors ; ; G:2+3" g: : G9P@ '9 pubdate& g9type# g9 title_id' g9titles 9 9 G8state<>'CA' Or state Is Null; '8 country& g8state$ g8city# g8pub_id% g8publishers%%% 8 8 G7 state<>'CA'* '7 country& g7state$ g7city# g7pub_id% g7publishers%%% 7 7 G6 state='CA') '6 country& g6state$ g6city# g6pub_id% g6publishers%%% 6 6 G5 country& g5state$ g5city# g5pub_id% g5publishers%%% 5 5 G4Z@ '4 pubdate& g4 title_id' g4titles 4 4 G3advance In (0,1000,5000)7 '3 advance& g3 title_id' g3royalties### 3 3 G2state Not In ('NY','NJ','CA')< '2state$ g2 au_lname' g2 au_fname' g2authors 2 2 G1(price>10) And (price<19.95); '1price$ g1 title_id' g  @ @ @ @ @ @ @ @ @ @ @ @ @ @9798999:9;96:<:>:=;?;A;B;C;@<D<F<G<H<I<J<E=K=M=N=O=L>P>R>S>T>U> >Q???????@@ @ @ @ @ AAAA A ABBBBB BCCCCC CD D"D#D$D%D&D!E'E)E*E+E,E(F-F/F0F1F2F.G3G5G6G7G8G9G4H:HH;I?IAIBICI@JDJFJGJHJIJEKJKLKMKKKLLLLLMMM M MN N NNNN N OOOOOOOPPPPPP PQ Q"Q#Q$Q%Q &Q!R'R)R*R+R(S,S.S/S0S1S 2S-T3T5T4U6U8U9U:U;U7VV?V@V AV=WBWDWEWFWGWHW IW JWCXKXMXNXOX XLYYYYYYYZZ Z Z Z Z [[[[\\\\=Na-`B$ U I  { /  l  m A  ~`B> q@d0W_)QT6K au_lname' gKauthors K K GJ"Both"'<'+TRIM(' AAA ')+'>'B oJ"Trailing"'<'+RTRIM(' AAA ')+'>'K%% oJ"Leading"'<'+LTRIM(' AAA ')+'>'I## oJ"Untrimmed"'<'+' AAA '+'>'F'' oJ J GIUCase(title_name) LIKE '%MO%'< 'I title_name) gItitles I I GH"Upper"UCase(au_lname)< oH"Lower"LCase(au_fname)< oHauthors H H GGMid(phone,1,3)='415'3 'Gphone$ gG au_lname' gG au_fname' gGauthors G G GFstate In ('NY','CO')3 'Fstate$ gF"Author name"!Mid(au_fname,1,1)+'. '+au_lnameX++ oFauthors F F GE"Num part"Mid(pub_id,2)@%% oE"Alpha part"MID(pub_id,1,1)F)) oEpub_id% gEpublishers%%% E E GDB@  'D au_lname' gD au_fname' gDau_id$ gDauthors D D GC d pubdate( /CP@  'C"Biography publication dates"~@ WKK oCtitles C C GB dsales& /BL@  'B"Biography sales"^@ ?33 oBtitles B B GA  au_fname' 'A  au_lname' 'A"Author name"au_fname+' '+au_lnameN++ oAauthors A A G@"6/(2*3)" 6 / (2 * 3)<## o@"6/2*3" 6 / 2 * 36 o@"(2+3)*4" (2 + 3) * 4<## o@"2+3*4" 2 + 3 * 46 o@ @ G?"pages/10point0" pages/10G11 o?"pages/10" pages/10;%% o?pages$ g? title_id' g?titles ? ? G> d price*sales, /0P~`6U! x B f H  e  w *  U ! qSrT*dF(.jL"aC%f&\(X"Sales category"@=11 oX title_id' gXtitles X X GW  title_id' 'W type# 'W"New price"@3'' oWprice$ gWtype# gW title_id' gWtitles W W GV dsales& /Vj@ 'V"History and biography sales"@WKK oVtitles V V GU"price(Str)"'<'+CStr(price)+'>'J)) oU"price(Int)" CInt(price)B)) oU"price(Decimal)"priceD11 oUtitles U U GT"User" CurrentUser6 oT T GS d pubdate( /Sp@ 'S pubdate& gS title_id' gStitles S S GR"Timestamp"Now():'' oR"Time"Time()1 oR"Date"Date()1 oR R GQ d pubdate( /Q@ 'Q pubdate& gQ title_id' gQtitles Q Q GP dInStr(1,title_name,'u')8 /PP@ 'P"Pos"InStr(1,title_name,'u')@ oP title_name) gPtitles P P GO"Pos ma"InStr(1,au_lname,'ma')E!! oO au_lname' gO"Pos e"InStr(1,au_fname,'e')B oO au_fname' gOauthors O O GN LEN(title_name). 'NLEN(title_name)<301 'N"Len"LEN(title_name)8 oN title_name) gNtitles N N GM"Len"LEN(au_fname)6 oM au_fname' gMauthors M M GLTRIM(title_id) LIKE 'T1_'8 'L title_id' gLtitles L L GK"Trimmed name"Replace(au_lname,'H','',1,1)W-- oS/O"FBN d L  K1 S OJ q  H G>`\FE7YUC{ B0@1at@1at@listing0703a88888888888 xnC@7J@listing07020 @ `@PDD88888886 @5C@J@listing07010 @`@PDD88888886 @C@L_ J@listing06220 @`@PDD88888886 @ x4C@`/J@listing06200 @`@ PDD88888886 @ˇC@?J@listing06190 @`@ PDD88888886 @~`C@vIJ@listing06180 @`@PDD88888886 @ x|i^C@TYJ@listing0616b0 @`@RFF:::::::8 @{C@uJ@listing0616a0 @`@RFF:::::::8 @z郍C@ϳJ@listing06150 @~`@PDD88888886 @y,/C@ԤƗJ@listing06140 @~`@PDD88888886 @xwXC@&J@listing06120 @~`@PDD88888886 @vC@=>J@listing06110 @~`@PDD88888886 @uEC@G|J@listing06100 @~`@ }PDD88888886 @xs(AC@ -u@listing0608d0 @~`@}RFF:::::::8 @r~C@~C@listing0608c0 {@~`@}RFF:::::::8 @qG~C@F'ͫC@listing0608b0 @|`@}RFF:::::::8 @xos|C@|(ȫC@listing0607c0 @|`@}RFF:::::::8 @n,%|C@lJ@listing0607b0 @|`@}RFF:::::::8 @mj{C@MJ@listing0607a0 @|`@}RFF:::::::8 @xkyC@*;L} @listing0606b0 @|`@}RFF:::::::8 @j{ @ZH @listing0606a0 @|`@ zRFF:::::::8 @iN5yC@V;vJ@listing0605c0 @|`@ zRFF:::::::8 @xgwC@V?V@V AV=WBWDWEWFWGWHW IW JWCXKXMXNXOX XLYYYYYYYZZ Z Z Z Z [[[[\\\\\\]]]]]^^^ ^_!_#_$_%_&_"`'`)`*`+`(a,a.a/a-b0b2b3b4b1c5c7c8c9c:c6d;d=d>dds!?s!|#?|#<}#@}#B}#C}#D}#E} #F} #G}#A~#H~#J~#K~%~ %~ %~#I%%%%% % %KLa0cE'  + | ! g = q  W g2d2X&@vX.tJ5xZ"~au_id$ g~title_authors+++ ~ ~ G} price$ '} price$ g}price IS NOT NULL0 '}"AVG(sales)" AVG(sales)A)) o}price$ g}titles } } G|type# g|titles | G| | G{ type# g{type# g{titles { { Gz  MIN(sales)) 'z @$ gz"Num titles" COUNT(*)?)) oz"Sales category"@=11 oztitles z z Gy d COUNT(*)) /y pub_id% 'y type# gy pub_id% gy"COUNT(*)" COUNT(*);%% oytype# gypub_id% gytitles y y Gx d SUM(sales)+ /x type# gx price>=13( 'x"COUNT(sales)"COUNT(sales)G-- ox"AVG(sales)" AVG(sales)A)) ox"SUM(sales)" SUM(sales)A)) oxtype# gxtitles x x Gw type# gw"COUNT(sales)"COUNT(sales)G-- ow"AVG(sales)" AVG(sales)A)) ow"SUM(sales)" SUM(sales)A)) owtype# gwtitles w w Gv type# gv"AVG(sales)" AVG(sales)A)) ov"SUM/COUNT(*)"SUM(sales)/COUNT(*)N-- ov"SUM/COUNT(sales)"SUM(sales)/COUNT(sales)Z55 ov"COUNT(*)" COUNT(*);%% ov"COUNT(sales)"COUNT(sales)G-- ov"SUM(sales)" SUM(sales)A)) ovtype# gvtitles v v Gu state$ gu"COUNT(*)" COUNT(*);%% ou"COUNT(state)"COUNT(state)G-- oustate$ gupublishers%%% u u Gt au_id$ gLVAL$ b P \ F rt&@(SELECT COUNT(sales) FROM empsales e2 WHERE e2.sales > e1.sales) + 1(SELECT COUNT(sales) FROM empsales e2 WHERE e2.sales >= e1.sales)(switch(i=1,author1,i=2,author2,i=3,author3))(switch(i=1,'1',i=2,'2',i=3,'3'))t1.id >= 5 AND t1.id BETWEEN t2.id AND t2.id+4(((t1.title_id)>=[t2].[title_id]))SELECT a.au_fname, a.au_lname, p.pub_name FROM authors a RIGHT OUTER JOIN publishers p ON a.city = p.city WHERE a.city IS NULLSELECT a.au_fname, a.au_lname, p.pub_name FROM authors a LEFT OUTER JOIN publishers p ON a.city = p.city SUM((t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share))>0t.sales Is Not Null And p.country In ('USA')SUM((t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share))SUM(t.sales*t.price*r.royalty_rate*ta.royalty_share)SUM((t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share))SUM(t.sales*t.price*r.royalty_rate*ta.royalty_share)SUM((t.sales*t.price*r.royalty_rate)-r.advance)SUM(t.sales*t.price*r.royalty_rate)t.sales Is Not Null And (t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share)>0(t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share)(t.sales*t.price*r.royalty_rate*ta.royalty_share)-(r.advance*ta.royalty_share)t.sales*t.price*r.royalty_rate*ta.royalty_shareSUM((t.sales*t.price*r.royalty_rate)-r.advance)SUM(t.sales*t.price*r.royalty_rate)t.type='biography' And r.advance Is Not Nullp.state='CA' Or p.country Not In ('USA','Canada','Mexico')p.pub_id=t.pub_id And t.title_id=r.title_id And r.advance<20000SUM(sales)>10000 And AVG(price)<20Switch([sales] Is Null,'Unknown',[sales]<=1000,'Not more than 1,000',[sales]<=10000,'Between 1,001 and 10,000',[sales]<=100000,'Between 10,001 and 100,000',[sales]<=1000000,'Between 100,001 and 1,000,000',[sales]>1000000,'Over 1,000,000')ON0d | ^ 4  <  t , b * F [=XPy[=sAf2uW)K  G"pub_state" p.state<'' o"au_state" a.state:%% opub_id% gau_id$ gpublishersp''% authorsa!!   Ga.city=p.city, 'a.city% g au_lname' g au_fname' gpublishersp''% authorsa!!   Gapa.city=p.city0 a.city% g au_lname' g au_fname' gpublishersp''% authorsa!!   Gapa.city=p.city0 a.city% g au_lname' g au_fname' gpublishersp''% authorsa!!   Gauthorspublishersauthors.city=publishers.city]3 authors.city+ gau_id$ gpublishers%%% authors   G D@$ ' type# gpub_id In ('P03','P04')6 '"AVG(price)" AVG(price)A)) o"SUM(sales)" SUM(sales)A)) otype# gtitles   G d "COUNT(*)"+ / pub_id% '  COUNT(*)>1) ' type# g pub_id% g"COUNT(*)" COUNT(*);%% otype# gpub_id% gtitles   G AVG(price*sales)>10000007 ' type# g"COUNT(price)"COUNT(price)G-- otype# gtitles   G AVG(price*sales)>10000007 ' type# g"AVG revenue"AVG(price*sales)I++ o"COUNT(price)"COUNT(price)G-- otype# gtitles   G~  COUNT(*)>=3* '~ au_id$ g~"num_books" COUNT(*)='' o") @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @p!2p!/q!3q!5q!6q!4r!7r!9r!:r!8s!;s!=s!>s!?s!|#?|#<}#@}#B}#C}#D}#E} #F} #G}#A~#H~#J~#K~%~ %~ %~#I%%%%% %  % %% % %% % %% %%%%% % % % % %%%%% %!%"%# %$ %%%%&%(%)%*%+%,%'%-%/%0%1%2%3%4%.%5%7%8%9%:%;%<%6%=%?%@%A%B%C%D%>%E%G%H%I%J%K%L%F%M((((((%N((( ( ( ( ( ((((((((((( ( ((((((( (!("(# ($( /$ OF l hM ! L C Je I >:H`FE7]YDC4AVxLx@-@listing0939b0 c@`@RFF:::::::8 @H$F@<@listing0939a0 c@`@RFF:::::::8 @[@'p@listing09250 @`@PDD88888886 @x_$M@j@listing09230 @ h`@PDD88888886 @[t@ @listing09220 @`@PDD88888886 @Ls@@listing09210 @`@PDD88888886 @x.>Am@Ve@listing09190 @`@ PDD88888886 @Wl@e:@listing09180 @`@ PDD88888886 @X@k@listing09170 @`@PDD88888886 @x1U@@listing09150 @`@PDD88888886 @M @Q' p@listing09120 3@`@PDD88888886 @/jn@lp@listing09110 {@`@PDD88888886 @xOC@OC@listing07330 }@`@PDD88888886 @^C@xhJ@listing07310 @`@PDD88888886 @#fC@˜ߛJ@listing07300 @`@PDD88888886 @x uC@:ݛJ@listing07280 @`@ PDD88888886 @{|C@S@)ܛJ@listing07270 @`@PDD88888886 @C@0ۛJ@listing07260 @`@PDD88888886 @xСC@j؛J@listing0725a0 @`@RFF:::::::8 @jؠC@vכJ@listing07240 @`@PDD88888886 @ߟC@/͚՛J@listing07230 @`@PDD88888886 @xC@~8ϛJ@listing07210 @`@PDD88888886 @Y4C@k͛J@listing07200 @`@PDD88888886 @;C@*N˛J@listing07190 @`@ PDD88888886 @xC@QFțJ@listing07170 @`@PDD88888886 @C@jƛJ@listing07160 @`@PDD88888886 @C@4fśJ@listing07150 @`@PDD88888886 @xޖC@+›J@listing07130 @`@PDD88888886 @#$C@\J@listing07120 @`@PDD88888886 @+C@!J@listing07110 @ `@PDD88888886 @ xxC@pJ@listing07090 @`@PDD88888886 @5C@I䁻J@listing07080 @`@ PDD88888886 @őC@{J@listing07070 @`@ PDD88888886 @> C@3J@listing07060 @`@PDD88888886 @ x܎C@\(?(@(A(B (C (D(=(E(G(H(I(J(K(L(M (N(F******** *  * ** * ******* * * * ** ****** *  *! *"**#*%*&*'*(*)***+*, *-*$*.*0*1*2*3*4*5*6*7 *8 *9 *:*/*;*=*>*?*@*A*B*C*D*E*F*G + + +*<++++++ + + ++ ++++++++++++ + ++ ++++ +!+"+#+$+%+&+'+(+)+* ++ +,++-+/+0+1+2+3+4+5+6+7 +8 +9+.+:+<+=+>+?+@+A+B+C,,, , ,+;,,,, , , , , ,,,,,,, , , , , ,,,,,,+.0Hf4= z \ * < ` . v X * b uW9 m8ZKey[= s=Xttat.title_id=ta.title_id; ataa.au_id=ta.au_id5 ptp.pub_id=t.pub_id4  p.pub_name) gt.title_name+ g a.au_lname) g a.au_fname) gtitle_authorsta//+ authorsa!! titlest publishersp''%   G t.title_name+ '  a.au_fname) '  a.au_lname) 'ttat.title_id=ta.title_id; ataa.au_id=ta.au_id5 t.title_name+ g a.au_lname) g a.au_fname) gtitle_authorsta//+ authorsa!! titlest   G dt.price*t.sales0 /trt.title_id=r.title_id8 trt.price*t.sales>r.advance*10? "Revenue"t.price*t.sales@## o r.advance( gt.title_name+ g t.title_id) groyaltiesr%%# titlest   G  ta.title_id* ' COUNT(ta.au_id)>10 '  ta.title_id* gataa.au_id=ta.au_id5 "Num authors"COUNT(ta.au_id)H++ o ta.title_id* gtitle_authorsta//+ authorsa!!   G  t.pub_id' ' t.type% '  t.pub_id' g t.type% gr.advance IS NOT NULL4 'rtr.title_id=t.title_id8 "SUM(advance)"SUM(r.advance)I-- o"COUNT(advance)"COUNT(r.advance)O11 o t.pub_id' gt.type% gtitlest royaltiesr%%#   G t.type% ' t.type% gr.advance IS NOT NULL4 'rtr.title_id=t.title_id8 "SUM(advance)"SUM(r.advance)I-- o"COUNT(advance)"COUNT(r.advance)O11 ot.type% gtitlest royaltiesr%%#   GD\> v B $  l 8  " M  h < m7<UQ[MuCi"Total due to author"@$G;; o"Total advances share"!SUM(r.advance*ta.royalty_share)j== o"Total royalties share"h@ $K?? o"Num books"COUNT(sales)A'' o ta.au_id' groyaltiesr%%# titlest title_authorsta//+   G  t.pub_id' '  t.pub_id' gt.sales IS NOT NULL2 'trr.title_id=t.title_id8 "Total due to authors"^@ $I== o"Total advances"SUM(r.advance)M11 o"Total royalties"F@ $?33 o"Num books"COUNT(t.sales)C'' o t.pub_id' groyaltiesr%%# titlest   G  t.title_id) '  a.au_id& '@ $ 'ttat.title_id=ta.title_id; ataa.au_id=ta.au_id5 trt.title_id=r.title_id8 "Due to author"@ $;// ot.title_name+ g a.au_lname) g a.au_fname) g a.au_id& gtitle_authorsta//+ authorsa!! royaltiesr%%# titlest   G  t.title_id) '  ta.au_id' 't.sales IS NOT NULL2 'ttat.title_id=ta.title_id; trt.title_id=r.title_id8 "Due to author"@$;// o"Advance share"r.advance*ta.royalty_shareW// o"Royalty share"^@$;// o t.pub_id' g t.title_id) g ta.au_id' gtitle_authorsta//+ royaltiesr%%# titlest   Gt.sales IS NOT NULL2 'trr.title_id=t.title_id8 "Total due to authors"^@$I== o"Total advances"SUM(r.advance)M11 o"Total royalties"F@$?33 oroyaltiesr%%# titlest   G t.title_name+ '  a.au_fname) '  a.au_lname) 'Ms4\0 Z  A g  c / [ % M}Gb4^!aCu?`B$lN0title_authorsta//+ authorsa!!   GX7YZ_____2@$1% 7X7YZ_____1@$1% 7 G  G  G  a.au_fname) '  a.au_lname) '  p.pub_name) 'apa.city=p.city0  p.pub_name) g a.au_lname) g a.au_fname) gpublishersp''% authorsa!!   G  a.au_fname) '  a.au_lname) '  p.pub_name) 'apa.city=p.city0  p.pub_name) g a.au_lname) g a.au_fname) gpublishersp''% authorsa!!   Gapa.city=p.city0  p.pub_name) g a.au_lname) g a.au_fname) gpublishersp''% authorsa!!   Gp.city% g p.pub_name) gpublishersp''%   Ga.city% g a.au_lname) g a.au_fname) gauthorsa!!   G  ta.au_id' '  t.pub_id' ' @$ '  ta.au_id' g  t.pub_id' gX@$ 'ttat.title_id=ta.title_id; trt.title_id=r.title_id8 ptp.pub_id=t.pub_id4 "Total due to author"@$G;; o"Total advances share"!SUM(r.advance*ta.royalty_share)j== o"Total royalties share"h@$K?? o"Num books" COUNT(*)='' o ta.au_id' g t.pub_id' gtitle_authorsta//+ royaltiesr%%# titlest publishersp''%   G  ta.au_id' '  ta.au_id' gt.sales IS NOT NULL2 'trr.title_id=t.title_id8 tatt.title_id=ta.title_id;  . @                  JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^QkJomWdik^YkmYbU666:^YkmYbU6868^YkmYbU6>68^YkmYbU6>6:^YkmYbU6>6<^YkmYbU6>6>^YkmYbU6>6@^YkmYbU6>6B^YkmYbU6>6D^YkmYbU6>6F^YkmYbU6>6H^YkmYbU6>86^YkmYbU6>88^YkmYbU6>8: ^YkmYbU6>8<!^YkmYbU6>8>"^YkmYbU6>8@#^YkmYbU6>8B$^YkmYbU6>8D%^YkmYbU6>8F&^YkmYbU6>8H'^YkmYbU6>:6(^YkmYbU6>:8)^YkmYbU6>::*^YkmYbU6>:<+^YkmYbU6>:>,^YkmYbU6>:@-^YkmYbU6>:B.^YkmYbU6>:D/^YkmYbU6>:F^YkmYbU6>:H^YkmYbU6><6^YkmYbU6><8^YkmYbU6><:^YkmYbU6><<^YkmYbU6><>^YkmYbU6><@^YkmYbU6>>6 ^YkmYbU6>>8 ^YkmYbU6>>:^YkmYbU6>><^YkmYbU6>>>^YkmYbU6>>@^YkmYbU6>>B^YkmYbU6@68^YkmYbU6@6:^YkmYbU6@6<^YkmYbU6@6>^YkmYbU6@6@^YkmYbU6@6B^YkmYbU6@6D^YkmYbU6@6F^YkmYbU6@6H^YkmYbU6@86^YkmYbU6@88^YkmYbU6@8:^YkmYbU6@8<^YkmYbU6@8> ^YkmYbU6@8@!^YkmYbU6@8B"^YkmYbU6@8D#^YkmYbU6@8F$^YkmYbU6@8H%^YkmYbU6@:6&^YkmYbU6@:8'^YkmYbU6@::(^YkmYbU6@:<)^YkmYbU6@:>*^YkmYbU6@:@+^YkmYbU6@:B,^YkmYbU6@:D-^YkmYbU6@:F.^YkmYbU6@:H/^YkmYbU6@<6^YkmYbU6@<8^YkmYbU6@<:^YkmYbU6@<<^YkmYbU6B68J^YkmYbU6B68L^YkmYbU6B68M^YkmYbU6B6:J^YkmYbU6B6:L^YkmYbU6B6:M ^YkmYbU6B6J ^YkmYbU6B6>L^YkmYbU6B6>M^YkmYbU6B6@J^YkmYbU6B6@L^YkmYbU6B6@M^YkmYbU6B6BJ^YkmYbU6B6BL^YkmYbU6B6BM^YkmYbU6B6DJ^YkmYbU6B6DL^YkmYbU6B6DM^YkmYbU6B6FJ^YkmYbU6B6FL^YkmYbU6B6FM^YkmYbU6B6FO^YkmYbU6B6H^YkmYbU6B86^YkmYbU6B88^YkmYbU6B8: ^YkmYbU6B8<!^YkmYbU6B8>"^YkmYbU6B8@#^YkmYbU6B8BJ$^YkmYbU6B8BL%^YkmYbU6B8D&^YkmYbU6B8F'^YkmYbU6B8H(^YkmYbU6B:6)^YkmYbU6B:8*^YkmYbU6B::+^YkmYbU6D68,^YkmYbU6D6:-^YkmYbU6D6'^YkmYbU6D6@'^YkmYbU6D6B'^YkmYbU6D6D'^YkmYbU6D6F'^YkmYbU6D6H'^YkmYbU6D86'^YkmYbU6D88'^YkmYbU6D8:' ^YkmYbU6D8<' ^YkmYbU6D8>' ^YkmYbU6D8@' ^YkmYbU6D8B' ^YkmYbU6D8D'^YkmYbU6D8F'^YkmYbU6D8H'^YkmYbU6D:6'^YkmYbU6D:8'^YkmYbU6D::'^YkmYbU6D:<'`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO-  @ @ @ @@@@@@@@@@@@@@@@ @ @ ^YkmYbU6@:B,^YkmYbU6@:D-^YkmYbU6@:F.^YkmYbU6@:H/^YkmYbU6@<6^YkmYbU6@<8^YkmYbU6@<:^YkmYbU6@<<^YkmYbU6B68J^YkmYbU6B68L^YkmYbU6B68M^YkmYbU6B6:J^YkmYbU6B6:L^YkmYbU6B6:M ^YkmYbU6B6J ^YkmYbU6B6>L^YkmYbU6B6>M^YkmYbU6B6@J^YkmYbU6B6@L^YkmYbU6B6@M^YkmYbU6B6BJ^YkmYbU6B6BL^YkmYbU6B6BM^YkmYbU6B6DJ^YkmYbU6B6DL^YkmYbU6B6DM^YkmYbU6B6FJ^YkmYbU6B6FL^YkmYbU6B6FM^YkmYbU6B6FO^YkmYbU6B6H^YkmYbU6B86^YkmYbU6B88^YkmYbU6B8: ^YkmYbU6B8<!^YkmYbU6B8>"^YkmYbU6B8@#^YkmYbU6B8BJ$^YkmYbU6B8BL%^YkmYbU6B8D&^YkmYbU6B8F'^YkmYbU6B8H(^YkmYbU6B:6)^YkmYbU6B:8*^YkmYbU6B::+^YkmYbU6D68,^YkmYbU6D6:-^YkmYbU6D6'^YkmYbU6D6@'^YkmYbU6D6B'^YkmYbU6D6D'^YkmYbU6D6F'^YkmYbU6D6H'^YkmYbU6D86'^YkmYbU6D88'^YkmYbU6D8:' ^YkmYbU6D8<' ^YkmYbU6D8>' ^YkmYbU6D8@' ^YkmYbU6D8B' ^YkmYbU6D8D'^YkmYbU6D8F'^YkmYbU6D8H'^YkmYbU6D:6'^YkmYbU6D:8'^YkmYbU6D::'^YkmYbU6D:<'^YkmYbU6D:>'^YkmYbU6D:@J'^YkmYbU6D:@L'^YkmYbU6D:B'^YkmYbU6D:D'^YkmYbU6D:F'^YkmYbU6D:H'^YkmYbU6D<6'^YkmYbU6D<8'^YkmYbU6D<<'^YkmYbU6H86'^YkmYbU6H88' ^YkmYbU6H8:'!^YkmYbU6H8@'"^YkmYbU6H8B'#^YkmYbU6H8D'$^YkmYbU6H8F'%^YkmYbU6H8H'&^YkmYbU6H:6''^YkmYbU6H:8'(^YkmYbU6H::')^YkmYbU6H:<'*^YkmYbU6H:>'+^YkmYbU6H:@',^YkmYbU6H64^YkmYbU6H>84^YkmYbU6H>:J4^YkmYbU6H><4^YkmYbU6H>>4^YkmYbU6H>@4^YkmYbU6H>B4`kvkJMMQkkdL[QMmk4`kvkJMMQkku`^4 `kvkJMQk`kvkY`QuMd^o`bk4 `kvkY`QukfQMk4 `kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfoL^YkWQik4 idvJ^mYQk4 mYm^Q+JomWdik4mYm^Qk4JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOJomWdikmYm^Q+JomWdik4foL^YkWQikmYm^Qk4mYm^QkidvJ^mYQk4mYm^QkmYm^Q+JomWdik4)1 @ @ @ @ @ @ @ @ @ @ @ @ @ @*A*B*C*D*E*F*G + + +*<++++++ + + ++ ++++++++++++ + ++ ++++ +!+"+#+$+%+&+'+(+)+* ++ +,++-+/+0+1+2+3+4+5+6+7 +8 +9+.+:+<+=+>+?+@+A+B+C,,, , ,+;,,,, , , , , ,,,,,,, , , , , ,,,,,,,,, ,",#,$,!,%,',(,),*,+,,,&,-,/,0,1,2,3,4 ,5 ,6 ,7,.,8,:,;,<,=,>,? ,@ ,A ,B,9,C,E,F,G,H,D,I,K,L000 0 0,J0000 0 0 0 0 0000000000000000 0 000 0"0#0$0%0& 0' 0(0!0)0+0,0-0.0/0001020304 050*0608090:07+Ky7g+ J  j  b D  d  c ,  OxZ< d'j#xTfBrT6t@  title_id' 'i BETWEEN 1 AND 30 'au_idZ@$' oau_orderB@$-!! o title_id' gseq au_orders###   Gi BETWEEN 1 AND 60 'FutDateDATEADD("m", i, Date())D oMonthsAheadi5'' oseq   Gi BETWEEN 32 AND 2563 'ChCHR(i)) oCharCodei/!! oseq   G t1.seq% 't1.seq+1 = t2.seq0 'distt2.miles - t1.miles: omiles2 t2.miles3 omiles1 t1.miles3 ocity2 t2.city0 ocity1 t1.city0 oseq2t2.seq- oseq1t1.seq- oroadtript2%%! roadtript1%%!   G t1.id$ ' t1.id$ gf@$ 'MovingAvgAVG(t2.price)>## ot1.id$ gtime_seriest2++' time_seriest1++'   G  t1.title_id* '  t1.title_id* gD@$ 'RunningCountCount(t2.sales)F)) oRunningAvgAvg(t2.sales)@%% oRunningSumSum(t2.sales)@%% o t1.title_id* gtitlest2!! titlest1!!   Ge1e2e1.boss_id=e2.emp_id; "Boss name" e2.emp_name@'' o"Employee name" e1.emp_nameH// oemployeese2''# employeese1''#   Gta.au_id IS NULL/ 'ataa.au_id=ta.au_id5  a.au_lname) g a.au_fname) g a.au_id& gtitle_authorsta//+ authorsa!!   G  a.au_id& '  a.au_id& gataa.au_id=ta.au_id5 "Num books"COUNT(ta.title_id)G'' o a.au_id& g/6 @ @ @ @ @ @ @ @ @ @ @ @ @ @,,, ,",#,$,!,%,',(,),*,+,,,&,-,/,0,1,2,3,4 ,5 ,6 ,7,.,8,:,;,<,=,>,? ,@ ,A ,B,9,C,E,F,G,H,D,I,K,L000 0 0,J0000 0 0 0 0 0000000000000000 0 000 0"0#0$0%0& 0' 0(0!0)0+0,0-0.0/0001020304 050*0608090:0;070<0>0?0@0A0=0B0D0E0F0G0H0I 0J 20C22222222 2 2 2 22 222222222222222222 2!2"2#2$22%2'2(2) 2*2&2+2-2.2/20 212,2224252627 2823292;2<2=2> 2?2:2@2B2C2D2E 2F2A2G2I2J2K2L 2M2H2N2P2Q2R2O2S2U552T554VzR4}@ e 9 r H * s 6 [ / h >  q> Q`/['Nz\> k8X:titlest1!!   GZ@3 'TrimmedMean AVG(sales)?'' otitlest1!!   G dsales& /ranking@3+ o e1.sales' g e1.emp_id( gempsalese1%%!   G dsales& /ranking@$+ o e1.sales' g e1.emp_id( gempsalese1%%!   G dsales& /ranking@$+ o e1.sales' g e1.emp_id( gempsalese1%%!   G sales$ 'sales$ gemp_id% gempsales!!! 040 O  G dsales& /sales$ gemp_id% gempsales!!! 3 O  G dsales& /sales$ gemp_id% gempsales!!!   G@3 'RegLent2.id - t1.id + 1< oEndRegt2.id0 oStartRegt1.id4!! otempst2 tempst1   G@3 'RegLent2.id - t1.id + 1< oEndRegt2.id0 oStartRegt1.id4!! otempst2 tempst1   G@3 'RunLent2.id - t1.id + 1< oEndRunt2.id0 oStartRunt1.id4!! otempst2 tempst1   GF@3 'SeqLent2.id - t1.id + 1< oEndSeqt2.id0 oStartSeqt1.id4!! otempst2 tempst1   Gtemps  G  G i 'LVAL : |"(SELECT COUNT(*) FROM titles t2 WHERE t2.sales <= t1.sales) >= (SELECT 0.25 * COUNT(*) FROM titles) AND (SELECT COUNT(*) FROM titles t3 WHERE t3.sales >= t1.sales) >= (SELECT 0.25 * COUNT(*) FROM titles)(SELECT COUNT(*) FROM titles t2 WHERE t2.sales <= t1.sales) > 3 AND (SELECT COUNT(*) FROM titles t3 WHERE t3.sales >= t1.sales) > 3(SELECT COUNT(sales) FROM empsales e2 WHERE e2.sales > e1.sales)(t1.id < t2.id) AND t2.id - t1.id = 1 AND NOT EXISTS( SELECT * FROM temps t3 WHERE (t3.hi_temp <> 50 AND t3.id BETWEEN t1.id AND t2.id) )(t1.id < t2.id) AND NOT EXISTS( SELECT * FROM temps t3 WHERE (t3.hi_temp <> 50 AND t3.id BETWEEN t1.id AND t2.id) OR (t3.id = t1.id - 1 AND t3.hi_temp = 50) OR (t3.id = t2.id + 1 AND t3.hi_temp = 50) )(t1.id < t2.id) AND NOT EXISTS( SELECT * FROM temps t3, temps t4 WHERE (t3.hi_temp <= t4.hi_temp AND t4.id = t3.id - 1 AND t3.id BETWEEN t1.id + 1 AND t2.id) OR (t3.id = t1.id - 1 AND t3.hi_temp < t1.hi_temp) OR (t3.id = t2.id + 1 AND t3.hi_temp > t2.hi_temp) )(t1.id < t2.id) AND NOT EXISTS( SELECT * FROM temps t3 WHERE (t3.hi_temp - t3.id <> t1.hi_temp-t1.id AND t3.id BETWEEN t1.id AND t2.id) OR (t3.id = t1.id - 1 AND t3.hi_temp - t3.id = t1.hi_temp - t1.id) OR (t3.id=t2.id+1 AND t3.hi_temp - t3.id = t1.hi_temp-t1.id) )3(O D@N f  M K * l K ;·a􆇆@ӄfE؁kSkC@&-FSkC@&-SkC@&-FJ@listing05260 @u`@tPDD88888886 @OYniC@ M;AJ@listing05220 @u`@tPDD88888886 @K8gC@rC>J@listing05180 @s`@tPDD88888886 @GGeC@B+J@listing05140 @s`@qPDD88888886 @CVcC@#J@listing05100 @p`@qPDD88888886 @?eaC@J@listing05060 @p`@ oPDD88888886 @;{t_C@aJ@listing05020 @ n`@oPDD88888886 @7]C@S\J@listing04440 @n`@oPDD88888886 @3\C@g&J@listing04400 @n`@ lPDD88888886 @/ZC@"$J@listing04360 @k`@lPDD88888886 @+$YC@ J@listing04320 @k`@lPDD88888886 @'WC@GJ@listing04280 @j`@iPDD88888886 @$qVC@tJ@listing04250 @j`@iPDD88888886 @ zUC@zJ@listing04210 @j`@iPDD88888886 @4TC@#aJ@listing04170 @h|@gPDD88888886 @= SC@CJ@listing04130 @h`@gPDD88888886 @RC@qO/J@listing04090 @e`@ dPDD88888886 @FZQC@1aJ@listing04050 @e`@dPDD88888886 @ PC@$J@listing04010 a@e`@dPDD88888886 @ 렬C@Yt@AccessLayout0 4MR2KeepLocal T@bzz:::::::8 @JENq@JENq@titlestitle_authors0 HHHHHHHHHHF {[Lq@{[Lq@titlesroyalties0 @@@@@@@@@@> H}lMq@H}lMq@publisherstitles0 BBBBBBBBBB@  D x8[t@\t@MSysAccessObjects0 DDDDDDDDDDB B`@xYc@ listing09460 @`@PDD88888886 @ -@RV@listing09450 @`@PDD88888886 @x @Y*@listing09430 Y@`@PDD88888886 @L@8@listing0942a0 @|@RFF:::::::8 @;@L@listing09410 k@`@PDD88888886 @x.}@q_@listing0939c0 c@ `@RFF:::::::8 @-lN0v> r < y C  | K  { K  r A  xR(4@7 'dups  G  G d COUNT(*)) / COUNT(*) >= 1, ' price$ g type# g  title_name) gNumDups COUNT(*)5 oprice$ gtype# g title_name) gdups   G COUNT(*) > 1+ ' price$ g type# g  title_name) gprice$ gtype# g title_name) gdups   Gprice$ gtype# g title_name) gid! gdups   G(((Rnd())<0.25))/ 'titles.sales+ g titles.type* gtitles.title_id. gtitles  G G  GH@3 'TrimmedMean AVG(sales)?'' oY1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @070<0>0?0@0A0=0B0D0E0F0G0H0I 0J 20C22222222 2 2 2 22 222222222222222222 2!2"2#2$22%2'2(2) 2*2&2+2-2.2/20 212,2224252627 2823292;2<2=2> 2?2:2@2B2C2D2E 2F2A2G2I2J2K2L 2M2H2N2P2Q2R2O2S2U552T5555555 5 55 5 55555 55555 5 5 5 555555 5!5" 5# 5$ 5% 5& 5'55(5*5+5,5)LVALid < ( SELECT MAX(d.id) FROM dups d WHERE dups.title_name = d.title_name AND dups.type = d.type AND dups.price = d.price) Y N99Y Y mADataIDLL9> nAYAOIndexv1@<K8[ jҟ|eAgAbA0eAMSysAccounts x@x@ x@x@PhA x@x@ x@x@MR2K8[ࡱ>   Root Entry 1l VBA1l1lVBAProject1l1lVBA1l1ldir|_VBA_PROJECTPROJECT)%PROJECTwm.  !"#$%&'(*+,-x0* pHd books @8= Vh @@> J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\e2.tlb#OLE Autom`ation`mADODB> ADOBDDEB1D10-8DAA006D2EA 4D1DProgram Files\CommonM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 LibraryHE- am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data ObjectsK8[ 2.1 Library @>- P`'AccessVBAWin16~Win32MacVBA6#booksstdole`ADODBslisting0001_and_0003R _EvaluateGetAuthorNameszdb\rs_ Recordseti`au_names7 CurrentDbS OpenRecordset|MoveLast RecordCount{ MoveFirstNEOFau_fnameau_lname ZMoveNextL!GetAuthorNames2n<   ID="{0D167FD7-2A7D-4FB9-B6A9-1AE388B35994}" Name="books" HelpContextID="0" VersionCompatible32="393222000" CMG="E0E21EE422E422E422E422" DPB="C0C23EC13FC13FC1" GC="A0A25EA15FA15F5E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] AcessVBAData/Forms  1l1lCmdbars1l1lModules  1l1lPropData 0PropDataCopyReports1l1lScripts1l1l 0CB0ijMSysDbPropData1Databases1l1l01l1lBlob DirData2CustomGroups1l1lDataAccessPagesK8[ 1l1l 8:;<=S YN@@Y W Y Y  Y  Y  Y Id LValueObjectGuidObjectNameProperty Value@A@B@CYYYId$ObjectGuidProperty$ObjectNameProperty@Hv1b ? ? ? qYNEEY Y  Y Y Y Y Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start WidthEFEGYY Index1PrimaryKeyv1@ D D YN  II Y Y Y Y  Y  Y Y Y  Y Y  Y   Y   Y  DateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimIJYPrimaryKeyv1 HBYNLL Y  Y ( Y  Y  Y  pub_idpub_namecity statecountryLNYYY.rB0Index_B5B73647_1A19_4C2Fv1@ SK\kP05CAAAA PublishingBerkeleyUSA>8( P04CATenterhooks PressBerkeleyUSAD>. P03Schadenfreude PressHamburgGermanyN@2 P02CACore Dump BooksSan FranciscoUSAJD* P01NYAbatis PublishersNew YorkUSAD>.  K@f68Mf6:Mf6<Mf6>Mf6@M 6Y NPP Y Y Ytitle_idadvanceroyalty_rateteotPRPSYP`.rYYYYPrimaryKey"royaltiestitle_idtitlesroyaltiesv1c O g4h5$ T13*T12@KL *T11*T10T09*T08*T07 *T06*T05 *T04*T03`*T02*T01@B* O@@@m68Qm6:Qm6<Qm6>Qm6@Qm6BQm6DQm6FQm6HQm86Q m88Q m8:Q m8<Q  O@@@m68Qm6:Qm6<Qm6>Qm6@Qm6BQm6DQm6FQm6HQm86Q m88Q m8:Q m8<Q ' YANUU  Y  Y Y  YYtitle_id au_idau_orderroyalty_sharet_UW_np_ gUXicuaU_YYYYY(authorstitle_authors0Index_4774F07A_EF52_4B1D*title_authorstitle_id&titlestitle_authorsv1@@ TxV4hF$ T13A01dT12A02dT11A06(T11A04T11A03T10A02dT09A06dT08A06dT07A042T07A022T06A02dT05A04dT04A04(T04A03<T03A05dT02A01dT01A01d Tm68J68Vm6:J68Vm6<J6@Vm6>J6<Vm6>J6>Vm6@J6>Vm6BJ6:Vm6DJ6:Vm6DJ6>Vm6FJ6BV m6HJ6BV m86J6:V m88J6<V m88J6>V m88J6BVm8:J6:Vm8<J68Vv T@@@@m68Vm6:Vm6<Vm6>Vm6>Vm6@Vm6BVm6DVm6DVm6FV m6HV m86V m88V m88V m88Vm8:Vm8<V Y ANZZ  Y  Y P Y  Y Y  YYYtitle_idtitle_nametype pub_id pages price salespubdateZ\Z]YOYTYYKY.rD.rE0Index_EB719F9D_3331_4613 publisherstitlestitlespub_idv1  Y 4. H X u T13P03"(@What Are The Civilian Applications?history rdT12P05 @Spontaneous, Not AnnoyingbiographysbPT11P05:o@Perhaps It's a Glandular Problempsychologyr^T10P05dNot Without My Faberge EggbiographyddRT09P01C@Kiss My Boo-Boochildrens]L<T08P01V`@Just Wait Until After SchoolchildrenwfVT07P03M(@@I Blame My Motherbiography[ cR@T06P018,@@How About Never?biographyaP>T05P01@Exchange of Platitudespsychologyo^JT04P012@But I Did It UnconsciouslypsychologywfRT03P02Cd@@Ask Your System AdministratorcomputeryhXT02P03^%@200 Years of German Humorhistoryo^PT01P01k6`@1977!historyG6( Y@@@m68[m6:[m6<[m6>[m6@[m6B[m6D[m6F[m6H[m86[ m88[ m8:[ m8<[  Y@@@f68[f68[f68[f68[f68[f68[f6:[f6<[f6<[f6<[ f6@[ f6@[ f6@[   titlestitle_authorstitle_authorstitle_idtitlestitle_idzj^N4titlesroyaltiesroyaltiestitle_idtitlestitle_idjZN>,publisherstitlestitlespub_idpublisherspub_idfZF:.authorstitle_authorstitle_authorsau_idauthorsau_idrhZP6v T@@@@J68VJ68VJ68VJ6:VJ6:VJ6:V J6:VJ6<VJ6<V J6>VJ6>VJ6>VJ6>V J6@VJ6BV J6BV J6BV O@@@m68Qm6:Qm6<Qm6>Qm6@Qm6BQm6DQm6FQm6HQm86Q m88Q m8:Q m8<Q QQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0  1  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  0  1  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  0  1  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  0  1  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0  0  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  1 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 0 1 0 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 1 @LVAL>Rάs?titlestitles?troyaltiesroyalties2!publisherspublishers?1title_authorstitle_authorsE?authorsauthorsʾauthorsCreate query in Design viewCreate form in Design viewCreate report in Design viewCreate data access page in Design view y^3zLVAL VMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      7ƚNk뎃jMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      /CU@]zfpMR2lOrientationOrderByOnNameMapDefaultViewRequiredColumnWidthColumnOrderColumnHiddenAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDescriptionGUID?    )xf/2II+x4au_lname  7     m      ( Author last name A/GBgX au_id       m      8 0Unique author identifier <A@ 6wau_fname e      m      * "Author first name B0ABzؕkru phone       m      6 .Author telephone number 8@rUJBaddress       m      $ Author address !^}Gxg^ city        m       Author city m}M!V state       m        Author state |M=O<_n zip       m      8 0Author zip (postal) code tgRFEOp:MR2( ReplicateProject MR2R Title AuthorCompanySubjectComments& Sample database  Chris FehilyZ RSQL: Visual QuickStart Guide, 2nd editionMR26ANSI Query ModeAccessVersionProjVerAuto Compact"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in Remote.Show Values in Snapshot*Show Values in Server.Use Default Page Folder&Default Page Folder6Use Default Connection File.Default Connection FileRow Limit Build0Perform Name AutoCorrect6Track Name AutoCorrect Info8Log Name AutoCorrect Changes4Four-Digit Year Formatting   08.50 #             '     LVAL @ `@άTe άTe άTe άTe άTe άTe άTe άTe άTe άTe άTe LVAL > | bMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      qSGM'aMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      DW>C[S\q) MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      R*+ @=~MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      8ҺuE ŖMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Va`B?ud9MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      f>G:Bs; "Postal code"   MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      dA;JW[ MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      p, /\C!LMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      UcM)fPMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicable[  <      S{G)u[0KvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[H+0 *1 *2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p *0 )1 )2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p )0 (1 (2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p (0 '1 '2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p '0 &1 &2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p &0 %1 %2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p %0 $1 $2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p $0 #1 #2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p #0 "1 "2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p "0 !1 !2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p !0  1  2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p  0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p LVAL @ `$ά? ά? άd&xtitlesά? ά` ά` άTe άTe άTe άTe LVAL m G !ZMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      ~Oe95F<a5title_name  ] MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      "D+cL)MR2BRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden Format[  <      ~_ְGKJiMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       >1IJHy&7MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      bBSTMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      P%#@Ş)4MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      DEIB@ MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       (OXޠ6MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      V~REa?DPLVAL @ `@άX8 άX8 άX8 άX8 άX8 άX8 άX8 άX8 άX8 άX8 άX8 LVAL 8p  \6MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      y} NIG44>MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      =*D?-MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      @sE;z>MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      iUѰBc^xpMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      `N͊sMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      9.;8C]L=AMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      ¤=CmE15title_name  ] MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Jmms)Lҥ?{5title_name  ] MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      0.K=U~_5title_name  ]  LVAL m G !hBMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      @ŕdm@8}FMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      1BVB^`'MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      rMXNFMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      fi}-:L+C\~MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      n@BʼnR +  {  g T A -}jVC0 lYE2 n[HD0 C1 C2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p C0 B1 B2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p B0 A1 A2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p A0 @1 @2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p @0 ?1 ?2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p ?0 >1 >2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p >0 =1 =2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p =0 <1 <2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p <0 ;1 ;2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p ;0 :1 :2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p :0 91 92֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 90 81 82֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 80 71 72֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 70 61 62֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 60 51 52֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 50 41 42֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 40 31 32֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 30 21 22֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 20 11 12֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 10 01 02֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 00 /1 /2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p /0 .1 .2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p .0 -1 -2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p -0 ,1 ,2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p ,0 +1 +2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 8LVAL m G !hZMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Di+PENq!>MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddenC  <     MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      v "A[`sMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      6a0LCP@rMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      9 J!|V{bMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      &,=oD'JMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      YC5Fc;MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      h!LȈd#8MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      8r!MMMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       ,EqoLVAL @ `@άX άX άX άX άX8 άX8 άX8 άX8 άX8 άX8 άX8 LVAL m G s *TfMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      M_Jl=-dMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      GHJq(HL[@:"Biography publication dates"  Z MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      N`CMkC(""Biography sales"  J MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       jBG5$+GB¿{; "Author name"  4 MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddenC  <     MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      4K!pZA& "pages/10point0"  5 MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      tncDªuxMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      gR&nIH1kwhMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      LA$KRLVAL @ `@άf`2 άf`  άf`  άf`  άf`  άf`  άf`  άf`  άf`7 άf`  άf`  KvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[H]0 \1 \2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p \0 [1 [2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p [0 Z1 Z2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p Z0 Y1 Y2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p Y0 X1 X2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p X0 W1 W2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p W0 V1 V2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p V0 U1 U2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p U0 T1 T2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p T0 S1 S2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p S0 R1 R2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p R0 Q1 Q2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p Q0 P1 P2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p P0 O1 O2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p O0 N1 N2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p N0 M1 M2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p M0 L1 L2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p L0 K1 K2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p K0 J1 J2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p J0 I1 I2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p I0 H1 H2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p H0 G1 G2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p G0 F1 F2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p F0 E1 E2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p E0 D1 D2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 8LVAL m G !ZMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      3&CH3QMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Kz~MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       fiKGѿ͜MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      F~yMVเzMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddenC  <     MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      {KBi,VMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      I[=WO"pMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Wϫ [N?vzMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      'ıGJm1?^MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      ߢ& AδLVAL @ `@άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 άf`2 LVALm G MMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      thA҈J;[@:"History and biography sales"   MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddeno  <       ((((listing0528.["price(Decimal)"]=21.99))) AND ((listing0528.["price(Decimal)"]=21.99))) AND ((listing0528.["price(Decimal)"]=21.99)) z#4Kl2>NA& "price(DECIMAL)"   MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddenC  <     MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      GDUBThIlMR2BRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden FormatC  <     E "Time"    hh:nn:sse"Timestamp"   . &yyyy-mm-dd hh:nn:ss4 "Date" yyyy-mm-ddMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      a!}$F\NMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      5MUN MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      dt/C?7<LVAL @ D$άV[# άV[# άV[# άV[#&xtitlesάV[# άV[# άJuB άV[# άxLE άf`2 LVAL Bn H KMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      Fc|M+H6MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <       =k~En#4OB?$"Max last name"   MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      ܤD&dMR2ZRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHiddenDescription Format[  <      nb`F6O`L*$"Earliest pubdate" yyyy-mm-ddMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      j 8'OM >eMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      f$˼Nls INMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      '^J@MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      =wO!r8A& "Sales category"   MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      jM^VK + price    p$F׍hE֊i"Fهl%K?(AC@(AC@MSysAccessXML0 4MR2KeepLocal  T|||<<<<<<<: @@T@listing09440 Y@`@PDD88888886 @ȱkg@ᐖ@listing09400 k@`@ PDD88888886 @"T@Bɕ@listing09240 @|@PDD88888886 @Hnp@@listing09200 @`@PDD88888886 @|U@@)@listing09160 @`@PDD88888886 @h @dp@listing09100 @`@PDD88888886 @mC@mC@listing07290 @ `@ PDD88888886 @aC@&ڛJ@listing0725b0 @`@RFF:::::::8 @P瞍C@ߧԛJ@listing07220 @`@PDD88888886 @=C@UʛJ@listing07180 @`@ PDD88888886 @חC@œÛJ@listing07140 @`@PDD88888886 @,qC@^佛J@listing07100 @`@PDD88888886 @jC@($J@listing07050 @`@PDD88888886 @ )C@-J@listing0703a0 @`@RFF:::::::8 @C@T\.J@listing06210 @`@PDD88888886 @}C@%J@listing06170 @`@PDD88888886 @xtC@J@listing06130 @~`@PDD88888886 @tC@_nJ@listing06090 @~`@ }PDD88888886 @p[}C@Y J@listing0608a0 @|`@}RFF:::::::8 @lYzC@/~-z @listing0606c0 @|`@}RFF:::::::8 @hxC@>rJ@listing0605b0 @{`@zRFF:::::::8 @d`uC@Zu_J@listing0604a0 @{`@zRFF:::::::8 @`asC@kUJ@listing0602c0 @{`@zRFF:::::::8 @\pC@SJ@listing0601b0 @w|@vRFF:::::::8 @X>nC@HLJ@listing05310 @w`@vPDD88888886 @KvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[Hv0 u1 u2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p u0 t1 t2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p t0 s1 s2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p s0 r1 r2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p r0 q1 q2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p q0 p1 p2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p p0 o1 o2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p o0 n1 n2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p n0 m1 m2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p m0 l1 l2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p l0 k1 k2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p k0 j1 j2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p j0 i1 i2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p i0 h1 h2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p h0 g1 g2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p g0 f1 f2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p f0 e1 e2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p e0 d1 d2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p d0 c1 c2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p c0 b1 b2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p b0 a1 a2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p a0 `1 `2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p `0 _1 _2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p _0 ^1 ^2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p ^0 ]1 ]2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p LVAL @ `@ά| άV[# ά{AG ά$1 άV[# άV[# άV[# άV[# άV[# άV[# άV[# LVAL m Z 4{MR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      -ennvIcMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      8AGLXtMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      󚬼DkfMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLReplicableColumnWidthColumnHidden[  <      {N +  {  g T A -}jVC0 lYE2 n[H0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 1 2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p 0 ~1 ~2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p ~0 }1 }2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p }0 |1 |2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p |0 {1 {2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p {0 z1 z2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p z0 y1 y2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p y0 x1 x2֮hɃ)nФ^|Vzk{e/9Mt^^#9UVq8 r Gs_]v'1=`5bd ֚l^[MC~75p x0 w1 w2֮hɃ)nФ^|Vzk