##conta i duplicati negli dirtySku
SELECT
  group_concat(id), dirtyProductId, size FROM DirtySku
WHERE shopId = 27
GROUP BY dirtyProductId, size
HAVING count(id) > 1
ORDER BY count(id) DESC, productSizeId IS NOT NULL DESC;

##conta i duplicati nei dirtyProduct
SELECT
  group_concat(id), group_concat(productId), group_concat(productVariantId) FROM DirtyProduct
WHERE shopId = 27
      and productId is not NULL
GROUP BY extId, var # productId, productVariantId
HAVING count(id) > 1
ORDER BY count(id) DESC