SELECT *
FROM main_t m
WHERE ( (autor LIKE "% Stanisław %" OR left(autor, 10)="Stanisław " OR right(autor, 10)=" Stanisław" ) AND (autor LIKE "% Zenon %" OR left(autor, 6)="Zenon " OR right(autor, 6)=" Zenon" ) AND (autor LIKE "% Zakrzewski %" OR left(autor, 11)="Zakrzewski " OR right(autor, 11)=" Zakrzewski" )) AND m.pawl="0" GROUP BY m.sygnatura ASC UNION SELECT *
FROM main_t m
WHERE ( (autor LIKE "% Stanisław %" OR left(autor, 10)="Stanisław " OR right(autor, 10)=" Stanisław" ) AND (autor LIKE "% Zenon %" OR left(autor, 6)="Zenon " OR right(autor, 6)=" Zenon" ) AND (autor LIKE "% Zakrzewski %" OR left(autor, 11)="Zakrzewski " OR right(autor, 11)=" Zakrzewski" )) AND m.pawl="1" GROUP BY m.sygnatura DESC
LIMIT 0,31
Znaleziono
1
rękopis.
1.
|
15509/II.
„Stanisław Zenon Zakrzewski: Andante. Autobiografia”. Wspomnienia z lat 1890-1945. |
|
Pol. 1970. Tomów 2. K. 135; 136-359. Mf BN.
|