SELECT t3.companyIDN IDN, t4.companyName FROM prd_fly_dates_combinations t1 LEFT JOIN prd_fly_flight_registry t2 ON (t1.dateFromID = t2.IDN OR t1.dateToID = t2.IDN) LEFT JOIN prd_fly_flights t3 ON t2.flightIDN = t3.IDN LEFT JOIN sys_companies t4 ON t3.companyIDN = t4.IDN WHERE t3.locationFrom = AND t3.locationTo = AND t2.vstatus = 1 GROUP BY t3.companyIDN