SELECT 1
		FROM account_info ai, client_accounts ca, orders o, users u
		WHERE ca.id = ai.`account_id` AND o.id = ai.`order_id` AND u.id = ca.uid
		AND (o.`paid` = 1 OR ca.`status`= 4 OR u.`blocked` = 1)
		AND ai.`cira_promo_price` > 0
		AND u.`signup_ip` = '3.147.103.202'
		and ca.start_date = '2020-11-27'