Untitled query #1276

SQL

use commonswiki_p;

#SELECT FIND_IN_SET('Make', img_metadata )
#select  img_name, img_metadata
# img_size , img_media_type, img_major_mime, img_minor_mime, 

# SELECT LOCATE(';s:', img_metadata, (LOCATE('"Make"', img_metadata)+4))
SELECT SUBSTR(
  			img_metadata, 
            Locate(":", img_metadata, (LOCATE('"Make"', img_metadata)+9)) , 
            (LOCATE('"Model"', img_metadata) - (LOCATE('"Make"', img_metadata))-14)
             )
from image 
where  img_minor_mime  = 'jpeg' 
and img_metadata <> 'a:1:{s:22:"MEDIAWIKI_EXIF_VERSION";i:2;}'
and img_metadata Not like '%File written by Adobe Photoshop%'


limit 50
SQL

Checking query status...
