Advertisement
Guest User

Untitled

a guest
May 20th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. select ts.travel_company_id, ts.id,ts.travel_route_id,ts.departure_time,ts.weekday, ts.bus_type_id,tr.`from`,tr.`to`,ts.created_at from travel_schedules ts
  2. left join travel_routes tr
  3. on ts.travel_route_id=tr.id
  4. where ts.bus_type_id='3'
  5. and ts.weekday = '6'
  6. and tr.`from`='accra'
  7. and tr.`to`='takoradi'
  8.  
  9. order by ts.id desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement