Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- left join travel_routes tr
- on ts.travel_route_id=tr.id
- where ts.bus_type_id='3'
- and ts.weekday = '6'
- and tr.`from`='accra'
- and tr.`to`='takoradi'
- order by ts.id desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement