Polska Bibliografia Judaistyczna -- Wyszukiwanie SQL

PTSŻ Home

Polskie Towarzystwo Studiów Żydowskich
C/O Instytut Judaistyki
Uniwersytetu Jagiellońskiego
ul. Józefa 19, 31-056 Kraków

Polska Bibliografia Judaistyczna

Strona główna

|

Pokaż wszystko

|

Wyszukiwanie proste

|

Wyszukiwanie zaawansowane

Przeszukaj bazę danych używając zapytań SQL:

Zapytanie SQL:		(SELECT author, title, orig_title, type, year, publication_author, publication, publication_editor, abbrev_journal, volume_numeric, volume, issue, pages, keywords, abstract, thesis, editor, publisher, place, abbrev_series_title, series_title, series_editor, series_volume_numeric, series_issue, edition, language, summary_language, author_count, first_author, online_publication, online_citation, doi, created_date, created_time, modified_date, modified_time, notes, area FROM (SELECT r.`TYPE` as 'type',r.`author` as 'author',r.`address` as 'address',r.`corporate_author` as 'corporate_author',r.`first_author` as 'first_author',r.`author_count` as 'author_count',r.`title` as 'title',r.`editor` as 'editor',r.`orig_title` as 'orig_title',r.`abbrev_journal` as 'abbrev_journal',r.`pages` as 'pages',r.`first_page` as 'first_page',r.`keywords` as 'keywords',r.`abstract` as 'abstract',r.`language` as 'language',r.`summary_language` as 'summary_language',r.`area` as 'area',r.`thesis` as 'thesis',r.`expedition` as 'expedition',r.`doi` as 'doi',r.`url` as 'url',r.`call_number` as 'call_number',r.`location` as 'location',r.`contribution_id` as 'contribution_id',r.`online_publication` as 'online_publication',r.`online_citation` as 'online_citation',r.`FILE` as 'file',r.`notes` as 'notes',r.`orig_record` as 'orig_record',r.`approved` as 'approved',r.`created_date` as 'created_date',r.`created_time` as 'created_time',r.`created_by` as 'created_by',r.`modified_date` as 'modified_date',r.`modified_time` as 'modified_time',r.`modified_by` as 'modified_by',r.`version` as 'version',r.`serial_parent` as 'serial_parent',r.`serial` as 'serial',rs.`author` as 'publication_author', NULL as 'publication',r.`year` as 'year',r.`volume` as 'volume',r.`volume_numeric` as 'volume_numeric',r.`issue` as 'issue',r.`edition` as 'edition',rs.`editor` as 'publication_editor',r.`publisher` as 'publisher',r.`place` as 'place',r.`series_editor` as 'series_editor',r.`series_title` as 'series_title',r.`abbrev_series_title` as 'abbrev_series_title',r.`series_volume` as 'series_volume',r.`series_volume_numeric` as 'series_volume_numeric',r.`series_issue` as 'series_issue',r.`issn` as 'issn',r.`isbn` as 'isbn',r.`conference` as 'conference',r.`medium` as 'medium' FROM `refs` r, (SELECT NULL as 'author', NULL as 'editor') rs) refs WHERE serial_parent IS NULL WHERE year > 2001 ORDER BY year DESC, author) UNION (SELECT author, title, orig_title, type, year, publication_author, publication, publication_editor, abbrev_journal, volume_numeric, volume, issue, pages, keywords, abstract, thesis, editor, publisher, place, abbrev_series_title, series_title, series_editor, series_volume_numeric, series_issue, edition, language, summary_language, author_count, first_author, online_publication, online_citation, doi, created_date, created_time, modified_date, modified_time, notes, area FROM (SELECT r.`TYPE` as 'type',r.`author` as 'author',r.`address` as 'address',r.`corporate_author` as 'corporate_author',r.`first_author` as 'first_author',r.`author_count` as 'author_count',r.`title` as 'title',r.`editor` as 'editor',r.`orig_title` as 'orig_title',r.`abbrev_journal` as 'abbrev_journal',r.`pages` as 'pages',r.`first_page` as 'first_page',r.`keywords` as 'keywords',r.`abstract` as 'abstract',r.`language` as 'language',r.`summary_language` as 'summary_language',r.`area` as 'area',r.`thesis` as 'thesis',r.`expedition` as 'expedition',r.`doi` as 'doi',r.`url` as 'url',r.`call_number` as 'call_number',r.`location` as 'location',r.`contribution_id` as 'contribution_id',r.`online_publication` as 'online_publication',r.`online_citation` as 'online_citation',r.`FILE` as 'file',r.`notes` as 'notes',r.`orig_record` as 'orig_record',r.`approved` as 'approved',r.`created_date` as 'created_date',r.`created_time` as 'created_time',r.`created_by` as 'created_by',r.`modified_date` as 'modified_date',r.`modified_time` as 'modified_time',r.`modified_by` as 'modified_by',r.`version` as 'version',r.`serial_parent` as 'serial_parent',r.`serial` as 'serial',rs.`author` as 'publication_author', rs.`title` as 'publication',rs.`year` as 'year',rs.`volume` as 'volume',rs.`volume_numeric` as 'volume_numeric',rs.`issue` as 'issue',rs.`edition` as 'edition',rs.`editor` as 'publication_editor',rs.`publisher` as 'publisher',rs.`place` as 'place',rs.`series_editor` as 'series_editor',rs.`series_title` as 'series_title',rs.`abbrev_series_title` as 'abbrev_series_title',rs.`series_volume` as 'series_volume',rs.`series_volume_numeric` as 'series_volume_numeric',rs.`series_issue` as 'series_issue',rs.`issn` as 'issn',rs.`isbn` as 'isbn',rs.`conference` as 'conference',rs.`medium` as 'medium' FROM `refs` r LEFT JOIN `refs` rs ON r.`serial_parent` = rs.`serial`) refs WHERE serial_parent IS NOT NULL WHERE year > 2001 ORDER BY year DESC, author)
Opcje wyświetlania::		Wyświetlaj linki	Pokaż rekordów na stronie
		Wyświetl zapytanie SQL	Rodzaj widoku:


Przykłady:		`SELECT author, title, year, publication FROM refs WHERE publication = "Polar Biology" AND author RLIKE "Legendre\|Ambrose" ORDER BY year DESC, author`
		`SELECT serial, author, title, year, publication, volume FROM refs ORDER BY serial DESC LIMIT 10`
Pomoc:		Więcej informacji można znaleźć w podręczniku użytkowania na stronie bazy danych MySQL. Pomocne informacje jak pracować z bazą danych MySQL można zrównież znaleźć w samouczku dla początkujących. Tam również można znaleźć szczegółowy opis i składnię polecenia SELECT. (UWAGA! Informacje na podanych stronach są w języku angielskim)

Strona główna

Wyszukiwanie CQL | Szukaj w bibliotece | Pokaż rekord | Wygeneruj bibliografię