|
Date Added (30 Days) |
Sale Start Date (30 Days) |
Total |
= (curdate() - interval 30 day), 1, 0)) as total_last30
, sum(if(r.ingestion_completed >= (curdate() - interval 30 day), 1, 0)) as date_added_last30
FROM releases r
INNER JOIN
(
SELECT mp.upc
FROM mkt_priority mp
WHERE mp.priority = 'a'
GROUP BY mp.priority, mp.upc ) as x ON x.upc = r.upc
INNER JOIN artist_info a ON r.artist_id = a.artist_id
INNER JOIN vendor v ON v.vendor_id = a.vendor_id
INNER JOIN genre g ON g.genre_id = r.genre_id
WHERE r.release_status = 'in_content'";
$release_summary = $pdoWrapper->executeQuery($sql, []);
if ($release_summary === false) {
show_pdo_error($sql, $pdoWrapper->getLastStatement());
}
$release_summary_row = !empty($release_summary[0]) ? $release_summary[0] : null;
if($release_summary_row)
{
?>
| Priority A |
"> |
"> |
|
= (curdate() - interval 30 day), 1, 0)) as total_last30
, sum(if(r.ingestion_completed >= (curdate() - interval 30 day), 1, 0)) as date_added_last30
FROM releases r
INNER JOIN
(
SELECT mp.upc
FROM mkt_priority mp
WHERE mp.priority = 'b'
GROUP BY mp.priority, mp.upc ) as x ON x.upc = r.upc
INNER JOIN artist_info a ON r.artist_id = a.artist_id
INNER JOIN vendor v ON v.vendor_id = a.vendor_id
INNER JOIN genre g ON g.genre_id = r.genre_id
WHERE r.release_status = 'in_content'";
$release_summary = $pdoWrapper->executeQuery($sql, []);
if ($release_summary === false) {
show_pdo_error($sql, $pdoWrapper->getLastStatement());
}
$release_summary_row = !empty($release_summary[0]) ? $release_summary[0] : null;
if($release_summary_row)
{
?>
| Priority B |
"> |
"> |
|
= (curdate() - interval 30 day), 1, 0)) as total_last30
, sum(if(r.ingestion_completed >= (curdate() - interval 30 day), 1, 0)) as date_added_last30
FROM releases r
INNER JOIN
(
SELECT mp.upc
FROM mkt_priority mp
WHERE mp.priority IN('a','b')
GROUP BY mp.priority, mp.upc ) as x ON x.upc = r.upc
INNER JOIN artist_info a ON r.artist_id = a.artist_id
INNER JOIN vendor v ON v.vendor_id = a.vendor_id
INNER JOIN genre g ON g.genre_id = r.genre_id
WHERE r.release_status = 'in_content'";
$release_summary = $pdoWrapper->executeQuery($sql, []);
if ($release_summary === false) {
show_pdo_error($sql, $pdoWrapper->getLastStatement());
}
$release_summary_row = !empty($release_summary[0]) ? $release_summary[0] : null;
if($release_summary_row)
{
?>
| Priority A & B |
"> |
"> |
|