编辑代码

查询TME歌曲歌手专辑名：
SELECT
  t.trackid,
  t.trackname,
  a.albumname,
  GROUP_CONCAT(ar.singername) AS artistname,
  t.version,
  GROUP_CONCAT(ar.`hotclass`) AS hotclass
FROM
  central_content.`trackinfo` t
  LEFT JOIN central_content.`albuminfo` a ON t.albumid = a.albumid
  JOIN central_content.`trackartist` tar ON tar.trackid = t.trackid
  JOIN central_content.`artistinfo` ar ON ar.singerid = tar.artistid
WHERE
  t.trackid IN (202287504)
GROUP BY
  t.trackid


查询TMS cpsp：
SELECT
  tcp.trackid,
  tcp.trackcpid AS SPID,
  sp.companyname AS SPname,
  tcp.origincpid AS CPID,
  cp.companyname AS CPname
FROM
  central_content.`trackcpinfo` tcp
  JOIN central_content.`company` sp ON sp.companyid = tcp.`trackcpid`
  JOIN central_content.`company` cp ON cp.companyid = tcp.`origincpid`
WHERE
  tcp.trackid IN (1388450)


根据合同查爱听商家歌曲：
SELECT
  tcp.copyrightid,
  t.trackid,
  t.cmsitemid,
  c.contractnumber
FROM
  `central_content`.`trackcpinfo` tcp
  JOIN central_content.`trackinfo` t ON tcp.trackid = t.trackid
  JOIN central_content.copyright c ON c.copyrightid = tcp.copyrightid
  JOIN masterdb.`iteminfo` i ON t.`cmsitemid` = i.`ItemID`
  AND i.`StatusID` = 404
WHERE
  c.contractnumber IN ('CON02-TME00-20231120-0033')


查takeofftype：
SELECT
  t.trackid,
  takeofftype
FROM
  central_content.`trackinfo` t
  JOIN central_content.`trackcontrol` tc ON t.`trackid` = tc.`trackid`
WHERE
  t.trackid IN (132352)


中央spid查询歌曲数据：
select
  trackcpinfo.trackcpid,
  trackcpinfo.trackid,
  trackinfo.cmsitemid,
  trackcontrol.umcp,
  trackcontrol.qmcp,
  trackcontrol.kwcp,
  trackcontrol.kgcp,
  trackcontrol.availablestatus,
  trackcontrol.paymode
from
  trackcpinfo
  left join trackinfo on trackinfo.trackid = trackcpinfo.trackid
  left join trackcontrol on trackcontrol.trackid = trackinfo.trackid
where
  trackcpinfo.trackcpid in (89129)


查询paymode：
SELECT
  trackid,
  paymode
FROM
  central_content.trackcontrol
WHERE
  trackid IN (200938485)


paymark=6的中央歌曲：
SELECT
  t.trackid
FROM
  central_content.trackinfo t
  JOIN (
    SELECT
      trackid
    FROM
      central_content.trackcontrol
    WHERE
      paymark = 6
  ) tc ON t.trackid = tc.trackid
  JOIN masterdb.iteminfo i ON t.cmsitemid = i.itemid


查询paymark：
SELECT
  trackid,
  `paymark`
FROM
  central_content.trackcontrol
WHERE
  trackid IN (309969371)


中央各bu权限查询：
SELECT
  trackid,
  umcp,
  qmcp,
  kwcp,
  kgcp,
  `availablestatus`
FROM
  central_content.trackcontrol
WHERE
  trackid IN (5642063)