 
 
<br />query=
	SELECT T1.IP, T1.NUM, T2.IP_NUM, IFNULL(fwc.CNUM,0) AS IP_COUNTER, IFNULL(fwc.CNUM/T2.IP_NUM,0) AS IP_Rating, (T2.IP_NUM/T1.NUM) AS IP_R1
	FROM (
	      SELECT COUNT( `IP` ) AS NUM, `IP`
	      FROM `b_stat_hit`
	      WHERE `DATE_HIT` >= DATE_SUB(now(), INTERVAL 600 SECOND)
	      AND `USER_AUTH` = 'N'
	      AND `URL` REGEXP '/shop/[[:alnum:]]+/[[:alnum:]]+/$|/shop/[[:alnum:]]+/[[:alnum:]]+/\\?|/equipment/'
	      AND `IP`='18.97.9.170'
	      HAVING COUNT(`IP`) >'5'
	     ) AS T1
	LEFT JOIN (
		SELECT COUNT( `IP` ) AS IP_NUM, `IP` AS IP_ALL
		FROM `b_stat_hit`
		WHERE `DATE_HIT` >= DATE_SUB(now(), INTERVAL 600 SECOND)
		AND `URL` NOT LIKE '%recaptcha%'
		AND `USER_AUTH` = 'N'
		AND `IP`='18.97.9.170'
	      ) AS T2 ON T1.IP  = T2.IP_ALL
	LEFT JOIN (
		SELECT COUNT(`ip_source`) AS CNUM,`ip_source`
		FROM `firewall_www_counter`
		WHERE `date_create`>= DATE_SUB(now(), INTERVAL 600 SECOND)
		AND `ip_source`='18.97.9.170'
	      ) AS fwc ON  T1.IP COLLATE utf8_general_ci = fwc.ip_source
     ;<br />NUM=, IP_NUM=, IP_COUNTER=, IP_Rating=, IP_R1=, rating=1<br />RR=1<br /><br />Общее время выполнения=0.082906007766724 секунд