$pdoWrapperObj = getPDOQueryWrapper(); if(check_user_permission(13) ) { $sql = 'SELECT ROUND(overall_priority) AS priority, COUNT(distinct v.vendor_id) AS vendor_count FROM vendor v INNER JOIN artist_info a ON v.vendor_id = a.vendor_id INNER JOIN releases r ON a.artist_id = r.artist_id WHERE v.status = "signed" AND r.deletions <> "Y" GROUP BY priority ORDER BY priority'; $prio_data = $pdoWrapperObj->executeQuery($sql, []); if ($prio_data === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } ?>
| Overall Prioritiee | # of Labels |
|---|---|
| =$prio_row['priority']?> | =$prio_row['vendor_count']?> |