Test - Quarry

SQL

SELECT #img_name,
	#CASE WHEN REGEXP_SUBSTR(img_metadata,'("DateTimeOriginal":)')!=""
    #THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'("DateTimeOriginal":(.*?[^[\\\\])")'), 21, 19)
    #WHEN REGEXP_SUBSTR(img_metadata,'(s:8:"DateTime";s:19:")')!=""
    #THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'(s:8:"DateTime";s:19:"(.*?[^[\\\\])")'), 22, 19) 
    #WHEN REGEXP_SUBSTR(img_metadata,'(s:16:"DateTimeOriginal";s:19:")')!=""
    #THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'(s:16:"DateTimeOriginal";s:19:"(.*?[^[\\\\])")'), 31, 19) 
    #WHEN REGEXP_SUBSTR(img_metadata,'("DateTimeDigitized":)')!=""
    #THEN SUBSTR(REGEXP_SUBSTR(img_metadata,'("DateTimeDigitized":(.*?[^[\\\\])")'), 22, 19)
    #ELSE "" 
    #END  as Zeit,
    REGEXP_SUBSTR('a:6:{s:368:"Zentralbild-FDGB 28.7.1951 Erholung.";','([1-9]|[12][0-9]|3[01])[-/.]([1-9]|1[012])[-/.]((19|20)[0-9][0-9])') as Zeit #,
    #img_metadata (\d{4})
#FROM image
#WHERE img_metadata != ""
#AND REGEXP_SUBSTR(img_metadata,'([1-9]|[12][0-9]|3[01])[-/.]([1-9]|1[012])[-/.]((19|20|)\d{2})') != ""
LIMIT 10;
SQL

Checking query status...
