 to be.
I am open minded at most parts but not enough to explore the veggies (laughs). I am a carnivore that loves fruits and drinks tea. I was introduced very early to the world of tea but never fully got interested until the beginning of 2013. I frequent David’s Tea – it’s the most accessible. I drink my tea whilst browsing through the world of fashion, arts and illustration; playing video games (PS3 & PC); reading books and mangas; watching Disney and Miyazaki films, and anime; gushing over how awesome the Green brothers are — all of which I regularly do on the daily meaning every hour is tea time!
Born in the Philippines, grew up in America, and recently moved to Canada, I have yet to explore more of the world.More cyclists = safer roads.
It's been shown already by Jacobsen 2003 - the number of accidents is inverse to the number of cyclists on the road. Hence partly why there are so few accidents in the Netherlands - and partly why there are so many more in London - drivers aren't looking for cyclists as relatively so few of them.
More cyclists= safer roads.
More seriously, there are a lot of valid points in the Guardian article. Now I do in fact wear lycra, for the performance not the image I might add, and I wouldn't cycle a yard without my helmet (third in three years, one retired with a big hole, the other split in two).
But I wholeheartedly agree that normalisation of cycling is a good thing in every way, and for most people that means not looking weird.
On a tangent from this, here's a question I was reminded of this morning - when cars start to encroach on the bike lane, & I'm not in a position either to get ahead or drop behind, I give them a polite "hello I'm here" tap on the window. Most drivers react either in great shock and surprise, or anger, which makes me wonder how effective this tactic is, but what else do you do?
keep tapping - stay safe.
As I undertake I point to the cycle lane and give them a long, lingering stare. I used to bang on their near-side wing but have decided this may put me on the wrong side of the law.
If it's a prolonged and bad case then I get verbal, as I would with mobile phone drivers or those not indicating and cutting me up.
In the place where I live more people commute daily by bicycles rather than by cars.
than it would harm. What do you think?
I think it is also how some drivers see cyclists over here, as a pest and are happy to treat you like one.
From what I have seen in places like France, it is very different.
Interesting article in the Guardian,however the bit about automatic presumtion of innocence of a cyclist when involved in a collision with a car is debatable. Most accidents involving cyclists and motor vehicles are caused at junctions and crossing points. Crossing points are areas marked for cyclists to cross a road but have no traffic light. Most of the time road users have right of way at these points and cyclists must cross when they think that it is safe to do so.
Also commuting, the article gives the impression that almost everybody cycles to work, school etc. My god, if only that were true.I work at a company 10 miles from my house which employs 450 people i am the only person who cycles to work all the year round. I have one colleague who cycles maybe 3 days out of five and there are three or four more who cycle occasionaly.The survey is not accurate. You only have to look at any major Dutch town or city in the morning or evening rush hour and ask yourself where are all these vehicles coming from or going to.Ok you will see a lot of commuters on bikes but a lot more in cars.
Q: Amount of time for giving the date I'm trying to get a report in MySQL for consecutive days based on activity recorded. I have the start date&time and end date&time of a given status. My goal is to receive a report in a form:
Status|Date|Sum of activity
The problem that I've encountered is that some activities start i.e. 2019-12-12 18:21:12 and ends the next day 2019-12-13 03:21:12. Is there a way to let's say split the result for one date until 23:59:59 and add the rest of time to the following day? So far I have a code below, but it just sums the timestampdiff.
USE db;
SELECT
  table1.status,
  left(table1.start_time, 7)'Date',
  sec_to_time(
    sum(
      timestampdiff(
        second,
        table1.start_time,
        (
          case when table1.end_time is null then now() else table1.end_time end
        )
      )
    )
  ) 'Sum of activity'
FROM
  table1
GROUP by 1,2

Update : Let me clarify a bit my question. I have some activities that take for example 36 hours, starting on 2019-12-20 and ending on 2019-12-22. I need a composed monthly report with each day in the month selected from start_time, so for the example described above (36h over 3 days) I would like to get: 
Activity1|2019-12-20|3h 
Activity1|2019-12-21|24h 
Activity1|2019-12-22|9h

Update2: Thank you for the 2nd update,but the proposed code works only for the first record in the dataset (for more records the time is not summed up) and doesn't take into account the activity type. I will provide more data maybe it will help: 
     Activity  start_time           end_time 
     1048      2019-12-27 06:42:51  2019-12-27 07:11:42 
     1048      2019-12-29 07:07:11  2019-12-29 07:08:59 
     1048      2019-12-29 07:09:19  2019-12-29 07:21:10 
     2066      2019-12-25 07:08:00  2019-12-25 19:01:17 
     2066      2019-12-25 19:01:17  2019-12-26 06:55:15 
     2066      2019-12-26 06:55:15  2019-12-26 18:20:51


A: You can use date() function :
select status, date(start_time) as date, count(*) as "Sum of activities"
  from table1
 group by status, date(start_time);

Demo
Update (depending on your comment): Try to use 
select status, date(start_time) as date, 
       sec_to_time(sum(timestampdiff(second,
                                     start_time,
                                     (case
                                       when end_time is null then
                                        now()
                                       else
                                        end_time
                                     end))))
       as "Sum of activities"
  from table1
 group by status, date(start_time);

Update2 : To accomplish the last mentioned duty, need to generate rows firstly :
select date1, 
       extract( hour from
       sec_to_time(
                   sum(case
                       when date1 = date(start_time) then
                    timestampdiff(second,start_time,date2)
               when date1 = date(end_time) then
                    timestampdiff(second,date1,end_time)
               else
                    timestampdiff(second,date1,date2)              
               end     
                    )) ) as "Time Difference as hour"
  from
  (
   select @cr := @cr + 1 as rn,       
          date_sub(date(end_time), interval date(end_time)-date(start_time) - @cr + 1 day) as date1,
          date_sub(date(end_time), interval date(end_time)-date(start_time) - @cr day) as date2,
          start_time, end_time
     from information_schema.tables c1 
    cross join ( select @cr := 0 ) r
    cross join table1 t
    where @cr < date(end_time)- date(start_time)+1
  ) q
  group by date1;

Demo 2
removing extract( hour from ) part you can get the whole difference upto second precision.
Shankill Castle started as a Bulter tower-house near the ruins of an old church. Peter Aylward bought the lands from his wife's family, the Butlers, in 1708, and it was rebuilt and set in a formal landscape with a vista to the front and canal to the rear. In the 19th century, it was enlarged and castellated, serpentine bays added to the canal and an unusual polyhedral sundial given pride of place on a sunken lawn. Other additions were a gothic porch bearing the Aylward crest and a conservatory. The stable-yard and the castellated entrance to the demesne are attributed to Daniel Robertson. The interior preserves much of its 18th-century character and features including a Georg