Date:2024-08-09 16:35:55
qu:SELECT nb.notice_board_id, nb.notice_subject, nb.notice_desc,
			nb.end_date, nb.start_date, nb.last_updated_ts, MIN(nbg.group_id) AS group_id
			FROM notice_board_assignment AS nbg
			JOIN notice_board AS nb ON nbg.notice_board_id = nb.notice_board_id
			Left join user_group_allocation as uga on  nbg.group_id=uga.group_id
			WHERE nb.end_date >= '2024-08-09' AND nb.start_date <= '2024-08-09' AND nb.last_updated_ts > '0000-00-00 00:00:00'
			AND (IF(nbg.group_id='0',nbg.user_id='232',nbg.group_id=uga.group_id AND uga.user_id='232')
			OR (nbg.group_id='0' and nbg.user_id='0'))
			GROUP BY notice_board_id
			ORDER BY nb.end_date
Date:2024-08-09 16:41:18
qu:SELECT nb.notice_board_id, nb.notice_subject, nb.notice_desc,
			nb.end_date, nb.start_date, nb.last_updated_ts, MIN(nbg.group_id) AS group_id
			FROM notice_board_assignment AS nbg
			JOIN notice_board AS nb ON nbg.notice_board_id = nb.notice_board_id
			Left join user_group_allocation as uga on  nbg.group_id=uga.group_id
			WHERE nb.end_date >= '2024-08-09' AND nb.start_date <= '2024-08-09' AND nb.last_updated_ts > '0000-00-00 00:00:00'			
            AND (
                (nbg.group_id = '0' AND nbg.user_id = '232') 
                OR (nbg.group_id = uga.group_id AND uga.user_id = '232') 
                OR (nbg.group_id = '0' AND nbg.user_id = '0')
            ) 
			GROUP BY notice_board_id
			ORDER BY nb.end_date
Date:2024-08-09 16:49:55
qu:SELECT nb.`notice_board_id` FROM `notice_board_assignment` as nbg 
								JOIN notice_board AS nb ON nbg.notice_board_id = nb.notice_board_id
								Left join user_group_allocation as uga on  nbg.group_id=uga.group_id 
								where nb.end_date >= '2024-08-09' AND nb.start_date <= '2024-08-09' AND
								(IF(nbg.group_id='0',nbg.user_id='232',nbg.group_id=uga.group_id AND uga.user_id='232')
									OR (nbg.group_id='0' and nbg.user_id='0')) and nbg.notice_board_id in()
								GROUP BY notice_board_id