SELECT parameter.id, 
           parameter.parameter_id, 
           parameter.hash, 
           parameter.name_display, 
           object_status.type_name 
FROM parameter, object_status 
WHERE exists (SELECT * FROM parameter_history 
                    WHERE parameter_history.parameter_id = parameter.id 
                    AND parameter_history.date_time 
                    BETWEEN '2013-07-21 00:00:00' AND '2013-08-06 00:00:00') 
AND parameter.device_id = 12 AND object_status.id = parameter.status_id;

CREATE TABLE IF NOT EXISTS object_status(
id INTEGER PRIMARY KEY AUTOINCREMENT,
type_name VARCHAR(30) NOT NULL
);

CREATE TABLE IF NOT EXISTS parameter(
id INTEGER PRIMARY KEY AUTOINCREMENT,
parameter_id INTEGER NOT NULL,
hash VARCHAR(256) NOT NULL,
name_display VARCHAR(30),
device_id INTEGER NOT NULL,
status_id INTEGER NOT NULL,
FOREIGN KEY(device_id) REFERENCES device(id),
FOREIGN KEY(status_id) REFERENCES object_status(id)
);

CREATE INDEX IF NOT EXISTS param_deviceid_index 
ON parameter(device_id);

CREATE INDEX IF NOT EXISTS parame_hash_index 
ON parameter(hash);

CREATE INDEX IF NOT EXISTS param_paramid_index 
ON parameter(parameter_id);

CREATE TABLE IF NOT EXISTS parameter_history(
id INTEGER PRIMARY KEY AUTOINCREMENT,
date_time TEXT NOT NULL,
value TEXT,
alias TEXT,
avary_level INTEGER,
text1 TEXT,
text2 TEXT,
parameter_id INTEGER NOT NULL,
reason_id INTEGER NOT NULL,
FOREIGN KEY(parameter_id) REFERENCES parameter(id),
FOREIGN KEY(reason_id) REFERENCES history_reason(id)
);

CREATE INDEX IF NOT EXISTS param_history_paramid_index 
ON parameter_history(parameter_id);

CREATE INDEX IF NOT EXISTS param_history_datetime_index 
ON parameter_history(date_time);

PRAGMA encoding = "UTF-8";
PRAGMA foreign_keys = 1;
PRAGMA count_changes = 0;
PRAGMA temp_store = MEMORY;
PRAGMA cache_size = 13000;
PRAGMA synchronous = 1;

CREATE INDEX IF NOT EXISTS param_history_paramid_and_date_index 
ON parameter_history(parameter_id, date_time);