SELECT cmp_no, cmp_name, sci_obj, date_obs, date_end, observer, comment FROM campaign WHERE cmp_no >= 1 and cmp_no <= 3 and cmp_name like '%st%' or cmp_name like '%ST%' or cmp_name like '%St%' and ((date_end IS NULL) and (date_obs <= '1995/02/29')) or ((date_end <= '2000/12/31') AND (date_obs >= '1990/01/01'));
