SELECT discount_id, discount_promotionalCode, discount_name, discount_description
			FROM tbl_discounts d
			WHERE d.discount_archive = 0
            
			
				AND (
					sitecode IN (4366) OR
					sitecode IN (SELECT b.bridgebrand FROM brands b JOIN brands_rel r ON b.brand_id = r.brand_id WHERE r.site_id = 4366 AND r.bridge = 1)
				)
				
				AND ({d '2024-10-18'} >= d.discount_startDate
				AND {d '2024-10-18'} <= d.discount_endDate)
				AND (d.discount_promotionalCode = ''
					OR d.discount_promotionalCode = '')