NW WA Meet / BS Thread

A friend of mine used to baby sit London Keys and I have a mutual friend of Miko Sinz (went to Kentwood HS I believe) and Evelyn Lin.

Before she became a porn star London Keys was a stripper and my buddy had her number (she was from shoreline I believe) but we never partied with her. Ah well.

 

Loaner shocks so people's trucks are still drivable whiler their shocks are being rebuilt.

 

Do you offer rebuilds? Are you charging a core?

 

What's the difference between these two?

select *
from dbo.Bowler_Scores
where RawScore =
(select max(RawScore) as HighestRawScore
from dbo.Bowler_Scores);

select *
from dbo.Bowler_Scores as bs1
where RawScore = (select max(RawScore) as HighestRawScore
from dbo.Bowler_Scores as bs2
where bs1.MatchID = bs2.MatchID);

So the first one we're just looking at the highest RawScores from dbo.bowler_scores while the 2nd one we're only looking high scores that have the same MatchID in the subquery?

 

Yup to the rebuilds. It will be a same day rebuild usually, so no core required. But if there's additional parts needed or something, these loaner shocks can be slapped in real quick so that truck can be driven in the meanwhile.

 

he did say it was hard to tell since its not actually installed in a lower but rather a fake lower thingy Larue has.

And anyone paying 240 for a SSA-E is paying 75 bucks to much. (or least 40 if they are impatiant)

 

Why three?

 

Anyone interested in an m&p 10? .308 ar10, 18" barrel, 10rnd magpul pmag, no scope. 811311 model. Will include a warne cantilever scope mount for 30mm tube. $1300?

 

Had a 30% off flyer. Ar-15, ar-10 and 300 blk.

 

Yes,
The first one returns the entire dbo.Bowler_Scores record of the player with the Max RawScore value from the same table.
The second one, it looks like it returns the highest score per match.
Without knowing the table structure (data dictionary), I can only go by theory.

 

Anyone here rocking an AR Pistol?

 

Yes, as are a few others

 

Oooo what’s your build? I got one as well.

 

Mines (well mine and dads) arent anything special at all for AR pistols. Honestly we dont shoot them hardly ever. Just a standard lower with a pistol buffer tube (no brace) and PSA uppers. hell i dont even remember what trigger is in them.

We both have SBR's so shoot those over the pistols. We had the pistols before SBR's were legal here and before the whole brace crap started up. Soon as SBR's were made legal I snuck in our applications before they were temporarily stopped while the law text was fixed

 

I’m trying to get my truck more trail worthy because I think some of you guys may be into something I’m into, I really don’t like going to the range as much as shooting outside, in fact I haven’t taken anything out of the safe in about two years because I lost my Paul Bunyan connection, I think that was the last range I really liked. That said, am I wrong in assuming some of you know some good spots outside to unload a few rounds?

 

The only place I shoot is Wades and I hate myself for it.

 

Sweet, thanks. That's what I was thinking.

 

I stopped going when my mutual buddy stopped working there. No more free shit.

Have you gone to the black diamond gun club?

 

I have not. I do friday night rifle league with @scollins which is pretty fun but would love to do more outside in general. Kinda interested in shooting trap/skeet too but havent explored much.

 

I hate going to the range. Costly, and not nearly as fun. There's quite of few of us here that head out to the hills to shoot. Whether some wish to share those said spots is another thing entirely. That said, there are groups that semi-regularly post on the monthly meet-up thread for shooting runs. Just keep an eye out.

Edit: Whoops. Wrong year.... Here we go.

https://www.tacomaworld.com/threads/march-2019-seattle-area-meet.595507/