CREATE TABLE table_47342 ("Game" FLOAT, "Date" CLOB, "Opponent" CLOB, "Score" CLOB, "Location" CLOB, "Record" CLOB)

What was the record when they played in the Miami Arena, before game 24?
SELECT "Record" FROM table_47342 WHERE "Game" < '24' AND "Location" = 'miami arena'
SELECT "Record" FROM "table_47342" WHERE "Game" < '24' AND "Location" = 'miami arena'