Rcom tips

check article main text in newsdb

• find uid in url http://www.reuters.com/article/2014/07/15/us-usa-immigration-idUSKBN0FK29N20140715 , the uid is "USKBN0FK29N20140715"
• use uid search NEWSGROUP table

mysql> SELECT * FROM NEWSGROUP WHERE UID='USKBN0FL07220140716' \G;
                  UID: USKBN0FL07220140716
           PACKAGE_ID: 833067408
            ...
         MAIN_TEXT_ID: 935512347
      MAIN_PICTURE_ID: 935512348

• use main_text_id search BASICPUBLICATION table

mysql> SELECT * FROM BASICPUBLICATION WHERE ID="935512347" \G;
                ID: 935512347
         FILE_NAME: tag:reuters.com,2014:newsml_KBN0FL072:1
     REVISION_DATE: 2014-07-16 03:11:43
          HEADLINE: Exclusive: U.N. monitors allege 'conspiracy' to divert Somali assets
          ...