select order_id from ec_customer_service_issues where issue_id=:issue_id select issue_type from ec_cs_issue_type_map where issue_id=:issue_id select first_names as d_first_names, last_name as d_last_name, user_id as d_user_id from cc_users where email =lower(:email)