Tango.info musical work code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(→‎Statistics based on track data: * 2012-07-03: 43,636 | 3,197 | 2,890 | 2,716)
Line 16: Line 16:


== Statistics based on track data ==
== Statistics based on track data ==
Query A
  SELECT count(*)  
  SELECT count(*)  
  FROM  `ti_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}'
 
Query B
UNION ALL
  SELECT COUNT( DISTINCT work_id)
  SELECT COUNT( DISTINCT work_id)
  FROM  `ti_tracks`
  FROM  `ti_tracks`
Line 42: Line 42:
  AND  `product_tin` REGEXP  '[0-9]{14}'
  AND  `product_tin` REGEXP  '[0-9]{14}'


 
date: Result
date: Result A | Result B
* 2012-03-08: 34,583 | 2,102
* 2012-03-08: 34,583 | 2,102
* 2012-03-15: 37,139 | 2,318
* 2012-03-15: 37,139 | 2,318

Revision as of 2012-07-03T07:27:44

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

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

UNION ALL

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

UNION ALL

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

UNION ALL

SELECT COUNT( DISTINCT work_id ) 
FROM  `ti_tracks` 
WHERE  `work_id` REGEXP  'T037[0-9]{7}'
AND  `product_tin` REGEXP  '[0-9]{14}'

date: Result

  • 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)
  • 2012-06-20: 43,347 | 3,129 | 2,828 (ISWC) | 2,655 (T037)
  • 2012-07-01: 43,537 | 3,173 | 2,869 (ISWC) | 2,695 (T037)
  • 2012-07-03: 43,636 | 3,197 | 2,890 | 2,716

List of performer specific sets that have been checked

It was tried to find codes for all tracks by these performers:

  • Angel D'Agostino - 0 missing
  • Angel Vargas - 2 missing