INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         2 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'SPINACH PASTA');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'GARLIC BREAD WITH CHEESE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'PRAWN COCKTAIL');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'BAKED PORK FILLET');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'STEAK AND MUSHROOM PIE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'OVEN BAKED BREAST OF DUCK');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'CHOCOLATE FUDGE CAKE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'RASPBERRY MERINGUE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'CRÈME BRULÉE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         3 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Mavis' AND
           b.start_time = '2005-11-20 18:00:00' AND
           m.item = 'TEA');


INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         2 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'COFFEE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         2 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'MOULES MARINEIERE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'KING PRAWNS');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'FISHERMAN\'S PIE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'MARINATED VENISON STEAK');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'HAZELNUL AND ORANGE ROULADE');

INSERT INTO orders (booking_id,menu_id,quantity)
  SELECT b.id AS "booking_id",
         m.id AS "menu_id",
         1 AS "quantity"
    FROM booking_view AS b
    CROSS JOIN menu AS m
    WHERE (b.customer_name = 'Coulter' AND
           b.start_time = '2005-11-20 16:00:00' AND
           m.item = 'CHIPS');