What the most common characteristic id?
SELECT characteristic_id from product_characteristics group by characteristic_id order by count ( * )  desc limit 1
most common characteristic id refers to characteristic_id with MAX(COUNT(characteristic_id));