Lines 22-32
return {
Link Here
|
22 |
JOIN biblio_metadata m ON b.biblionumber = m.biblionumber |
22 |
JOIN biblio_metadata m ON b.biblionumber = m.biblionumber |
23 |
SET b.opac_suppressed = |
23 |
SET b.opac_suppressed = |
24 |
CASE |
24 |
CASE |
25 |
WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN |
25 |
WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN |
26 |
ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') |
26 |
ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') |
27 |
ELSE 0 |
27 |
ELSE 0 |
28 |
END |
28 |
END |
29 |
WHERE m.metadata LIKE '%<datafield tag="952">%'; |
29 |
WHERE m.metadata LIKE '%<datafield tag="942">%'; |
30 |
} |
30 |
} |
31 |
); |
31 |
); |
32 |
|
32 |
|
Lines 47-57
return {
Link Here
|
47 |
JOIN deletedbiblio_metadata m ON b.biblionumber = m.biblionumber |
47 |
JOIN deletedbiblio_metadata m ON b.biblionumber = m.biblionumber |
48 |
SET b.opac_suppressed = |
48 |
SET b.opac_suppressed = |
49 |
CASE |
49 |
CASE |
50 |
WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN |
50 |
WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN |
51 |
ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') |
51 |
ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') |
52 |
ELSE 0 |
52 |
ELSE 0 |
53 |
END |
53 |
END |
54 |
WHERE m.metadata LIKE '%<datafield tag="952">%'; |
54 |
WHERE m.metadata LIKE '%<datafield tag="942">%'; |
55 |
} |
55 |
} |
56 |
); |
56 |
); |
57 |
|
57 |
|
58 |
- |
|
|