9 lines
252 B
SQL
9 lines
252 B
SQL
|
UPDATE osint.exhibits AS exhibit
|
||
|
|
SET height = 220,
|
||
|
|
updated_at = NOW()
|
||
|
|
FROM osint.document_exhibits AS document
|
||
|
|
WHERE document.exhibit_id = exhibit.id
|
||
|
|
AND document.capture_kind_id = 'clipping'
|
||
|
|
AND exhibit.width = 220
|
||
|
|
AND exhibit.height = 272;
|