Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_train_128 ( "id" int, "vascular" bool, "mania" bool, "pulmonary_disease" bool, "cardiac" bool, "stroke" bool, "substance_dependence" bool, "schizophrenia" bool, "cerebrovascular_disease" bool, "hematologic_disease" bool, "adverse_reactions_venlaflaxine" bool, "traumatic_brain_injury" bool, "focal_brain_lesion" bool, "adverse_reactions_escitalopram" bool, "malignancy" bool, "metabolic" bool, "seizure_disorder" bool, "neuropathology" bool, "major_depression" bool, "NOUSE" float )

### Question ###
subjects with a history of significant cerebrovascular disease. this will be identified by one of the following: i. history of stroke. ii. any focal signs of significant neuropathology from the neurological examination.

### Accurate SQL ###

SELECT * FROM table_train_128 WHERE cerebrovascular_disease = 1 OR ((CASE WHEN stroke = 1 THEN 1 ELSE 0 END + CASE WHEN neuropathology = 1 THEN 1 ELSE 0 END) >= 1)