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 (
'56524', '56519', '56517', '56512',
'56526', '56513', '56514', '56525',
'56522', '56523', '56510', '56518',
'56516', '56521', '56511', '56515',
'56527'
)
GROUP BY
tag