CREATE TABLE table_71057 ("Year" FLOAT, "Population  ( Total ) " FLOAT, " ( Caboolture ) " FLOAT, " ( Pine Rivers ) " FLOAT, " ( Redcliffe ) " FLOAT)

What is the Pine Rivers total population after 1947 with a Redcliffe population smaller than 68,877, a total population greater than 50,785, and a Caboolture population greater than 12,207?
SELECT COUNT("(Pine Rivers)") FROM table_71057 WHERE "Year" > '1947' AND "(Redcliffe)" < '68,877' AND "Population (Total)" > '50,785' AND "(Caboolture)" > '12,207'
SELECT COUNT("(Pine Rivers)") FROM "table_71057" WHERE "(Caboolture)" > '12,207' AND "(Redcliffe)" < '68,877' AND "Population (Total)" > '50,785' AND "Year" > '1947'