user: Question: How many people are there for Glengallan having a Rosenthal population less than 1582 for years before 1976 with a total population of 25917?
Columns: ['Year', 'Population (Region total)', 'Population (Stanthorpe)', 'Population (Warwick)', 'Population (Allora)', 'Population (Glengallan)', 'Population (Rosenthal)']
Types: ['real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1933.0, 25016.0, 6934.0, 6664.0, 2624.0, 6334.0, 2460.0]
SQL:

assistant: SELECT "Population (Glengallan)" FROM "Table" WHERE "Population (Rosenthal)" < 1582.0 AND "Year" < 1976.0 AND "Population (Region total)" = 25917.0;