| 
      
            Lines 7-14
          UPDATE language_descriptions SET subtag = 'kn', lang = 'kn' WHERE subtag = 'ka'
      
      
        Link Here
      
     | 
  
        
          | 7 | 
          UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';  | 
          7 | 
          UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';  | 
        
        
          | 8 | 
           | 
          8 | 
           | 
        
        
          | 9 | 
          INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20');  | 
          9 | 
          INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20');  | 
        
            
               | 
               | 
              10 | 
              DELETE FROM language_subtag_registry  | 
            
            
              | 11 | 
                     WHERE NOT id IN  | 
            
            
              | 12 | 
                       (SELECT id FROM  | 
            
            
              | 13 | 
                         (SELECT MIN(id) as id,subtag,type,description,added  | 
            
            
              | 14 | 
                          FROM language_subtag_registry  | 
            
            
              | 15 | 
                          GROUP BY subtag,type,description,added)  | 
            
            
              | 16 | 
                         AS subtable);  | 
            
            
              | 17 | 
               | 
            
        
          | 10 | 
           | 
          18 | 
           | 
        
        
          | 11 | 
          INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo');  | 
          19 | 
          INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo');  | 
        
            
               | 
               | 
              20 | 
              DELETE FROM language_rfc4646_to_iso639  | 
            
            
              | 21 | 
                     WHERE NOT id IN  | 
            
            
              | 22 | 
                       (SELECT id FROM  | 
            
            
              | 23 | 
                         (SELECT MIN(id) as id,rfc4646_subtag,iso639_2_code  | 
            
            
              | 24 | 
                          FROM language_rfc4646_to_iso639  | 
            
            
              | 25 | 
                          GROUP BY rfc4646_subtag,iso639_2_code)  | 
            
            
              | 26 | 
                         AS subtable);  | 
            
        
          | 12 | 
           | 
          27 | 
           | 
        
        
          | 13 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული');  | 
          28 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული');  | 
        
        
          | 14 | 
           | 
          29 | 
           | 
        
  
    | 
      
            Lines 19-21
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES
      
      
        Link Here
      
     | 
  
        
          | 19 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische');  | 
          34 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische');  | 
        
        
          | 20 | 
           | 
          35 | 
           | 
        
        
          | 21 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano');  | 
          36 | 
          INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano');  | 
        
            
               | 
               | 
              37 | 
               | 
            
            
              | 38 | 
              DELETE FROM language_descriptions  | 
            
            
              | 39 | 
                     WHERE NOT id IN  | 
            
            
              | 40 | 
                       (SELECT id FROM  | 
            
            
              | 41 | 
                         (SELECT MIN(id) as id,subtag,type,lang,description  | 
            
            
              | 42 | 
                          FROM language_descriptions GROUP BY subtag,type,lang,description)  | 
            
            
              | 43 | 
                         AS subtable);  |