Formule
(( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'green', '')))/LENGTH('green')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'green', '')))/LENGTH('green')) ) * 3.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'crimson', '')))/LENGTH('crimson')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'crimson', '')))/LENGTH('crimson')) ) * 1.7) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'autumn', '')))/LENGTH('autumn')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'autumn', '')))/LENGTH('autumn')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'leaves', '')))/LENGTH('leaves')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'leaves', '')))/LENGTH('leaves')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'ribbed', '')))/LENGTH('ribbed')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'ribbed', '')))/LENGTH('ribbed')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'shades', '')))/LENGTH('shades')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'shades', '')))/LENGTH('shades')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'spring', '')))/LENGTH('spring')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'spring', '')))/LENGTH('spring')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'summer', '')))/LENGTH('summer')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'summer', '')))/LENGTH('summer')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'pink', '')))/LENGTH('pink')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'pink', '')))/LENGTH('pink')) ) * 1.4) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'with', '')))/LENGTH('with')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'with', '')))/LENGTH('with')) ) * 1.4)