Bands
prefix}bands b
JOIN {$wpdb->posts} p ON b.post_id = p.ID
WHERE p.post_type = 'bands'
ORDER BY
CASE
WHEN b.active = 1 THEN 0
ELSE 1
END,
p.post_title ASC"
;
$bands = $wpdb->get_results($query);
if ($bands) {
foreach ($bands as $band) {
// Display each band
echo '';
echo '
active ? 'style="border-style: dashed !important; border-color: #F0F0F0 !important;"' : '') . '>';
echo '';
echo '
';
echo '';
}
} else {
echo 'No bands found.';
}
?>
' .
esc_html($band->bandsitename ?: $band->post_title) .
'
';
echo '