I would like to optimize this SQL statement: SELECT hyobjects_id, hyobjects_globalpriority FROM hyobjects, hyobjectypes, actionlltypes WHERE hyobjects_hyobjectypes = hyobjectypes_id AND hyobjectypes_actionlltypes = actionlltypes_id AND actionlltypes_id = 1 UNION SELECT hyobjects_id, hyobjects_globalpriority FROM hyobjects, actionstatuses, actionlltypes WHERE actionstatuses_id = hyobjects_actionstatuses AND actionstatuses_actionlltypes = actionlltypes_id AND actionlltypes_id = 1 EXCEPT SELECT hyobjects_id, […]