SELECT
					l.*, w.id AS webhook_id
				FROM
					link l
				LEFT JOIN
					webhook_install w
				ON
					w.date = '2026-01-27' AND
					w.link_id = l.id AND
					w.tier = '1' AND
					w.platform = 'ios' AND
					w.quality = 0
				WHERE
					l.url = 'https://dtm.app.link/AlgWlD4f7x'
			

{
    "id": "2",
    "timestamp_created": "2016-11-07 19:27:30",
    "user_id": "2",
    "game_id": "1",
    "url": "https:\/\/dtm.app.link\/AlgWlD4f7x",
    "name": "Facebook link for DTM",
    "channel": "Facebook",
    "campaign": "Facebook DTM Campaign",
    "multiplier": "1",
    "webhook_id": "1386"
}

						UPDATE
							webhook_install
						SET
							tier = '1',
							campaign = 'Facebook DTM Campaign',
							channel = 'Facebook',
							installs = installs + 1
						WHERE id = '1386'
					

UPDATE promotion SET current_installs_webhook = current_installs_webhook + 1 WHERE game_id = '1' AND start_date <= UTC_DATE AND end_date > UTC_DATE()