-
ROW...............ID..................TYPE............SEQ
1.....................1.....................inc...............A
2.....................5.....................exc...............B
3.....................7.....................inc...............C
4.....................7.....................exc...............CI have a table like this; how do I get only the records that for a given ID and SEQ have either both inc and exc or just inc?
A join? A group by?
in this example, Rows 1,3,4 are all good
-
"Darkness cannot drive out darkness; only voting in the lfgss photocomp can do that" - MLK
Apologies if I missed anyone off, have at it.
Skydancer - Night Vision ()
https://www.lfgss.com/comments/13929214/
zazkar - Acton ()
https://www.lfgss.com/comments/13929644/
Mi7rennie - last light before the darkness ()
https://www.lfgss.com/comments/13932687/
xDOMx - clear night ()
https://www.lfgss.com/comments/13932850/
moocher - the onset of darkness ()
https://www.lfgss.com/comments/13932905/
Rik_van_looy - artificial light ()
https://www.lfgss.com/comments/13932960/
WillMelling - darkness ()
https://www.lfgss.com/comments/13932970/
d0cA - the battle against darkness ()
https://www.lfgss.com/comments/13933366/
h2o - sol y sombra (1)
https://www.lfgss.com/comments/13933704/
moorhen - darkness ()
https://www.lfgss.com/comments/13933759/
MetalMelly - guinness darkness ()
https://www.lfgss.com/comments/13933876/
Mattioats - colours in the darkness ()
https://www.lfgss.com/comments/13933924/
AlphaOmega - darkness ()
https://www.lfgss.com/comments/13934001/ -
-
-
Our Sky subscription is £134 a month including broadband, plus movies, sport etc. £134! I really dont want to give Rupert Murdoch £1500 pa.
Definitely need broadband from a provider, but what cheap options are there for viewing?
We already have an amazon prime account and I think netflix but dont use either. Will this get us enough stuff to watch?
What other devices are there? -
-
-
Wait But Why covers AI.
https://waitbutwhy.com/2015/01/artificial-intelligence-revolution-1.html
-
For Sale - Further Reductions – Paul Levers, Shimano Tiagra, Thompon post, Bullhorn bars, Exustar Pedals, Crank, Chainring, Frame and Forks
A pair of Paul brake levers. LHS is missing the bolt. Will see if I can find it in the shed but sold without
SOLDA pair of Shimano Tiagra brakes. Forged in the glowing fires of Japan these will make you stop
£15 was 40 then 35 then 25Thompson stem. The shiniest of all stems. 90 mm, 5 degree fits a 25.4 handlebar
£15 was 30 then 25 then 20Handlebars:
A Nitto straight bar 25.4 – cut down length is 42.cm just under 17 inches
SOLD
Generic bullhorn bars, again 25.4
£5 was 10Combination of Pedals/Crank/Chainring
48t BCD130 chainring from Brick Lane Bikes around 8 years ago. Good teeth, shiny. Two of the bolts won’t come undone, so it comes pre-attached to a 165mm crank (also from BLB)
At the other end is an Exustar track pedal. Smooth like butter. Pedal bolt won’t come undone.
Matching other crank also with pre-attached pedal. Remaining bolts for crank and chainring all present
£30 was 60 then 50 then 40Fork and Frame, including BB and Thompson seatpost
Small frame from BLB 8 years ago approx. Horizontal dropouts. I’ve given it a basic clean, but let’s be clear it would benefit from some TLC. Comes with 4 spacers, Cane Creek thing the name I’ve forgotten. Seatpost is stuck (or pre-attached)
£50 was 100 then 80 then 60Prefer not to post, can meet in Reading, or somewhere between Paddington and Canary Wharf
Happy to be corrected if these prices are way off.
Purchase the whole lot and you’ll get a discount. -
the onset of #darkness
-
-
-
-
-
-
-
-
-
there was some talk of it back in the beginning but i dont think there's a rule either way. @mi7rennie is the arbiter of all such things.....
-
otherwise we have to send @mi7rennie and @Oliver Schick round to have a word
-
Thanks. Got distracted by Halloween so will investigate this tomorrow