SELECT
count(*) as counts_tag,
tag_id,
tag
FROM
cscart_tags
INNER JOIN cscart_tag_links USING (tag_id)
INNER JOIN cscart_products ON cscart_tag_links.object_id = cscart_products.product_id
WHERE
object_type = 'P'
AND cscart_tags.status = 'A'
AND cscart_products.product_id IN (
'62370', '60925', '60431', '62371'
)
GROUP BY
tag