RESET-VIEW-TABLE-top-5-touch

-- top 5 touch Reset VIEW TABLE
DROP VIEW IF EXISTS `v_top_vs`;
create view v_top_vs as
SELECT gvauser_id as pilot , min(abs(LandingVS)) as vs FROM pirepfsfk group by pilot
UNION
SELECT pilot_id as pilot , min(abs(LandingVS)) as vs from reports group by pilot
UNION
SELECT gvauser_id as pilot , min(abs(landing_vs)) as vs from vampireps
group by pilot order by vs asc limit 5;