SELECT
  p.servtype,
  p.clientid AS uberid,
  p.period,
  (CASE WHEN p.start     > 0 THEN DATE(FROM_UNIXTIME(p.start))     ELSE NULL END) AS start,
  (CASE WHEN p.end       > 0 THEN DATE(FROM_UNIXTIME(p.end))       ELSE NULL END) AS end,
  (CASE WHEN p.lastrenew > 0 THEN DATE(FROM_UNIXTIME(p.lastrenew)) ELSE NULL END) AS lastrenew,
  (CASE WHEN p.renewdate > 0 THEN DATE(FROM_UNIXTIME(p.renewdate)) ELSE NULL END) AS renewdate
FROM
  metadata_values AS v
JOIN
  metadata_config AS c ON v.metaconf_id = c.metaconf_id
JOIN
  PACKAGES AS p ON p.packid = v.id
WHERE
  c.variable = 'rbclientid' AND
  v.value = '23456';

// Where the value of '23456' is replaced at call time w/ the clientid passed to the CPM