CREATE TABLE table_52472 ("Productions" CLOB, "Rose" CLOB, "Louise" CLOB, "Dainty June" CLOB, "Herbie" CLOB, "Director" CLOB)

What production had Angela Lansbury as Rose and Barrie Ingham as Herbie?
SELECT "Productions" FROM table_52472 WHERE "Rose" = 'angela lansbury' AND "Herbie" = 'barrie ingham'
SELECT "Productions" FROM "table_52472" WHERE "Herbie" = 'barrie ingham' AND "Rose" = 'angela lansbury'