Write SQL Query

Hi everyone

We have a single MySQL Database Table called "visits"

id (INT)
memberid (varchar) Member ID
branchuuid(varchar) Branch ID
arrival (bigint) UNIX TIMESTAMP
departure (bigint) UNIX TIMESTAMP
duration (int) Seconds

I want to run a select query on a Member to identify the branches they have visited, their arrival and departure times during the last 2 weeks where they stayed for at least 15 minutes (900 seconds).

Then using this list of Branches and Arrival / Departure Times I want to run another Select Query based on who else was at these branches and stayed at least 15 minutes (900 seconds) at the same time as the First Member.

For example

Branch 1

First Member Arrived at 1pm on Monday
First Member Departed at 2pm on Monday

Search is based on a Member that visited Branch 1 between 3pm and 4pm on Monday does not count. Main Member wasn't there.

Search is based on a Member that visited Branch 1 between 1:50pm and 2:15pm on Monday does not count. Main Member only matches for 10 minutes not 15 or more

Search is based on a Member that visited Branch 1 between 1:30pm and 2:00pm on Monday does count. Both Member and Main Member were at the same location at the same time for at least 15 minutes.

The query should generate a distinct list of Members who came into contact with the Main Member for at least 15 minutes during this last 2 weeks.

The query just asks for a MEMBERID and generates a list of MEMBERIDs who came into contact with same for at least 15 minutes during the last 2 weeks.

So both SELECT queries are part of a single MAIN QUERY.

Good luck