# /var/www/html/lib/helper.inc.php:98
^ "Engine ⚙️ : SLiMS\SearchEngine\SearchBiblioEngineBukvarna"

^ "SQL ⚒️"

^ array:2 [
  "count" => "select count(DISTINCT(sb.biblio_id)) from search_biblio as sb INNER JOIN biblio b ON (sb.biblio_id = b.biblio_id) INNER JOIN item ON (b.biblio_id = item.biblio_id) INNER JOIN biblio_author ba ON (sb.biblio_id = ba.biblio_id) where sb.opac_hide=0 AND b.gmd_id IN (1) and (ba.author_id IN ('9376'))"
  "query" => "select sb.biblio_id, sb.title, sb.author, sb.topic, sb.image, sb.isbn_issn, sb.publisher, sb.publish_place, sb.publish_year, sb.labels, sb.input_date, b.title_seo, ( SELECT (item.item_code) AS itemCodes FROM item WHERE item.biblio_id = sb.biblio_id LIMIT 1 ) AS itemCodes, ( SELECT GROUP_CONCAT(item.item_id) AS itemIds FROM item WHERE item.biblio_id = sb.biblio_id ) AS itemIds, ( SELECT COUNT(item.item_id) AS izvodov FROM item WHERE item.biblio_id = sb.biblio_id AND `item`.`item_status_id` NOT IN ('PRO') ) AS izvodov, ( SELECT COUNT(bakc2.biblio_id) FROM biblio_akcija bakc2 WHERE bakc2.biblio_id = sb.biblio_id AND bakc2.trajanje_do > NOW() ) AS v_akciji from search_biblio as sb INNER JOIN biblio b ON (sb.biblio_id = b.biblio_id) INNER JOIN item ON (b.biblio_id = item.biblio_id) INNER JOIN biblio_author ba ON (sb.biblio_id = ba.biblio_id) where sb.opac_hide=0 AND b.gmd_id IN (1) and (ba.author_id IN ('9376')) group by b.biblio_id order by sb.last_update desc limit 20 offset 0"
]

^ "Bind Value ⚒️"

^ []

Kletka strahu in smrti

Na seznam želja Deli

Felc, Jože.Toresini, Lorenzo.

"Kletka strahu in smrti" raziskuje življenje v zaporu, osredotočajoč se na psihološke in socialne vidike zaporniškega sistema. Avtorja Jože Felc in Lorenzo Toresini skozi intervjuje, osebne zgodbe in analize razkrivata, kako zaporniško okolje vpliva na posameznike, tako na zapornike kot na paznike. Knjiga se poglablja v teme, kot so strah, nasilje, izolacija in smrt, ter postavlja vpraš…

Ohranjenost:

Izvodov: 1

 Dodaj v košarico
Pridobitev knjige na osnovi dogovora s predstavnikom Bukvarne