Date:2024-08-01 11:26:24
qu:SELECT pn.privacy_notice_title, pn.privacy_notice_desc, CASE WHEN pnu.user_id IS NULL OR pn.last_updated_ts > pnu.last_updated_ts THEN 0 ELSE 1 END AS flag
					  FROM privacy_notice pn
					  LEFT JOIN privacy_notice_user pnu ON pn.privacy_notice_id = pnu.privacy_notice_id AND pnu.user_id = '0'
					  WHERE pn.company_id = '10'
Date:2024-08-01 11:28:27
qu:SELECT pn.privacy_notice_title, pn.privacy_notice_desc, CASE WHEN pnu.user_id IS NULL OR pn.last_updated_ts > pnu.last_updated_ts THEN 0 ELSE 1 END AS flag
					  FROM privacy_notice pn
					  LEFT JOIN privacy_notice_user pnu ON pn.privacy_notice_id = pnu.privacy_notice_id AND pnu.user_id = '26'
					  WHERE pn.company_id = '10'
Date:2024-08-01 14:27:43
qu:SELECT pn.privacy_notice_title, pn.privacy_notice_desc, CASE WHEN pnu.user_id IS NULL OR pn.last_updated_ts > pnu.last_updated_ts THEN 0 ELSE 1 END AS flag
					  FROM privacy_notice pn
					  LEFT JOIN privacy_notice_user pnu ON pn.privacy_notice_id = pnu.privacy_notice_id AND pnu.user_id = '26'
					  WHERE pn.company_id = '10'