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?
CREATE TABLE "population" (
  "year" real,
  "population_total" real,
  "caboolture" real,
  "pine_rivers" real,
  "redcliffe" real
);
SELECT COUNT("pine_rivers") FROM "population" WHERE "year">1947 AND "redcliffe"<'68,877' AND "population_total">'50,785' AND "caboolture">'12,207';