Skip to content

Instantly share code, notes, and snippets.

View salgadobreno's full-sized avatar

Breno Santos Salgado salgadobreno

  • Origem Motos
  • Brasília, Brazil
View GitHub Profile
-- there's 5 events in the range 2010-10-15 to 2010-10-21
-- event1,event2,event3 and event4 have start_at in 2010-10-20
-- and event5 is on 2010-10-21
-- thats their tags: event1{tag1,tag2,tag3,tag4}, event2{tag1,tag2,tag3}, event3{tag1,tag2}, event4{tag1}
-- and event5 has only 'tag4'... so..
-- the tag count in the range 2010-10-15 to 2010-10-21 should display count = 2 for tag4...but its ignoring
-- the 2010-10-21 day, what is wrong with this select?
-- event with id = 13 is the one with tag4 with the start_at thats being ignored(2010-10-21)
sqlite> select events.* from events where events.id = 13;