Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT vd.vehicle_id FROM person_data pd, vehicle_data vd
- WHERE pd.person_id IN (105870,105768,105769,105863,105763,105777,109876,105836,105821,105957,103858,115350,105855,111392,120479,124102,124146,105773,105833,103872,105854,105818,105849,105869,114682,115552,103357,105827,105861,110519,121990,105868,105939,125850,105867,105780,105840,105872,112318,121992,105792,115342,126295,105779,116409,124765,125852,105772,105857,107362,121984,103365,114609,105839,119720,105825,105765,105814,105852,105829,106251,105859,105834,125849,105770,105933,105819,105874,107737,105766,105843,110518,109988,134690,366894,655303,655305,655304)
- AND pd.event_date >= SYSDATE - 128
- AND pd.vehicle_data_id = vd.vehicle_data_id;
- SELECT * FROM gu_vehicle;
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119031,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187578,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123044,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (184077,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (196365,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123042,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187615,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169516,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119495,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (195241,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169363,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119885,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122643,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122741,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119554,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (188726,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123020,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (190856,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123041,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169522,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (120898,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (184075,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123367,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (194336,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123038,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169527,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169549,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122766,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169524,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187585,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123220,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123146,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123363,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169515,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (120917,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (194346,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (183914,213019);
- INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (121272,213019);
- COMMIT;
- SELECT * FROM gu_vehicle
- WHERE gui_user_id = 213019;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement