{"mysql":"\n\t\t\tSELECT  wp_blogs.blog_id\n\t\t\tFROM wp_blogs \n\t\t\tWHERE domain = 'example.com' AND path IN ( '\/site\/wp-json\/', '\/site\/', '\/' )\n\t\t\t\n\t\t\tORDER BY CHAR_LENGTH(path) DESC\n\t\t\tLIMIT 1\n\t\t","postgresql":"SELECT  wp_blogs.blog_id, CHAR_LENGTH(path)\n\t\t\tFROM wp_blogs \n\t\t\tWHERE domain = 'example.com' AND path IN ( '\/site\/wp-json\/', '\/site\/', '\/' )\n\t\t\t\n\t\t\tORDER BY CHAR_LENGTH(path) DESC\n\t\t\tLIMIT 1"}