SELECT dc_route_stops.*, dc_routes.* FROM dc_route_stops LEFT JOIN dc_routes on dc_route_stops.route_id = dc_routes.route_id WHERE route_stop_id = ? LIMIT 1

SELECT dc_stops.*, dc_route_stops.*, dc_routes.route_name, dc_zones.*, connection_stop_id, connectionurl, linkdesc, main_route_id, connect_route_id FROM dc_stops LEFT JOIN dc_route_stops ON dc_stops.stop_id = dc_route_stops.stop_id LEFT JOIN dc_zones ON dc_route_stops.zone_id = dc_zones.zone_id LEFT JOIN dc_connections ON dc_route_stops.route_stop_id = dc_connections.route_stop_id  LEFT JOIN dc_routes on dc_route_stops.route_id = dc_routes.route_id WHERE dc_stops.stop_id = ?  AND dc_stops.active >= 1 ORDER BY dc_route_stops.route_id