"SELECT appinfo.id, appinfo.package_name, appinfo.attrib_platform, appinfo.geo, appinfo.app_name,
		appinfo.max_score, appinfo.installs_per_try, appinfo.reinstall, appinfo.reinstall_date FROM appinfo
		LEFT JOIN campaigns ON campaigns.appinfo_id=appinfo.id
		WHERE appinfo.installs_per_try = 0 AND appinfo.is_available='T' AND COUNT(campaigns.id) >= 4
		AND campaigns.is_active IN ('T','D') AND appinfo.reinstall_date >= DATE(DATE_SUB(NOW(), INTERVAL 3 DAY))
		GROUP BY (appinfo.id)";

"SELECT appinfo.id, appinfo.package_name, appinfo.attrib_platform, appinfo.geo, appinfo.app_name,
		appinfo.max_score, appinfo.installs_per_try, appinfo.reinstall, appinfo.reinstall_date FROM appinfo
		LEFT JOIN campaigns ON campaigns.appinfo_id=appinfo.id
		WHERE appinfo.installs_per_try = 0 AND appinfo.is_available='T' AND (SELECT COUNT(*) FROM campaigns WHERE campaigns.appinfo_id = appinfo.id) >= 4
		AND campaigns.is_active IN ('T','D') AND appinfo.reinstall_date >= DATE(DATE_SUB(NOW(), INTERVAL 3 DAY))
		GROUP BY (appinfo.id)";