Miscellany

SELECT id FROM host WHERE host_template_id = 9 AND id NOT IN (SELECT host_id FROM host_graph WHERE host_graph.host_id = host.id AND host_graph.graph_template_id = 45);foreach (select_ids_from_above as id){ INSERT INTO host_graph (host_id, graph_template_id) VALUES (:id, 37)}