SELECT date_format pr urgent_time_to urgent_time_to date_format pr urg

1
SELECT *, date_format(pr.urgent_time_to, '%H:%i') urgent_time_to, date_format(pr.urgent_time_from, '%H:%i') urgent_time_from, DATEDIFF(NOW(), pr.date) date, DATEDIFF(pr.urgent_date, NOW()) urgent_date, ci.name city_name, au.name user_name, pr.id request_id FROM parent_requests pr JOIN accounts_users au ON au.id = pr.parent_id JOIN cities ci ON pr.city_id = ci.id JOIN join_parent_regions jpr ON au.id = jpr.user_idJOIN cities ci2 ON jpr.region_id = ci2.id WHERE au.name != '' AND pr.request_type = :request_type AND pr.employment = :employment AND pr.request_type = :request_type AND pr.weekend = :weekend AND pr.holidays = :holidays AND pr.salary_sum <= :right_salary_sum AND pr.salary_sum >= :left_salary_sum AND pr.salary_type = :salary AND au.city_id = :city_id AND (DATEDIFF(pr.urgent_date, NOW()) >= 0 || pr.urgent_date = false) ORDER BY request_type, : LIMIT 0, :