Tango.info musical work code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
(→‎Statistics based on track data: 2012-06-19: 43,111 | 3,098 | (2,802 ISWC, 2,631 T037))
Line 18: Line 18:
Query A
Query A
  SELECT *  
  SELECT *  
  FROM  `tango_tracks`  
  FROM  `ti_tracks`  
  WHERE  `work_id`  
  WHERE  `work_id`  
  REGEXP  '[TZ]{1}[0-9]{10}'
  REGEXP  '[TZ]{1}[0-9]{10}'
Line 26: Line 26:
Query B
Query B
  SELECT DISTINCT(work_id)
  SELECT DISTINCT(work_id)
  FROM  `tango_tracks`
  FROM  `ti_tracks`
  WHERE  `work_id` REGEXP  '[TZ]{1}[0-9]{10}'
  WHERE  `work_id` REGEXP  '[TZ]{1}[0-9]{10}'
  AND `product_tin` REGEXP  '[0-9]{14}'
  AND `product_tin` REGEXP  '[0-9]{14}'
Line 37: Line 37:
* 2012-03-25: 42,097 | 2,905 | (2,632 ISWC, 2,474 T037)
* 2012-03-25: 42,097 | 2,905 | (2,632 ISWC, 2,474 T037)
* 2012-04-06: 42,341 | 2,947 | (2,670 ISWC, 2,508 T037)
* 2012-04-06: 42,341 | 2,947 | (2,670 ISWC, 2,508 T037)
* 2012-06-19: 43,111 | 3,098 | (2,802 ISWC, 2,631 T037)

Revision as of 2012-06-19T04:26:58

Definition

A tango.info musical work code (TIWC) is a tango.info code that identifies a tango.info musical work.

TIWC can start with the letter T or with the letter Z.

  • TIWC that start with the letter T are ISWC, e.g. T0370000024
  • TIWC that start with Z are not ISWC.
    • TIWC that start with the Z000 contain the SADAIC work number, e.g. the TIWC Z0000015621 contains the SADAIC work number 15621.
    • TIWC that start with Z but do not start with Z000 start with Z0999.

TIWC that start with the letter Z are not stable.

TIWC-6

As of 2011-12-29 the old TIWC 6-char codes have been withdrawn.

Statistics based on track data

Query A 

SELECT * 
FROM  `ti_tracks` 
WHERE  `work_id` 
REGEXP  '[TZ]{1}[0-9]{10}'
AND  `product_tin` 
REGEXP  '[0-9]{14}'

Query B 

SELECT DISTINCT(work_id)
FROM  `ti_tracks`
WHERE  `work_id` REGEXP  '[TZ]{1}[0-9]{10}'
AND `product_tin` REGEXP  '[0-9]{14}'

date: Result A | Result B | other

  • 2012-03-08: 34,583 | 2,102
  • 2012-03-15: 37,139 | 2,318
  • 2012-03-17: 40,051 | 2,644
  • 2012-03-20: 41,135 | 2,759 | (2,503 ISWC, 2,361 T037)
  • 2012-03-25: 42,097 | 2,905 | (2,632 ISWC, 2,474 T037)
  • 2012-04-06: 42,341 | 2,947 | (2,670 ISWC, 2,508 T037)
  • 2012-06-19: 43,111 | 3,098 | (2,802 ISWC, 2,631 T037)
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_musical_work_code&oldid=41251"