Formule
(( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'black', '')))/LENGTH('black')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'black', '')))/LENGTH('black')) ) * 3.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'traditional', '')))/LENGTH('traditional')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'traditional', '')))/LENGTH('traditional')) ) * 3.1) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'interior', '')))/LENGTH('interior')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'interior', '')))/LENGTH('interior')) ) * 2.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'outside', '')))/LENGTH('outside')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'outside', '')))/LENGTH('outside')) ) * 2.7) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'bamboo', '')))/LENGTH('bamboo')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'bamboo', '')))/LENGTH('bamboo')) ) * 2.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'fence', '')))/LENGTH('fence')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'fence', '')))/LENGTH('fence')) ) * 2.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'manufacture', '')))/LENGTH('manufacture')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'manufacture', '')))/LENGTH('manufacture')) ) * 2.1) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'decoration', '')))/LENGTH('decoration')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'decoration', '')))/LENGTH('decoration')) ) * 2) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'dimensions', '')))/LENGTH('dimensions')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'dimensions', '')))/LENGTH('dimensions')) ) * 2) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'japanese', '')))/LENGTH('japanese')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'japanese', '')))/LENGTH('japanese')) ) * 1.8)