User 'sklepkam_kami' has exceeded the 'max_questions' resource (current value: 4532)<br /><br /><pre>
		SELECT t.name, COUNT(pt.id_tag) AS times
		FROM `ps_product_tag` pt
		LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag)
		LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product)
		WHERE t.`id_lang` = 3
		AND p.`active` = 1
		AND p.`id_product` IN (
			SELECT cp.`id_product`
			FROM `ps_category_group` cg
			LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
			WHERE cg.`id_group` = 1
		)
		GROUP BY t.id_tag
		ORDER BY times DESC
		LIMIT 0, 10</pre>