SELECT `tbl_notice`.*, `tbl_categories`.`category_name`
FROM `tbl_notice`
LEFT JOIN `tbl_categories` ON `tbl_categories`.`id` = `tbl_notice`.`category_id`
WHERE `publish_date` <= '2026-05-15'
AND   (
`expiry_date` >= '2026-05-15'
OR expiry_date IS NULL
 )
AND `tbl_notice`.`status` = 'active'
ORDER BY `is_pinned` ASC, `id` DESC